如何使用create_engine在sqlalchemy中使用数据库？

Question

现在；我得到以下错误：

    ProgrammingError: (psycopg2.ProgrammingError) relation "tableName" does not exist
    LINE 2: FROM tableName

我以为这是因为我没有在会话中使用那个数据库；所以我去处理使用session.execute并使用sql语句use来使用数据库，但它给我带来了语法错误

engine = create_engine('postgresql://postgres:passwordhere@localhost:5432/test1')

sa.orm.configure_mappers()  # IMPORTANT!
Base.metadata.create_all(engine)
session = sessionmaker(bind=engine)()
session.connection().connection.set_isolation_level(0)
session.execute('USE DATABASE test1;')
session.connection().connection.set_isolation_level(1)

 cursor.execute(statement, parameters)
sqlalchemy.exc.ProgrammingError: (psycopg2.ProgrammingError) syntax error at or near "USE"
LINE 1: USE DATABASE test1;
        ^
 [SQL: 'USE DATABASE test1;'] (Background on this error at: http://sqlalche.me/e/f405)

check_if_exists=session.query(latest_movies_scraper).filter_by(name=dictionary['title']).first（）

 if check_if_exists:
                    print check_if_exists.name
                    print 'skipping this...'
                    pass
                else:
                    insert_to_db = latest_movies_scraper(name=dictionary['title'], url=dictionary['href'], image_url=dictionary['featured_image'])
                    session.add(insert_to_db)
                    session.commit()   

class latest_movies_scraper(Base):
    __tablename__ = 'latest_movies_scraper'


    id = sa.Column(sa.Integer, primary_key=True)
    name = sa.Column(sa.Unicode(255))
    url = sa.Column(sa.Unicode(255))
    image_url = sa.Column(sa.Unicode(255))
    create = sa.Column(sa.DateTime, default=datetime.datetime.utcnow)
    search_vector = sa.Column(TSVectorType('name'))

Answer 1

mssql+pyodbc://servername/Databasename?driver=ODBC Driver 13 for SQL Server
eng = create_engine(mssql+pyodbc://servername/Databasename?driver=ODBC Driver 13 for SQL Server)

Session = sessionmaker(bind=eng, autoflush=false)
db = Session()

对于select use db.query（“select*from tableName”），还可以使用db.execute（“select query”）