def getCond():
sqlstr = [{"sql": "SELECT name FROM db.area order by id;", "name": "地區"},
{"sql": "SELECT name FROM db.figure group by name;", "name": "姓名"},
{"sql": "SELECT term as name FROM db.politician group by term;", "name": "屆別"}]
return DB.execution(DB.select, sqlstr)
def getArticle(type):
sqlstr = "select * from article where =%s" % type
return DB.execution(DB.select, sqlstr)
def findPolicy():
sqlstr = "select id,content from policy"
return DB.execution(DB.select, sqlstr)
def findProposal():
sqlstr = ("select id from proposal" % id)
print(sqlstr)
data = DB.execution(DB.select, sqlstr)
return data
def findHash(hashtag):
sqlstr = "select id from hashtag"
return DB.execution(DB.select, sqlstr)
def identity():
sqlstr = "select * from identity"
return DB.execution((DB.select), sqlstr)
def findPolitician():
sqlstr = "select id,figure_id from politician"
return DB.execution(DB.select, sqlstr)
def findProposal():
sqlstr = "select id,title from proposal"
return DB.execution(DB.select, sqlstr)
def returnproCategory(propsoal_id, category_id):
sqlstr = "insert into proposal_category (propsoal_id, category_id) VALUES (%s, %s)" % (
propsoal_id, category_id)
return DB.execution(DB.create, sqlstr)
def findMessage():
sqlstr = "select id,content from message"
return DB.execution(DB.select, sqlstr)
from tqdm import tqdm
from parsers.asat_usage_extractor import ASATUsageExtractor
from util.downloader import RepoDownloader
from model.db import DB
from util.statistics import compute_statistics
DB_PATH = 'data/projects.sqlite3'
REPOS_PATH = 'repos'
db = DB(DB_PATH)
asats = db.get_ASATs()
projects = db.get_projects()
asat_usage_extractor = ASATUsageExtractor(asats)
downloader = RepoDownloader(REPOS_PATH)
for project in tqdm(projects):
repo_path = downloader.download(project.url)
project.asat_usages = asat_usage_extractor.extract(repo_path)
cloud_projects = [proj for proj in projects if proj.is_cloud_app]
non_cloud_projects = [proj for proj in projects if not proj.is_cloud_app]
print('Statistics for cloud projects:')
compute_statistics(cloud_projects, asats)
print('Statistics for non-cloud projects:')
compute_statistics(non_cloud_projects, asats)
def getArea():
sqlstr = "SELECT name FROM db.area order by id;"
strCond = ""
return DB.execution(DB.select, sqlstr)
def score(user_id, policy_id, ps_id, remark):
sqlstr = ("insert into user_policy(user_id,policy_id,ps_id,remark) values(\"%s\",\"%s\",\"%s\",\"%s\")" %
( user_id, policy_id, ps_id, remark))
return DB.execution(DB.create, sqlstr)
def schedule():
sqlstr = "select * from db.schedule"
return DB.execution(DB.select, sqlstr)
def old_msgList(proposal_id):
sqlstr = "select * from message where proposal_id=\"%s\"" % (proposal_id)
return DB.execution(DB.select, sqlstr)
def returnTitle(lateestnewsTitle, createDate):
sqlstr = "insert into article (title, createTime) VALUES (%s, %s)" % (
lateestnewsTitle, createDate)
print(sqlstr)
return DB.execution(DB.create, sqlstr)
def setIdentity(user_id, identity):
sqlstr = f"update user set identity={identity} where id=\"{user_id}\""
return DB.execution(DB.update, sqlstr)
def msgListByUser(user_id):
sqlstr = "select m.*,p.title from message as m join proposal as p on m.proposal_id = p.id where user_id=\"%s\";" % (
user_id)
return DB.execution(DB.select, sqlstr)
def findPolid():
sqlstr = "select name,figure_id,p.id from politician as p inner Join figure as f on f.id =p.figure_id"
return DB.execution(DB.select, sqlstr)
def getSave(user_id):
sqlstr = (
"select * from favorite as f join proposal as p on f.proposal_id=p.id join status as s on p.status_id=s.id where user_id=\"%s\""
% user_id)
return DB.execution(DB.select, sqlstr)
def returnAttend(polid, session1, avg):
sqlstr = "insert into attendance(politician_id,session,attend) VALUES ('%s',%s,%s)" % (
polid, session1, avg)
return DB.execution(DB.create, sqlstr)
def save(user_id, proposal_id):
sqlstr = (
"insert into favorite( user_id,proposal_id) values(\"%s\",\"%s\");" %
(user_id, proposal_id))
return DB.execution(DB.create, sqlstr)
def findPdfurl():
sqlstr = "select id,pdfUrl,term,session_Period,session_Time from proposal where term ='10'"
return DB.execution(DB.select, sqlstr)
def rule():
sqlstr = "select * from rule"
return DB.execution(DB.select, sqlstr)
def returnPdfcontent(content):
sqlstr = "insert into proposal (content) VALUES (%s)" % (
content)
return DB.execution(DB.create, sqlstr)
def returnMessage(postive, iid):
sqlstr = "insert into message set postive = %s where id=\"%s\"" % (
postive, iid)
print(sqlstr)
return DB.execution(DB.create, sqlstr)
def returnCategory(policy_id, category_id):
sqlstr = "insert into policy_category (policy_id, category_id) VALUES (%s, %s)" % (
policy_id, category_id)
return DB.execution(DB.create, sqlstr)
def vote(userid, sp_id, proposal_id):
sqlstr = "insert into user_proposal(user_id,stand_id,proposal_id) values(\"%s\",\"%s\",\"%s\")" % (
userid, sp_id, proposal_id)
return DB.execution(DB.create, sqlstr)
def findCategory():
sqlstr = "select id,name from category"
return DB.execution(DB.select, sqlstr)
def getTerm():
sqlstr = "SELECT term FROM db.politician group by term;"
strCond = ""
return DB.execution(DB.select, sqlstr)