Advertisement
Guest User

Untitled

a guest
Nov 21st, 2016
59
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.56 KB | None | 0 0
  1. def get_sql_engine():
  2. import sqlalchemy
  3.  
  4. db_conn_info = get_conn_info()
  5.  
  6. engine_string = '{db_type}://{user}:{password}@{server}:{port}/{database}'.format(
  7. db_type=db_conn_info['databasetype'],
  8. user=db_conn_info['username'],
  9. password=db_conn_info['password'],
  10. server=db_conn_info['server'],
  11. port=db_conn_info['port'],
  12. database=db_conn_info['databasename']
  13. )
  14.  
  15. return sqlalchemy.create_engine(engine_string)
  16.  
  17.  
  18. if __name__ == '__main__':
  19. sql_engine = get_sql_engine()
  20. agingar = pd.read_sql_table('agingar', sql_engine)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement