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'))