def channels():
message = """select live_channel.chid,tvs_channel.chname,live_server.live_ip,live_url.live_path,live_status.sname """
message += """from tvs_channel,live_channel,live_server,live_url,live_status where tvs_channel.chid=live_channel.chid and """
message += """live_status.statusid=live_channel.statusid and live_url.live_urlid=live_channel.live_urlid and live_url.serverid = live_server.serverid """
message += """and live_url.status=0 order by live_channel.chid """
conn = my_sql.connect()
cursor = conn.cursor()
cursor.execute(message)
result = cursor.fetchall()
conn.close()
headers = ["频道名称", "直播地址", "直播路径", "发布状态"]
print(yate.start_response())
print(yate.include_header("JSB living system"))
print(yate.start_form("edit.py"))
print(yate.start_table(tb_width="80%", tb_border="1px solid"))
print(yate.tb_caption("已发布频道"))
print(yate.tb_header(headers))
for array in result:
print(yate.tb_data(array[1:]))
print(yate.end_table())
print(yate.end_form())
print(yate.include_footer({"Home": "/index.html"}))
def do_web_process():
#test functions for yate.py
print(yate.start_response())
print(yate.start_response("text/plain"))
print(yate.start_response("application/json"))
print(yate.include_header("Test title for my web application in python test"))
print(yate.include_footer({'Home':'/index.html', 'Select':'/cgi-bin/select.py'}))
print(yate.start_form("/cgi-bin/process-athlete.py"))
#print(urllib.request.urlopen('http://192.168.0.1/test.py', urllib.parse.urlencode({'a':'c'})))
print(urllib.parse.urlencode({'a':'c'}))
the_files = ['testdata/sarah2.txt', 'testdata/james2.txt', 'testdata/mikey2.txt']
data = put_to_store(the_files)
for each_data in data:
print(data[each_data].name+' '+data[each_data].dob)
data_copy = get_from_store()
for each_data in data_copy:
print(data_copy[each_data].name+' '+data_copy[each_data].dob)
#start simple http server for test
simple_http_server_test()
pass
#! /usr/bin/python3
# -*- coding: gbk -*-
import cgi
import athletemodel
import yate
athletes = athletemodel.get_from_store()
form_data = cgi.FieldStorage()
athlete_name = form_data['which_athlete'].value
print(yate.start_response())
print(yate.include_header(athlete_name+"的情报收集"))
print(yate.header("角色英文名:"+athletes[athlete_name].ename+",生日:"+athletes[athlete_name].dob+"."))
print(yate.para("登场作品:"))
print(yate.para(athletes[athlete_name].movie))
print(yate.include_footer({"返回首页":"/index.html","选择其他角色":"generate_list.py"}))
import cgi
import cgitb
cgitb.enable()
#这两行代码启用python的CGI跟踪技术
import athletemodel
import yate
athletes = athletemodel.get_from_store()
# 从模型获得数据
form_data = cgi.FieldStorage()
#所有表单数据，并放到一个字典中
athlete_name =form_data['which_athlete'].value
#从表单数据中访问一个指定的数据
print(yate.start_response())
print(yate.include_header("Coach Kelly's Timing Data"))
print(yate.header("Athlete: " + athlete_name + ", DOB: " +
athletes[athlete_name].dob + "."))
print(yate.para("The top times for this athlete are:"))
print(yate.u_list(athletes[athlete_name].top3))
print(yate.include_footer({'Home':"/index.html",
"Select anthor athlete:":"generate_list.py"}))
#! /usr/local/bin/python3
import athletemodel_sqlite3
import yate
athletes = athletemodel_sqlite3.get_namesID_from_store()
print(yate.start_response())
print(yate.include_header("Coach Kelly's List of Athletes"))
print(yate.start_form("generate_timing_data_sqlite3.py"))
print(yate.para("Select an athlete from the list to work with:"))
for each_athlete in sorted(athletes):
print(
yate.radio_button_id("which_athlete", each_athlete[0],
each_athlete[1]))
print(yate.end_form("Select"))
print(yate.include_footer({"Home": "/index_sqlite3.html"}))
#! /usr/local/bin/python3
import cgitb
cgitb.enable()
import athletelist_model #to get data from model py
import yate #to html texts
import cgi
athletes = athletelist_model.get_from_store() #get data from pickled format
#get form data
form_data = cgi.FieldStorage()
athlete_name = form_data['which_athlete'].value
#print html page
print(yate.start_response())
print(yate.include_header("Coach Kelly's Timing Data"))
print(yate.header("Athlete: " + athlete_name + ", DOB: " +athletes[athlete_name].dob + "."))
print(yate.para("The top times for this athlete are:"))
print(yate.u_list(athletes[athlete_name].top3()))
print(yate.include_footer({"Home": "/index.html","Select another athlete": "athletelist_generate_list.py"}))
#!/usr/bin/python3
import yate
import wishmodel
import get_db_path
wishes = wishmodel.get_wishes_from_store()
#时间倒序排序
wishes.sort(key = lambda x:x[5], reverse=1)
#生成页面
print(yate.start_response())
print(yate.include_header("心愿墙"))
boxes = yate.include_wishes_form(wishes)
print(yate.include_footer(boxes))
#!/usr/local/bin/python
import cgi
import athletemodel
import yate
import sys
athletes = athletemodel.get_from_store()
form_data = cgi.FieldStorage()
athlete_name = form_data["which_athlete"].value
print(yate.start_response())
print(yate.include_header('Coach Kellys Timing Data'))
print(yate.header("Athlete: " + athlete_name + "DOB: " + athletes[athlete_name].dob + "."))
print(yate.para("Top three times for this athlete are:"))
print(yate.u_list(athletes[athlete_name].top3()))
print(yate.include_footer({"Home":"/index.html", "Select another Athlete":"/cgi-bin/generate_list.py"}))
#! /usr/bin/python3
# -*- coding: utf-8 -*-
import athletemodel
import yate
import glob
data_files = glob.glob("data/*.txt")
athletes = athletemodel.put_to_store(data_files)
print(yate.start_response())
print(yate.include_header("老司机 Silence 的资源收藏"))
print(yate.start_form("generate_timing_data.py"))
print(yate.para("请选择你想要深入了解的角色:"))
for each_athlete in athletes:
print(yate.radio_button("which_athlete",athletes[each_athlete].name))
print(yate.end_form("选择"))
print(yate.include_footer({"返回首页":"/index.html"}))
import cgitb
cgitb.enable()
import cgi
import athletemodel
import yate
athletes = athletemodel.get_from_store()
form_data = cgi.FieldStorage()
athlete_name = form_data['which_athlete'].value
print(yate.start_response())
print(yate.include_header("Athlete's timing data:"))
#print(yate.para(athlete_name+"'s time data:"))
print(
yate.header("Athlete:" + athlete_name + ",DOB = " +
athlete[athlete_name].dob + '.'))
print(yate.para("The top times for this athletes are:"))
print(yate.u_list(athletes[athlete_name].top3))
print(
yate.include_footer({
"Home": "index.html",
"Choose another athlete": "generate_list.py"
}))
import cgi
import cgitb
cgitb.enable()
import yate
import athletemodel
athletes = athletemodel.get_from_store()
form_data = cgi.FieldStorage()
athlete_name = form_data['which_athlete'].value
print(yate.start_response())
print(yate.include_header('coach keyy timing data'))
print(
yate.header('Athlete: ' + athlete_name + ',dob: ' +
athletes[athlete_name].dob + '.'))
print(yate.para('the top times for this athlete are :'))
print(yate.u_list(athletes[athlete_name].top3))
print(
yate.include_footer({
'home': '/index.html',
'selecte anther athlere': 'generate_list.py'
}))
try:
with open(RecordFilePath, mode='r', encoding='utf-8') as readfile:
jsonstring = json.loads(readfile.read().strip())
WrongRecDict = OrderedDict()
for Arec in sorted(jsonstring.keys(), reverse=True):
WrongRecDict[Arec] = Arec + '(<span style="color:red">' + str(
len(jsonstring[Arec])) + '</span>)'
print(yate.para('请选择查看哪天的错题？'))
print(yate.start_form('WrongRecord.py'))
print(yate.select_set('WrongRecSelect', WrongRecDict))
print(yate.end_form('确定', 'sub'))
try:
Recordkey = form_data['WrongRecSelect'].value
print(yate.para(''))
print(
yate.header(
'以下为 <ins>%s</ins> 的错题记录（共 <ins>%d</ins> 道）：' %
(Recordkey, len(jsonstring[Recordkey])), 2))
print(yate.u_list(jsonstring[Recordkey]))
except KeyError:
pass
finally:
print(yate.header('', 2))
except FileNotFoundError:
print(yate.header('目前没有错误记录，请继续努力！', 1))
print(yate.include_footer({'返回首页': '/index.html'}))
# -*- coding: utf-8 -*-
"""
这是一个生成算术表述式的脚本
"""
import arithmetic_training_games as ATG
import yate
import cgi
form_data = cgi.FieldStorage()
if(isinstance(form_data['operator'],list)):
OperatorList = [x.value for x in form_data['operator']]
else:
OperatorList = form_data['operator'].value
print(yate.start_response())
print(yate.include_header('这是查看结果页面'))
print(yate.header('%s'%('=' * 10 + '以下为测试结果' + '=' * 10),3))
print(yate.header(str(OperatorList)))
footer_string = '=' * 10 + '结束' + '=' * 10
print(yate.include_footer({footer_string:''}))
#! /usr/bin/env python
import cgi
import athletemodel
import yate
import cgitb
#cgitb.enable()
form_data = cgi.FieldStorage()
athlete_id = form_data['which_athlete'].value
athlete = athletemodel.get_athlete_from_id(athlete_id)
print(yate.start_response())
print(yate.include_header("NUAC's Timing Data"))
print(yate.header("Athlete: " + athlete['Name'] + " DOB: " + athlete['DOB'] + "."))
print(yate.para('The top times for this athlete are:'))
print(yate.u_list(athlete['top3']))
print(yate.para("The entire set of timing data is: " + str(athlete['data']) + " (duplicates removed)."))
print(yate.include_footer({'Home': '/index.html', 'Select another athlete': 'generate_list.py'}))
#!/usr/local/bin/python3
import athletemodel
import yate
import cgi
import cgitb
cgitb.enable()
form_data = cgi.FieldStorage()
athlete_id = form_data['which_athlete'].value
athlete = athletemodel.get_athlete_from_id(athlete_id)
print(yate.start_response())
print(yate.include_header("Coach Kelly's Timing Data"))
print(yate.header("Athlete:" + athlete['Name'] + ",DOB:" + athlete['DOB'] + "."))
print(yate.para("The times for this athlete are:"))
print(yate.u_list(athlete['top3']))
print(yate.para("The entire set of timing data is: " + str(athlete['data']) + "(duplicates removed)."))
print(yate.include_footer({"Home":"/index.html","Choose":"generate_list.py"}))
#! /usr/local/bin/python3
import cgi
import cgitb
cgitb.enable()
import athletemodel
import yate
athletes = athletemodel.get_from_store()
form_data = cgi.FieldStorage()
athlete_name = form_data['which_athlete'].value
print(yate.start_response())
print(yate.include_header("Coach Kelly's Timing Data"))
print(yate.header("Athlete: " + athlete_name + ", DOB: " +
athletes[athlete_name].dob + "."))
print(yate.para("The top times for this athlete are:"))
print(yate.u_list(athletes[athlete_name].top3()))
print(yate.include_footer({"Home": "/index.html",
"Select another athlete": "generate_list.py"}))
import cgi
import yate
import athletemodle
form_data = cgi.FieldStorage()
athlete_name = form_data['which_athlete'].value
athlete = athletemodle.get_from_store()[athlete_name]
print(yate.start_response())
print(yate.include_header(athlete_name + " 's timing: " + " " + athlete.dob))
print(yate.u_list(athlete.top3()))
the_links = {
"Home": "/index.html",
"Choose another athlete": "/cgi-bin/generate_list.py"
}
print(yate.include_footer(the_links))
#!/usr/local/bin/python3
#coding=utf-8
import athletemodel
import glob
import yate
data_files = glob.glob("data/*.txt")
ath = athletemodel.put_to_store(data_files)
print(yate.start_response())
print(yate.include_header("Coach Kelly's List of Athletes'"))
print(yate.start_form("generate_time_data.py"))
print(yate.para("Select an athlete from the list:"))
for each in ath:
print(yate.radio_button("which_athlete", ath[each].name))
print(yate.end_form("Select"))
print(yate.include_footer({"Home": "/index.html"}))
#! /usr/local/bin/python3
import cgi
import cgitb
import athletemodel
import yate
cgitb.enable()
form_data = cgi.FieldStorage()
athlete_id = form_data['which_athlete'].value
athlete = athletemodel.get_athlete_from_id(athlete_id)
print(yate.start_response())
print(yate.include_header("NUAC's Timing Data"))
print(
yate.header("Athlete:" + athlete['Name'] + ",Dob:" + athlete['Dob'] + "."))
print(yate.para("The top times for this athlete are:"))
print(yate.u_list(athlete['top3']))
print(
yate.para("The entire set of timing data is: " + str(athlete['data']) +
".(dumplicates removed)"))
print(
yate.include_footer({
"Home": "/index.html",
"Select another athlete": "generate_list.py",
"Add time": "test-form.py?AthleteId=" + athlete_id
}))
#! /usr/bin/env python
import athletemodel
import yate
import cgitb
#cgitb.enable()
athletes = athletemodel.get_namesID_from_store()
print(yate.start_response())
print(yate.include_header("NUAC's List of Athletes"))
print(yate.start_form('generate_timing_data.py'))
print(yate.para('Select an athlete from the list to work with: '))
for each_athlete in sorted(athletes):
print(yate.radio_button_id('which_athlete', each_athlete[0], each_athlete[1]))
print(yate.end_form('Select'))
print(yate.include_footer({'Home': '/index.html'}))
#! /usr/local/bin/python3
import cgi
import athletemodel
import yate
#处理选中选手的数据
form_data = cgi.FieldStorage()
athlete_id = form_data['which_athlete'].value #这边书里面还是athlete_name，导致下面调用没有定义。
athlete = athletemodel.get_athlete_from_id(athlete_id)
#用yata里面的内容返回成网页可以理解的内容
print(yate.start_response())
print(yate.include_header("运动员的成绩"))
print(
yate.header("运动员：" + athlete['Name'] + ", 出生日期：" + athlete['DOB'] +
" ."))
print(yate.para("最好成绩: "))
print(yate.u_list(athlete['top3']))
print(
yate.para("the entire set of timing data is: " + str(athlete['data']) +
"(duplicates removed).")) #增加了显示所有数据的内容
print(
yate.include_footer({
"返回主页": "/index.html",
"查看其他运动员成绩": "generate_list.py"
}))
#! /usr/bin/env python3
import glob
import athletemodel
import yate
data_files = glob.glob("data/*.txt")
athletes = athletemodel.put_to_store(data_files)
print(yate.start_response())
print(yate.include_header("Coach Kelly's List of Athletes"))
print(yate.start_form("generate_timing_data.py"))
print(yate.para("Select an athlete from the list to work with:"))
for each_athlete in athletes:
print(yate.radio_button("which_athlete", athletes[each_athlete].name))
print(yate.end_form("Select"))
print(yate.include_footer({"Home": "/index.html"}))
import cgi
import cgitb
import athletemodel
import yate
cgitb.enable()
athletes = athletemodel.get_from_store()
form_data = cgi.FieldStorage()
athlete_name = form_data['which_athlete'].value
print(yate.start_response())
print(yate.include_header("Coach Kelly's Timing Data"))
print(
yate.header("Athlete: " + athlete_name + " DOB: " +
athletes[athlete_name].dob + "."))
print(yate.para("The top times for this athlete are: "))
print(yate.u_list(athletes[athlete_name].top3))
print(
yate.include_footer({
"Home": "/index.html",
"Select another athlete": "generate_list.py",
"JSON Response": "generate_names.py"
}))
import cgi
import cgitb
import athletemodel
import yate
cgitb.enable()
plays = athletemodel.get_from_store()
form_data = cgi.FieldStorage()
name = form_data['which_player'].value
print(yate.start_response())
print(yate.include_header("Coack Kelly's timing data"))
print(yate.header("player name:" + name + ",birthday:" + plays[name].dob))
print(yate.para("top times"))
print(yate.u_list(plays[name].top3))
print(
yate.include_footer({
"Click here to go Home":
"/index.html",
"Click here to select another player":
"generate_list.py"
}))
import athletemodel
import yate #模板
import cgi
#启用python的cgi跟踪技术
import cgitb
cgitb.enable()
#获取表单提交的数据
form_data = cgi.FieldStorage(
) #获取所有表单数据;cgi.FieldStorage()返回一个字典，字典的每一个key就是变量名，key对应的值就是变量名的值
# athlete_name=form_data['which_athlete'].value
athlete_id = form_data['which_athlete'].value
#从模型得到数据
athletes = athletemodel.get_athlete_from_id(athlete_id)
print(yate.start_response())
print(yate.include_header("---'NUAC's Timing Data---------------"))
print(
yate.include_header("Athlete:" + athletes['Name'] + "|dob:" +
athletes['Bob']))
print(yate.para("The top3 times is:"))
print(yate.u_list(athletes['top3']))
print(yate.include_footer({"Home": "/index.html"}))
print(yate.include_footer({"Other athletes": "/cgi-bin/generate_list.py"}))
import yate
import cgitb
cgitb.enable()
# 纯文本发回给等待的web浏览器
# print(yate.start_response('text/plain'))
print(yate.start_response('text/html'))
# 将页面输入的数据转换为一个字典
form_data = cgi.FieldStorage()
try:
the_name = form_data['athlete_name'].value
the_time = form_data['TimeValue'].value
connection = pymysql.connect(host="localhost",port=3306,user="******", \
passwd="root",db="test",charset="utf8")
cursor = connection.cursor()
cursor.execute("""SELECT id FROM athletes WHERE name=%s""", (the_name))
the_id = cursor.fetchone()[0]
cursor.execute("""INSERT INTO timing_data (athlete_id, value) VALUES (%s, %s)""",\
(the_id, the_time))
connection.commit()
connection.close()
print('OK.')
except KeyError as kerr:
print(str(kerr) + ' error: must input name and time value!')
print(yate.include_footer({'Home':'/index.html',\
'Selecte another athlete':'generate_list.py'}))
if len(form_data.list) == 1:
connection = sqlite3.connect("target/coach_data.sqlite")
cursor = connection.cursor()
cursor.execute("SELECT value FROM timing_data as t INNER JOIN athletes as a on a.id=t.athlete_id where a.name=?",
(athlete_name,))
values = cursor.fetchall()
times = []
for value in values:
times.append(value[0])
print(yate.start_response())
print(yate.include_header("Coack Kelly's timing data"))
print(yate.header("player name:" + athlete_name))
print(yate.para("top times"))
print(yate.u_list(times))
print(yate.include_footer(
{"Click here to go Home": "/index.html", "Click here to select another player": "generateL_list_sqlite3.py"}
))
connection.commit()
connection.close()
else:
time_value = form_data['time_value'].value
connection = sqlite3.connect("target/coach_data.sqlite")
cursor = connection.cursor()
cursor.execute("SELECT id FROM athletes WHERE name = ?", (athlete_name,))
athlete_id = cursor.fetchone()[0]
cursor.execute("INSERT INTO timing_data (athlete_id, value) VALUES (? ,?)", (athlete_id, time_value))
connection.commit()
connection.close()
print(yate.start_response())
print(yate.include_header("OK"))
print(yate.include_footer({"Click here to go Home": "/index.html"}))
print ('</br>')
print('<h2>' + "these are Rules produced by Aprori" +'</h2>')
for name in candidateList:
print('<h3>' + name +'</h3>')
print ('<p>' + "Rule number: " +str(mixInfoDic[name]['rule_num']) +'</p>')
print ('</br>')
print ('<p>' + "min_support: " + str(mixInfoDic[name]['min_support']) + " min_confidence: " + str(mixInfoDic[name]['min_confidence']) +'</p>')
print ('</br>')
for left, right, c in zip(mixInfoDic[name]['leftHand'],mixInfoDic[name]['rightHand'],mixInfoDic[name]['conf'] ):
print ('<p>' + left.encode("utf-8") + ' --> '+ right.encode("utf-8") + ' ' + str(c) + '</p>')
print ('</br>')
print(yate.include_footer({"Done, go back to Google": "/index.html"}))
"""
mixData = {'min_support': min_support,
'min_confidence': min_confidence,
'leftHand': leftHand,
'rightHand': rightHand,
'BOW': BOW,
'dictionary': dictionary,
'rule_num': rule_num}
"""
import athletemodel
import yate
import glob #this module lets you query your operating system for a list of file names
data_files = glob.glob(
"data/*.txt"
) #creating a list of the file names of type '*.txt' within folder 'data'
athletes = athletemodel.put_to_store(
data_files) #creating a dictionary of athletes from the list of data files
print(yate.start_response()) #always start with a Content-type line
print(yate.include_header(
"Coach Kelly's List of Athletes")) #provide a title for the page
print(
yate.start_form("generate_timing_data.py")
) #start generating the form providing the name of the server-side program to link to.
print(yate.para("Select an athlete from the list to work with:"))
for each_athlete in athletes: #generate a radio button for each athlete
print(yate.radio_button("which_athlete", athletes[each_athlete].name))
print(yate.end_form(
"Select")) # end the form with a custom text for the submit button
print(yate.include_footer({"Home": "/index.html"
})) # a link to go back to the Home page
import glob
import athletemodel
import yate
files = glob.glob("data/*.txt")
plays = athletemodel.put_to_store(files)
print(yate.start_response())
print(
yate.include_header(
"Coack Kelly's List of Plays, attention: data comes from pickle"))
print(yate.start_form("generate_time_data.py"))
print(yate.para("Click here to select an play you want to see"))
for play in plays:
print(yate.radio_button("which_player", plays[play].name))
print(yate.end_form("Select to show detail"))
print(yate.include_footer({"Click here to go Home": "/index.html"}))
#!/usr/bin/python3
import athletemodel
import yate
import cgi
import cgitb
cgitb.enable()
form_data = cgi.FieldStorage()
athelete_name = form_data['which_athelete'].value
atheletes = athletemodel.get_from_store()
print(yate.start_response())
print(yate.include_header("Coach Kelly's Timing Data"))
print(
yate.header("Timing data for :" + athelete_name + ", DOB: " +
atheletes[athelete_name].dob))
print(yate.para("The top times for this athelete are:"))
print(yate.u_list(atheletes[athelete_name].top3))
print(
yate.include_footer({
"Home": "/index.html",
"Select Another Athelete": "/cgi-bin/generate_list.py"
}))
import glob
import athletemodel
import yate
data_files = glob.glob('data/*.txt')
athletes = athletemodel.put_to_store(data_files)
print(yate.start_response())
print(yate.include_header("Coach Kelly's List of Athletes"))
print(yate.start_form("generate_timing_data.py"))
print(yate.para('Select an athlete from the list to work with:'))
for each_athlete in athletes:
print(yate.radio_button("which_athlete", athletes[each_athlete].name))
print(yate.end_form("Select"))
print(yate.include_footer({'Home': '/index.html'}))
#! /usr/local/bin/python3
import athletemodel
import yate
import glob
data_files = glob.glob("data/*.txt")
athletes = athletemodel.put_to_store(data_files)
print(yate.start_response())
print(yate.include_header("Coach Kelly's List of Athletes"))
print(yate.start_form("generate_timing_data.py", "GET"))
print(yate.para("Select an athlete from the list to work with:"))
for each_athlete in athletes:
print(yate.radio_button("which_athlete", athletes[each_athlete].name))
print(yate.end_form("Select"))
print(
yate.include_footer({
"Home": "/index.html",
"PHP": "http://127.0.0.1:80/php.php?name=xxx"
}))
#! /usr/local/bin/python3
import cgi
# import cgitb
# cgitb.enable()
import athletemodel
import yate
athletes = athletemodel.get_from_store()
form_data = cgi.FieldStorage()
athlete_name = form_data['which_athlete'].value
print(yate.start_response())
print(yate.include_header("Coache Kelly's Timing Data"))
print(
yate.header('Athlete:' + athlete_name + ', DOB:' +
athletes[athlete_name].dob + '.'))
print(yate.para('The top times for this athlete are: '))
print(yate.u_list(athletes[athlete_name].top3))
print(
yate.include_footer({
'Home': '/index.html',
'Select another athlete': '/cgi-bin/generate_list.py'
}))
#! /usr/local/bin/python3
import athletemodel
import yate
import cgi
import cgitb
cgitb.enable()
athletes = athletemodel.get_from_store()
form_data = cgi.FieldStorage()
athlete_name = form_data['which_athlete'].value
print(yate.start_response())
print(yate.include_header("Athlete's best 3 score"))
print(yate.para(athlete_name + "'s score"))
print(yate.u_list(athletes[athlete_name].top3))
print(yate.include_footer({"Home": "/index.html", "Select anthoer player": "generate_list.py"}))
import athletemodel
import yate
import glob
data_files = glob.glob("data/*.txt")
athletes = athletemodel.put_to_store(data_files)
print(yate.start_response())
print(yate.include_header("The List of Athletes"))
print(yate.start_form("generate_timing_data.py"))
print(yate.para("Select an athlete from the list to work with:"))
for each_athlete in athletes:
print(yate.radio_button("which_athlete", athletes[each_athlete].name))
print(yate.end_form("Select"))
print(yate.include_footer({'Home':"/index.html"}))
import yate
import athletemodel
import cgi
import os
form_data = cgi.FieldStorage()
athlete_name = form_data['which_athlete'].value
#athlete_name="Sarah Sweeney"
print(yate.start_response())
print(yate.include_header(athlete_name + "'s timing"))
#print(yate.para(athlete_name+"'s timing"))
data = athletemodel.get_from_store()
athlete = data[athlete_name]
print(yate.u_list(sorted(set(athlete))[:3]))
print(
yate.include_footer({
"Home": "/index.html",
"Select another athlete": "generate_list.py"
})) #os.path.join(os.getcwd(),"index.html")
yate.td_tag('等级' + AwardLevel),
yate.td_tag(AwardTable[AwardLevel]['AwardValue'],
id='level' + AwardLevel),
yate.td_tag(
img_string +
'<span style="position:relative;top:-8px;left:2px"> × %d </span>' %
AwardTable[AwardLevel]['AwardReq']),
yate.td_tag(AwardTable[AwardLevel]['AwardReq'],
id='value' + AwardLevel,
display=False),
yate.td_tag(
yate.subbutton(
'兑换',
'Awardconfirm(\'%s\',\'%s\',\'%s\')' %
('level' + AwardLevel, 'value' + AwardLevel, 'AwardCountid'),
status=status_string,
style=style_string))))
print('</table>')
print('<div id="AwardCountid" style="display:none;">%d</div>' % RealAwardCount)
# ======= 以下构造一个表单，将本次兑换花费奖励值传给后台 ========
print(yate.start_form('AwardTable.py', name='formAward'))
print(yate.input_hidden('awardcost'))
print('</form>')
# ======= 以下为页脚部分 ========
FooterString = OrderedDict()
FooterString['返回首页'] = '/index.html'
FooterString['开始练习'] = 'expresssion_set.py'
print(yate.include_footer(FooterString))
page = page + (yate.addcomment('BEGIN CONTENT'))
page = page + (yate.opendiv('page-content-wrapper'))
page = page + (yate.opendiv('page-content-wrapper'))
page = page + (yate.opendiv('page-content'))
page = page + (yate.addtitle("CodeVald", "MySql -> XML"))
page = page + (yate.addcomment('BEGIN PAGE CONTENT'))
page = page + (yate.addcomment('BEGIN Portlet PORTLET'))
Content = yate.addcontent('content/MySqltoXML.html')
page = page + (Content)
page = page + (yate.addcomment('END PAGE CONTENT'))
page = page + (yate.closediv())
page = page + (yate.closediv())
page = page + (yate.closediv())
page = page + (yate.addcomment('END CONTENT'))
page = page + (yate.closediv())
#End Content
#Footer
page = page + (yate.include_footer({"Home": "/index.html"}))
#End Footer
page = yate.setformvalues(page, form)
#convert = MySQLtoXML(form["txtMySQL"].value)
#xml = mySQLtoXML.GetXML
print(page)
#! /usr/bin/env python
import cgitb; cgitb.enable()
import athletemodel
import yate
import glob
data_files = glob.glob("data/*.txt")
athletes = athletemodel.put_to_store(data_files)
print yate.start_response()
print yate.include_header("Coach Kelly's List of Athletes")
print yate.start_form("generate_timing_data.py")
print yate.para("Select an athlete from the list to work with:")
for each_athlete in athletes:
print yate.radio_button("which_athlete", each_athlete)
print yate.end_form("Select")
print yate.include_footer({"Home": "../index.html"})
#! /usr/local/bin/python3
import athletelist_model #loaded model file
import yate #html help file
import glob #to list the data files
data_files=glob.glob("data/*.txt")
athletes=athletelist_model.put_to_store(data_files)
print(yate.start_response())
print(yate.include_header("Coach Kelly's List of Athletes"))
print(yate.start_form("athletelist_generate_time.py"))
print(yate.para("Select an athlete from the list to work with:"))
for each_athlete in athletes:
print(yate.radio_button("which_athlete",athletes[each_athlete].name))
print(yate.end_form("Select"))
print(yate.include_footer({"Home": "/index.html"})) #argument is dictiornary list
import MySQLdb as mdb
import cgi
import yate
from TFBS_tools import print_tfbs, print_intervall
from pybedtools import BedTool
con = mdb.connect('genome', 'rsnp', 'RSNP', 'testdb');
header_order = ['TFBS_ID','peak','de_novo_motif','organism','chr','start','stop','target_perc','p']
header = {'TFBS_ID':'TFBS','peak':'PEAK','de_novo_motif':'motif','organism':'Organism','chr':'chr','start':'start','stop':'stop','target_perc':'target%','p':'P'}
a=cgi.FieldStorage()
form_data = a.getvalue('exp')
user_file = a.getvalue('user')
mypath='/var/www/rsnpdb/DATA/BED/'+form_data+'.bed'
a = BedTool(user_file)
b = BedTool(mypath)
result = []
for line in BedTool.intersect(a,b):
result.append(str(line).split())
print(yate.start_response())
print(yate.include_header(''))
for line in result:
print_intervall("'"+line[0][3:].lower()+"'",line[1],line[2])
print(yate.include_footer({""}))
import yate
import athletemodel
import athletelist
import cgi
import cgitb
cgitb.enable()
athletes = athletemodel.get_from_store()
form_data = cgi.FieldStorage()
athlete_name = form_data['which_athlete'].value
print(yate.start_response())
print(yate.include_header("Time Data Page"))
if athlete_name:
print(
yate.header(athletes[athlete_name].name + athletes[athlete_name].dob +
"'s timing data top 3 are:"))
#tops=athletes[athlete_name].top3
print(yate.u_list(athletes[athlete_name].top3))
print(athlete_name)
print(
yate.include_footer({
"Home": "../index.html",
"Another Athlete": "generate_list.py"
}))
#!/usr/bin/python
# -*- coding: utf-8 -*-
import MySQLdb as mdb
import cgi
import yate
def export_ort(line):
ID,TFBS,ORT=line.split(';')
for i in range(len(header)):
if len(ORT.split(',')[i])>40:
print(">"+header[i])
print(ORT.split(',')[i])
header=('hg19','panTro2','gorGor1','ponAbe2','rheMac2','papHam1','calJac1','tarSyr1','micMur1','otoGar1','tupBel1','mm9','rn4','dipOrd1','cavPor3','speTri1','oryCun2','ochPri2','vicPac1','turTru1','bosTau4','equCab2','felCat3','canFam2','myoLuc1','pteVam1','eriEur1','sorAra1','loxAfr3','proCap1','echTel1','dasNov2','choHof1','macEug1','monDom5','ornAna1')
con = mdb.connect('genome', 'rsnp', 'RSNP', 'testdb');
data=[]
form_data = cgi.FieldStorage().getvalue('peak')
with con:
cur = con.cursor()
cur.execute("SELECT data FROM ORTHOLOGS WHERE peak='%s';" % form_data)
data.append(cur.fetchone()[0])
print(yate.start_response())
for i in data:
export_ort(i)
print(yate.include_footer())
#!/usr/local/bin/python3
import cgi
import cgitb
import yate
import athletemodel
cgitb.enable()
athletes = athletemodel.get_from_store()
form_data = cgi.FieldStorage()
athlete_name = form_data["which_athlete"].value
print(yate.start_response())
print(yate.include_header("Coach Kelly's Timing Data:"))
print(
yate.header("Athlete: " + athlete_name + ", DOB: " +
athletes[athlete_name].dob + "."))
print(yate.para("The top times for this athlete are:"))
print(yate.u_list(athletes[athlete_name].top3()))
print(
yate.include_footer({
"Home": "/index.html",
"Select another Athlete": "generate_time_cgi.py"
}))
print(dir())
the_files = ['sarah2.txt', 'james2.txt', 'mikey2.txt', 'julie2.txt']
data = put_to_store(the_files)
print(data)
for each_athlete in data:
print(data[each_athlete].name + ' ' + data[each_athlete].dob)
data_copy = get_from_store()
for each_athlete in data_copy:
print(data_copy[each_athlete].name + ' ' + data_copy[each_athlete].dob)
print(yate.start_response())
print(yate.start_response("text/plain"))
print(yate.start_response("application/json"))
print(yate.include_header("Welcome to my home on the web!"))
print(yate.include_footer({'Home': '/index.html', 'Select': '/cgi-bin/select.py'}))
print(yate.include_footer({}))
print(yate.start_form("/cgi-bin/process-athlete.py"))
print(yate.end_form())
print(yate.end_form("Click to Confirm Your Order"))
for fab in ['John', 'Paul', 'George', 'Ringo']:
print(yate.radio_button(fab, fab))
print(yate.u_list(['Life of Brian', 'Holy Grail']))
print(yate.header("Welcome to my home on the web"))
print(yate.header("This isa sub-sub-sub-sub-heading", 5))
print(yate.para("Was it worth the wait? We hope it was..."))
__author__ = 'micheng'
import athletemodel
import yate
import glob
import cgitb
athletes = athletemodel.get_namesID_from_store()
print(yate.start_response())
print(yate.include_header("NUAC's List of Athletes"))
print(yate.start_form("generate_data_web.py"))
print(yate.para("Select an athlete from the list to work with:"))
for each_athlete in sorted(athletes):
print(yate.radio_button_id("which_athlete", each_athlete[0], str(each_athlete[1])))
print(yate.end_form("Select"))
print(yate.include_footer({"See the Champion": "/cgi-bin/champion.py"}))
print(yate.include_footer({"Home":"/index.html"}))
#! /usr/bin/env python
import cgitb
cgitb.enable()
import cgi
import yate
import athletemodel
athletes = athletemodel.get_from_store()
form_data = cgi.FieldStorage()
if "which_athlete" not in form_data:
print "<H1>Error</H1>"
print "Please choose one athlete."
athlete_name = form_data["which_athlete"].value
the_athlete = athletes[athlete_name]
print yate.start_response()
print yate.include_header("Coach Kelly's Timing Data")
print yate.header("Athlete:" + athlete_name + ", DOB:" + the_athlete.dob + ".")
print yate.para("The top times for " + athlete_name + " are:")
print yate.u_list(the_athlete.top3)
print yate.include_footer({"Home":"index.html", "Select another athlete":"generate_list.py"})
def main():
form_data = cgi.FieldStorage()
print(yate.start_response())
print(yate.include_header('Estatísticas para Loterias do Brasil'))
if not form_data:
print(yate.start_form('', 'jogos.py'))
print(yate.drop_box('Jogo: ', 'Jogos', {'Quina':'Quina',
'Mega-Sena': 'Mega-Sena',
'LotoFácil':'LotoFácil'}, 'Mega-Sena'))
print(yate.drop_box('Estatística: ', 'Estat', {
'doze': 'Dezenas Mais Sorteadas',
'rule': 'Distribuição entre Pares e Impares',
'wors': 'Maior tempo sem ser sorteado',
'more': 'Mais Sorteado',
'aver': 'Média de tempo sem ser sorteado',
'sugs': 'Sugere números com melhor Escore Z',
'sugl': 'Sugere números menos sorteados recentemente',
'sugm': 'Sugere números sorteados recentemente',
'last': 'Última vez sorteado',
'unit': 'Unidades Mais Sorteadas'},
'more'))
print(yate.end_form('Enviar'))
elif form_data.getvalue('Jogos') and form_data.getvalue('Estat'):
jogo = form_data.getvalue('Jogos')
estat = form_data.getvalue('Estat')
if jogo == 'Quina':
obj = QuinaStats('../data/D_QUINA.HTM')
elif jogo == 'Mega-Sena':
obj = SenaStats('../data/d_megasc.htm')
elif jogo == 'LotoFácil':
obj = LotoFacilStats('../data/D_LOTFAC.HTM')
else:
print(yate.para('Opção Inexistente'))
print(yate.include_footer('© LotoEstat 2012'))
return
if form_data.getvalue('Estat') == 'more':
print(yate.header('Números Mais Sorteados'))
print(yate.para('Lista decrescente dos números mais sorteados da ' + form_data.getvalue('Jogos') + '.'))
to_print = obj.prepare_to_print('More', for_print=False)
print(yate.start_tb(['Dezena ', ' Número de Vezes Sorteado']))
for each in to_print:
print(yate.inner_tb([each[0],each[1]]))
print(yate.end_tb())
elif form_data.getvalue('Estat') == 'rule':
print(yate.header('Distribuição entre Pares e Impares'))
print(yate.para('Combinação de pares e ímpares entre os números da ' + form_data.getvalue('Jogos') + '.'))
to_print = obj.print_rule_even_by_odd(for_print=False)
print(yate.start_tb(['Dezenas Pares ', ' Dezenas Ímpares ', ' Número de Vezes Sorteado']))
p = re.compile('\d+')
for each in to_print:
even, odd = p.findall(each[0])
print(yate.inner_tb([even, odd, each[1]]))
print(yate.end_tb())
elif form_data.getvalue('Estat') == 'unit':
print(yate.header('Unidades Mais Sorteadas'))
print(yate.para('Lista das Unidades mais Sorteadas dos Jogos da ' + form_data.getvalue('Jogos') + '.'))
to_print = obj.print_more_often_unit(for_print=False)
print(yate.start_tb(['Dezenas terminadas em ', ' Número de Vezes Sorteado']))
p = re.compile('\d+')
for each in to_print:
unidade = p.findall(each[0])
print(yate.inner_tb([unidade[0], each[1]]))
print(yate.end_tb())
elif form_data.getvalue('Estat') == 'doze':
print(yate.header('Dezenas Mais Sorteadas'))
print(yate.para('Lista das Dezenas mais Sorteadas dos Jogos da ' + form_data.getvalue('Jogos') + '.'))
to_print = obj.print_more_often_dozen(for_print=False)
print(yate.start_tb(['Dezenas Começadas por ', ' Número de Vezes Sorteado']))
p = re.compile('\d+')
for each in to_print:
dezena = p.findall(each[0])
print(yate.inner_tb([dezena[0], each[1]]))
print(yate.end_tb())
elif form_data.getvalue('Estat') == 'last':
print(yate.header('Última vez Sorteado'))
print(yate.para('A quanto tempo a dezena não é sorteada entre os números premiados da ' + form_data.getvalue('Jogos') + '.'))
to_print = obj.prepare_to_print('Last', for_print=False)
print(yate.start_tb(['Dezena ', ' Tempo sem ser sorteada']))
for each in to_print:
print(yate.inner_tb([each[0],each[1]]))
print(yate.end_tb())
elif form_data.getvalue('Estat') == 'wors':
print(yate.header('Maior tempo sem ser sorteado'))
print(yate.para('Pior tempo de espera que um número aguardou para ser sorteado entre todos os sorteios da ' + form_data.getvalue('Jogos') + '.'))
to_print = obj.prepare_to_print('Worst', for_print=False)
print(yate.start_tb(['Dezena ', ' Pior tempo sem ser sorteada']))
for each in to_print:
print(yate.inner_tb([each[0],each[1]]))
print(yate.end_tb())
elif form_data.getvalue('Estat') == 'aver':
print(yate.header('Média de tempo sem ser sorteado'))
print(yate.para('Tempo médio que um número leva até ser sorteado, obtidos à partir do histórico de resultados da ' + form_data.getvalue('Jogos') + '.'))
to_print = obj.prepare_to_print('Average', for_print=False)
print(yate.start_tb(['Dezena ', ' Média de espera entre dois sorteios']))
for each in to_print:
print(yate.inner_tb([each[0],each[1]]))
print(yate.end_tb())
elif form_data.getvalue('Estat') == 'sugm':
print(yate.header('Sugere números sorteados recentemente'))
print(yate.para('Ordena os números da ' + form_data.getvalue('Jogos') + ' levando em conta as estatísticas individuais, favorecendo os números que saíram com mais frequencia e que foram sorteados recentemente.'))
to_print = obj.suggest_num(method='Most Recently', for_print=False)
if form_data.getvalue('Jogos') == 'Quina':
dez_sug = 7
elif form_data.getvalue('Jogos') == 'Mega-Sena':
dez_sug = 15
elif form_data.getvalue('Jogos') == 'LotoFácil':
dez_sug = 15
cabecalho_tabela = []
for num in range(1, dez_sug + 1):
cabecalho_tabela.append(str(num) + 'ª dezena')
print(yate.start_tb(cabecalho_tabela))
lis = []
for each in to_print[:dez_sug]:
lis.append(each[0])
print(yate.inner_tb(lis))
print(yate.end_tb())
elif form_data.getvalue('Estat') == 'sugl':
print(yate.header('Sugere números menos sorteados recentemente'))
print(yate.para('Ordena os números da ' + form_data.getvalue('Jogos') + ' levando em conta as estatísticas individuais, favorecendo os números que saíram com mais frequencia e que estão a mais tempo sem serem sorteados.'))
to_print = obj.suggest_num(method='Least Recently', for_print=False)
if form_data.getvalue('Jogos') == 'Quina':
dez_sug = 7
elif form_data.getvalue('Jogos') == 'Mega-Sena':
dez_sug = 15
elif form_data.getvalue('Jogos') == 'LotoFácil':
dez_sug = 15
cabecalho_tabela = []
for num in range(1, dez_sug + 1):
cabecalho_tabela.append(str(num) + 'ª dezena')
print(yate.start_tb(cabecalho_tabela))
lis = []
for each in to_print[:dez_sug]:
lis.append(each[0])
print(yate.inner_tb(lis))
print(yate.end_tb())
elif form_data.getvalue('Estat') == 'sugs':
print(yate.header('Sugere números com melhor escore padrão'))
print(yate.para('Ordena os números da ' + form_data.getvalue('Jogos') + ' levando em conta o escore padrão de cada um, favorecendo os números com menor desvio padrão da média de tempo de espera para um número ser sorteado.'))
to_print = obj.suggest_num(method='Score', for_print=False)
if form_data.getvalue('Jogos') == 'Quina':
dez_sug = 7
elif form_data.getvalue('Jogos') == 'Mega-Sena':
dez_sug = 15
elif form_data.getvalue('Jogos') == 'LotoFácil':
dez_sug = 15
cabecalho_tabela = []
for num in range(1, dez_sug + 1):
cabecalho_tabela.append(str(num) + 'ª dezena')
print(yate.start_tb(cabecalho_tabela))
lis = []
for each in to_print[:dez_sug]:
lis.append(each[0])
print(yate.inner_tb(lis))
print(yate.end_tb())
print(yate.header('Atualizado em : %s', header_level=6) % obj.print_updated_data())
else :
print(yate.para('Opção por Jogo ou Estatística não efetuada.'))
print(yate.include_footer('© LotoEstat 2012'))
