Hi,
I want to connect an existing database with sqlobject 0.7.
My script is still very simple:
---------------------------------------------------------------------------
#!/usr/bin/env python
import MySQLdb
from sqlobject import *
connection = connectionForURI('mysql://[EMAIL PROTECTED]/xamstest')
sqlhub.processConnection = connection
class pm_users(SQLObject):
_fromDatabase = True
_style = MixedCaseStyle
for i in pm_users.select():
print i
---------------------------------------------------------------------------
Running it on CentOS 4.4 (Python 2.3) gives:
---------------------------------------------------------------------------
Traceback (most recent call last):
File "./sq.py", line 10, in ?
class pm_users(SQLObject):
File "/home/fs/sqlobject/declarative.py", line 94, in __new__
cls.__classinit__(cls, new_attrs)
File "/home/fs/sqlobject/main.py", line 770, in __classinit__
cls.sqlmeta.addColumnsFromDatabase()
File "/home/fs/sqlobject/main.py", line 421, in addColumnsFromDatabase
for columnDef in conn.columnsFromSchema(sqlmeta.table, soClass):
File "/home/fs/sqlobject/mysql/mysqlconnection.py", line 131, in
columnsFromSchema
kw['name'] = soClass.sqlmeta.style.dbColumnToPythonAttr(field)
TypeError: unbound method dbColumnToPythonAttr() must be called with
MixedCaseStyle instance as first argument (got str instance instead)
---------------------------------------------------------------------------
What am I missing?
My database schema looks like this:
mysql> show fields from pm_users;
+------------------+-----------------------------------------+------+-----+-------------------+----------------+
| Field | Type | Null | Key |
Default | Extra |
+------------------+-----------------------------------------+------+-----+-------------------+----------------+
| ID | int(11) | | PRI |
NULL | auto_increment |
| SiteID | int(11) | | MUL | 0
| |
| UniqueName | varchar(100) | YES | MUL |
NULL | |
| Name | varchar(100) | | |
| |
| Password | varchar(32) | | MUL |
| |
| Quota | int(11) | YES | |
NULL | |
| AddrType | tinyint(1) unsigned | | | 0
| |
| VirusCheckIn | enum('false','true') | YES | |
NULL | |
| VirusCheckOut | enum('false','true') | YES | |
NULL | |
| SpamCheckIn | enum('false','true') | YES | |
NULL | |
| SpamCheckOut | enum('false','true') | YES | |
NULL | |
| RelayOnAuth | enum('false','true') | | |
true | |
| RelayOnCheck | enum('false','true') | | |
false | |
| AutoReply | enum('false','true') | | MUL |
false | |
| AutoReplySubject | varchar(50) | | |
| |
| AutoReplyText | text | YES | |
NULL | |
| AccountState | enum('default','locked','lockedbounce') | | |
default | |
| Added | datetime | YES | |
NULL | |
| Updated | timestamp | YES | |
CURRENT_TIMESTAMP | |
+------------------+-----------------------------------------+------+-----+-------------------+----------------+
19 rows in set (0.00 sec)
Thanks for your help. :-)
fs
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
sqlobject-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
