예제 #1
0
    def update_setting(self, key, value):
        """
        Update the value of a setting in the database.

        Arguments:
            key (str): The setting to change
            value (str): The value to change the setting to
        """
        db.modify('settings', 'value=%s', (value, key), where='skey=%s')
예제 #2
0
    def set_status(self, new_status):
        """
        Set the status of the request, and update the database to reflect the new status

        Arguments:
            new_status (PCRStatus): New status for the request
        """
        self.status = new_status
        db.modify('pcr',
                  'status=%s', (int(self.status), self.id),
                  where='id=%s')
예제 #3
0
    def change_user_password(self, username, newpw):
        """
        Set the given user's password to the given password.

        Arguments:
            username (str): The user to change the password for
            newpw (str): The new password
        """
        newpw = newpw.encode('utf-8')
        pwhash = bcrypt.hashpw(newpw, bcrypt.gensalt())
        db.modify('users',
                  'password=%s', (pwhash, username),
                  where='username=%s')
예제 #4
0
 def service_request(self):
     """
     Service this request, updating account credentials in the database, and updating the current status of the request
     """
     for cred in self.creds:
         username, password = cred
         db.set_credential_password(username, password, self.team_id,
                                    self.check_id, self.domain)
     self.completed = datetime.datetime.now()
     db.modify('pcr',
               'completed=%s', (self.completed, self.id),
               where='id=%s')
     self.set_status(PCRStatus.COMPLETE)
예제 #5
0
    delete(id)
    return redirect('/userlist')


@app.route('/update',methods=['POST','GET'])
def update():
    if not session.get('name',None):
	return redirect('login')
    if request.method == 'POST':
	data = dict(request.form)
'''
	condition = ["%s='%s'" % (k,v[0]) for k,v in data.items()]
	sql = 'update users set %s where id = %s' % (','.join(condition),data['id'][0])
	cur.execute(sql)
'''
	modify(data)	
	return redirect('/userlist')
    else:
	id = request.args.get('id',None)
	if not id:
	    errmsg = 'must have id'
	    return render_template('update.html',result=errmsg)
	fields = ['id', 'name', 'name_cn', 'email', 'mobile']
'''
	try:
	    sql = 'select %s from users where id = %s ' % (','.join(fields),id)
	    cur.execute(sql)
	    res = cur.fetchone()
	    user = dict((k,res[i]) for i,k in enumerate(fields))
	    return render_template('update.html', user = user)
	except:
예제 #6
0
    delete(id)
    return redirect('/userlist')


@app.route('/update',methods=['POST','GET'])
def update():
    if not session.get('name',None):
	return redirect('login')
    if request.method == 'POST':
	data = dict(request.form)
'''
	condition = ["%s='%s'" % (k,v[0]) for k,v in data.items()]
	sql = 'update users set %s where id = %s' % (','.join(condition),data['id'][0])
	cur.execute(sql)
'''
	modify(data)	
	return redirect('/userlist')
    else:
	id = request.args.get('id',None)
	if not id:
	    errmsg = 'must have id'
	    return render_template('update.html',result=errmsg)
	fields = ['id', 'name', 'name_cn', 'email', 'mobile']
'''
	try:
	    sql = 'select %s from users where id = %s ' % (','.join(fields),id)
	    cur.execute(sql)
	    res = cur.fetchone()
	    user = dict((k,res[i]) for i,k in enumerate(fields))
	    return render_template('update.html', user = user)
	except:
예제 #7
0
import db
import sys
from threading import Thread

if __name__ == '__main__':
    if len(sys.argv) > 3:
        print("Usage: ./engine [start|stop] [team_number]")
    if len(sys.argv) == 2:
        engine = ScoringEngine()
    if len(sys.argv) == 3:
        team_num = int(sys.argv[2]) - 1
        engine = ScoringEngine(team_num)

    if sys.argv[1] == 'start':
        file_manager = FileManager()
        file_manager_thread = Thread(target=file_manager.manage_files)
        file_manager_thread.start()

        db.modify('settings',
                  set='value=%s',
                  where='skey=%s',
                  args=(True, 'running'))
        engine.start()
    elif sys.argv[1] == 'stop':
        db.modify('settings',
                  set='value=%s',
                  where='skey=%s',
                  args=(False, 'running'))
    else:
        print("Usage: ./engine [start|stop] [team_number]")
