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()
