Hi Paolo the script mentioned in the book python scripts/cpdb.py \ -f applications/app/databases \ -y 'sqlite://storage.sqlite' \ -Y 'postgres://username:password@localhost/mydb' \ -d ../gluon
can no longer find DAL. What is the correct -d ? (if you know) thanks in advance, Ben On Friday, March 6, 2015 at 2:50:49 AM UTC-8, Paolo Valleri wrote: > > Instantiate DAL with migrate=False is enough to guarantee the > read-only-mode operations. > In addition accessing the db using an user without write permissions is > better if you only have to dump data. > > To copy data from one db to an other, have a look at > https://github.com/web2py/web2py/blob/master/scripts/cpdb.py > > Paolo > > On Friday, March 6, 2015 at 12:30:02 AM UTC+1, Michel Krav wrote: >> >> Hi , >> >> I need to dump some tables from oracle db let's call it *dbo *into >> sqlite *db *to allow a "disconnect/offline" mode for an app. >> >> I' ve already done this stuff using cx_oracle, building a cursor, then my >> own SQL requests..., now I'm looking to ease those tasks. >> [So no problem to connect oracle dbo using cx_oracle even in web2py] >> >> But I'm not really sure about how to do it using DAL : >> >> 1. Once define connexion to oracle dbo is done : (using lazy_tables=True >> to enhance performance as hundred of table have to be read but not >> for each request) >> 2. I've read I have to *define_table* manually for each table I want >> to query, (to instantiate table class and attributes) >> 3. In the signature of define_table : I plan to secure the *"read >> only mode"* to *dbo *using* migration = False *and *fake_migration* >> = *True *in order to never alter the source table : is it correct ? I >> will specify *redefine = False* for the same reason. By the way , I >> think there's a mistake in the online documentation in >> >> http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Fixing-broken-migrations >> >> : >> >> db.define_table(....,migrate=True,fake_migrate=True) >> should be in this context : >> db.define_table(....,migrate=False,fake_migrate=True) >> >> >> 4. Once *dbo*.table is available, I should use export_to_csv_file method >> then import_from_csv_file to (re)load *db.table * when needed >> (synchronisation >> on demand). >> >> Thanks. >> > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.