Following up on this issue - here is a test.
===
from decimal import Decimal
from sqlobject import *
sqlhub.processConnection =
connectionForURI('sqlite:///path/to/decimaltest.db')
class Test(SQLObject):
number = DecimalCol(size=8, precision=4)
Test.createTable(ifNotExists=True)
foo = Test
Oleg,
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On
> Behalf Of Oleg Broytmann
> Sent: Tuesday, February 12, 2008 8:37 AM
> To: sqlobject-discuss@lists.sourceforge.net
> Subject: Re: [SQLObject] MS SQL pain for a newb
>
> On Tue, Feb 12, 2008 at 08:22:17
On Tue, Feb 12, 2008 at 08:22:17AM -0600, Mike Driscoll wrote:
> >Or, if empID is the Primary Key,
> > use it as the id:
> >
> > class tblAcctPrefs(SQLObject):
> > class sqlmeta:
> > idName = "emp_id"
> > idType = str
> > pref_name = StringCol()
> > pref_value = St
On Tue, Feb 12, 2008 at 09:18:02AM -0500, Nathan Edwards wrote:
> Oleg Broytmann wrote:
> >My guess is that after any unhandled exception you must rollback the
> > connection.
>
> I'm not using transactions explicitly, each insert is atomic, so
> autoCommit is fine for me.
Then my guess i
Hi Oleg,
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of
> Oleg Broytmann
> Sent: Friday, February 08, 2008 3:47 PM
> To: sqlobject-discuss@lists.sourceforge.net
> Subject: Re: [SQLObject] MS SQL pain for a newb
>
> On Fri, Feb 08, 2008 at 03:07:3
Christopher,
>
> Try reading this whole section part of the SQLObject documentation:
> http://sqlobject.org/SQLObject.html#legacy-database-schemas
> """
> All tables that you want to turn into a class need to have an integer
> primary key.
> [...]
> By default names in SQLObject are expected to
Oleg Broytmann wrote:
> On Mon, Feb 11, 2008 at 09:21:56PM -0500, Nathan Edwards wrote:
>> If I change "a = A.byValue(1)" to "pass" the exceptions go away...it
>> seems like the exception puts the connection in a bad state.
>
>My guess is that after any unhandled exception you must rollback t
On Tue, Feb 12, 2008 at 01:08:19PM +0900, Alex wrote:
> How do you delete tables with constraints? The .dropTable options of
> cascade and dropJoinTables do not seem to do the trick.
Do you have mutually referenced tables? Try to clear them first issuing
a DELETE command.
Oleg.
--
Oleg
On Mon, Feb 11, 2008 at 09:21:56PM -0500, Nathan Edwards wrote:
> If I change "a = A.byValue(1)" to "pass" the exceptions go away...it
> seems like the exception puts the connection in a bad state.
My guess is that after any unhandled exception you must rollback the
connection.
Oleg.
--
