Author: poeml Date: Wed May 5 23:07:48 2010 New Revision: 8052 URL: http://svn.mirrorbrain.org/viewvc/mirrorbrain?rev=8052&view=rev Log: mb db vacuum: - remove a stray line (which had no effect), forgotten two months ago. Modified: trunk/mb/mb/dbmaint.py Modified: trunk/mb/mb/dbmaint.py URL: http://svn.mirrorbrain.org/viewvc/mirrorbrain/trunk/mb/mb/dbmaint.py?rev=8052&r1=8051&r2=8052&view=diff ============================================================================== --- trunk/mb/mb/dbmaint.py (original) +++ trunk/mb/mb/dbmaint.py Wed May 5 23:07:48 2010 _at_@ -4,7 +4,6 @@ n_file_total = conn.Filearr.select().count() - query = "SELECT count(*) FROM filearr WHERE mirrors = '{}'" query = """SELECT count(*) FROM filearr LEFT OUTER JOIN hash ON filearr.id = hash.file_id WHERE mirrors = '{}' AND hash.file_id IS NULL""" _______________________________________________ mirrorbrain-commits mailing list Archive: http://mirrorbrain.org/archive/mirrorbrain-commits/ Note: To remove yourself from this list, send a mail with the content unsubscribe to the address mirrorbrain-commits-request_at_mirrorbrain.orgReceived on Wed May 05 2010 - 21:07:49 GMT
This archive was generated by hypermail 2.3.0 : Mon Feb 20 2012 - 23:47:04 GMT