def post(self, commodity): print 'CommoditiesApi post: [%s]' % commodity resp = {} try: d = json.loads(commodity) d[self.entry.COLUMN_NAME_MODIFY_TIME] = int(time.time()) if not d[self.entry.COLUMN_NAME_THUMBNAIL]: d[self.entry.COLUMN_NAME_THUMBNAIL] = d[self.entry.COLUMN_NAME_IMAGE_1] cs = [x for x in d.keys() if x != self.entry.COLUMN_NAME_ID] id = d[self.entry.COLUMN_NAME_ID] if id == 0: # add commodity ps = ', '.join(cs) ss = ', '.join(['%s' for c in cs]) sql = 'INSERT INTO %s (%s) VALUES (%s)' % (self.entry.TABLE_NAME, ps, ss) else: # replace kvs = ', '.join(['%s=%%s' % (c) for c in cs]) sql = 'UPDATE %s SET %s WHERE %s=%d' % (self.entry.TABLE_NAME, kvs, self.entry.COLUMN_NAME_ID, id) print sql args = tuple([urllib.unquote(str(d[c])) for c in cs]) print args r = mysql.execute(sql, args) if r != 1: print 'mysql execute return %d' % r resp['status'] = SERVER_MYSQL_ERROR else: resp['status'] = OK except Exception as e: print e resp['status'] = REQUEST_PARAM_ERROR return json.dumps(resp, ensure_ascii=False)
def post(data): resp = {} try: obj = json.loads(data) d = {col:obj[col] for col in self.entry.COLUMNS if col in obj} kvs = d.items() ks = ', '.join([x[0] for x in kvs]) ss = ', '.join(['%s' for x in kvs]) sql = "REPLACE INTO %s (%s) VALUES (%s)" % (self.entry.TABLE_NAME, ks, ss) args = tuple([x[1] for x in kvs]) r = mysql.execute(sql, args) if r == -1: resp['status'] = SERVER_MYSQL_ERROR else: return self.get(s['id']) except Exception as e: resp['status'] = INPUT_DATA_ERROR resp['error'] = str(e) return json.dumps(resp, ensure_ascii=False)
def post(self, buyer): print 'BuyerApi post: [%s]' % buyer resp = {} try: d = json.loads(buyer) d[self.entry.COLUMN_NAME_MODIFY_TIME] = int(time.time()) cs = [x for x in d.keys()] ps = ', '.join(cs) ss = ', '.join(['%s' for c in cs]) sql = 'REPLACE INTO %s (%s) VALUES (%s)' % (self.entry.TABLE_NAME, ps, ss) args = tuple([urllib.unquote(str(d[c])) for c in cs]) r = mysql.execute(sql, args) if r != 1: print 'mysql execute return %d' % r resp['status'] = SERVER_MYSQL_ERROR else: resp['status'] = OK except Exception as e: print e resp['status'] = REQUEST_PARAM_ERROR return json.dumps(resp, ensure_ascii=False)
def post(self, buyer): print 'BuyerApi post: [%s]' % buyer resp = {} try: d = json.loads(buyer) d[self.entry.COLUMN_NAME_MODIFY_TIME] = int(time.time()) cs = [x for x in d.keys()] ps = ', '.join(cs) ss = ', '.join(['%s' for c in cs]) sql = 'REPLACE INTO %s (%s) VALUES (%s)' % (self.entry.TABLE_NAME, ps, ss) args = tuple([urllib.unquote(str(d[c])) for c in cs]) r = mysql.execute(sql, args) if r != 1: print 'mysql execute return %d' % r resp['status'] = SERVER_MYSQL_ERROR else: resp['status'] = OK except Exception as e: print e resp['status'] = REQUEST_PARAM_ERROR return json.dumps(resp, ensure_ascii=False)