#! /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)