def post(self): args = convertRequestArgs(self.request.arguments) salt, digest = hasher.getDigest(args['password']) curr=conn.cursor() SQL = 'SELECT "editUserPassword"(%s, CAST(%s AS TEXT), CAST(%s AS TEXT), CAST(%s AS TEXT));' vals = [args['userID'], args['username'].lower(), digest, salt] curr.execute(SQL, vals) conn.commit() curr.close()
def post(self): args = convertRequestArgs(self.request.arguments) curr=conn.cursor() salt, digest = hasher.getDigest(args['password'].lower()) SQL = 'SELECT * FROM "addUser"(CAST(%s AS TEXT), CAST(%s AS TEXT), CAST(%s AS TEXT), CAST(%s AS TEXT), CAST(%s AS TEXT), CAST(%s AS TEXT), %s, CAST(%s AS TEXT), CAST(%s AS TEXT), CAST(%s AS TEXT))' vals = [args['username'], args['firstName'], args['lastName'], args['streetAddress'], args['city'], args['state'], int(args['zipcode']), args['email'], digest, salt]; #put values her execSQL(curr, SQL, vals) result = curr.fetchone() conn.commit() curr.close()
def post(self):
args = convertRequestArgs(self.request.body)
curr=conn.cursor()
salt, digest = hasher.getDigest(args['password'])
SQL = 'SELECT * FROM "addUser"(CAST(%s AS TEXT), CAST(%s AS TEXT), CAST(%s AS TEXT), CAST(%s AS TEXT), CAST(%s as VARCHAR(2)), %s, %s, CAST(%s AS TEXT), CAST(%s AS BIGINT), CAST(%s AS BOOLEAN), CAST(%s AS BOOLEAN), CAST(%s AS TEXT), CAST(%s AS TEXT), CAST(%s AS TEXT))'
vals = [args['firstName'], args['lastName'], args['streetAddress'], args['city'], args['state'], args['zipcode'], args['numberOfPeopleInHome'], args['email'], args['phoneNumber'], args['isOnCityWater'], args['allowStatisticsTracking'], args['username'], digest, salt];
execSQL(curr, SQL, vals)
result = curr.fetchone()
conn.commit()
curr.close()
self.write(json.dumps({"Result":result}, separators=(', ',': ')))
def post(self):
args = convertRequestArgs(self.request.arguments)
curr=conn.cursor()
SHSQL = 'SELECT * FROM "getSaltandHash"(CAST(%s AS TEXT));'
SHvals = [args['username'].lower()]
execSQL(curr, SHSQL, SHvals)
saltnhash = curr.fetchone()
if(saltyhash[2] & hasher.isPassword(args['pass'], saltnhash[0], saltnhash[1])):
SQL = 'SELECT * FROM "verifyLogin"( CAST(%s AS TEXT), CAST(%s AS TEXT));'
vals = [args['username'].lower(), hasher.getDigest(args['password'],saltnhash[0])[1]]
execSQL(curr, SQL, vals)
results = curr.fetchone()
curr.close()
else:
curr.close()
results = [False, - 1]
self.write(json.dumps({'verified':results[0], 'userID':results[1]}, separators=(', ', ': ')))
