def insert_multi_row_with_recommendations(raw_collection):
for row_item in raw_collection:
row = row_item.split(',')
DataFrameObject.uploaded_csv_data = DataFrameObject.uploaded_csv_data.append(
pandas.DataFrame(
[row], columns=DataFrameObject.uploaded_csv_data.columns))
DataFrameObject.save_data()
def get_ad_by_id(self, ad_id):
result = AdObject()
result.id = ad_id
auction = ""
if State.system_mode == State.AD_USER_RECOM_MODE:
full_adds = DataFrameObject.uploaded_product_recom_data.loc[
DataFrameObject.uploaded_product_recom_data['lot_id'] == int(
ad_id)].values
for row in full_adds:
auction = row[1]
result.title = "{auction_name} > {title}".format(
auction_name=row[2], title=row[3])
result.categories = row[6]
break
enriched_result, loaded = self.__set_enriched_data(ad_id, result)
result = enriched_result
if not loaded and not State.offline_mode:
data = TenantConfig().startForId(
tenant=State.tenant,
id="{auction}_{lot_id}".format(auction=auction, lot_id=ad_id))
if data is not None:
if data.loaded:
data.title = result.title
data.categories = [result.categories]
data = data.enriched_panda_row()
panda_row = pandas.DataFrame(
data=[data],
columns=DataFrameObject.enriched_data.columns)
DataFrameObject.enriched_data = DataFrameObject.enriched_data.append(
panda_row, ignore_index=True)
DataFrameObject.save_enriched_data()
result, loaded = self.__set_enriched_data(ad_id, result)
return result
def insert_multi_row_product_recom_list(raw_collection):
for row_item in raw_collection:
row = row_item.split(',')
DataFrameObject.uploaded_product_recom_data = DataFrameObject.uploaded_product_recom_data.append(
pandas.DataFrame([row],
columns=DataFrameObject.
uploaded_product_recom_data.columns))
DataFrameObject.save_product_recom_data()
def insert_multi_row_add_list(raw_collection):
for row_item in raw_collection:
panda_row = pandas.DataFrame(
[[row_item]],
columns=DataFrameObject.uploaded_add_list_data.columns)
DataFrameObject.uploaded_add_list_data = DataFrameObject.uploaded_add_list_data.append(
panda_row, ignore_index=True)
DataFrameObject.save_add_list_data()
def insert_single_row_with_recommendations(ad_id, recommendation_list):
for item in recommendation_list:
panda_row = pandas.DataFrame(
[[ad_id, item.id, item.rank,
int(item.score)]],
columns=DataFrameObject.uploaded_csv_data.columns)
DataFrameObject.uploaded_csv_data = DataFrameObject.uploaded_csv_data.append(
panda_row, ignore_index=True)
DataFrameObject.save_data()
def insert_single_row_product_recommendations(ad_id, recommendation_list):
for item in recommendation_list:
# todo: match form and fields
panda_row = pandas.DataFrame(
[[ad_id, item.id, item.rank,
int(item.score)]],
columns=DataFrameObject.uploaded_product_recom_data.columns)
DataFrameObject.uploaded_product_recom_data = DataFrameObject.uploaded_product_recom_data.append(
panda_row, ignore_index=True)
DataFrameObject.save_product_recom_data()
def insert_single_row_add_list(ad_id):
panda_row = pandas.DataFrame(
[[ad_id]], columns=DataFrameObject.uploaded_add_list_data.columns)
DataFrameObject.uploaded_add_list_data = DataFrameObject.uploaded_add_list_data.append(
panda_row, ignore_index=True)
DataFrameObject.save_add_list_data()