Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- def get_sql_engine():
- import sqlalchemy
- db_conn_info = get_conn_info()
- engine_string = '{db_type}://{user}:{password}@{server}:{port}/{database}'.format(
- db_type=db_conn_info['databasetype'],
- user=db_conn_info['username'],
- password=db_conn_info['password'],
- server=db_conn_info['server'],
- port=db_conn_info['port'],
- database=db_conn_info['databasename']
- )
- return sqlalchemy.create_engine(engine_string)
- if __name__ == '__main__':
- sql_engine = get_sql_engine()
- agingar = pd.read_sql_table('agingar', sql_engine)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement