123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105 |
- '''Created on 17 Mar 2023 @author: vnc-console'''
- from pypxlib import Table
- class Dbtodf(object):
- '''classdocs'''
- def __init__(self, dbp, *kwargs):
- '''Constructor'''
- self.dbp = dbp
- self.kwargs = kwargs
- for key in self.kwargs:
- self.__setattr__(key, [])
-
- def convert_oblig(self):
- with Table(self.dbp) as table:
- all_oblig = []
- for row in table:
- self.Part.append(row.Part)
- all_oblig.append(self.Part)
- self.TipDoc.append(row.TipDoc)
- all_oblig.append(self.TipDoc)
- self.Cont.append(row.Cont)
- all_oblig.append(self.Cont)
- self.Doc.append(row.Doc)
- all_oblig.append(self.Doc)
- self.Moneda.append(row.Moneda)
- all_oblig.append(self.Moneda)
- self.Curs.append(row.Curs)
- all_oblig.append(self.Curs)
- self.NrDoc.append(row.NrDoc)
- all_oblig.append(self.NrDoc)
- self.DataDoc.append(row.DataDoc)
- all_oblig.append(self.DataDoc)
- self.Valoare.append(row.Valoare)
- all_oblig.append(self.Valoare)
- self.Rest.append(row.Rest)
- all_oblig.append(self.Rest)
- return dict(zip(self.kwargs, all_oblig))
-
- def convert_obligf(self):
- with Table(self.dbp) as table:
- all_oblig = []
- for row in table:
- self.Part.append(row.Part)
- all_oblig.append(self.Part)
- self.TipTranz.append(row.TipTranz)
- all_oblig.append(self.TipTranz)
- self.Cont.append(row.Cont)
- all_oblig.append(self.Cont)
- self.Doc.append(row.Doc)
- all_oblig.append(self.Doc)
- self.Moneda.append(row.Moneda)
- all_oblig.append(self.Moneda)
- self.Curs.append(row.Curs)
- all_oblig.append(self.Curs)
- self.NrDoc.append(row.NrDoc)
- all_oblig.append(self.NrDoc)
- self.DataDoc.append(row.DataDoc)
- all_oblig.append(self.DataDoc)
- self.Valoare.append(row.Valoare)
- all_oblig.append(self.Valoare)
- self.Rest.append(row.Rest)
- all_oblig.append(self.Rest)
- return dict(zip(self.kwargs, all_oblig))
-
- def convert_parts(self):
- with Table(self.dbp) as table:
- all_nparts = []
- for row in table:
- self.Cod.append(row.Cod)
- all_nparts.append(self.Cod)
- self.Denumire.append(row.Denumire)
- all_nparts.append(self.Denumire)
- self.CodFiscal.append(row.CodFiscal)
- all_nparts.append(self.CodFiscal)
- return dict(zip(self.kwargs, all_nparts))
-
- def convert_cont(self):
- with Table(self.dbp) as table:
- all_conts = []
- for row in table:
- self.Cod.append(row.Cod)
- all_conts.append(self.Cod)
- self.Simbol.append(row.Simbol)
- all_conts.append(self.Simbol)
- return dict(zip(self.kwargs, all_conts))
-
- def convert_mon(self):
- with Table(self.dbp) as table:
- all_mons = []
- for row in table:
- self.Cod.append(row.Cod)
- all_mons.append(self.Cod)
- self.Simbol.append(row.Simbol)
- all_mons.append(self.Simbol)
- return dict(zip(self.kwargs, all_mons))
- if __name__ == '__main__':
- oblig_headers = ['Part', 'TipDoc', 'Doc', 'NrDoc', 'DataDoc', 'Valoare', 'Rest']
- nparts_headres = ['Cod', 'Denumire', 'CodFiscal']
- dbtodf = Dbtodf(*oblig_headers)
- dbtodf.convert()
- print(dbtodf.Part)
|