def listurl(_request):
res = Response()
rsslist = Rssurl.select()
t = SimpleTemplate(file_path=relativepath('urllist.html'))
body = t.render({'rsslist': rsslist})
res.set_body(body)
return res
def index(_request, foo="", d={"counter": 0}):
body = base_body % ("<p>Logged in!</p>")
res = Response()
t = SimpleTemplate(body)
body = t.render(d)
d["counter"] += 1
res.set_body(body)
return res
def login_form(_request, values={}, errors={}):
body = base_body % ("${form.display(values, errors)}")
res = Response()
t = SimpleTemplate(body)
values["password"] = ""
body = t.render({"form": loginform, "values": values, "errors": errors})
res.set_body(body)
return res
def index(_request, d ={'counter':0}):
body = """<html><body><p>${counter}</p></body></html>"""
res = Response()
t = SImpleTemplate(body)
body = t.render(d)
d['counter'] += 1
res.set_body(body)
return res
def login_form(_request, values={}, errors={}):
body = base_body % ('${form.display(values, errors)}')
res = Response()
t = SimpleTemplate(body)
values['password'] = ''
body = t.render({'form': loginform, 'values': values, 'errors': errors})
res.set_body(body)
return res
def index(_request, foo='', d={'counter': '0'}):
body = base_body % ('<p>Logged in!</p>')
res = Response()
t = SimpleTemplate(body)
body = t.render(d)
d['counter'] = str(int(d['counter']) + 1)
res.set_body(body)
return res
def index(_request, d={'counter': '0'}):
body = """<html><body><p>${counter}</p></body></html>"""
res = Response()
t = SimpleTemplate(body)
body = t.render(d)
d['counter'] = str(int(d['counter']) + 1)
res.set_body(body)
return res
def get_add_form(values={}, errors={}):
res = Response()
t = SimpleTemplate(file_path=relativepath('form.html'))
body = t.render({'message': 'RSS巡回用URLの追加',
'form': addform,
'values': values, 'errors': errors})
res.set_body(body)
return res
def login_form(_request, values={}, errors={}):
res=Response()
t=SimpleTemplate(file_path=relativepath('form.html'))
values['password']=''
body=t.render({'form':loginform, 'values':values, 'errors':errors,
'message':u'ログイン'})
res.set_body(body)
return res
def login_form(_request, values={}, errors={}):
body = base_body % ('${form.display(values, errors)}')
res = Response()
t = SimpleTemplate(body)
values['password'] = ''
body = t.render({'form': loginform, 'values': values, 'errors': errors})
res.set_body(body)
return res
def logout(_request):
body = base_body % ('<p>Logged out</p>')
res = Response()
c = SimpleCookie()
c['authhash'] = ''
res.set_header(*c.output().split(': '))
res.set_body(body)
return res
def logout(_request):
body=get_htmltemplate() % ('<p>Logged out</p>')
res=Response()
c=SimpleCookie()
c['authhash']=''
res.set_header(*c.output().split(': '))
res.set_body(body)
return res
def index(_request, foo='', d={'counter': 0}):
body = base_body % ('<p>Logged in!</p>')
res = Response()
t = SimpleTemplate(body)
body = t.render(d)
d['counter'] += 1
res.set_body(body)
return res
def index(_request, d={'counter': '0'}):
body = """<html><body><p>${counter}</p></body></html>"""
res = Response()
t = SimpleTemplate(body)
body = t.render(d)
d['counter'] = '1'
res.set_body(body)
return res
def logout(_request):
body = base_body % ("<p>Logged out</p>")
res = Response()
c = SimpleCookie()
c["authhash"] = ""
res.set_header(*c.output().split(': '))
res.set_body(body)
return res
def wrapper(_request, *args, **kws):
if self.checkfunc(_request):
return func(_request=_request, *args, **kws)
else:
res=Response()
res.status=302
res.set_header('Location', self.loginpath)
res.set_body('')
return res
def wrapper(_request, *args, **kws):
if self.checkfunc(_request):
return func(_request=_request, *args, **kws)
else:
res = Response()
res.status = 302
res.set_header('Location', self.loginpath)
res.set_body('')
return res
def login_form(_request, values={}, errors={}):
res = Response()
t = SimpleTemplate(file_path=relativepath('form.html'))
values['password'] = ''
body = t.render({
'form': loginform,
'values': values,
'errors': errors,
'message': u'ログイン'
})
res.set_body(body)
return res
def add(_request, title='', url=''):
res = Response()
values, errors = addform.validate({'title': title, 'url': url})
if [ x for x in Rssurl.select(url=url)]:
errors['url'] = "このURLは登録済みです"
if errors:
return get_add_form(values, errors)
Rssurl(title=title, url=url)
t = SimpleTemplate(file_path=relativepath('posted.html'))
body = t.render({'message': '巡回用URLを追加しました'})
res.set_body(body)
return res
def login_form(_request, values={}, errors={}):
res = Response()
t = SimpleTemplate(file_path=relativepath("form.html"))
values["password"] = ""
body = t.render({
"form": loginform,
"values": values,
"errors": errors,
"message": u"ログイン"
})
res.set_body(body)
return res
def get_edit_form(item_id, values={}, errors={}):
res = Response()
t = SimpleTemplate(file_path=relativepath('form.html'))
if not values:
for item in Rssurl.select(id=item_id):
pass
values = {'item_id': item_id, 'title':item.title, 'url': item.url}
body = t.render({'message': 'RSS巡回用URLの編集',
'form': editform,
'values': values, 'errors': errors})
res.set_body(body)
return res
def edit(_request, item_id, title='', url=''):
res=Response()
values, errors=editform.validate({'item_id':item_id,
'title':title, 'url':url})
if errors:
return get_edit_form(item_id, values, errors)
for item in Rssurl.select(id=item_id):
item.title=title
item.url=url
t=SimpleTemplate(file_path=relativepath('posted.html'))
body=t.render({'message': u'巡回用URLを編集しました'})
res.set_body(body)
return res
def index(_request):
rsslist = []
try:
for rss in Rssurl.select(order_by='id'):
rsslist.extend(parse_rss(rss.url))
except:
pass
res = Response()
p = path.join(path.dirname(__file__), 'rsslist.html')
t = SimpleTemplate(file_path=p)
body = t.render({'rsslist': rsslist})
res.set_body(body)
return res
def login(_request, username='', password=''):
res = Response()
values, errors = loginform.validate({'username': username,
'password': password})
if errors or fixeduser != username or fixedpass != password:
return login_form(_request, values, errors)
c = SimpleCookie()
m = hashlib.md5((username+':'+password).encode('utf-8'))
c['authhash'] = m.hexdigest()
c['authhash']['expires'] = 'Thu, 1-Jan-2030 00:00:00 GMT'
res.set_header(*c.output().split(': '))
res.status = 302
res.set_header('Location', '/')
res.set_body('')
return res
def login(_request, username="", password=""):
res = Response()
values, errors = loginform.validate({
"username": username,
"password": password
})
if errors or fixeduser != username or fixedpass != password:
return login_form(_request, values, errors)
c = SimpleCookie()
m = md5.md5(username + ":" + password)
c["authhash"] = m.hexdigest()
c["authhash"]["expires"] = "Thu, 1-Jan-3000 00:00:00 GMT"
res.set_header(*c.output().split(": "))
res.status = 302
res.set_header("Location", "/")
res.set_body("")
return res
def login(_request, username='', password=''):
res = Response()
values, errors = loginform.validate({
'username': username,
'password': password
})
if errors or fixeduser != username or fixedpass != password:
return login_form(_request, values, errors)
c = SimpleCookie()
m = md5.md5(username + ':' + password)
c['authhash'] = m.hexdigest()
c['authhash']['expires'] = 'Thu, 1-Jan-2030 00:00:00 GMT'
res.set_header(*c.output().split(': '))
res.status = 302
res.set_header('Location', '/')
res.set_body('')
return res
def index(_request, name='', body='', submit=''):
res=Response()
t=SimpleTemplate(htmlbody)
body=t.render({'name':name, 'body':body})
res.set_body(body)
return res
<p>after firstname : <input id="first" type="text"></p>
<input id="username" type="hidden" value="%s">
<input type="submit" name="submit" value="exe change">
</form>
<script src="../js-dir/pchange.js">
</script>
</body>
"""
html_bodytest = """
<body>
<h1>profile change page</h1>
<p>What do you change infomation?</p>
<form action="change_check.py" method="POST">
<p></p>
<p>after familyname : <input name="family" type="text"></p>
<p>after firstname : <input name="first" type="text"></p>
<input type="submit" name="submit" value="exe change">
</form>
</body>
"""
req = Request()
res = Response()
body = html_bodytest
res.set_body(get_htmltemplate_mypage() % body)
print(str(res))
except:
pass
req=Request()
f=req.form
value_dic={'message':'', 'title':'', 'url':'','bookmarks':''}
if f.has_key('post'):
if f.getvalue('title', '') and f.getvalue('url', ''):
cur.execute("""INSERT INTO bookmark(title, url) VALUES(?, ?)""",
(f.getvalue('title', ''), f.getvalue('url', '')))
con.commit()
else:
value_dic['message']=u'タイトルとURLは必須項目です'
value_dic['title']=f.getvalue('title', '')
value_dic['url']=f.getvalue('url', '')
listbody=''
cur.execute("SELECT title, url FROM bookmark")
for item in cur.fetchall():
listbody+="""<dt>%s</dt><dd>%s</dd>\n"""%(item)
listbody="""<ul>\n%s</ul>"""%listbody
value_dic['bookmarks']=listbody
res=Response()
f=open(path.join(path.dirname(__file__), 'bookmarkform.html'))
t=Template(unicode(f.read(), 'utf-8', 'ignore'))
body=t.substitute(value_dic)
res.set_body(body)
print res
radio_parts=u"""
<input type="radio" name="language" value="%s" />%s
<div style="border-left: solid %sem red; ">%s</div>
"""
lang_dic={}
try:
f=open('./favorite_langage.dat')
lang_dic=pickle.load(f)
except IOError:
pass
content=""
req=Request()
if req.form.has_key('language'):
lang=req.form['language'].value
lang_dic[lang]=lang_dic.get(lang, 0)+1
f=open('./favorite_langage.dat', 'w')
pickle.dump(lang_dic, f)
for lang in ['Perl', 'PHP', 'Python', 'Ruby']:
num=lang_dic.get(lang, 0)
content+=radio_parts%(lang, lang, num, num)
res=Response()
body=form_body%content
res.set_body(get_htmltemplate()%body)
print res
req = Request()
con = MySQLdb.connect(host = 'localhost', db = 'usermanage', user = '******',
passwd = 'python', charset = 'utf8')
cur = con.cursor(MySQLdb.cursors.DictCursor)
str = req.form.getvalue('custname', 'none')
radio = req.form.getvalue('cust', 'none')
template_path = '/var/www/html/cpy/result.html'
if str == "none":
body = u"テキストフィールドに検索する文字を入力してください"
res = Response()
res.set_body(get_htmltemplate() % body)
print res
elif radio == "custini":
cur.execute("""SELECT * FROM main WHERE custini = '%s' FOR UPDATE""" % str)
con.commit()
temp = cur.fetchall()
if temp:
item = temp[0]
t = SimpleTemplate(file_path = template_path)
body = t.render(item)
res = Response()
res.set_body(body)
print res
else:
notapplicable()
def notapplicable():
body = u"該当がありません"
res = Response()
res.set_body(get_htmltemplate() % body)
print res
con = sqlite3.connect("./dbfile.dat")
cur = con.cursor()
try:
cur.execute("""CREATE TABLE language_pole(
name text, value int);""")
except:
pass
req = Request()
if "language" in req.form:
incrementvalue(cur, req.form["language"].value)
lang_dic = {}
cur.execute("""SELECT name, value FROM language_pole;""")
for res in cur.fetchall():
lang_dic[res[0]] = res[1]
content = ""
for lang in ["Perl", "PHP", "Python", "Ruby"]:
num = lang_dic.get(lang, 0)
content += radio_partu.format(lang, lang, num, num)
con.commit()
res = Response()
body = form_body.format(content)
res.set_body(get_htmltemplate("軽量言語アンケート DB版").format(body))
print(res)
