[Sqlalchemy-tickets] Issue #3962: Unsupported SQLAlchemy of mssql instance (zzzeek/sqlalchemy)
Brought to you by:
zzzeek
From: Ramin <iss...@bi...> - 2017-04-10 10:11:53
|
New issue 3962: Unsupported SQLAlchemy of mssql instance https://bitbucket.org/zzzeek/sqlalchemy/issues/3962/unsupported-sqlalchemy-of-mssql-instance Ramin: Hi, i going to connect of SQLAlchemy to other mssql instance exm: `<ip>\SQLInstance` but i see your [docs](http://docs.sqlalchemy.org/en/latest/dialects/mssql.html#module-sqlalchemy.dialects.mssql.pymssql) SQAlchemy default connect to `.` instance, default instance code : ```python from sqlalchemy import create_engine engine = create_engine('mssql+pymssql://<user>:<pass>@<ip>:1433/database_name') from sqlalchemy.ext.declarative import declarative_base Base = declarative_base() from sqlalchemy import Column, Integer, String class teeetttt(Base): __tablename__ = 'testtetetet' id = Column(Integer, primary_key=True) name = Column(String) fullname = Column(String) password = Column(String) print teeetttt.__table__ ed_user = teeetttt(name='ed', fullname='Ed Jones', password='edspassword') from sqlalchemy.orm import sessionmaker Session = sessionmaker(bind=engine) Session = sessionmaker() Session.configure(bind=engine) session = Session() session.add(ed_user) session.commit() print ed_user.name session.query(teeetttt).all() f = session.query(teeetttt).all() print f[0].name print session.query(teeetttt).all() ``` my goals connect to ```engine=create_engine('mssql+adodbapi://sa:a`123456@172.16.20.181:1433\SQLInstance/DB')``` that `SQLInstance` this is my instance and DB is database name Responsible: zzzeek |