def AddAA(NameTable: str, TABLA: str, REF: str, CODEBAR: str, WORKER: str,
LOTE: str, INITIAL_DATE: str, FINAL_DATE: str):
engine = create_engine(TABLA, echo=True)
Session = sessionmaker(engine)
session = Session()
if NameTable == Settings.Var_AA(): MP = SQLAA()
elif NameTable == Settings.Var_AAR(): MP = SQLAAR()
MP.Ref = REF
MP.CodeB = CODEBAR
MP.Worker = WORKER
MP.Lote = LOTE
MP.Initial_Date = INITIAL_DATE
MP.Final_Date = FINAL_DATE
session.add(MP)
session.commit()
session.close()
def WhichTable(NameTable: str):
if NameTable == Settings.Var_AA(): return SQLAA
elif NameTable == Settings.Var_AAR(): return SQLAAR
