#! /usr/bin/python3 # -*- coding: utf-8 -*- import pymysql import Functions.connectionDb as conn import Functions.delete as delete import Functions.modifyRow as modify import Functions.merge as fct # Initialize users parameters and connection to DB user_name, password, date = conn.parametersWithPass() db, cursor = conn.connectionToDb(user_name, password=password) authorized = conn.getAuthorizedTerms(cursor) # Get the rows to merge usedTable = fct.chooseTable() id1, id2, answer = fct.haveIDs(usedTable, cursor) if answer == "O": namesColumns, controlled, units, categories = conn.getNamesOfColumns(usedTable, cursor) columns, type_columns, sizeTable = fct.getTableStructure(usedTable, cursor) row1, description1 = modify.returnRowToModify(id1, usedTable, cursor) row2, description2 = modify.returnRowToModify(id2, usedTable, cursor) new_values, old_values, entered_values = fct.getNewValues(row1, row2, namesColumns, sizeTable, controlled, units, authorized) values = fct.buildValues(new_values, entered_values, sizeTable) request = fct.buildSQLrequest(values, columns, sizeTable, usedTable, id1, date, user_name) modification = modify.executeModification(request, cursor, db) if modification: deletion = delete.delete(id2, usedTable, cursor, db)
) for i in range(sizeTable): unit = units[i] if unit == None: unit = " " elif " " in unit: unit = unit else: unit = "$%s$" % unit f.write("\n\\hline\n%s & %s & %s & %s \\\\" % (namesColumns[i], unit, categories[i], controlled[i])) f.write("\n\\hline\n\\end{tabular}") f.close() db, cursor = conn.connectionToDb(username='******') columns, type_columns, sizeTable, default_columns, null = getTableStructure( "Pieces", cursor) namesColumns, controlled, units, categories = getNamesOfColumns( "Pieces", cursor) createRowsMetaM(sizeTable, columns, namesColumns, controlled, units, categories, "tablemetaP") createRowsFillM(sizeTable, columns, type_columns, default_columns, null, "tablefillP") columns, type_columns, sizeTable, default_columns, null = getTableStructure( "Materiaux", cursor) namesColumns, controlled, units, categories = getNamesOfColumns( "Materiaux", cursor) createRowsMetaM(sizeTable, columns, namesColumns, controlled, units, categories, "tablemetaM")
#! /usr/bin/python3 # -*- coding: utf-8 -*- import pymysql import Functions.search as fct import Functions.connectionDb as conn import Functions.scroll as scr # Initialize users parameters and connection to DB user_name, date = conn.parametersWithoutPass() db, cursor = conn.connectionToDb(user_name) authorized = conn.getAuthorizedTerms(cursor) answer_abort = "O" while answer_abort == "O": #Ask about the type of research and get the structure of the table search = fct.typeOfSearch() usedTable = fct.chooseTable() namesColumns, controlled, units, categories = conn.getNamesOfColumns( usedTable, cursor) columns, type_columns, sizeTable = fct.getTableStructure(usedTable, cursor) if search == "S": # Ask about what is being searched nameColumn, column, type_column, unit = fct.getColumnToSearch( namesColumns, units, columns, type_columns) searched_one, searched_two = fct.getSearchCriteria( usedTable, column, type_column, cursor)