Re: [SQLObject] DBMConnection not saving any data

[Ian B. <ia...@co...>]

Yes indeed there is a problem.  It seems the dbm modules were not being
closed/synced when Python is exited, you have to explicitly close the
file.

I've made a fix to CVS (DBConnection.py) for this.

On Tue, 2003-07-08 at 15:20, Mark Melvin wrote:
> OK, I don't know if this is a dumb question or not - but I am trying to 
> develop using the DBM connection for now, but when I try to create the 
> tables, it creates the '.db' files but there is no data saved (i.e. they 
> are 0 bytes in size).  I assume I am doing something wrong.  I'm also 
> assuming this works on Win2K, with SQLObject 0.4, and that the DBM 
> filesystem is actually supposed to be a persistent format?
> 
> My code is as follows (note - I changed all my StringCols to Cols with 
> sqlType set just to make sure that wasn't it):
> 
> from SQLObject import *
> 
> __connection__ = DBMConnection('db/', debug=1)
> 
> class Customer(SQLObject):
>     Contacts    = MultipleJoin('Contact', orderBy=['LastName', 
> 'FirstName'])
>     CustomerName= Col(sqlType='VARCHAR(30)', default="")
>     Street      = Col(sqlType='VARCHAR(35)', default="")
>     Suite       = Col(sqlType='VARCHAR(35)', default="")
>     City        = Col(sqlType='VARCHAR(20)', default="")
>     Province    = Col(sqlType='VARCHAR(15)', default="")
>     PostalCode  = Col(sqlType='VARCHAR(7)', default="")
>     PhoneNumber1= Col(sqlType='VARCHAR(20)', default="")
>     FaxNumber   = Col(sqlType='VARCHAR(20)', default="")
> 
> class Contact(SQLObject):
>     Customer    = ForeignKey('Customer')
>     LastName    = Col(sqlType='VARCHAR(15)', default="")
>     FirstName   = Col(sqlType='VARCHAR(15)', default="")
>     Title       = Col(sqlType='VARCHAR(25)', default="")
>     PhoneNumber1= Col(sqlType='VARCHAR(20)', default="")
>     PhoneNumber2= Col(sqlType='VARCHAR(20)', default="")
>     Notes       = Col(sqlType='TEXT', default="")
> 
> if __name__ == '__main__':
>     Customer.createTable()
>     Contact.createTable()
>     Customer.new(CustomerName='Blow, Joe', City='Waterloo')
>     c = Customer.new(CustomerName='Wankus Inc.', City='Waterloo')
>     Contact.new(FirstName='Doctor', LastName='Evil', Title='The Bug 
> Cahuna', Customer=c)
>     print list(Customer.select())
>     print list(Contact.select())
> 
> 
> I see the data printed fine, and the select statements work fine as well.  
> It isn't saved to the file however.  Do I have to close the connection or 
> flush things somehow?