This is what I was looking for.
https://groups.google.com/forum/#!searchin/web2py/extract_mysql_models.py/web2py/XPoTlzPG7lQ/ngSsMbd6zHAJ
But homehow the code didn't work for me even when I followed the example
like it says. So, I am creating a stand alone version that works with
MySQLdb.
On Tuesday, April 21, 2015 at 4:58:52 PM UTC-4, Ron Chatterjee wrote:
>
> I have sqlite browser. I am guessing its the same like SQlite Manager
> where someone can import, export csv or sql file. I don't have password in
> that database and work externally to the python
>
> *I guess one possibility will be:*
>
> import MySQLdb
>
> import sys
>
> try:
>
> db = MySQLdb.connect(host = 'localhost',user ='root',passwd = ' ',db =
> 'my_dabasename')
>
> except Exception as e:
>
> sys.exit('we cant get into the db');
>
> cursor = db.cursor()
>
> cursor.execute('SELECT *FROM table')
>
> results = cursor.fetchall()
>
> print results
>
>
> Once the table is fetched then use the insert_into_table option to create
> db object.
>
>
> But I agree with Niphlod, import, export csv is probably the only way to
> go around, if it works:-). And also agree with richard. sqlbroser does take
> the storage object as input and can export csv table and then use that back
> to create the database. I was just hoping to directly connect to my local
> server (WAMP) where I have the mysql database defined. I was under the
> impression, db =
> DAL('mysql://[email protected]:8000/my_database_name',migrate_enabled=False,
> pool_size=20) is the way to go about it.
>
>
>
>
>
>
>
> On Tuesday, April 21, 2015 at 4:07:02 PM UTC-4, Richard wrote:
>>
>> 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 <[email protected]> wrote:
>>
>>>
>>>
>>> On Tuesday, April 21, 2015 at 9:39:14 PM UTC+2, Ron Chatterjee wrote:
>>>>
>>>> I tried this:
>>>>
>>>> db =
>>>> DAL('mysql://[email protected]: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 [email protected].
>>> 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 [email protected].
For more options, visit https://groups.google.com/d/optout.
