Advertisement
abrar1

Untitled

Dec 10th, 2020
169
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.70 KB | None | 0 0
  1. #SALES VIEWS ER LOAD FUNCTION E
  2. #SQL_4 ER EXECUTION ER PART TUKU EI CODE DIYE REPLACE KOR
  3.  
  4.  
  5.  
  6. cursor = connection.cursor()
  7.  
  8. if not date_of_sell:
  9. print("XDXDXDXDXDXDXDXDXDXDXDXDXDX")
  10. sql_4 = "INSERT INTO SALES(CUSTOMER_ID,PRODUCT_IMEI_NO,EMPLOYEE_ID) VALUES(%s,%s,%s);"
  11. cursor.execute(sql_4, [customer_id_fetched, imei, employee_id])
  12.  
  13. else :
  14. sql_4 = "INSERT INTO SALES(CUSTOMER_ID,PRODUCT_IMEI_NO,DATE_OF_SALE,EMPLOYEE_ID) VALUES(%s,%s,%s,%s);"
  15. cursor.execute(sql_4, [customer_id_fetched, imei, date_of_sell, employee_id])
  16.  
  17. connection.commit()
  18. cursor.close()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement