Interesting ...
as I want to migrate to web2py
and want to have some kind of DAL for my desktop applications,
this sounds very good.
Can you give me some guide lines, how to use the web2py DAL for desktop
applications ?
thanks,
Stef Mientki
On 19-10-2010 05:44, Bruno Rocha wrote:
> I know DAL was not made for that, but I'm using the DAL in a desktop
> application with PyGTK, and
> it is working very well :-)
>
> It is a simple application that monitors the presence of employees in a
> company and reads small
> CSV files from a time clock,
> people has cards that open the gates/doors of the company factory, I use a
> stream to read the
> track from serial port of time clock,
> then, I take the information serialized as CSV, I parse and write it into
> SQLite db, after that ,
> the Janitor uses a PyGTK app to access that information.
>
> already been running for about 6 months, So far everything is working fine,
> but I can not run the
> automatic migrations.
>
> Does anyone know a way to make migration work automatically with DAL Stand
> Alone?
>
> I'm importing sql.py I'm connecting with SQLite, setting tables, accessing
> and doing out any crud
> operation.
>
> The only thing missing is to make migration works.
>
> I already set migrate='Mytable.table' and I tried with migrate=True
>
> ----
> An example of what I have working in my
>
> "connect.py"
> >>> from gluon.sql import *
> >>> db = DAL('sqlite://timeclock1.db')
> >>> Track =
> db.define_table('track',Field('regnumber','integer'),Field('action','integer'),Field('timestamp','datetime'),migrate='track.table')
>
> "Form_workflow.py"
> >>> Track.insert(regnumber=123,action=2,timestamp='2010-10-19')
> 1
> >>> Track.insert(regnumber=124,action=2,timestamp='2010-10-19')
> 2
> >>> db.commit
>
> Until here, its ok.
>
> But now I am wanting to change the model, and including Field('department')
>
> "connect.py"
> >>> Track =
> db.define_table('track',Field('regnumber','integer'),Field('action','integer'),Field('timestamp','datetime'),*Field('department')*,migrate='track.table')
>
> Traceback (most recent call last):
> File "<stdin>", line 1, in <module>
> File "/bin/DAL/gluon/sql.py", line 1346, in define_table
> raise SyntaxError, 'invalid table name: %s' % tablename
> SyntaxError: invalid table name: track
> >>>
>
> ----
>
> If this is not possible, I'll have to create new fields in SQLite and then
> update my model.
