[sqlalchemy] Unlogged Postgresql Table

2014-12-17 Thread Danish Abdullah
What's the recommended way to create, assuming there is a way, an unlogged postgresql table through the ORM? -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To unsubscribe from this group and stop receiving

Re: [sqlalchemy] Unlogged Postgresql Table

2014-12-17 Thread Ladislav Lenart
Hello. On 17.12.2014 16:30, Danish Abdullah wrote: What's the recommended way to create, assuming there is a way, an unlogged postgresql table through the ORM? This might be of help: http://stackoverflow.com/questions/13455207/sqlalchemy-temporary-table-with-declarative-base Just replace

[sqlalchemy] double select in a raw sql?

2014-12-17 Thread jichao liu
hello, in a scenario i want query two table at once : q = article_engine.execute('select * from table1;select * from table2') for i in q: print i.Name how can i get data from the second table? and how to use the orm select ,i only find the usage with engin/session. is there some

[sqlalchemy] aggregate data by date-window over multiple import files

2014-12-17 Thread dewey
This is a fairly vague / abstract question because I'm looking for a design pattern -- I don't yet have any code built (except data importing) toward the problem. I'm importing large excel files (using csv.DictReader) (DB is MySQL / Maria) There are 3 columns in excel: user_id (int)