OUCH !!
I now get the following after your changes:
----------------------------------------------------------------
Dabo Error Log: Thu Aug 17 11:20:10 2006: Failed to create newval for field 'id'
Dabo Error Log: Thu Aug 17 11:20:10 2006: TYPES: {'owing': <type
'type'>, 'code': <type 'type'>, 'contact': <type 'type'>, 'id': <type
'type'>, 'name': <type 'type'>}
Dabo Error Log: Thu Aug 17 11:20:10 2006: type() takes 1 or 3 arguments
Dabo Error Log: Thu Aug 17 11:20:10 2006: Failed to create newval for
field 'code'
Dabo Error Log: Thu Aug 17 11:20:10 2006: TYPES: {'owing': <type
'type'>, 'code': <type 'type'>, 'contact': <type 'type'>, 'id': <type
'type'>, 'name': <type 'type'>}
Dabo Error Log: Thu Aug 17 11:20:10 2006: type() takes 1 or 3 arguments
Dabo Error Log: Thu Aug 17 11:20:10 2006: Failed to create newval for
field 'name'
Dabo Error Log: Thu Aug 17 11:20:10 2006: TYPES: {'owing': <type
'type'>, 'code': <type 'type'>, 'contact': <type 'type'>, 'id': <type
'type'>, 'name': <type 'type'>}
Dabo Error Log: Thu Aug 17 11:20:10 2006: type() takes 1 or 3 arguments
Dabo Error Log: Thu Aug 17 11:20:10 2006: Failed to create newval for
field 'contact'
Dabo Error Log: Thu Aug 17 11:20:10 2006: TYPES: {'owing': <type
'type'>, 'code': <type 'type'>, 'contact': <type 'type'>, 'id': <type
'type'>, 'name': <type 'type'>}
Dabo Error Log: Thu Aug 17 11:20:10 2006: type() takes 1 or 3 arguments
Dabo Error Log: Thu Aug 17 11:20:10 2006: Failed to create newval for
field 'owing'
Dabo Error Log: Thu Aug 17 11:20:10 2006: TYPES: {'owing': <type
'type'>, 'code': <type 'type'>, 'contact': <type 'type'>, 'id': <type
'type'>, 'name': <type 'type'>}
Dabo Error Log: Thu Aug 17 11:20:10 2006: type() takes 1 or 3 arguments
----------------------------------------------------------------
On 8/17/06, Mark Doukidis <[EMAIL PROTECTED]> wrote:
Thanks Echo,
Will check it out.
Something else you may be able to answer:
I noticed trying to create "temporary" SQLite tables that it wrote to
the current directory.
Can you specify memory resident SQLite tables?
Regards
Mark Doukidis
On 8/17/06, Echo <[EMAIL PROTECTED]> wrote:
> On 8/16/06, Mark Doukidis <[EMAIL PROTECTED]> wrote:
> > Hi all,
> >
> > I am trying to create tables on the fly and populate them via
> > dAutoBizobj.initTable.
> >
> > I cannot figure why this message is produced:
> > --------------------------------------------------------------------
> > Traceback (most recent call last):
> > File "testapp.py", line 32, in ?
> > main()
> > File "testapp.py", line 29, in main
> > dabo.biz.autoCreateTables()
> > File "c:\dabo\dabo\dabo\biz\dAutoBizobj.py", line 47, in autoCreateTables
> > biz.CreateTable()
> > File "c:\dabo\dabo\dabo\biz\dAutoBizobj.py", line 283, in CreateTable
> > self.new()
> > File "c:\dabo\dabo\dabo\biz\dBizobj.py", line 615, in new
> > self._onNew()
> > File "c:\dabo\dabo\dabo\biz\dBizobj.py", line 941, in _onNew
> > cursor.setDefaults(self.DefaultValues)
> > File "c:\dabo\dabo\dabo\db\dCursorMixin.py", line 1124, in setDefaults
> > raise ValueError, "Can't set default value for nonexistent field '%s'."
% kk
> > ValueError: Can't set default value for nonexistent field 'owing'.
> > --------------------------------------------------------------------
> > from this code:
> > --------------------------------------------------------------------
> > import dabo
> > from dabo.db import dTable
> > import dabo.biz.dAutoBizobj as autobiz
> >
> > def main():
> > class Customer(autobiz):
> >
> > def initProperties(self):
> > self.DataSource = "customer"
> > self.KeyField = "id"
> > self.RequeryOnLoad = False
> >
> > def getTable(self):
> > tab = dTable(Name="customer", IsTemp=False)
> > tab.addField(Name="id", IsPK=True, DataType="int", Size=2,
> > IsAutoIncrement=True)
> > tab.addField(Name="code", DataType="int", Size=4,
> > AllowNulls=False, Index="idx_code")
> > tab.addField(Name="name", DataType="string", Size=50,
> > Index="idx_name")
> > tab.addField(Name="contact", DataType="string", Size=15)
> > tab.addField(Name="owing", DataType="float", TotalDP=8,
> > RightDP=2, Size=8, Default=0)
> > return tab
> >
> > def initTable(self):
> > cols = ('code','name','contact','owing')
> > return (cols, ((1,"Ken's Kayaks","Ken",100.55),(2,"Bob's
> > Bikes","Bob",234.56)))
> >
> > ci = dabo.db.dConnectInfo(DbType="SQLite", Database="test.db")
> > conn = dabo.db.dConnection(ci)
> > dabo.biz.setupAutoBiz(conn, (Customer,))
> > dabo.biz.autoCreateTables()
> >
> > if __name__ == "__main__":
> > main()
> > --------------------------------------------------------------------
> >
> > Any pointers welcome.
> >
> > Mark Doukidis
>
> Cool, that didn't take as long as I though it would. I just commited
> the fix for it.
>
> PS. I'm glad I'm not the only one using the autoBizobj feature.
>
>
> --
> "Now that I am a Christian I do not have moods in which the whole
> thing looks very improbable: but when I was an atheist I had moods in
> which Christianity looked terribly probable."
> -C. S. Lewis
>
> -Echo
>
> _______________________________________________
> Post Messages to: [email protected]
> Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
>
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
