def record(self, dbrow):
"""Transforms each raw table row into data model objects."""
raw_vndr_name = (
strip_plus4(dbrow["vendorlegalorganizationname"].strip() or dbrow["vendorname"].strip())
.decode("utf8")
.encode("utf8", "replace")
)
raw_duns = dbrow["dunsnumber"][:9].strip()
raw_parent_duns = dbrow["parentdunsnumber"][:9].strip()
if (
len(raw_vndr_name) > 0
and (len(raw_duns) > 0 or len(raw_parent_duns) > 0)
and dbrow["fiscal_year"] is not None
):
vndr_name = self._name(raw_vndr_name)
duns = self._duns(raw_duns) if len(raw_duns) > 0 else None
parent_duns = self._duns(raw_parent_duns) if len(raw_parent_duns) > 0 else None
fpds = FPDS(data_commons_id=dbrow["id"])
fpds.unique_transaction_id = dbrow["unique_transaction_id"]
fpds.duns = duns
fpds.duns_parent = parent_duns
fpds.company_name = vndr_name
fpds.fiscal_year = dbrow["fiscal_year"]
fpds.piid = dbrow["piid"]
fpds.psc = dbrow["productorservicecode"]
fpds.psc_category = dbrow["psc_cat"]
fpds.save()
def record(self, dbrow):
"""Transforms each raw table row into data model objects."""
raw_vndr_name = strip_plus4(
dbrow['vendorlegalorganizationname'].strip()
or dbrow['vendorname'].strip()).decode('utf8').encode(
'utf8', 'replace')
raw_duns = dbrow['dunsnumber'][:9].strip()
raw_parent_duns = dbrow['parentdunsnumber'][:9].strip()
if len(raw_vndr_name) > 0 and (len(raw_duns) > 0
or len(raw_parent_duns) > 0
) and dbrow['fiscal_year'] is not None:
vndr_name = self._name(raw_vndr_name)
duns = self._duns(raw_duns) if len(raw_duns) > 0 else None
parent_duns = self._duns(
raw_parent_duns) if len(raw_parent_duns) > 0 else None
fpds = FPDS(data_commons_id=dbrow['id'])
fpds.unique_transaction_id = dbrow['unique_transaction_id']
fpds.duns = duns
fpds.duns_parent = parent_duns
fpds.company_name = vndr_name
fpds.fiscal_year = dbrow['fiscal_year']
fpds.piid = dbrow['piid']
fpds.psc = dbrow['productorservicecode']
fpds.psc_category = dbrow['psc_cat']
fpds.save()
