Hi all,
I have a sqlite database with provinces of my country,
[EMAIL PROTECTED]:~/mvpot/lib$ sqlite3 model/codigospostales.db
SQLite version 3.3.13
Enter ".help" for instructions
sqlite> .tables
poblaciones provincias
and a simple class to access the contents:
class Provincias(SQLObject)
p = abspath('codigospostales.db')
_connection = connectionForURI('sqlite:'+p)
nombre = StringCol()
when I try to do Provincias.get(1) I got a 'no such table' error. It
seems to me a very silly error, but I can't find a clue. Any help will
be apreciated. This is the execution traceback:
Traceback (most recent call last):
File "<input>", line 1, in <module>
File
"/usr/lib/python2.5/site-packages/SQLObject-0.8.1-py2.5.egg/sqlobject/main.py",
line 934, in get
val._init(id, connection, selectResults)
File
"/usr/lib/python2.5/site-packages/SQLObject-0.8.1-py2.5.egg/sqlobject/main.py",
line 973, in _init
selectResults = self._connection._SO_selectOne(self, dbNames)
File
"/usr/lib/python2.5/site-packages/SQLObject-0.8.1-py2.5.egg/sqlobject/dbconnection.py",
line 629, in _SO_selectOne
self.sqlrepr(so.id)))
File
"/usr/lib/python2.5/site-packages/SQLObject-0.8.1-py2.5.egg/sqlobject/dbconnection.py",
line 359, in queryOne
return self._runWithConnection(self._queryOne, s)
File
"/usr/lib/python2.5/site-packages/SQLObject-0.8.1-py2.5.egg/sqlobject/dbconnection.py",
line 230, in _runWithConnection
val = meth(conn, *args)
File
"/usr/lib/python2.5/site-packages/SQLObject-0.8.1-py2.5.egg/sqlobject/dbconnection.py",
line 352, in _queryOne
self._executeRetry(conn, c, s)
File
"/usr/lib/python2.5/site-packages/SQLObject-0.8.1-py2.5.egg/sqlobject/sqlite/sqliteconnection.py",
line 181, in _executeRetry
raise OperationalError(ErrorMessage(e))
OperationalError: no such table: provincias
greetings,
jonhattan
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
sqlobject-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
