[Hejes-devel] [946] replaced the query - used a test query before, now it's the full db.

hejes-devel at nytud.hu hejes-devel at nytud.hu
Wed Sep 18 13:10:23 CEST 2013


Revision: 946
Author:   hussami
Date:     2013-09-18 13:10:23 +0200 (Wed, 18 Sep 2013)
Log Message:
-----------
replaced the query - used a test query before, now it's the full db.
we could use command-line options to make sure that an arbitrary db id interval
can be addressed, let's see that tomorrow.

Modified Paths:
--------------
    trunk/misc/osiris_xml/ohanalyze.py

Modified: trunk/misc/osiris_xml/ohanalyze.py
===================================================================
--- trunk/misc/osiris_xml/ohanalyze.py	2013-09-18 10:40:32 UTC (rev 945)
+++ trunk/misc/osiris_xml/ohanalyze.py	2013-09-18 11:10:23 UTC (rev 946)
@@ -321,7 +321,8 @@
     return result
 
   def readDB(self):
-    query = "select id, actual, norm from ohdict where id > 1000 and id not in (253, 1617, 10954, 10962, 14118, 21042, 26766, 28090, 31341, 35355, 41501, 41502, 41503, 53195, 63253, 66216, 66217, 68562, 69228, 69229, 72479, 72480, 72481, 72482, 72483, 72484, 72565, 79810, 79812, 81608, 81609, 82178, 82181, 104301, 107148, 110649, 112890) order by id asc limit 100";
+#    query = "select id, actual, norm from ohdict where id > 1000 and id not in (253, 1617, 10954, 10962, 14118, 21042, 26766, 28090, 31341, 35355, 41501, 41502, 41503, 53195, 63253, 66216, 66217, 68562, 69228, 69229, 72479, 72480, 72481, 72482, 72483, 72484, 72565, 79810, 79812, 81608, 81609, 82178, 82181, 104301, 107148, 110649, 112890) order by id asc limit 100";
+    query = "select id, actual, norm from ohdict where id > 0"
     self.db.execute(query)
 
     result = self.db.fetchall()




More information about the Hejes-devel mailing list