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)