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()