def db_save(url, task_code, task_id): detail_attributes = Detail(url) component = detail_attributes.get_component() try: orcl_conn = OracleSave(task_code, task_id) orcl_conn.component_insert(component) many_properties = detail_attributes.get_properties() for properties in many_properties: orcl_conn.properties_insert(properties) orcl_conn.commit() except Exception as e: print(e)
def db_save(component, many_properties, task_code, task_id): orcl_conn = OracleSave(task_code, task_id) try: orcl_conn.component_insert(component) except Exception as e: print(e) for properties in many_properties: try: orcl_conn.properties_insert(properties) except Exception as e: print(e) orcl_conn.commit() orcl_conn.conn.close()
def db_save(product, task_code, task_id): detail_attributes = Detail(product) component = detail_attributes.get_component(kiname="厚膜高精度贴片电阻器", attach="https://industrial.panasonic.cn/cdbs/www-data/pdf/RDA0000/AOA0000C127.pdf", img="https://industrial.panasonic.cn/cdbs/www-data/gif/RDA0000/AOA0000SC85.jpg") try: orcl_conn = OracleSave(task_code, task_id) orcl_conn.component_insert(component) many_properties = detail_attributes.get_properties() for properties in many_properties: orcl_conn.properties_insert(properties) orcl_conn.commit() except Exception as e: print(e)
def db_save(product_json, task_code, task_id): detail_attributes = Detail(product_json) component = detail_attributes.get_component() orcl_conn = OracleSave(task_code, task_id) try: orcl_conn.component_insert(component) except Exception as e: print(e) many_properties = detail_attributes.get_attributes() for properties in many_properties: try: orcl_conn.properties_insert(properties) except Exception as e: print(e) orcl_conn.commit() orcl_conn.conn.close()
def get_csv_data(self): csv_file = self.csv_download() import csv with open(csv_file) as csvfile: reader = csv.DictReader(csvfile) for row in reader: component = [ 'http://www.semicon.panasonic.co.jp/cn/products/discrete/diodes/shottkybarrierdiodes/#products-document', row['锘縋arts'], row['series'], '-', row['Datasheet'] ] try: orcl_conn = OracleSave(self.task_code, self.task_id) orcl_conn.component_insert(component) for k in row: if k not in ('锘縋arts', 'series', 'Datasheet'): single_property = k, row[k] orcl_conn.properties_insert(single_property) print(single_property) orcl_conn.commit() except Exception as e: print(e)