Thread: [SQLObject] SQLObject using trouble
SQLObject is a Python ORM.
Brought to you by:
ianbicking,
phd
From: Nicolay A. V. <nva...@wh...> - 2005-10-07 19:03:02
|
Hello! I am trying to use SQLObject, but in the first test I've got some trouble. I use Python 2.4, SQLObject 0.6 under Windows98. My code (using documentation example): #!/usr/bin/env python import sqlobject conn = 'mysql://root@localhost/newcatalog' class Person(SQLObject): _connection = conn firstName = StringCol() middleInitial = StringCol(length=1, default=None) lastName = StringCol() I get an error message: Traceback (most recent call last): File "C:\PYTHON24\LIB\SITE-PACKAGES\PYTHONWIN\pywin\framework\scriptutils.py", line 307, in RunScript debugger.run(codeObject, __main__.__dict__, start_stepping=0) File "C:\PYTHON24\LIB\SITE-PACKAGES\PYTHONWIN\pywin\debugger\__init__.py", line 60, in run _GetCurrentDebugger().run(cmd, globals,locals, start_stepping) File "C:\PYTHON24\LIB\SITE-PACKAGES\PYTHONWIN\pywin\debugger\debugger.py", line 595, in run exec cmd in globals, locals File "C:\Python24\Tutors\sqlobject.py", line 6, in ? import sqlobject File "C:\Python24\Tutors\sqlobject.py", line 13, in ? class Person(SQLObject): NameError: name 'SQLObject' is not defined Where is a mistake? Suggest me please. TIA |
From: Oleg B. <ph...@ma...> - 2005-10-07 19:59:46
|
On Fri, Oct 07, 2005 at 09:39:46PM +0400, Nicolay A. Vasiliev wrote: > I use Python 2.4, SQLObject 0.6 under Windows98. BTW, we've released version 0.7 already! > import sqlobject [skip] > class Person(SQLObject): [skip] > NameError: name 'SQLObject' is not defined You have imported the name "sqlobject" (which is the correct name for version 0.7) but not "SQLObject". In python you must import all names you want to use. Please reread tutorials. For version 0.7 correct code is either import sqlobject class Person(sqlobject.SQLObject): ... or from sqlobject import SQLObject class Person(SQLObject): ... Oleg. -- Oleg Broytmann http://phd.pp.ru/ ph...@ph... Programmers don't die, they just GOSUB without RETURN. |
From: Jorge G. <go...@ie...> - 2005-10-07 20:11:52
|
"Nicolay A. Vasiliev" <nva...@wh...> writes: > Hello! > > I am trying to use SQLObject, but in the first test I've got some trouble. > > I use Python 2.4, SQLObject 0.6 under Windows98. > > My code (using documentation example): > > #!/usr/bin/env python > > import sqlobject > > conn = 'mysql://root@localhost/newcatalog' > > class Person(SQLObject): > _connection = conn > firstName = StringCol() > middleInitial = StringCol(length=1, default=None) > lastName = StringCol() > > I get an error message: > Traceback (most recent call last): > File > "C:\PYTHON24\LIB\SITE-PACKAGES\PYTHONWIN\pywin\framework\scriptutils.py", > line 307, in RunScript > debugger.run(codeObject, __main__.__dict__, start_stepping=0) > File > "C:\PYTHON24\LIB\SITE-PACKAGES\PYTHONWIN\pywin\debugger\__init__.py", > line 60, in run > _GetCurrentDebugger().run(cmd, globals,locals, start_stepping) > File > "C:\PYTHON24\LIB\SITE-PACKAGES\PYTHONWIN\pywin\debugger\debugger.py", > line 595, in run > exec cmd in globals, locals > File "C:\Python24\Tutors\sqlobject.py", line 6, in ? > import sqlobject > File "C:\Python24\Tutors\sqlobject.py", line 13, in ? > class Person(SQLObject): > NameError: name 'SQLObject' is not defined > > Where is a mistake? Suggest me please. You imported the "sqlobject" namespace, but you haven't used it to call the class SQLObject within it. You should either: from sqlobject import * or import sqlobject class Person(sqlobject.SQLObject): ... I prefer the second form, but then you have to qualify all structures. You can also import specific structures: from sqlobject import SQLObject, IntCol and then use those. Be seeing you, -- Jorge Godoy <go...@ie...> |
From: Ian B. <ia...@co...> - 2005-10-07 20:15:20
|
Jorge Godoy wrote: > You imported the "sqlobject" namespace, but you haven't used it to call the > class SQLObject within it. > > You should either: > > from sqlobject import * > > or > > import sqlobject > class Person(sqlobject.SQLObject): > ... > > > I prefer the second form, but then you have to qualify all structures. You > can also import specific structures: > > from sqlobject import SQLObject, IntCol A compromise can also be: import sqlobject as so class Person(so.SQLObject):... -- Ian Bicking / ia...@co... / http://blog.ianbicking.org |
From: Nicolay A. V. <nva...@wh...> - 2005-10-08 09:15:16
|
Hello, and thank you all for suggestions. But... #!/usr/bin/env python from sqlobject import SQLObject conn = 'mysql://root@localhost/newcatalog' class Person(SQLObject): _connection = conn firstName = StringCol() middleInitial = StringCol(length=1, default=None) lastName = StringCol() Traceback (most recent call last): File "sqlobject.py", line 8, in ? from sqlobject import SQLObject File "c:\Python24\Tutors\sqlobject.py", line 8, in ? from sqlobject import SQLObject ImportError: cannot import name SQLObject |
From: Oleg B. <ph...@ma...> - 2005-10-08 17:00:59
|
On Sat, Oct 08, 2005 at 01:03:33PM +0400, Nicolay A. Vasiliev wrote: > Traceback (most recent call last): > File "sqlobject.py", line 8, in ? > from sqlobject import SQLObject > File "c:\Python24\Tutors\sqlobject.py", line 8, in ? > from sqlobject import SQLObject > ImportError: cannot import name SQLObject Your test script is called sqlobject.py, and of course there is no SQLObject in it. Rename your script and never create a script with a name that conflicts with library modules! Oleg. -- Oleg Broytmann http://phd.pp.ru/ ph...@ph... Programmers don't die, they just GOSUB without RETURN. |
From: Nicolay A. V. <nva...@wh...> - 2005-10-08 17:19:03
|
Yes! Problem was solved, thank you very much! > > Your test script is called sqlobject.py, and of course there is no > SQLObject in it. Rename your script and never create a script with a name > that conflicts with library modules! > > Oleg. |