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)