Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- def check_user_db(self, getFrom):
- #mysql
- check_cnx = mysql.connector.connect(user='root', password='root',
- host='127.0.0.1', port='8889',
- database='test')
- check_cursor = check_cnx.cursor()
- check_chat =("SELECT number, lang FROM user WHERE number = %s")
- #("SELECT number, lang from user where "
- #"number ='(%s)'")
- check_cursor.execute(check_chat, (getFrom))
- for (number) in check_cursor:
- file = open("logFile.txt","a")
- file.write("\n" + number)
- file.close()
- # Make sure data is committed to the database
- check_cnx.commit()
- check_cursor.close()
- check_cnx.close()
Add Comment
Please, Sign In to add comment