def filldatabase(fingerprintdf):
mysession = SQLSession(Schemas.qsar_schema).get_session()
username = '******'
descriptors_index = 1448
compound_descriptor_set_objects = []
# print(fingerprintdf)
for index, row in fingerprintdf.iterrows():
efk_dsstox_compound_id = row[0].split('0', 1)[1]
fk_descriptor_set_id = descriptors_index
xx = [str(x) for x in list(row[1])]
descriptor_string_tsv = '\t'.join(xx)
created_by = username
updated_by = username
compound_descriptor_sets = CompoundDescriptorSets(
efk_dsstox_compound_id=efk_dsstox_compound_id,
descriptor_string_tsv=descriptor_string_tsv,
created_by=created_by,
fk_descriptor_set_id=fk_descriptor_set_id,
updated_by=updated_by)
compound_descriptor_set_objects.append(compound_descriptor_sets)
mysession.bulk_save_objects(compound_descriptor_set_objects)
mysession.commit()
def filldatabase(yourlist, desc_set_id, prefix):
username = '******'
descriptors_index = desc_set_id
mysession = SQLSession(Schemas.qsar_schema).get_session()
descriptor_objects = []
for index, val in enumerate(yourlist):
fk_descriptor_set_id = descriptors_index
index_number = index + 1
# xx = [str(x) for x in list(row)]
descriptors_name = str(prefix.format(index + 1))
created_by = username
updated_by = username
long_description = ''
short_description = ''
label = val
descriptor = Descriptors(index_number=index_number,
descriptors_name=descriptors_name,
long_description=long_description,
short_description=short_description,
label=label,
created_by=created_by,
fk_descriptor_set_id=fk_descriptor_set_id,
updated_by=updated_by)
descriptor_objects.append(descriptor)
mysession.bulk_save_objects(descriptor_objects)
mysession.commit()
