And what would be the utility since you already have INSERT INTO TABLE...
Someone can just use something like SQLite Manager (
https://addons.mozilla.org/en-us/firefox/addon/sqlite-manager/) to import
it... Once in SQLite DB (which anyway it should) he can use web2py csv
export import if he want to migrate from SQLite to Postgres for instance...
Richard
On Tue, Apr 21, 2015 at 3:55 PM, Niphlod <niph...@gmail.com> wrote:
>
>
> On Tuesday, April 21, 2015 at 9:39:14 PM UTC+2, Ron Chatterjee wrote:
>>
>> I tried this:
>>
>> db =
>> DAL('mysql://root@127.0.0.1:8000/my_database_name',migrate_enabled=False,
>> pool_size=20)
>>
>> It didn't work either. I guess someone needs to look at how to connect to
>> legacy database.
>>
>>
> where is the password ?!
>
> BTW: I think there's a bit of misunderstandings going on in this thread.
> There are two separate concept at play: schema (structure) AND data.
> Every script/extract_***_models.py can "inspect" an existing database and
> figure out (with limitations) the model you should write to access that
> database --> schema (or structure) translated to nifty
> "db.define_table(....)"
>
> Exporting and importing a csv (compatible with what web2py generates)
> instead - again, with limitations - is the way to transfer data around.
>
> If you have a long list of SQL statements in a file, those are NOT going
> to work.
> There's virtually nothing that reverse-engineers table definitions such as
> "CREATE TABLE ....." to a model file, nor something that turns "INSERT INTO
> TABLE..." to a db.table.insert(), although it can be fun to create one
> (with lots of headaches).
>
> --
> 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.
>
--
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.
