testing/junit-cleartables-mysql.sql

-- Licensed to the Apache Software Foundation (ASF) under one or more
--  contributor license agreements.  The ASF licenses this file to You
-- under the Apache License, Version 2.0 (the "License"); you may not
-- use this file except in compliance with the License.
-- You may obtain a copy of the License at
--
--     http://www.apache.org/licenses/LICENSE-2.0
--
-- Unless required by applicable law or agreed to in writing, software
-- distributed under the License is distributed on an "AS IS" BASIS,
-- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
-- See the License for the specific language governing permissions and
-- limitations under the License.  For additional information regarding
-- copyright in this work, please see the NOTICE file in the top level
-- directory of this distribution.

-- Running local tests in eclipse.

-- Script is used to clear old data prior to running local tests

-- Copy this file to app/src/test/resources/dbscripts/junit-cleartables-mysql.sql

-- Any changes here should also be in docs/testing/junit-cleartables-mysql.sql.

delete mt from weblog w, roller_mediafile mf, roller_mediafiletag mt where w.id = mf.weblogid and mt.mediafile_id = mf.id and w.creator like 'junit_%';
delete mf from weblog w, roller_mediafile mf where w.id = mf.weblogid and w.creator like 'junit_%';
delete md from weblog w, roller_mediafiledir md where w.id = md.websiteid and w.creator like 'junit_%';
delete from roller_mediafile WHERE creator like 'junit_%';
delete from roller_mediafiledir;

delete r from weblog w, referer r WHERE w.id = r.websiteid and w.creator like 'junit_%';

delete from weblog WHERE creator like 'junit_%';

delete b from weblog w, bookmark_folder f, bookmark b where f.id = b.folderid and w.id = f.websiteid and w.creator like 'junit_%';
delete from bookmark_folder WHERE websiteid like 'junit_%';

delete from userrole WHERE username like 'junit_%';
delete from roller_permission WHERE username like 'junit_%';
delete from roller_user WHERE username like 'junit_%';
delete from roller_userattribute WHERE username like 'junit_%';
delete from roller_oauthconsumer WHERE username like 'junit_%';
delete from roller_oauthaccessor WHERE username like 'junit_%';
delete from roller_tasklock WHERE name = 'TestTask';