Python startEngine Examples

Example #1

 def getPricesFromDB(self):
     engine = dbconnection.startEngine()
     priceFrame = pd.read_sql(("SELECT * FROM " + self.assetDBs[1] +
                       " WHERE code = %(code)s AND "
                       "date <= %(eDate)s AND date >= %(sDate)s"),
                       engine,
                       params={"code":self.code,"eDate": self.eDate,
                               "sDate":self.sDate})
     return priceFrame

Example #2

File: updateIndex.py Project: ack8006/dataAggregation2

def storePriceData(indexDBs, priceData):
    engine = db.startEngine()
    priceData.to_sql(indexDBs[1], engine, if_exists='append')