Ritatuzik_1

class Project:
    def __init__(self, object_list, project_parametrs):
        self.object_list = object_list
        self.name_proj = project_parametrs[0]
        self.date_beg = project_parametrs[1]
        self.date_end = project_parametrs[2]
        self.name_user = project_parametrs[3]

        self.save = "C:\\Users\\User\\PycharmProjects\\untitled1 Rita_New_new\\src\\result\\" + self.name_proj + ".json"


    def readingObjectfromtheDatabase(self, object_list=[], model_list=[], progress_check=None):
        try:
            cnx = mysql.connector.connect(host='localhost', database='Db_3D_Print', user='root', password='')
        except mysql.connector.Error as err:
            if err.errno == errorcode.ER_ACCESS_DENIED_ERROR:
                progress_check = "Что-то не так с Login/Password !"
            elif err.errno == errorcode.ER_BAD_DB_ERROR:
                progress_check = "БД не найдена! "
            else:
                progress_check = err

        if progress_check == None:
            cursor = cnx.cursor()
            query = ("SELECT Printer_Name FROM Printers ")
            cursor.execute(query)
            rows = cursor.fetchall()
            for row in rows:
                object_list.append(row)

            query = ("SELECT * FROM Models")
            cursor.execute(query)
            rows = cursor.fetchall()

            for row in rows:
                model_list.append(row)
            cnx.close()

    def readingPrinterParametrs(self, printer_name=None, progress_check=None):
        try:
            cnx = mysql.connector.connect(host='localhost', database='Db_3D_Print', user='root', password='')
        except mysql.connector.Error as err:
            if err.errno == errorcode.ER_ACCESS_DENIED_ERROR:
                progress_check = "Что-то не так с Login/Password !"
            elif err.errno == errorcode.ER_BAD_DB_ERROR:
                progress_check = "БД не найдена! "
            else:
                progress_check = err
        parametrs_temp = []
        if progress_check == None:
            cnx = mysql.connector.connect(host='localhost', database='Db_3D_Print', user='root', password='')
            cursor_1 = cnx.cursor()
            query_1 = ("SELECT Height_Table, Length_Table, Width_Table, Printer_ID FROM Printers WHERE Printer_Name = "
                       + "'{0}' ".format(printer_name))
            cursor_1.execute(query_1)
            parametrs_temp = cursor_1.fetchall()

            cnx.close()
        return parametrs_temp

    def writingObjectintheDatabase(self, object_list, printer_parametrs, result):
        self.saveJson(result)

        query = ("INSERT INTO Project (Project_Name, Printer_ID, DateOfBeginning, DateOfCompletion, Performer) VALUES "+
        "(%s,%s,%s,%s,%s)")
        args = (self.name_proj, printer_parametrs[3], self.date_beg, self.date_end, self.name_user)

        query_1 = ""

        try:
            cnx = mysql.connector.connect(host='localhost', database='Db_3D_Print', user='root', password='')
            cursor = cnx.cursor()
            cursor.execute(query, args)
            cnx.commit()

          #  cursor_1 = cnx.cursor()
          #  cursor_1.executemany(query_1, args)

        except mysql.connector.Error as err:
            if err.errno == errorcode.ER_ACCESS_DENIED_ERROR:
                progress_check = "Что-то не так с Login/Password !"
            elif err.errno == errorcode.ER_BAD_DB_ERROR:
                progress_check = "БД не найдена! "
            else:
                progress_check = err
        finally:
            cursor.close()
            cnx.close()


    def saveJson(self, result):
        dump(result, open(self.save, "w"), separators=(",", ":"))