def insert(self, sku):
query = '''INSERT INTO sku_management (sku, name, link, min_price, max_price,
compete_price, special_price, state, repeat_time, created_at, updated_at)
VALUES ('{}', '{}', '{}', {}, {}, {}, {}, {}, {}, {}, 0)'''.format(
StringUtils.toString(sku['sku']),
StringUtils.toString(sku['name']),
StringUtils.toString(sku['link']), sku['min_price'],
sku['max_price'], sku['compete_price'], sku['special_price'],
sku['state'], sku['repeat_time'], sku['created_at'])
DatabaseHelper.execute(query)
def insert(self, user):
query = '''INSERT INTO t_user (user_name, password, token, lazada_user_name, lazada_user_id, lazada_api_key, created_at, updated_at, role, certain_size)
VALUES ('{}', '{}', 'temptoken', '{}', '{}', '{}', '{}', 0, '{}', '{}')'''.format(
StringUtils.toString(user['username']),
StringUtils.toString(user['password']),
StringUtils.toString(user['lazada_user_name']),
StringUtils.toString(user['lazada_user_id']),
StringUtils.toString(user['lazada_api_key']),
user['created_at'],
user['role'],
user['certain_size'])
DatabaseHelper.execute(query)
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 checkExistSku(self, sku):
query = ''' SELECT count(*) FROM sku_management WHERE sku = '{}' '''.format(
StringUtils.toString(sku['sku']))
conn = DatabaseHelper.getConnection()
cur = conn.cursor()
cur.execute(query)
count = 0
row = cur.fetchone()
count = row[0]
conn.close()
return count
def insert(self, sku, user):
query = '''INSERT INTO sku_management (sku, name, link, min_price, max_price,
compete_price, special_price, state, created_at, updated_at, user_id)
VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, 0, %s)'''
conn = DatabaseHelper.getConnection()
cur = conn.cursor()
try:
cur.execute(
query,
(StringUtils.toString(
sku['sku']), StringUtils.toString(sku['name']),
StringUtils.toString(sku['link']), sku['min_price'],
sku['max_price'], sku['compete_price'], sku['special_price'],
sku['state'], sku['created_at'], user['id']))
conn.commit()
conn.close()
return None, None
except Exception as ex:
conn.rollback()
conn.close()
return None, '''User: {}-{}, Insert-Sku: {}'''.format(
user['username'], user['id'], str(ex))
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 getUser(self, token):
try:
query = '''SELECT id, lazada_user_name, lazada_user_id, lazada_api_key FROM t_user WHERE token='{}' '''.format(StringUtils.toString(token))
conn = DatabaseHelper.getConnection()
cur = conn.cursor()
cur.execute(query)
row = cur.fetchone()
if not row:
conn.close()
return None
user = {
'id': row[0],
'username': row[1], # Using lazada user name instead.
'lazada_user_name': row[1],
'lazada_user_id': row[2],
'lazada_api_key': row[3]
}
conn.close()
return user
except Exception as ex:
print(ex)
return None
def getUserUpdatePW(self, token):
try:
query = '''SELECT id, user_name, password FROM t_user WHERE token='{}' '''.format(StringUtils.toString(token))
conn = DatabaseHelper.getConnection()
cur = conn.cursor()
cur.execute(query)
row = cur.fetchone()
if not row:
conn.close()
return None
user = {
"id": row[0],
"user_name": row[1],
"password": row[2],
}
conn.close()
return user
except Exception as ex:
print(ex)
return None
