def index(request, response, db, session, stdin):
user = session.get("username")
if isnull(user):
user = "NO USER"
db.execute("CREATE CACHED TABLE foo (bar VARCHAR(256))")
res = db.query("select bar from foo order by bar")
sb = StringBuilder.new()
sb.append("Index -- overviewOverview
")
sb.append("Hi, ")
sb.append(user)
sb.append("!
")
if isnull(res):
sb.append("No data available
")
else:
sb.append("")
for item in res:
txt = item.getat(0)
sb.append("- ")
sb.append(txt)
sb.append("
")
sb.append("
")
sb.append("")
db.execute("SHUTDOWN")
return sb.toString()
def foo(request, response, db, session, stdin, first, hiho):
sb = StringBuilder.new()
sb.append("INSERT INTO foo (bar) values('")
sb.append(hiho)
sb.append("')")
db.execute(sb.toString())
db.execute("SHUTDOWN")
return hiho
def login(r, e, d, s, i, username):
s.put("username", username)
e.setContentType("text/plain")
y = s.get("username")
return y + "You're logged in now."