write_to_database

import pymysql.cursors
from read_file import *
import csv




cnx = pymysql.connect(user='root', password='ptekm8n8', host='127.0.0.1', database='productdb')
cursor = cnx.cursor()




def sql_stuff(object):

    query = ('INSERT INTO company (time_capacity) VALUES (%s);')
    query1 = ('INSERT INTO productdb (name, unit_cost) VALUES (%s);')

    cursor.execute(query, (Max_timer))

    for i in VO:
        uquery = ('INSERT INTO productdb (unit_cost) VALUES (%s);')
        cursor.execute(uquery, i)

        for k in Timer_pr_enhed:
            aquery = ('UPDATE productdb SET time_produce_minutes=%s WHERE unit_cost IS NOT NULL;')
            cursor.execute(aquery, k)
            continue

def time(object):
    for k in Timer_pr_enhed:
        aquery = ('UPDATE productdb SET time_produce_minutes=%s WHERE unit_cost IS NOT NULL;')
        cursor.execute(aquery, k)
        continue








def reset_database(object):

    reset = ('SET FOREIGN_KEY_CHECKS = 0; truncate company; truncate product_data; truncate productdb; truncate productinfo; SET FOREIGN_KEY_CHECKS = 1;  commit')
    cursor.execute(reset)


sql_stuff(object)
time(object)
##reset_database(object)

cnx.commit()
cnx.close()