Python get_connection_string示例

示例#1

文件： init_db.py 项目： derElektrobesen/grid_calc

def init_db(dbhost, dbport = 5432):
    SQLALCHEMY_DATABASE_URI = settings.get_connection_string(dbhost, dbport)

    engine = create_engine(SQLALCHEMY_DATABASE_URI, convert_unicode=True)
    db_session = scoped_session(sessionmaker(autocommit=True, autoflush=True, bind=engine))
    Base = declarative_base()
    Base.query = db_session.query_property()

    init_models(Base)

    Base.metadata.drop_all(bind=engine)
    Base.metadata.create_all(bind=engine)

示例#2

文件： init_db.py 项目： derElektrobesen/grid_calc

def init_db(dbhost, dbport=5432):
    SQLALCHEMY_DATABASE_URI = settings.get_connection_string(dbhost, dbport)

    engine = create_engine(SQLALCHEMY_DATABASE_URI, convert_unicode=True)
    db_session = scoped_session(
        sessionmaker(autocommit=True, autoflush=True, bind=engine))
    Base = declarative_base()
    Base.query = db_session.query_property()

    init_models(Base)

    Base.metadata.drop_all(bind=engine)
    Base.metadata.create_all(bind=engine)

示例#3

def get_cursor():
    db = psycopg2.connect(settings.get_connection_string())
    db.autocommit = True
    return db.cursor(cursor_factory=psycopg2.extras.RealDictCursor)

示例#4

def init_conn_string(dbhost, dbport = 5432):
    app.config.update(dict(SQLALCHEMY_DATABASE_URI=settings.get_connection_string(dbhost, dbport)))