def setstatus(id, status):
isbigint(id)
issmallint(status)
db.update('notes',
where='id=$id',
status=status,
vars=locals(),
_test=is_debug)
def update(i):
isbigint(i.id)
isbigint(i.groupid)
istext(i.notes)
i.summary = i.notes[:150]
id = i.id
db.update('notes',where='id=$id',
groupid=i.groupid,notes=i.notes,summary=i.summary,
vars=locals(),_test=is_debug)
def changepwd(i):
isbigint(i.id)
isvarchar(i.email,1,50)
isvarchar(i.password,1,100)
isdatetime(i.registerdate)
isdatetime(i.lastlogindate)
issmallint(i.status)
id = i.id
db.update('users',where='id=$id',
id=i.id,email=i.email,password=i.password,registerdate=i.registerdate,lastlogindate=i.lastlogindate,status=i.status,
vars=locals(),_test=is_debug)
def update_preferences():
preferences = request.args["preference"].strip()
if len(request.args["preference"].split(",")) < 3:
flash("Enter 3 or more preferences please")
return redirect(url_for("profile"))
if not preferences:
db.update("none", session['logged_in'])
else:
flash("Preferences updated")
db.update(preferences, session['logged_in'])
return redirect(url_for("profile"))
def update(i):
isbigint(i.id)
isbigint(i.groupid)
istext(i.notes)
i.summary = i.notes[:150]
id = i.id
db.update('notes',
where='id=$id',
groupid=i.groupid,
notes=i.notes,
summary=i.summary,
vars=locals(),
_test=is_debug)
def setstatus(id,status):
db.update('users',where='id=$id', status = status, vars=locals(),_test=is_debug)
def setstatus(id,status):
isbigint(id)
issmallint(status)
db.update('notes',where='id=$id', status = status, vars=locals(),_test=is_debug)
def setstatus(id,status):
db.update('groups',where='id=$id', status = status, vars=locals(),_test=is_debug)
def update(i):
isint(i.id)
isvarchar(i.name,1,50)
id = i.id
db.update('groups',where='id=$id',name=i.name,
vars=locals(),_test=is_debug)
