Re: [sqlalchemy] Re: How to load data into existing database tables, using sqlalchemy?

2015-07-21 Thread Ivan Evstegneev
Hello again ))) I solved my problem (after thorough re-reading of SA docs) Here is the code: import (all the relevant import here) def alchemy_current(): system_data = load_current_system_data() engine = cretae_engine('mysql+pymysql://user:pass@locahost/my_db') meta = MetaData()

Re: [sqlalchemy] Re: How to load data into existing database tables, using sqlalchemy?

2015-07-19 Thread Mike Bayer
On 7/19/15 4:58 PM, Ivan Evstegneev wrote: Thanks for the reply. if by online examples you mean that you're just reading blog posts and things trying to find a code snippet that matches what you're doing, then yes, that's a wasteful use of time :) Wrong! ^_^ I'm not a lazy one. I'm

Re: [sqlalchemy] Re: How to load data into existing database tables, using sqlalchemy?

2015-07-19 Thread Ivan Ogasawara
Hi Ivan, Maybe you may iterate over the system_data[table_name] to execute your conn.execute. 2015-07-19 17:58 GMT-03:00 Ivan Evstegneev bravo@gmail.com: Thanks for the reply. if by online examples you mean that you're just reading blog posts and things trying to find a code snippet

Re: [sqlalchemy] Re: How to load data into existing database tables, using sqlalchemy?

2015-07-19 Thread Mike Bayer
On 7/19/15 4:33 PM, Ivan Evstegneev wrote: Someone? Please. On Sunday, July 19, 2015 at 6:02:13 PM UTC+3, Ivan Evstegneev wrote: I have my data loaded from excel files and organized as python dict where each key is database table name and its value is defined as list

[sqlalchemy] Re: How to load data into existing database tables, using sqlalchemy?

2015-07-19 Thread Ivan Evstegneev
Someone? Please. On Sunday, July 19, 2015 at 6:02:13 PM UTC+3, Ivan Evstegneev wrote: http://stackoverflow.com/questions/31501999/how-to-load-data-into-existing-database-tables-using-sqlalchemy?noredirect=1# I have my data loaded from excel files and organized as python dict where

Re: [sqlalchemy] Re: How to load data into existing database tables, using sqlalchemy?

2015-07-19 Thread Ivan Evstegneev
Thanks for the reply. if by online examples you mean that you're just reading blog posts and things trying to find a code snippet that matches what you're doing, then yes, that's a wasteful use of time :) Wrong! ^_^ I'm not a lazy one. I'm also reading sqla official documentation, but