예제 #8
0
파일: main.py 프로젝트: mwbond/clearanceDB
    def POST(self):
        db_info = []
        form = web.input()
        layout_txt = form.layoutfile
        reader = csv.reader(cStringIO.StringIO(layout_txt))
        nodes, lanes, links, phases = {}, {}, {}, {}
        heading = ""
        for row in reader:
            try:
                if len(row) == 0:
                    heading = ""
                elif "[" in row[0]:
                    heading = row[0][1:-1]
                elif heading == "Nodes" and row[1] == "0":
                    nodes[row[0]] = {"int_id": row[0]}
                    links[row[0]] = [[], []]
                    lanes[row[0]] = {"speed": [], "phase": [], "peds": []}
                    phases[row[0]] = []
                elif heading == "Links":
                    if row[0] == "RECORDNAME":
                        links["col"] = row[2:]
                    elif row[0] == "Grade" and row[1] in nodes.keys():
                        links[row[1]][0] = row[2:]
                    elif row[0] == "Name" and row[1] in nodes.keys():
                        links[row[1]][1] = row[2:]
                elif heading == "Lanes":
                    if row[0] == "RECORDNAME":
                        lanes["col"] = row[2:]
                    elif row[1] not in lanes.keys():
                        continue
                    elif row[0] == "Speed":
                        lanes[row[1]]["speed"] = row[2:]
                    elif row[0] == "Phase1":
                        lanes[row[1]]["phase"] = row[2:]
                    elif row[0] == "Peds":
                        lanes[row[1]]["peds"] = row[2:]
                elif heading == "Phases":
                    if row[0] == "RECORDNAME":
                        phases["col"] = [p[1:] for p in row[2:]]
                    elif row[0] == "BRP" and row[1] in phases.keys():
                        phases[row[1]] = row[2:]
            except IndexError:
                pass
        lanes_mod = {}
        for int_id in nodes.keys():
            if int_id == "col":
                continue
            matrix = []
            str_phases = map(str, range(1, num_phases + 1))
            brp = list(set(phases[int_id]))
            if "" in brp:
                brp.remove("")
            brp.sort()
            maxes, phase_maxes = [], []
            for index in range(len(brp)):
                if len(brp) == index + 1:
                    maxes.append(brp[index])
                elif brp[index][:2] != brp[index + 1][:2]:
                    maxes.append(brp[index])
            for index in range(len(maxes)):
                phase = phases["col"][phases[int_id].index(maxes[index])]
                if phase in lanes[int_id]["phase"]:
                    phase_maxes.append(phase)
                else:
                    phase_maxes.append("")

            for index in range(len(lanes[int_id]["phase"])):
                phase = lanes[int_id]["phase"][index]
                dirs = lanes["col"][index]
                speed = lanes[int_id]["speed"][index]
                peds = lanes[int_id]["peds"][index]
                mov = ""
                speed = speed or "0"
                if "L" in dirs:
                    mov = "on"
                    speed = "20"
                peds = peds or "0"
                if dirs[:2] in links["col"]:
                    i = links["col"].index(dirs[:2])
                    road = links[int_id][1][i]
                    grade = links[int_id][0][i]
                else:
                    road = ""
                    grade = ""
                end = []
                if phase in phase_maxes:
                    barrier = maxes[phase_maxes.index(phase)][0]
                    print barrier
                    for brp in maxes:
                        if brp[0] == barrier:
                            p = phase_maxes[maxes.index(brp)]
                            if p and p != phase and int(p) > 0 and int(p) <= num_phases:
                                end.append(p)
                end = ",".join(end)

                if phase in str_phases:
                    matrix.append([phase, dirs, speed, grade, mov, road, end])
                    str_phases.pop(str_phases.index(phase))
            for phase in str_phases:
                matrix.append([phase] + [""] * 7)
            matrix.sort(key=lambda x: x[0])
            lanes_mod[int_id] = zip(*matrix)

        for int_id in nodes.keys():
            nodes[int_id]["dir"] = ";".join(lanes_mod[int_id][1])
            nodes[int_id]["speed"] = ";".join(lanes_mod[int_id][2])
            nodes[int_id]["grade"] = ";".join(lanes_mod[int_id][3])
            nodes[int_id]["mov"] = ";".join(lanes_mod[int_id][4])
            nodes[int_id]["road"] = ";".join(lanes_mod[int_id][5])
            nodes[int_id]["end"] = ";".join(lanes_mod[int_id][6])
            nodes[int_id]["min_walk"] = "7"

            names = list(set(links[int_id][1]))
            if "" in names:
                names.remove("")
                if len(names) > 1:
                    nodes[int_id]["minor"] = names[1]
                if len(names) > 0:
                    nodes[int_id]["major"] = names[0]
            db.modify(**nodes[int_id])
        raise web.seeother("/")
예제 #9
0
파일: main.py 프로젝트: mwbond/clearanceDB
 def POST(self):
     form = dict(web.input())
     db.modify(**form)
     raise web.seeother("/overview")
예제 #10
0
파일: main.py 프로젝트: mwbond/clearanceDB
 def POST(self):
     form = dict(web.input())
     db.modify(**form)
     raise web.seeother("/intersection" + "?IntID=" + form["int_id"])