def deleteHistories(self, sku, millisecond):
try:
query = '''DELETE FROM sku_history WHERE sku = '{}' and created_at < {} '''.format(StringUtils.toString(sku['sku']), millisecond)
DatabaseHelper.execute(query)
return ExceptionUtils.success()
except Exception as ex:
return ExceptionUtils.error('''Delete history failed: {}'''.format(str(ex)))
def insertHistory(self, history, sku, user):
try:
query = '''INSERT INTO sku_history(sku, enemy_json, user_id, status, created_at) VALUES ('{}', '{}', {}, {}, {}) '''.format(
sku['sku'], history['enemy_json'], user['id'], history['status'], history['created_at'])
DatabaseHelper.execute(query)
return ExceptionUtils.success()
except Exception as ex:
return ExceptionUtils.error('''Insert new history failed: {}'''.format(str(ex)))
def delete(self, sku, user):
query = '''DELETE from price_by_time where id = '{}' '''.format(
sku['id'])
try:
DatabaseHelper.execute(query)
return ExceptionUtils.success()
except Exception as ex:
return ExceptionUtils.error(
'''User: {}-{}, delete price by time: {}, exception: {}'''.
format(user['username'], user['id'], sku['id'], str(ex)))
def updateSpecialPrice(self, sku, user, newSpecialPrice):
query = '''UPDATE price_by_time
set special_price = '{}'
WHERE id = '{}'
'''.format(newSpecialPrice, sku['id'])
try:
DatabaseHelper.execute(query)
return ExceptionUtils.success()
except Exception as ex:
return ExceptionUtils.error(
'''User: {}-{}, update special price of sku: {}, exception: {}'''
.format(user['username'], user['id'], sku['id'], str(ex)))
def insert(self, sku, user):
query = '''INSERT INTO price_by_time(sku, name, link, price_by_time, special_price, user_id)
VALUES ('{}', '{}', '{}', '{}', '{}', '{}')'''.format(
StringUtils.toString(sku['sku']),
StringUtils.toString(sku['name']),
StringUtils.toString(sku['link']), sku['price_by_time'],
sku['special_price'], user['id'])
try:
DatabaseHelper.execute(query)
return ExceptionUtils.success()
except Exception as ex:
return ExceptionUtils.error(
'''User: {}-{}, Insert price by time exception: {}'''.format(
user['username'], user['id'], str(ex)))
def setStatusToPackedByMarketplace(self, user, orderItems):
parameters = {
'Action': 'SetStatusToPackedByMarketplace',
'DeliveryType': 'dropship',
'Format': 'json',
'OrderItemIds': '''[{}]'''.format(
orderItems
), # orderItems format should be string like this: 3,425,234
'Timestamp': LazadaApiHelper.getCurrentUTCTime(),
'UserID': user['lazada_user_id'],
'Version': '1.0'
}
parameters['Signature'] = LazadaApiHelper.generateSignature(
parameters, user['lazada_api_key'])
url = "{}/?Action={}&DeliveryType={}&Format={}&OrderItemIds={}&&Timestamp={}&UserID={}&Version={}&Signature={}".format(
LazadaAPI.ENDPOINT, parameters["Action"],
parameters['DeliveryType'], parameters["Format"],
parameters['OrderItemIds'],
LazadaApiHelper.formatTimestamp(parameters["Timestamp"]),
parameters["UserID"], parameters["Version"],
parameters["Signature"])
try:
resp = requests.get(url)
if resp.status_code == 200:
response = json.loads(resp.text)
if 'ErrorResponse' in response:
return ExceptionUtils.error(
'''User: {}-{}, Set Status to Packed is error: {}'''.
format(
user['id'], user['username'],
response['ErrorResponse']['Head']['ErrorMessage']))
return ExceptionUtils.success(
"Set status to Parked is done") # Can't return None
# Request except
return ExceptionUtils.error(
'''User: {}-{}, Set Status to Packed is error: {}'''.format(
user['id'], user['username'], resp.status_code))
except Exception as ex:
return ExceptionUtils.error(
'''User: {}-{}, Set Status to Packed is error: {}'''.format(
user['id'], user['username'], str(ex)))
def updateProductSpecialPrice(self, sku, user, newSpecialPrice):
parameters = {
'Action': 'UpdateProduct',
'Format': 'JSON',
'Timestamp': LazadaApiHelper.getCurrentUTCTime(),
'UserID': user['lazada_user_id'],
'Version': '1.0'
}
parameters['Signature'] = LazadaApiHelper.generateSignature(
parameters, user['lazada_api_key'])
url = "{}/?Action={}&Format={}&Timestamp={}&UserID={}&Version={}&Signature={}".format(
LazadaAPI.ENDPOINT, parameters["Action"], parameters["Format"],
LazadaApiHelper.formatTimestamp(parameters["Timestamp"]),
parameters["UserID"], parameters["Version"],
parameters["Signature"])
# Must use xmlBody to update
xmlBody = LazadaApiHelper.getUpdateProductSpecialPriceXML(
sku, newSpecialPrice)
try:
resp = requests.post(url, data=xmlBody)
if resp.status_code != 200:
return ExceptionUtils.error(
'''Request error with response-code: {}'''.format(
resp.status_code))
response = resp.json()
if ('SuccessResponse' in response):
return ExceptionUtils.success(
"Update procduct special price success")
else:
return ExceptionUtils.returnError(
"Update product special price error: ", response)
except Exception as ex:
return ExceptionUtils.error(
'''Update product special price got exception: {}'''.format(
str(ex)))