well. I disagree. ;-) http://web2py.com/AlterEgo/default/show/215
On 30 oct, 12:42, Thadeus Burgess <[email protected]> wrote: > Just my 2 cents. > > Using the DAL on anything but web2py is going to be a pain in the ass and a > nightmare waiting to happen. This is due to its inherent forced procedural > coding style. You "can" wrap DAL calls as methods, but it just gets really > messy. I'm a clean code zealot, so I bet I care more than most. > > For any kind of software your developing that uses object oriented > programming, use a database system that is structured around classes and > declarative bases. You will find this is much much much easier to integrate > into, for example a wxWidgets program, than the DAL is. > > -- > Thadeus > > On Sat, Oct 30, 2010 at 7:29 AM, Stef Mientki <[email protected]>wrote: > > > On 30-10-2010 12:06, rochacbruno wrote: > > > Look this simple example: > > > http://bitbucket.org/rochacbruno/dal_on_flask/src/tip/dalFlask.py > > > I have a PyGTK app running very well, I will put the code online soon. > > > hi Bruno, > > > one other question, > > in the gtk application, > > do you access the database through a local server, > > or direct through a local disk location ? > > And in the latter case, how do you specify a hard disk location ? > > > thanks, > > Stef > > > Em 30/10/2010, às 06:33, Stef Mientki <[email protected]> escreveu: > > > 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. > >
