conexao_matriz

#pip install mysql-connector-python
#https://stackoverflow.com/questions/53077133/market-basket-analysis-in-python-for-large-transaction-dataset
import mysql.connector
import numpy as np
from mysql.connector import errorcode


try:
	cnx = mysql.connector.connect(user='root', password='p@ssw0rd',
		                          host='localhost',
								  port='3307',
			                      database='sice')

	cursor_documentos = cnx.cursor(buffered=True)
	query_documentos = ("SELECT documento FROM vendaarquivo WHERE data='{}'".format("2016-06-23"))
	cursor_documentos.execute(query_documentos)

	cursor_itens = cnx.cursor()

	dataset = []
	i = 0

	for x in cursor_documentos:
		query_itens = "select codigo from vendaarquivo where documento='{}'".format(x[0])
		cursor_itens.execute(query_itens)
		y = cursor_itens.fetchall()
		for z in zip(*y):
			dataset.insert(i, z)
			i +=  1

	#print(dataset)
	print(dataset[0][0])
	cursor_documentos.close()
	cursor_itens.close()

except mysql.connector.Error as err:

  if err.errno == errorcode.ER_ACCESS_DENIED_ERROR:
    print("Something is wrong with your user name or password")
  elif err.errno == errorcode.ER_BAD_DB_ERROR:
    print("Database does not exist")
  else:
    print(err)
else:
  cnx.close()