Changeset 3025

Timestamp:

Sep 19, 2010 10:07:37 PM (11 years ago)

Author:

wehart

Message:

Creating a 'table' option, which creates a query automatically.

Location:

coopr.pyomo/trunk/coopr/pyomo/data

Files:

• db_table.py (modified) (2 diffs)
• process_data.py (modified) (1 diff)

coopr.pyomo/trunk/coopr/pyomo/data/db_table.py

@@ -20 +20 @@
 # user=
 # password=
+# table=
 
 class db_Table(TableData):
@@ -54 +55 @@
         #print "\nReading foods:\n"
         tmp = []
+        if self.options.query is None:
+            self.options.query = 'SELECT * FROM '+self.options.table
         print "DATA start",self.options.query
         cursor.execute(self.options.query[1:-1])

coopr.pyomo/trunk/coopr/pyomo/data/process_data.py

@@ -521 +521 @@
     options = Options(**cmd[1])
     for key in options:
-        if not key in ['range','filename','format','using','query','user','password']:
+        if not key in ['range','filename','format','using','query','table','user','password']:
             raise ValueError, "Unknown import option '%s'" % key