[sqlalchemy] Help to use no auto rehashing in sqlchemy.

2019-09-23 Thread ashish vicky
Hello All, Can someone help me use no auto rehashing (as what is used in mysql using option -A) using create _engine in sqlalchemy.I want to reduce time in connecting with mysql using sqlalchemy to optimese performance of our application. Thanks, Ashish. -- SQLAlchemy - The Python SQL

[sqlalchemy] Re: SA support for SQLite ATTACH?

2015-09-15 Thread Ashish Srivastava
Thanks it is nice post. I also refer very useful and helpful article about SQLite - ATTACH DATABASE Please visit this helpful article. http://www.mindstick.com/blog/10947/SQLite%20ATTACH%20DATABASE#.VffLzhFViko http://www.tutorialspoint.com/sqlite/sqlite_attach_database.htm -- You received this

[sqlalchemy] mysql isolation _level

2012-02-28 Thread Ashish
How to set isolation_level for mysql create_enggine in pool configuration code. currently i get following error: Invalid argument(s) 'isolation_level' sent to create_engine(), using configuration MySQLDialect_mysqldb/QueuePool/Engine. Please check that the keyword arguments are appropriate for

[sqlalchemy] Re: Dynamic making of the where clause

2009-06-27 Thread Ashish Bhatia
Thanks for the reply but still m not able to make as i stated in the example regarding the input On Jun 26, 8:27 pm, Michael Bayer mike...@zzzcomputing.com wrote: Ashish Bhatia wrote: :( Is it possible ! On Jun 23, 3:32 pm, Ash ashishsinghbha...@gmail.com wrote: Hello, I am tryin

[sqlalchemy] Re: Dynamic making of the where clause

2009-06-26 Thread Ashish Bhatia
:( Is it possible ! On Jun 23, 3:32 pm, Ash ashishsinghbha...@gmail.com wrote: Hello, I am tryin to make the dynamic where clause using append_whereclause. But how i can do that,  For eg : I have a==b and c in (1,2,3,4) or d like %s So i made three sqlalchemy expression 1. a==b 2. c

[sqlalchemy] Re: Dynamic making of the where clause

2009-06-26 Thread Ashish Bhatia
Thanks But i get input as [['a==b'],'and', [object of sqlalchemmy binary expression],'and','(', ['x==y'],'or',['t==y'],')'] for a==b and id in(1,2,3,4,5) and (x==y or t==y) Now from this ;list input i want to make the where expression. I tried making all to the string but the objects (binary

[sqlalchemy] Re: insert statment

2009-06-08 Thread Ashish Bhatia
Sorry, Its my typing mistake :( . I put : insted , . But still my question yeat remained unanswered. :( On Jun 8, 7:50 pm, Didip Kerabat did...@gmail.com wrote: You have Syntax Error here: ('sdsd':'sdsds') That one should be tuple right? - Didip - On Mon, Jun 8, 2009 at 6:14 AM, Ash

[sqlalchemy] Re: making join with using clause

2009-05-28 Thread Ashish Bhatia
Thanks. I have one more question do we have the option of making different type of joins ? i have seen in docs it says it have join and outer join only What abbt left outer right outer natural cross and many ... On May 28, 9:00 pm, Michael Bayer mike...@zzzcomputing.com wrote: SQLAlchemy SQL

[sqlalchemy] Re: Creating SQL Expression

2009-02-25 Thread Ashish Bhatia
sorry its resolved and working On Feb 25, 12:20 pm, Ash ashishsinghbha...@gmail.com wrote: Hello , I am trying to make query like select (a+b) from xyz; to do this xyz = sqlalchemy.Table('xyz',metadata) a = sqlalchemy.Column('a', sqlalchemy.Integer) xyz.append_column(a) b =

[sqlalchemy] Re: Creating SQL Expression

2009-02-25 Thread Ashish Bhatia
The problem is still their. The two seprate list of columns = List of sqlalchem object operator = ['+'','-'] using join to join them will convert the columns object to string which is not desirable. Any way to fix this. On Feb 25, 3:54 pm, Ashish Bhatia ashishsinghbha...@gmail.com wrote

[sqlalchemy] Re: Creating SQL Expression

2009-02-25 Thread Ashish Bhatia
= Table('bobloblaw', MetaData(), Column('a', Integer), Column('b', Integer), Column('c', Integer)) t.c.a + t.c.b # evaluates to sqlalchemy.sql.expression._BinaryExpression object at 0x1ec9ff0 print t.c.a + t.c.b #  bobloblaw.a + bobloblaw.b On Wed, Feb 25, 2009 at 1:25 PM, Ashish Bhatia

[sqlalchemy] Re: Creating SQL Expression

2009-02-25 Thread Ashish Bhatia
@googlegroups.com [mailto:sqlalch...@googlegroups.com] On Behalf Of Ashish Bhatia Sent: 25 February 2009 13:26 To: sqlalchemy Subject: [sqlalchemy] Re: Creating SQL Expression The problem is still their. The two seprate list of columns = List of sqlalchem object operator = ['+'','-'] using join