[sqlalchemy] Re: SQLAlchemy & Teradata

2016-12-06 Thread Mark Sandan
There is also a tutorial here https://developer.teradata.com/tools/articles/teradata-sqlalchemy-introduction It's a hands on way of getting started with SQLAlchemy but using the Teradata Dialect. I wrote it in such a way so that the details of the dialect aren't that significant so hopefully

[sqlalchemy] SQLAlchemy & Teradata

2016-11-30 Thread Mark Sandan
Hello group, I'd like to announce a dialect for the Teradata database! I'm still learning a lot about SQLAlchemy and ORMs in general. The dialect isn't "production" ready per se but it provides a functioning base for future Dialects against Teradata. I have a gitter:

Re: [sqlalchemy] Dialects supporting autocommit in the current session

2016-09-27 Thread Mark Sandan
, Mike Bayer wrote: > > > On 09/26/2016 09:25 PM, Mark Sandan wrote: > > Hi, > > I was wondering if there exists a dialect-wide way to query whether > > the underlying database is in a transaction mode that requires an > > autocommit or not. In Teradata, ther

[sqlalchemy] Dialects supporting autocommit in the current session

2016-09-26 Thread Mark Sandan
Hi, I was wondering if there exists a dialect-wide way to query whether the underlying database is in a transaction mode that requires an autocommit or not. In Teradata, there is this notion of a transaction mode. When a session in Teradata is in a certain transaction mode (TDBS), autocommits

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

2016-05-23 Thread Mark Sandan
Sunday, May 22, 2016 at 8:23:14 PM UTC-7, Mike Bayer wrote: > > OK so we'll probably just add the hook you've proposed. > > I've not had anytime to work on a computer for like five days straight > which puts me super behind, ill try to get to your PR soon. > > > On 05

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

2016-05-20 Thread Mark Sandan
I recommend Mike's article from the open source architecture book . It helped me understand where dialects fall in relation to the other SQLAlchemy components and it provided a great overview in general. I bootstrapped off of what other dialects did

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

2016-05-19 Thread Mark Sandan
wrote: > > 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 >

[sqlalchemy] Create Table DDL options before "("

2016-05-18 Thread Mark Sandan
Hi, I'm implementing a dialect for sqlalchemy and would like to add options before the '(' but after the table name in visit_create. I know I can just subclass visit_create in my ddl compiler but it seems kind of silly since I'd be making a small change. Something like the following: def