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.
