[web2py] Re: SQlite to Postgres insert problems

2015-11-19 Thread Carla Raquel
Problem solved!Everything is working fine now! quarta-feira, 18 de Novembro de 2015 às 15:35:32 UTC, Carla Raquel escreveu: > > I'm having some troubles importing from csv files while using a Postgres > connection, when a table has one or more references to other tables like so: > > db.define_tab

[web2py] Re: SQlite to Postgres insert problems

2015-11-18 Thread Anthony
You can use the method to export/import the all tables at once - that will handle all the references automatically. If you want to limit it to a subset of the tables, just run the export/impo

Re: [web2py] Re: sqlite to postgres

2012-03-29 Thread Wikus van de Merwe
Upgrade. Python 2.7 is backward compatible with 2.6. Pip install is also a good option.

Re: [web2py] Re: sqlite to postgres

2012-03-28 Thread Massimo Di Pierro
true. cpdb was rewrtten and requires 2.7. I think it is the only module/script that requires 2.7. On Wednesday, 28 March 2012 17:43:48 UTC-5, Marco Tulio wrote: > > That sounds what I need > > but: > > ubuntu@ip:/home/www-data/web2py$ python scripts/cpdb.py -h > Traceback (most recent call l

Re: [web2py] Re: sqlite to postgres

2012-03-28 Thread Marco Tulio Cicero de M. Porto
seems to work, but I still couldn't make it work on my project (worked well on smaller projects though) 2012/3/27 Anthony > http://web2py.com/books/default/chapter/29/6#CSV-(all-tables-at-once) > > > On Tuesday, March 27, 2012 11:26:17 AM UTC-4, Marco Tulio wrote: >> >> Hi! >> >> I was using sql

Re: [web2py] Re: sqlite to postgres

2012-03-28 Thread Marco Tulio Cicero de M. Porto
That sounds what I need but: ubuntu@ip:/home/www-data/web2py$ python scripts/cpdb.py -h Traceback (most recent call last): File "scripts/cpdb.py", line 5, in import argparse ImportError: No module named argparse then I read somewhere this: 1down vote The argparse module was added i

[web2py] Re: sqlite to postgres

2012-03-27 Thread nick name
On Tuesday, March 27, 2012 11:26:17 AM UTC-4, Marco Tulio wrote: > > How do I get the data that was on my app (on the sqlite database). Web2py comes with scripts/cpdb.py, which copies databases from one connection string to another with lots of other goodies. see http://web2py.com/books/defaul

[web2py] Re: sqlite to postgres

2012-03-27 Thread Anthony
http://web2py.com/books/default/chapter/29/6#CSV-(all-tables-at-once) On Tuesday, March 27, 2012 11:26:17 AM UTC-4, Marco Tulio wrote: > > Hi! > > I was using sqlite as my database for a few projects, but decided to go to > postgres. > > While to web2py going from one to another is pretty much a