def box():

print "Abriendo Caja: " + name
a=raw_input('Press enter to continue...')
name = str((datetime.datetime.now()).strftime("%Y-%m-%d %H:%M"))
TABLES = {}
TABLES[name] = (
	"CREATE TABLE `"+name+"` ("
	"  `CODE` int(11) NOT NULL AUTO_INCREMENT,"
	"  `NAME` varchar(40) NOT NULL,"
	"  `STATE` enum('A','I','P') NOT NULL,"
	"  `STARTED_TIME` varchar(20) NOT NULL,"
	"  `PRINT_TIME` varchar(20) NOT NULL,"
	"  `CHECKOUT_TIME` varchar(20) NOT NULL,"
	"  PRIMARY KEY (`CODE`)"
	") ENGINE=InnoDB")

connection_name = MySQLdb.connect(host='localhost', user='root', passwd='K0p!r1nn4', db='ACCOUNTS_NAME')
cursor = connection_name.cursor()

for name, ddl in TABLES.iteritems():
	cursor.execute(ddl)

cursor.close()
connection_name.close()
print "Abriendo Caja: " + name
a=raw_input('Press enter to continue...')

def inventory():

con = MySQLdb.connect('localhost', 'root', 'K0p!r1nn4', 'PRODUCTS');
with con: 
	cur = con.cursor()
	cur.execute('''SELECT * FROM productos''')
	rows = cur.fetchall()
	gabriel2 = range(len(rows))       
	for i,row in zip(gabriel2, rows):
		gabriel2[i] = str(row[1]) + "\t" + str(row[2]) + str(row[3]) + "\t" + str(row[4]) + "\t" + str(row[9]) + "\t" + str(row[10])
		print gabriel2[i]
	#return gabriel2
cur.close ()
con.close ()