def read(id,uid): isbigint(id) isbigint(uid) results = db.select('notes',where='id=$id and userid=$uid',vars=locals(), _test=is_debug) if not results: return False return results[0]
def setstatus(id, status): isbigint(id) issmallint(status) db.update('notes', where='id=$id', status=status, vars=locals(), _test=is_debug)
def create(uid,gid,content): isbigint(uid) isbigint(gid) istext(gid) summary = content[:150] return db.insert('notes', groupid=gid,userid=uid,notes=content,summary= summary,createdate=datetime.now(),status=1, _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 read(id, uid): isbigint(id) isbigint(uid) results = db.select('notes', where='id=$id and userid=$uid', vars=locals(), _test=is_debug) if not results: return False return results[0]
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(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 create(uid, gid, content): isbigint(uid) isbigint(gid) istext(gid) summary = content[:150] return db.insert('notes', groupid=gid, userid=uid, notes=content, summary=summary, createdate=datetime.now(), status=1, _test=is_debug)
def setdel(id): isbigint(id) setstatus(id,0)
def setstatus(id,status): isbigint(id) issmallint(status) db.update('notes',where='id=$id', status = status, vars=locals(),_test=is_debug)
def setdel(id): isbigint(id) setstatus(id, 0)