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