If you're no longer referencing this file within the code, I don't
personally have a need for this test script (I have my own half-dozen I
keep with me personally), so I would go ahead and delete it so we don't
need a separate "tools" submodule right now. I don't have a problem
with diagnostic scripts like these in src/main if it's helpful for you
to have it in the classpath while testing (or in src/test if you're
running it only with JUnit tests where the test classpath is visible),
but if you don't need it in the classpath it would be preferable to keep
personal testing scripts on your local machine or in a throwaway GitHub
project so others aren't wondering what it's for.
OTOH, if you think there's a pretty good chance this file might be
helpful for others, OK to keep but please comment the file letting
people know how it can be used.
Cheers,
Glen
On 08/01/2013 01:49 AM, [email protected] wrote:
Added: roller/trunk/tools/tests/junit-cleartables-mysql.sql
URL:
http://svn.apache.org/viewvc/roller/trunk/tools/tests/junit-cleartables-mysql.sql?rev=1509084&view=auto
==============================================================================
--- roller/trunk/tools/tests/junit-cleartables-mysql.sql (added)
+++ roller/trunk/tools/tests/junit-cleartables-mysql.sql Thu Aug 1 05:49:08
2013
@@ -0,0 +1,36 @@
+-- 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.
+
+-- Script is used to clear old data prior to running local tests
+
+delete mt from website 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 website w, roller_mediafile mf where w.id = mf.weblogid and
w.creator like 'junit_%';
+delete md from website w, roller_mediafiledir md where w.id = md.websiteid and
w.creator like 'junit_%';
+
+delete r from website w, referer r WHERE w.id = r.websiteid and w.creator like
'junit_%';
+
+delete from website WHERE creator like 'junit_%';
+
+delete b from website w, folder f, bookmark b where f.id = b.folderid and w.id
= f.websiteid and w.creator like 'junit_%';
+delete from folder WHERE websiteid like 'junit_%';
+
+delete from userrole WHERE username like 'junit_%';
+delete from roller_permission WHERE username like 'junit_%';
+delete from rolleruser 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_%';
+
