> That's funny because Oracle and SQL server are utterly, totally different > from a SQL quirks perspective. If I were to pick two dialects in SQLA > that were *most* different from each other and also non-standard, those > would be the two.
I was a bit puzzled by this also (granted this was from some early press release I dredged up* from google). I'm still working through their documentation and haven't run across any configuration that might enable a compatability mode yet. * "improved compatibility with Oracle and SQLServer SQL dialects" http://www.vertica.com/company/news_and_events/Vertica-Analytics-Database-2.5-The-Most-Cost-Effective-Way-To-Modernize-Data-Warehousing > create_engine() >> using 'mssql+pyodbc' seems to work but upon attempting to execute a >> simple select statement, I get a programming error indicating the >> following failed to run: >> >> 'SELECT user_name() as user_name;' >> >> >> So it seems the dialect is getting some additional state under the >> hood. lib/sqlalchemy/dialects/mssql/pyodbc.py appears to be hooking >> PyODBCConnector and MSDialect together. Is it possible to specify >> another dialect here? If so, is there any documentation on how to do >> so? > > you'd want to make yourself a "vertica" dialect module that imports the > PyODBCConnector and uses it as a mixin. I'd suggest copying one of the > existing dialects, and probably not the SQL server one unless you know > that vertica has a lot of the transact-SQL lineage that SQL server does > (the PG and SQLite dialects are the most barebones). To run it, add a > setup.py which configures your library as a setuptools entry point, in > this case the name would be "vertica+pyodbc": > > from setuptools import setup > > setup(name="SQLAVertica", > description="...", > entry_points={ > 'sqlalchemy:plugins': > ['vertica+pyodbc = mypackage.base:VerticaDialect'] > } > > > then using create_engine('vertica+pyodbc://user:p...@host/dbname') will load > in your dialect. > > -- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To post to this group, send email to sqlalch...@googlegroups.com. > To unsubscribe from this group, send email to > sqlalchemy+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/sqlalchemy?hl=en. > > > >
-- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalch...@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.