RE: [Pythoncard-users] Re: creating SQL insert/Update stmts

[Kevin A. <al...@se...>]

Another pre morning coffee email, let's see if I do better this time <wink>

> From: ralph heimburger
>
> I am looking for an easy way to create the insert/update SQL
> statements and how to reference self.components.<TextField>.text objects.
>
> Is there a programatic way to do a for fieldname in
> self.components.fields???

self.components is a custom dictionary based on the UserDict class.

http://www.python.org/doc/current/lib/module-UserDict.html

Since components is a "mapping" type object that means the standard mapping
operations apply.

http://www.python.org/doc/current/lib/typesmapping.html

Using that info, we can run the widgets sample with the shell (-s on the
command-line) to experiment. There are actually several ways you could solve
your problem. If you just want to match components of type TextField and not
subclasses of TextField like TextArea, then the second comparison below
(c.__class__ is TextField) is probably what you want to use. You can also do
a string compare against the __class__.__name__ if you don't want to import
the class.

>>> from PythonCardPrototype.components.textfield import TextField
>>> for c in self.components.itervalues():
...     if isinstance(c, TextField):
...         print c.name
...
fldPasswordField
fldTextFieldNoBorder
fldTextArea
fldTextField
>>> for c in self.components.itervalues():
...     if c.__class__ is TextField:
...         print c.name
...
fldTextFieldNoBorder
fldTextField
>>> self.components.fldTextField.__class__.__name__
'TextField'
>>>

You can also give the fields you want to process special names or a special
prefix that you can compare against in a loop. You might also want to keep
your own list of what you want to process. For example, in the
openBackground event handler, create a list like:

    self.fieldNames = ['SSN', 'FirstName']

Then when you need to process those fields you can loop over the list. The
loop below would print out the text of the SSN and FirstName fields.

    for name in self.fieldNames:
        print self.components[name].text

> How would I handle date columns?

I don't know what you mean.

> insstmt="INSERT INTO MEMBER ("
>             for colname in self.rowsDict: insstmt=insstmt+colname+","
>             insstmt=insstmt[1:len(insstmt)-1]+") VALUES ("
>             ##for textvalue in self.components:
>             insstmt=insstmt+"'"+self.components.SSN.text+"',"
>             insstmt=insstmt+"'"+self.components.FirstName.text+"',"
>             ... (60+fields)

ka
p.s. Just in case anyone was wondering, yes components will probably become
a direct subclass of the built-in dict type instead of UserDict. When
PythonCard was started we were using Python 2.1. I'll add that to the 0.8 to
do list.