Thanks Alan for your quick respond! I have check sql.tmp - it contains only 'END'. After adding the print line I have got following message, with no tables([]):
c:\Users\power\PycharmProjects\test_test\web2py>python scripts/cpdb.py -d g -f applications/app/databases -y sqlite://storage.sqlite -Y postgres://post :avh1981@localhost/idna_db1 gluon path not found creating tables... [] exporting data... importing data... done! Any ideas I can do to force the cpdb.py to make tables and delivery what it suppose to do? Thank you in advance! On Monday, January 27, 2014 2:04:51 AM UTC+3, Alan Etkin wrote: > > try: >> import pyreadline as readline >> except ImportError: >> import readline >> > > It seems this win problem should be posted at > http://code.google.com/p/web2py/issues > > >> >> 2)I have created brand new db in postgres. >> >> 3)I have tried to copy data from 1 db to another by following cmd: >> c:\Users\power\PycharmProjects\test_test\web2py>python scripts/cpdb.py >> -d gluon >> -f applications/app/databases -y sqlite://dbs.sqlite -Y >> postgres://postgres:avh >> 1981@localhost/idna_dbs1 -t False >> >> 4)It gave me following results: >> >> gluon path not found >> creating tables... >> exporting data... >> importing data... >> done! >> Attention: do not run this program again or you end up with duplicate >> records >> >> 5)But I have got nothing in my postgresql db! >> > > There should be a sql.tmp file somewhere used for copying the data between > databases (maybe at the command working directory). You can check that to > verify the script is writing the input values. Also check that the script > is retrieving the app model correctly, i.e., adding the following command > in cpdb.py after line 537: > > print other_db.tables > -- 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/groups/opt_out.
