Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import sqlite3
- import random
- import qrcode
- import string
- from datetime import *
- banco = sqlite3.connect ("codigos.db")
- cursor = banco.cursor()
- cursor.execute ("CREATE TABLE IF NOT EXISTS codigosV (codeValido VARCHAR(8), dataHora VARCHAR(17), nomeVendedor VARCHAR(25), emailCliente VARCHAR(50))")
- cursor.execute ("CREATE TABLE IF NOT EXISTS codigosN (codeNvalido VARCHAR(8))")
- def criarQRcode():
- vendedor = input("Nome vendedor: ")
- email = input("email cliente: ")
- data = datetime.now()
- dataSimples = data.strftime('%d/%m/%Y %H:%M')
- print (dataSimples)
- QRcode = 1
- code = 8
- for x in range(QRcode):
- CodigoFinal = (''.join(random.choice(string.ascii_letters + string.digits) for _ in range(code)))
- print (CodigoFinal)
- cursor.execute ("INSERT INTO codigosV (codeValido, dataHora, nomeVendedor, emailCliente) VALUES (?,?,?,?)",(CodigoFinal,dataSimples,vendedor,email))
- cursor.execute("""
- SELECT * FROM codigosV;
- """)
- for linha in cursor.fetchall():
- print(linha)
- img = qrcode.make (CodigoFinal)
- type(img)
- img.save(f"QRcodeFor {email} .png")
- def lerQRcode():
- lerCodigo = input("codigo:")
- cursor.execute(f""" SELECT * FROM codigosV WHERE codeValido = '{lerCodigo}' """)
- codigodb = cursor.fetchall()
- print (codigodb)
- if codigodb :
- print("ok")
- else:
- print("fake")
- print("criar um QRcode (1)")
- print("Verificar codigo (2)")
- tabela = cursor.fetchall()
- print(tabela[0][0])
- opcao = (int(input(">> ")))
- if opcao == 1 :
- criarQRcode()
- if opcao == 2 :
- lerQRcode()
- banco.commit()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement