Re: [sqlalchemy] SQLAlchemy with DSN InterSystems ODBC35

sure but you need to know the structure of those tables. you might want to see if there's a tool that already exists for this database which does this. it seems to be heavy on the JDBC side so perhaps there are java tools that do it. On Thu, Mar 29, 2018 at 10:59 AM, Maki

Re: [sqlalchemy] SQLAlchemy with DSN InterSystems ODBC35

In your knowledge do you think there is a way to use pyodbc to copy all the tables and data in the table in the datasource to ms sql server and then after copying it in the sql server use SQLAlchemy for further process? Am Donnerstag, 29. März 2018 16:54:29 UTC+2 schrieb Mike Bayer: > > On Thu,

Re: [sqlalchemy] SQLAlchemy with DSN InterSystems ODBC35

On Thu, Mar 29, 2018 at 10:46 AM, Maki wrote: > I would love to code a new dialect for SQLAlchemy but i guess my python > skills are not there yet just started to learn python a few months ago. > What i dont understand is why i can connect to that Datasource using >

Re: [sqlalchemy] SQLAlchemy with DSN InterSystems ODBC35

I would love to code a new dialect for SQLAlchemy but i guess my python skills are not there yet just started to learn python a few months ago. What i dont understand is why i can connect to that Datasource using pyodbc.connect(mydsn) with no problems but SQLAlchemy cant? Is there any other way

Re: [sqlalchemy] SQLAlchemy with DSN InterSystems ODBC35

OK this database is an entirely distinct product that has no particular resemblance to SQL server or anything else.You'd have to create your own dialect for this. The most fundamental thing to get working with a dialect is how to fetch identity values for integer primary keys, for this

Re: [sqlalchemy] SQLAlchemy with DSN InterSystems ODBC35

Hi Mike, here is the information about Cache Monitor. Its likely similar to MSSQL thats why i used the msql+pyodbc dialect. https://www.cachemonitor.de/ Secondly about the print(pyodbc_connection.getinfo(pyodbc.SQL_DBMS_VER)) ==> *OUTPUT: Cache Objects Version 2012.2.5.962 Cache xDBC Server

Re: [sqlalchemy] SQLAlchemy with DSN InterSystems ODBC35

On Thu, Mar 29, 2018 at 9:18 AM, Maki wrote: > Hi Mike! > > I think there's a misunderstanding. Im trying to connect to a InterSystem > Cache Database thru ODBC (Datasource) but my MS SQL Server Management Studio > has this version (12.0.5207.0) oh, so the "InterSystem

Re: [sqlalchemy] SQLAlchemy with DSN InterSystems ODBC35

What i think is, in Cache Monitor Database there is no such thing as: SELECT CAST(SERVERPROPERTY('ProductVersion') AS VARCHAR) Not like in a MSSQL Server. Im looking for ways to get the SERVERPROPERTY ProductVersion in Cache Monitor Database. Cant find how to query that in a Cache Monitor

Re: [sqlalchemy] SQLAlchemy with DSN InterSystems ODBC35

Hi Mike! Both gives me the following error message: Traceback (most recent call last): File "db_test.py", line 17, in cursor.execute("SELECT CAST(SERVERPROPERTY('ProductVersion') AS VARCHAR)") pyodbc.Error: ('HY000', "[HY000] [Cache ODBC][State : HY000][Native Code

Re: [sqlalchemy] SQLAlchemy with DSN InterSystems ODBC35

missing a dot: import pyodbc pyodbc_connection = pyodbc.connect(...) print(pyodbc_connection.getinfo(pyodbc.SQL_DBMS_VER)) On Thu, Mar 29, 2018 at 9:29 AM, Mike Bayer wrote: >> I render the code in pyodbc.py and add the pass to the except clause but it >> doesnt

Re: [sqlalchemy] SQLAlchemy with DSN InterSystems ODBC35

> I render the code in pyodbc.py and add the pass to the except clause but it > doesnt help getting the same error message with the str and int like before. OK that may suggest that it is falling back to the base pyodbc version management, so here is the updated patch: diff --git

Re: [sqlalchemy] SQLAlchemy with DSN InterSystems ODBC35

Hi Mike! I think there's a misunderstanding. Im trying to connect to a *InterSystem Cache Database thru ODBC* (Datasource) but my *MS SQL Server Management Studio* has this version (12.0.5207.0) I render the code in pyodbc.py and add the pass to the except clause but it doesnt help getting

Re: [sqlalchemy] Using __getattr__ and __setattr__ with sqlalchemy

send a complete MCVE please On Thu, Mar 29, 2018 at 2:08 AM, Tolstov Sergey wrote: > Before update it worked. But today i have a exception AttributeError: type > object 'Base' has no attribute '__getattr__' > > -- > SQLAlchemy - > The Python SQL Toolkit and Object

Re: [sqlalchemy] SQLAlchemy with DSN InterSystems ODBC35

Hi - unfortunately the stack trace indicates a bug in SQLAlchemy in that it is not interpreting your database's version string correctly. can you please provide me with the output of: SELECT CAST(SERVERPROPERTY('ProductVersion') AS VARCHAR) Additionally, the likely cause of your issue can be

[sqlalchemy] Re: Using __getattr__ and __setattr__ with sqlalchemy

def __getattr__ (self2, key2): if False: pass elif key2 == "attr_new": self2.attr_new = sqlalchemy.Column(UUID, sqlalchemy. ForeignKey(self.RELATED_CLASS.mRID), nullable = True) else: return getattr(self2.__class__, key2)

Re: [sqlalchemy] Using __getattr__ and __setattr__ with sqlalchemy

Solved, return getattr(self2.__class__, key2) -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a

Re: [sqlalchemy] rollback() practice

On Thu, Mar 29, 2018 at 8:57 AM, wrote: > Hello, > > I had some database problems (unfinished transactions) so I have wrapped > sqlalchemy database handling functions in following way: > > def add(entry, session): > """Wrapper for db_session.add""" > try: >

[sqlalchemy] rollback() practice

Hello, I had some database problems (unfinished transactions) so I have wrapped sqlalchemy database handling functions in following way: def add(entry, session): """Wrapper for db_session.add""" try: return session.add(entry) except Exception as e: session.rollback()

Re: [sqlalchemy] How to create multiple TABLES and INSERTS programatically ?

> > Thanks Mike for that quick help. I will try write a new code and test it > out. All 200+ tables are same except the inserted data and table names vary. I will get back to you after I modify my code. Thanks. -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper

Re: [sqlalchemy] Using __getattr__ and __setattr__ with sqlalchemy

Before update it worked. But today i have a exception AttributeError: type object 'Base' has no attribute '__getattr__' -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and