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)
