def fast_sql_to_df(table, schema):
engine = table.bind
if engine.dialect.name == "mysql":
return fast_mysql_to_df(table, schema)
elif engine.dialect.name == "postgresql":
return fast_postgresql_to_df(table, schema)
ods = OdoDataStore(schema, table)
df = ods.load()
df = df[schema.col_names()]
return df
def fast_sql_to_df(table, schema):
engine = table.bind
if engine.dialect.name == 'mysql':
return fast_mysql_to_df(table, schema)
elif engine.dialect.name == 'postgresql':
return fast_postgresql_to_df(table, schema)
ods = OdoDataStore(schema, table)
df = ods.load()
df = df[schema.col_names()]
return df
def fast_df_to_sql(df, table, schema):
ods = OdoDataStore(schema, table, storage_target_type="sqlalchemy")
ods.store(df)
def fast_df_to_sql(df, table, schema):
ods = OdoDataStore(schema, table, storage_target_type='sqlalchemy')
ods.store(df)
