class Dao (Connector): con = Connector() def __init__(self): self.db = self.con.generateDBConnector('BIKEWALE') self.db.autocommit(True) self._helper = DaoHeper() def getCursor(self): return self.db.cursor() def getInsertQueryTemplateTest(self, dictObj): placeholders = ', '.join(['%s'] * len(dictObj)) columns = ', '.join(dictObj.keys()) sql = "INSERT INTO %s ( %s ) VALUES ( %s )" % ('new_table', columns, placeholders) return sql def populateAndExecuteTest(self, obj): str = self.getInsertQueryTemplateTest(obj) print str cur = self.getCursor() cur.execute(str, obj.values()) print cur.fetchall() def getInsertQueryTemplate(self, dictObj): columnNameList = self._helper.getKeyToColumnName(dictObj) placeholders = ', '.join(['%s'] * len(columnNameList)) columns = ', '.join(columnNameList) sql = "INSERT INTO %s ( %s ) VALUES ( %s )" % (self.con.BIKEWALETABLE, columns, placeholders) return sql def populateAndExecute(self, dictObj): values = dictObj.values() str = self.getInsertQueryTemplate(dictObj) print str cur = self.getCursor() cur.execute(str, values) print cur.fetchall()
class Dao (Connector): con = Connector() def __init__(self): self.db = self.con.generateDBConnector('BIKEWALE') self.db.autocommit(True) self._helper = DaoHeper() def getCursor(self): return self.db.cursor() def getInsertQueryTemplateTest(self, dictObj): placeholders = ', '.join(['%s'] * len(dictObj)) columns = ', '.join(dictObj.keys()) sql = "INSERT INTO %s ( %s ) VALUES ( %s )" % ('new_table', columns, placeholders) return sql def populateAndExecuteTest(self, obj): str = self.getInsertQueryTemplateTest(obj) print str cur = self.getCursor() cur.execute(str, obj.values()) print cur.fetchall() def getInsertQueryTemplate(self, dictObj): columnNameList = self._helper.getKeyToColumnName(dictObj) placeholders = ', '.join(['%s'] * len(columnNameList)) columns = ', '.join(columnNameList) sql = "INSERT INTO %s ( %s ) VALUES ( %s )" % (self.con.BIKEWALET_STAGE_TABLE, columns, placeholders) return sql def populateAndExecute(self, dictObj): try: values = dictObj.values() str = self.getInsertQueryTemplate(dictObj) cur = self.getCursor() cur.execute(str, values) except: logger.error("DB query execution failed for an obj : " + dictObj) def getInsertQueryTemplateForTemp(self, dictObj): columnNameList = self._helper.getKeyToColumnNameForTemp(dictObj) placeholders = ', '.join(['%s'] * len(columnNameList)) columns = ', '.join(columnNameList) sql = "INSERT INTO %s ( %s ) VALUES ( %s )" % (self.con.BIKEWALE_TEMP_TABLE, columns, placeholders) return sql def populateAndExecuteIntoTemp(self, dictObj): try: values = dictObj.values() str = self.getInsertQueryTemplateForTemp(dictObj) cur = self.getCursor() cur.execute(str, values) except: logger.error("DB query execution failed for an obj : " + dictObj) def select_query_template(self): return 'SELECT profile_id, bike_name, city_posted, kilometer_done,\ color, fuel_type, price, owner_type, model_year, url\ from Bikewale_Stage' def get_entries_from_stage(self): try: str = self.select_query_template() cur = self.db.cursor(MySQLdb.cursors.DictCursor) cur.execute(str) rows = cur.fetchall() return rows except: logger.error("DB query execution failed for an obj : ")
def __init__(self): self.db = self.con.generateDBConnector('BIKEWALE') self.db.autocommit(True) self._helper = DaoHeper()