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.
