def load_formula(self, formula_name):
query = select([Formulas]).where(Formulas.formula == formula_name)
df = pd.read_sql(query, self.engine)
if not df.empty:
return decode_formula(df.loc[0, 'formula_desc']['desc'])
def load_all_formulas(self):
query = select([Formulas])
df = pd.read_sql(query, self.engine, index_col='formula')
if not df.empty:
return pd.Series({name: decode_formula(df.loc[name, 'formula_desc']['desc']) for name in df.index})
