Help please, I have three tables (Period, News and Liquidation) with the following information, the tables are configured as classes in ORM Sqlalchemy: >
Periodo:
# con los campos
id_periodo(int)(pk)
num_periodo (int)
nombre_periodo(varchar)
Novedades:
#campos
id_novedades(int)(pk)
num_periodo(int)(fk)
empleado(int)
dias trabajados(int)
sueldo(float)
horas extras(float)
Liquidacion:
id_liquidacion(int)(pk)
num_periodo (int)(fk)
empleado(int)
dias trabajadosmes(float)
sueldomes(float)
horas extrasmes(float)
I need to execute the Settlement Class, and when I choose the Period number, I insert the records of the table What's new in the settlement table and I can execute the calculations that I need. according to the established parameters. example: the field sueldomes in the table liquidacion seria (sueldomes = salary / 30 * diastrabajados). I appreciate guidance in advance thank you.