On Sunday 17 August 2008 2:08:00 am Sibylle Koczian wrote:
> "Paul McNett" <[EMAIL PROTECTED]> schrieb:
> > Sibylle Koczian wrote:
> > > as I'm slowly working through this guide, I get the next error: when I
> > > try to save a new record for the "hours" table, the error messages are:
> > >
> > > 1. "Notice" message box:
> > > Save Failed:
> > >
> > > table hours has no column named clientname
> > > SQL: insert into "hours"
> > > ("clientfk", "notes", "hours", "servicedate", "billed", "clientname")
> > > values (1, 'Test', 2.00, '2008-08-16', '', NULL)
> > >
> > > 2. In the terminal:
> > >
> > > Dabo Error Log: Sat Aug 16 16:02:14 2008: !!! Data Type Mismatch:
> > > field=servicedate. Expecting: <type 'unicode'>; got: <type
> > > 'datetime.date'> Dabo Info Log: Sat Aug 16 16:02:14 2008: Key '0' not
> > > found
> > >
> > > Why this? In the database the field has type "date", and only using the
> > > Python sqlite3 module I can use a datetime.date object as parameter to
> > > an insert statement.
> >
> > Does the save happen okay, even though you get the message? It is
> > probably an erroneous error message.
>
> Looking at this a second time I see that the message is printed when the
> forms
> "new" method is executed, not at saving time. The save happens. But
> still I don't
> understand it. The control in the form is a dDateTextBox, so shouldn't
> it expect
> a datetime.date object? Or is this SQLite with its non-standard data
> types?
Try changing:
self.DefaultValues = {"servicedate": datetime.date.today()}
to:
self.DefaultValues = {"servicedate": datetime.date.today().isoformat()}
This will return a date string instead of a date object.
The other option is to explore:
http://paul.dabodev.com/doc/api/dabodoc/dabo.biz.dBizobj.dBizobj.html#Properties_DataStructure
and:
http://dabodev.com/wiki/DataTypes
to explicitly set the data types.
>
> > > Message 1 is quite right, but why has such an insert statement been
> > > generated? And where can I change it?
> >
> > NonUpdateFields should be getting automatically set to not include the
> > foreign/calculated fields. Obviously it didn't happen in this case.
>
> The BizHours code was handwritten (as in the Guide), should
> NonUpdateFields be set
> anyway? Where and by which magician?
Other option is to explore virtual fields:
http://dabodev.com/wiki/VirtualFields
>
> > > The BizObject:
> > >
> > > #!/usr/bin/env python
> > > # -*- coding: utf8 -*-
> > > # BizHours.py
> > > # Step-By-Step Guide to Dabo Programming
> > >
> > > import datetime
> > > import dabo
> > >
> > > class BizHours(dabo.biz.dBizobj):
> > > def afterInit(self):
> > > self.DataSource = "hours"
> > > self.KeyField = "pkid"
> > > self.addField("hours.pkid")
> > > self.addField("hours.clientfk")
> > > self.addField("clients.clientname")
> > > self.addField("hours.servicedate")
> > > self.addField("hours.hours")
> > > self.addField("hours.notes")
> > > self.addField("hours.billed")
> > > self.addFrom("hours")
> > > self.addJoin("clients", "hours.clientfk = clients.pkid")
> > > self.DefaultValues = {"servicedate": datetime.date.today()}
> > >
> > > def getClients(self):
> > > """Return a 2-tuple of lists of the client names and their
> > > keys.""" crs = self.getTempCursor()
> > > crs.execute("select pkid, clientname from clients order by
> > > clientname")
> > > ds = crs.getDataSet()
> > > # Create the lists
> > > names = [rec["clientname"] for rec in ds]
> > > keys = [rec["pkid"] for rec in ds]
> > > return (names, keys)
> > >
> > > And the table structure for the "hours" table (ported to SQLite):
> > >
> > > CREATE TABLE hours (
> > > pkid integer PRIMARY KEY,
> > > clientfk integer NOT NULL,
> > > servicedate date NOT NULL default CURRENT_DATE,
> > > hours real(4,2) NOT NULL,
> > > notes text(240) NOT NULL,
> > > billed tinyint(1) NOT NULL default 0 check(billed in (0, 1))
> > > );
> > >
> > > What is wrong here?
> >
> > First off, get into the habit of putting your property settings in
> > initProperties() instead of afterInit(). Second of all, try explicitly
> > setting NonUpdateFields, like:
> >
> > class BizHours(..):
> > ..
> > def initProperties(self):
> > ..
> > self.NonUpdateFields = ["clientname"]
> > ..
>
> Done and now this works. But shouldn't that be changed in the text of
> the Guide?
>
> New problem with the same application: following your mail about the
> dSpinner
> increment I wanted to put the conversion to Decimal into the
> "initProperties"
> method of the dSpinner, but put it first into "setProperties" by
> mistake. All
> this in the ClassDesigners editor. Now I always get "Indented Block
> expected"
> for the initProperties method (can't cut and paste this, I'm using
> Windows at
> the moment). I can't see anything wrong with the code in the editor.
> What can
> I do? And how can I delete methods I shouldn't ever have used?
>
> Sibylle
--
Adrian Klaver
[EMAIL PROTECTED]
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/[EMAIL PROTECTED]
