Re: [sqlalchemy] Dialect not replacing ? with parameter

2016-05-19 Thread John Omernik
Hey Mike, thanks for the reply. I feel really bad in that I am struggling on this, a little background, I am trying to get Caravel, which uses SQL Alchemy to play nice with Apache Drill, this means I am learning about dialects through a crash course of feeling really dumb, I've had some success

Re: [sqlalchemy] Is there a good doc page/tutorial for writing a dialect?

2016-05-19 Thread John Omernik
Appreciate the link Mike. Not to sound ungrateful, but is there any thing more specifc on the various items within the base.py file that I can do? The Access example is great, and I've copied that as my base, but understanding a bit more on the the under the hood methods would be helpful. I think

Re: [sqlalchemy] Dialect not replacing ? with parameter

2016-05-19 Thread Mike Bayer
a SQL query that uses parameters will use ? if the DBAPI uses "qmark" paramstyle which is very common. The actual value that lines up with the ? is part of the "parameters" sequence. The specification for this is at https://www.python.org/dev/peps/pep-0249/#id15 which also links out to

Re: [sqlalchemy] Is there a good doc page/tutorial for writing a dialect?

2016-05-19 Thread Mike Bayer
the guidelines we have are in a README you can see here: https://github.com/zzzeek/sqlalchemy/blob/master/README.dialects.rst however, the best way to really get into the methods and things is to look at the existing dialects and see what they are doing.we don't have extensive

[sqlalchemy] Dialect not replacing ? with parameter

2016-05-19 Thread John Omernik
I am writing my own dialect, and for some reason, when my application sets a limit via parameter, the query submitted to the back end just has ? in it. Is this an issue with the dialect, the pyodbc (doubt it's that), or the ODBC driver itself? Thanks, John -- You received this message

[sqlalchemy] Is there a good doc page/tutorial for writing a dialect?

2016-05-19 Thread John Omernik
I am trying to write a new dialect, and while many things are fairly obvious, many are also not. It would be helpful to point to some docs on how the dialect writing works, what events/methods we can overwrite and what it can help us do. Thanks! John -- You received this message because

Re: [sqlalchemy] Create Table DDL options before "("

2016-05-19 Thread Mark Sandan
Sure, the Teradata database has create table ddl where you can specify certain options that are separated by commas. We have a reference manual available online specifying the full DDL here

Re: [sqlalchemy] Create Table DDL options before "("

2016-05-19 Thread Mike Bayer
saw your pull request, just curious what database / DDL is this? Just like to see the finished product that you're going for. On 05/18/2016 09:19 PM, Mark Sandan wrote: Hi, I'm implementing a dialect for sqlalchemy and would like to add options before the '(' but after the table name in

Re: [sqlalchemy] How to map class to multiple tables (for sharding purpose)

2016-05-19 Thread Mike Bayer
On 05/19/2016 08:58 AM, Михаил Доронин wrote: Suppose I have models (with corresponding tables) in pseudocode table1 | some_unique_name | some_property | |--+---| | foo | 1 | |--+---| | bar | 2

Re: [sqlalchemy] Re: SQLAlchemy 1.0.13 released

2016-05-19 Thread Jonathan Vanasco
I rarely think in terms of hits anymore, just free memory and cpu. Apache is still a bit too greedy for me, so I prefer to offload onto a cdn and or use nginx to free up resources. -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe

[sqlalchemy] Re: mysql/sqlite date workaround

2016-05-19 Thread Jonathan Vanasco
The bigger issues with a lot of the date operations are the the internal db representations, different functions in each db, and the nonstandardness of driver behavior. Sqlalchemy does a lot, even when it looks like it doesn't. -- You received this message because you are subscribed to the

[sqlalchemy] How to map class to multiple tables (for sharding purpose)

2016-05-19 Thread Михаил Доронин
Suppose I have models (with corresponding tables) in pseudocode table1 | some_unique_name | some_property | |--+---| | foo | 1 | |--+---| | bar | 2 | |--+---|

Re: [sqlalchemy] mysql/sqlite date workaround

2016-05-19 Thread Михаил Доронин
Completely forgot! Thank you, Mike. That works. On Tuesday, 17 May 2016 00:43:07 UTC+3, Mike Bayer wrote: > > > > On 05/16/2016 04:34 PM, Михаил Доронин wrote: > > I've opened issue here > > < > https://bitbucket.org/zzzeek/sqlalchemy/issues/3714/sqlalchemy-core-returns-string-instead-of>, > >