[SQLObject] Allowing DateTime to be specified as a string...

2009-08-11 Thread Ray Van Dolson
Hi all; It seems like this worked in the past, but I could just be imagining things :) I have a column in my database defined as a DateTimeCol with no default and where NULL is allowed. I'm parsing a CSV file and one of the columns in the CSV file corresponds with this DateTimeCol. The CSV valu

Re: [SQLObject] Getting odd syntax error...

2009-08-11 Thread Ray Van Dolson
On Tue, Aug 11, 2009 at 01:12:08PM -0700, Ray Van Dolson wrote: > Using sqlobject 0.9.9 with pymssql 1.0.1 on RHEL 5.3 (the > aforementioned have been installed with yum via either the base OS > packaeges or EPEL). Egg on my face. This appears to be a known issue with pymssql 1.0.1. Upg

[SQLObject] Getting odd syntax error...

2009-08-11 Thread Ray Van Dolson
Using sqlobject 0.9.9 with pymssql 1.0.1 on RHEL 5.3 (the aforementioned have been installed with yum via either the base OS packaeges or EPEL). I have a class defined similar to the following: class SystemsInfo(SQLObject): class sqlmeta: style = MixedCaseStyle(longID=True) fromDatabase

Re: [SQLObject] assert id is not None

2008-07-22 Thread Ray Van Dolson
>Oops, seems like a bug. I think what caused the bug is using > fromDatabase and idName simultaneously - SQLObject drew SystemName from the > DB and added it because of the idName. To work around the bug avoid > using fromDatabase - declare your columns explicitly. Thanks for the explanation.

Re: [SQLObject] assert id is not None

2008-07-21 Thread Ray Van Dolson
On Mon, Jul 21, 2008 at 05:31:24PM -0700, Ray Van Dolson wrote: > Hi all, I'm running into an exception trying to create a new row in a > table with fromDatabase = True defined (the table is pre-existing). Hmm, I am guessing the note right above this: http://www.sqlobject.org/SQL

[SQLObject] assert id is not None

2008-07-21 Thread Ray Van Dolson
Hi all, I'm running into an exception trying to create a new row in a table with fromDatabase = True defined (the table is pre-existing). The class definition looks like this: class SystemsInfo(SQLObject): class sqlmeta: fromDatabase = True table = 'SystemsInfo' idType = str idN

Re: [SQLObject] sqlmeta, fromDatabase and "No connection has been defined" errors...

2008-07-08 Thread Ray Van Dolson
> I'm trying to pull in an SQLObject class from an already existing > database schema, but having no success. It would seem to be pretty > straightforward: It never fails -- post a question and five seconds later come up with the answer. It occurred to me that I hadn't defined a connection for

[SQLObject] sqlmeta, fromDatabase and "No connection has been defined" errors...

2008-07-08 Thread Ray Van Dolson
Hi all, new to SQLObject, but already really enjoying it. I'm trying to pull in an SQLObject class from an already existing database schema, but having no success. It would seem to be pretty straightforward: import sys, os from sqlobject import * class Owners(SQLObject): class sqlmeta