Example #1
0
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]
Example #2
0
def setstatus(id, status):
    isbigint(id)
    issmallint(status)
    db.update('notes',
              where='id=$id',
              status=status,
              vars=locals(),
              _test=is_debug)
Example #3
0
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)
Example #4
0
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)
Example #5
0
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]
Example #6
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)
Example #7
0
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)
Example #8
0
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)
Example #9
0
def setdel(id):
    isbigint(id)
    setstatus(id,0)
Example #10
0
def setstatus(id,status):
    isbigint(id)
    issmallint(status)
    db.update('notes',where='id=$id', status = status, vars=locals(),_test=is_debug)
Example #11
0
def setdel(id):
    isbigint(id)
    setstatus(id, 0)