def search_Product(self): connection = con_db() cursor1 = connection.cursor() #cursor2 = connection.cursor() cursor1.execute("SELECT * FROM productmaster") #cursor2.execute("SELECT * FROM productmaster") #cursor1.execute ("SELECT * FROM productmaster AS p INNER JOIN categorymaster AS c ON p.`product_categoryId` = c.`categoryId`") #cursor1.execute("SELECT product_subcategoryId FROM productmaster INNER JOIN subcategorymaster ON productmaster.product_subcategoryId = subcategorymaster.subcategoryId") cursor1.execute( "SELECT * FROM subcategorymaster INNER JOIN productmaster ON product_subcategoryId = subcategoryId INNER JOIN categorymaster ON categoryId=subcategory_categoryId" ) #cursor1.execute("SELECT * FROM productmaster INNER JOIN subcategorymaster ON productmaster.'product_subcategoryId' = subcatrgorymaster.'subcategoryId'") data1 = cursor1.fetchall() #data = cursor2.fetchall() print(data1) #print(data) connection.commit() connection.close() cursor1.close() #cursor2.close() return data1
def update_data(self, firstname, lastname, username, password, id): con_db_obj = con_db() cursor = con_db_obj.connection.cursor() cursor.execute( '''update register_master_mvc set firstname=%s, lastname=%s, username=%s, password=%s where id=%s''', (firstname, lastname, username, password, id)) cursor.connection.commit() cursor.close()
def updateLogin(self,loginVO): connection = con_db() cursor1 = connection.cursor() cursor1.execute("UPDATE loginmaster SET loginEmailId = '{}',loginActiveStatus='{}' WHERE loginId = '{}'".format(loginVO.loginEmailId,loginVO.loginActiveStatus,loginVO.loginId)) connection.commit() cursor1.close() connection.close()
def insert_data(self, firstname, lastname, username, password): con_db_obj = con_db() cursor = con_db_obj.connection.cursor() cursor.execute( '''Insert into register_master_mvc (firstname, lastname, username, password) values(%s, %s, %s, %s)''', (firstname, lastname, username, password)) cursor.connection.commit() cursor.close()
def getMaxId(self): connection = con_db() cursor1 = connection.cursor() cursor1.execute("SELECT MAX(loginId) from loginmaster") loginDict = cursor1.fetchall() cursor1.close() connection.close() return loginDict
def deleteCategory(self, categoryVO): connection = con_db() cursor1 = connection.cursor() cursor1.execute("UPDATE categorymaster SET WHERE categoryId='" + categoryVO.categoryId + "'") connection.commit() connection.close() cursor1.close()
def updateState(self, stateVO): connection = con_db() cursor1 = connection.cursor() cursor1.execute( "UPDATE statemaster SET stateName='{}', stateDescription='{}' WHERE stateId = '{}' " .format(stateVO.stateName, stateVO.stateDescription, stateVO.stateId)) connection.commit() cursor1.close() connection.close()
def searchState(self): connection = con_db() cursor1 = connection.cursor() cursor1.execute( "select * from statemaster WHERE stateActiveStatus='active' ") stateDict = cursor1.fetchall() cursor1.close() connection.close() return stateDict
def deleteProduct(self, productVO): connection = con_db() cursor1 = connection.cursor() cursor1.execute( "UPDATE productmaster SET productActiveStatus='deactive' WHERE productId='" + productVO.productId + "'") connection.commit() connection.close() cursor1.close()
def deleteseller(self, registerVO): connection = con_db() cursor1 = connection.cursor() cursor1.execute( "UPDATE sellerregistermaster SET registerActivestatus='deactive' WHERE registerId='" + registerVO.registerId + "'") connection.commit() cursor1.close() connection.close()
def insertLogin(self,loginVO): connection = con_db() cursor1 = connection.cursor() cursor1.execute("INSERT INTO loginmaster (loginRole,loginEmailId,loginPassword,\ loginActiveStatus) VALUES('{}','{}','{}','{}')".format\ (loginVO.loginRole,loginVO.loginEmailId,loginVO.loginPassword,loginVO.loginActiveStatus)) connection.commit() cursor1.close() connection.close()
def deleteSubcategory(self, subcategoryVO): connection = con_db() cursor1 = connection.cursor() cursor1.execute( "UPDATE subcategorymaster SET subcategoryActiveStatus='deactive' WHERE subcategoryId='" + subcategoryVO.subcategoryId + "'") connection.commit() connection.close() cursor1.close()
def deletebuyer(self, loginVO): connection = con_db() cursor1 = connection.cursor() #cursor1.execute("UPDATE userregistermaster SET userregisterActivestatus='deactive' WHERE userregisterId='" + registerVO.userregisterId + "' ") cursor1.execute( "UPDATE loginmaster SET loginActivestatus='deactive' WHERE loginId='" + loginVO.loginId + "'") connection.commit() connection.close() cursor1.close()
def insertCategory(self, categoryVO): connection = con_db() cursor1 = connection.cursor() cursor1.execute( "INSERT INTO categorymaster (categoryName,categoryDescription,categoryActiveStatus) VALUES ('" + categoryVO.categoryName + "','" + categoryVO.categoryDescription + "','" + categoryVO.categoryActiveStatus + "')") connection.commit() cursor1.close() connection.close()
def searchFeedback(self, feedbackVO): connection = con_db() cursor1 = connection.cursor() cursor1.execute( "SELECT * FROM feedbackmaster JOIN loginmaster ON feedbackmaster.feedbackFrom_loginId=loginmaster.loginId WHERE feedbackActiveStatus='active' " ) data = cursor1.fetchall() connection.commit() cursor1.close() connection.close() return data
def deleteState(self, stateVO): connection = con_db() cursor1 = connection.cursor() cursor1.execute( "UPDATE statemaster SET stateActiveStatus='{}' WHERE stateId = '{}' " .format(stateVO.stateActiveStatus, stateVO.stateId)) connection.commit() cursor1.close() connection.close()
def insertState(self, stateVO): connection = con_db() cursor1 = connection.cursor() cursor1.execute( "INSERT INTO statemaster (stateName,stateDescription,stateActiveStatus) VALUES ('{}','{}','{}')" .format(stateVO.stateName, stateVO.stateDescription, stateVO.stateActiveStatus)) connection.commit() cursor1.close() connection.close()
def searchCategory(self): connection = con_db() cursor1 = connection.cursor() cursor1.execute( "SELECT * FROM categorymaster WHERE categoryActiveStatus='active'") data = cursor1.fetchall() connection.commit() connection.close() cursor1.close() return data
def editState(self, stateVO): connection = con_db() cursor1 = connection.cursor() cursor1.execute( " SELECT * FROM statemaster WHERE stateId = '{}' ".format( stateVO.stateId)) stateDict = cursor1.fetchall() cursor1.close() connection.close() return stateDict
def ajaxSubcategoryProduct(self, subcategoryVO): connection = con_db() cursor1 = connection.cursor() cursor1.execute( "SELECT * FROM subcategorymaster WHERE subcategory_categoryId='" + str(subcategoryVO.subcategory_categoryId) + "' ") subcategoryJsonDict = cursor1.fetchall() connection.close() cursor1.close() return subcategoryJsonDict
def searchLoginDetailsById(self,loginVO): connection = con_db() cursor1 = connection.cursor() cursor1.execute("SELECT * FROM loginmaster AS lm INNER JOIN registermaster AS rm ON lm.loginId = rm.register_LoginId WHERE loginId ='{}'".format(loginVO.loginId)) loginDict = cursor1.fetchall() connection.commit() cursor1.close() connection.close() return loginDict
def searchLoginByEmailId(self,loginVO): connection = con_db() cursor1 = connection.cursor() cursor1.execute("SELECT * FROM loginmaster WHERE loginEmailId ='{}'".format(loginVO.loginEmailId)) loginDict = cursor1.fetchall() connection.commit() cursor1.close() connection.close() return loginDict
def search_data(self, id=None): con_db_obj = con_db() cursor = con_db_obj.connection.cursor() if id is not None: cursor.execute('select * from register_master_mvc where id=%s', str(id)) return_data = cursor.fetchone() else: cursor.execute('select * from register_master_mvc') return_data = cursor.fetchall() cursor.close() return return_data
def searchCategoryId(self, categoryVO): connection = con_db() cursor1 = connection.cursor() cursor1.execute( "SELECT * FROM categorymaster WHERE categoryName LIKE '" + categoryVO.categoryName + "%'") data = cursor1.fetchall() connection.commit() connection.close() cursor1.close() return data
def forheadersubcategorymen(self): connection = con_db() cursor1 = connection.cursor() cursor1.execute( "SELECT * FROM subcategorymaster AS s INNER JOIN categorymaster AS c ON s.`subcategory_categoryId` = c.`categoryId` WHERE s.subcategoryActiveStatus='active' and c.categoryName='men'" ) data = cursor1.fetchall() print("data=", data) connection.commit() connection.close() cursor1.close() return data
def insertFeedback(self, feedbackVO): connection = con_db() cursor1 = connection.cursor() cursor1.execute( "INSERT INTO feedbackmaster (feedbackSubject,feedbackDescription,feedbackRating,feedbackDate,feedbackTime,feedbackActiveStatus, feedbackFrom_loginId)VALUES ('" + feedbackVO.feedbackSubject + "','" + feedbackVO.feedbackDescription + "','" + feedbackVO.feedbackRating + "','" + feedbackVO.feedbackDate + "','" + feedbackVO.feedbackTime + "','" + feedbackVO.feedbackActivestatus + "','" + str(feedbackVO.feedbackFrom_loginId) + "')") connection.commit() cursor1.close() connection.close()
def searchSubcategory(self): connection = con_db() cursor1 = connection.cursor() cursor1.execute("SELECT * FROM subcategorymaster") cursor1.execute( "SELECT * FROM subcategorymaster AS s INNER JOIN categorymaster AS c ON s.`subcategory_categoryId` = c.`categoryId`" ) data = cursor1.fetchall() connection.commit() connection.close() cursor1.close() return data
def viewbuyer(self): connection = con_db() cursor1 = connection.cursor() cursor1.execute("SELECT * FROM userregistermaster") data1 = cursor1.fetchall() connection.commit() connection.close() return data1
def ajaxLoadheadersubcategory(self, subcategoryVO): connection = con_db() cursor1 = connection.cursor() cursor1.execute( "SELECT * FROM subcategorymaster WHERE subcategory_categoryId= '" + str(subcategoryVO.subcategory_categoryId) + "'") ajaxheadersubcategoryDict = cursor1.fetchall() connection.close() cursor1.close() return ajaxheadersubcategoryDict
def insertSubcategory(self, subcategoryVO): connection = con_db() cursor1 = connection.cursor() cursor1.execute( "INSERT INTO subcategorymaster (subcategoryName,subcategoryDescription,subcategoryActiveStatus,subcategory_categoryId) VALUES ('" + subcategoryVO.subcategoryName + "','" + subcategoryVO.subcategoryDescription + "','" + subcategoryVO.subcategoryActiveStatus + "','" + str(subcategoryVO.subcategory_categoryId) + "')") connection.commit() print(subcategoryVO.subcategoryName, subcategoryVO.subcategoryDescription, subcategoryVO.subcategoryActiveStatus, subcategoryVO.subcategory_categoryId) cursor1.close() connection.close()