def printMovieTimes(self, day_id):
dbConn = DBConnection()
cur = dbConn.connection()
query = "SELECT id,time FROM movie_timings where day_id = ?"
for row in cur.execute(query, day_id):
print("[" + str(row[0]) + "]", "\t", row[1])
cur.close()
def printMovieDays(self, movie_id):
dbConn = DBConnection()
cur = dbConn.connection()
query = "SELECT id,day FROM movie_days where movie_id = ?"
for row in cur.execute(query, movie_id):
print("[" + str(row[0]) + "]", "\t", row[1])
cur.close()
def __init__(self):
self.db = DBConnection(
'postgresql://*****:*****@192.168.1.102/controllerdb')
self.topology_manager = TopologyManager(self.db)
self.ryu = RyuManager(self.db)
self._current_mpls_label = 0
self._flows_added = 0
def __init__(self, args):
self.con = DBConnection(args.uri, args.user, args.password)
self.write_prepare()
self.write_dict(args.dict)
self.write_docs(args.docs)
a = time.time()
self.write_terms(args.terms)
print(time.time() - a)
def getBookedSeatNos(self, time_id):
dbConn = DBConnection()
conn = dbConn.connection()
cur = conn.cursor()
seat_no = list()
query = "SELECT row,col from movie_booking where time_id = ?"
for row in cur.execute(query, time_id):
seat_no.append(row)
return seat_no
def predict_accident(self):
insert_into_DB = 1
db = DBConnection()
conn = db.get_connection()
mycursor = conn.cursor()
mycursor.execute("SELECT path FROM buffer")
buffer_items = mycursor.fetchall()
for path_row in buffer_items:
path = path_row[0]
clf = Classify(path)
class_name, percentage = clf.classify_image()
if (class_name[0] is 'a'
or class_name[0] is 'A') and (insert_into_DB is 1):
insert_into_DB = 0
print('accident detected')
Camera_id = 'CAM001'
db1 = DBConnection()
conn1 = db1.get_connection()
mycursor1 = conn1.cursor()
mycursor1.execute("SELECT count(path) FROM Accident")
count_row = mycursor1.fetchone()
new_path = '../accident/Accident' + str(count_row[0]) + '.jpg'
copyfile(path, new_path)
date_time = datetime.datetime.now().strftime(
"%Y-%m-%d %H:%M:%S")
timestamp = time.time()
sql1 = "insert into Accident(Camera_id,path,date_time,timestampAcc) values(%s,%s,%s,%s);"
mycursor1.execute(
sql1, [Camera_id, new_path, date_time,
int(timestamp)])
conn1.commit()
mycursor1.execute(
"UPDATE flag set flag_var = 1 where flag_key = 1;")
conn1.commit()
mycursor1.execute(
"UPDATE smbool set continue_buffer = 0 where flag_var = 0")
conn1.commit()
if (insert_into_DB is 0):
print('skipping database entry')
sql = "DELETE FROM buffer WHERE path = %s"
mycursor.execute(sql, [path])
conn.commit()
os.remove(path)
def printMovieList(self):
dbConn = DBConnection()
cur = dbConn.connection()
print(
"#########################\n#\tMovies \t\t#\n#########################"
)
query = "SELECT * FROM movies"
for row in cur.execute(query):
print("[" + str(row[0]) + "]", "\t", row[1])
cur.close()
def getMovieTitle(self, id):
dbConn = DBConnection()
conn = dbConn.connection()
cur = conn.cursor()
query = "SELECT title from movies where id = ?"
cur.execute(query, id)
row = cur.fetchone()
if row:
return row[0]
else:
return False
def getMovieTime(self, id, dayID):
dbConn = DBConnection()
conn = dbConn.connection()
cur = conn.cursor()
query = "SELECT time from movie_timings where id = {0} and day_id = {1}".format(
id, dayID)
cur.execute(query)
row = cur.fetchone()
if row:
return row[0]
else:
return False
def getMovieDay(self, id, movieID):
dbConn = DBConnection()
conn = dbConn.connection()
cur = conn.cursor()
query = "SELECT day from movie_days where id = {0} AND movie_id = {1}".format(
id, movieID)
cur.execute(query)
row = cur.fetchone()
if row:
return row[0]
else:
return False
def bookTicket(self, time_id, seatnos, name):
dbConn = DBConnection()
conn = dbConn.connection()
cur = conn.cursor()
for seat in seatnos:
(row, col) = seat
query = "INSERT INTO movie_booking(time_id,row,col,username) values({0},{1},{2},'{3}')".format(
time_id, row, col, str(name))
if cur.execute(query):
conn.commit()
else:
return False
return True
def add_to_buffer(self):
count = 0
db = DBConnection()
conn = db.get_connection()
mycursor = conn.cursor()
mycursor.execute("SELECT path FROM vidbuffer")
vid_buffer_items = mycursor.fetchall()
for row in vid_buffer_items:
should_continue = 1
path = row[0]
vidcap = cv2.VideoCapture(path)
success, image = vidcap.read()
while success:
img_path = "../buffer/frame" + str(count) + ".jpg"
cv2.imwrite(img_path, image)
db1 = DBConnection()
conn1 = db1.get_connection()
mycursor1 = conn1.cursor()
mycursor1.execute("INSERT INTO `buffer`(`path`) VALUES (%s);",
[img_path])
conn1.commit()
count = count + 1
for _ in range(25):
success, image = vidcap.read()
mycursor1.execute(
"SELECT continue_buffer FROM smbool where flag_var = 0")
row1 = mycursor1.fetchone()
should_continue = row1[0]
print("should continue", should_continue)
mycursor1.execute(
"UPDATE smbool set continue_buffer = 1 where flag_var = 0")
conn1.commit()
if should_continue is 0:
break
mycursor1.execute("DELETE FROM `vidbuffer` WHERE `path` = %s",
[path])
conn1.commit()
def main():
handle = DBConnection()
queries = [
"some",
"sql",
"queries",
"here..."
]
for query in queries:
handle.add(query)
handle.commit()
print("\nDone")
bot.loading_failure["cache"] = e
# ----------------------- START UP -----------------------------------
# load all Discord, MySQL, and API credentials
tokenFile = open(AUTH_FILE_PATH, "r", encoding="utf-8")
tokenLines = tokenFile.read().splitlines()
tokens = {}
for line in tokenLines:
key_value = line.split(":")
tokens[key_value[0]] = key_value[1]
credentials.set_tokens(tokens)
# Create MySQL connection
bot.dbconn = DBConnection(credentials.tokens["MYSQL_USER"],
credentials.tokens["MYSQL_PASSWORD"], "suitsBot")
bot.loading_failure = {}
# Load opus library
if not discord.opus.is_loaded():
discord.opus.load_opus('opus')
print("\n\n------------")
print('Loading Data...')
# Load data from database
load()
print("Loading cogs...")
# Load cogs
def loadcache():
""" Load Cache values from database """
global currently_playing, scribble_bank
try:
currently_playing = utils.load_from_cache(bot.dbconn, "currPlaying",
"")
scribble_bank = utils.load_from_cache(bot.dbconn, "scribble",
"").split(',')
except Exception as e:
bot.loading_failure["cache"] = e
# ----------------------- START UP -----------------------------------
# Create MySQL connection
bot.dbconn = DBConnection(tokens["MYSQL_USER"], tokens["MYSQL_PASSWORD"],
"suitsBot")
bot.loading_failure = {}
# Load opus library
if not discord.opus.is_loaded():
discord.opus.load_opus('opus')
print("\n\n------------")
print('Loading Data...')
# Load data from database
load()
print("Loading cogs...")
# Load cogs
def __init__(self): self.dbc = DBConnection() self.getDate = GetDate()
from django.shortcuts import render
# Create your views here.
#views.py
from login.forms import *
from django.contrib.auth.decorators import login_required
from django.contrib.auth import logout
from django.views.decorators.csrf import csrf_protect
from django.shortcuts import render_to_response
from django.http import HttpResponseRedirect
from django.template import RequestContext
from dbconnection import DBConnection
from login.forms import PostForm
connection = DBConnection()
val = connection.select()
@csrf_protect
def register(request):
if request.method == 'POST':
form = RegistrationForm(request.POST)
if form.is_valid():
user = User.objects.create_user(
username=form.cleaned_data['username'],
password=form.cleaned_data['password1'],
email=form.cleaned_data['email'])
return HttpResponseRedirect('/register/success/')
else:
form = RegistrationForm()
variables = RequestContext(request, {'form': form})
return "%d rows modified." % count
else:
ret = "Results:\n"
for entry in rows:
for key, val in entry.iteritems():
ret += "%s: %s\n" % (key, val)
ret += "\n"
return ret
except db.IntegrityError:
# Nothing changed
return "Integrity error - nothing changed."
except db.OperationalError, e:
code, desc = e
return "Database operational error - try again: " + desc
except:
return "Database operation error. Please try again"
finally:
if connection:
self.disconnect()
if __name__ == "__main__":
m = MySQL()
connection = DBConnection(username='******',
password='******',
db='otpasswd')
print m.execute("insert into test values('a', 4)", connection)
# vim:tabstop=4:expandtab
def install():
dbConn = DBConnection()
conn = dbConn.connection()
cur = conn.cursor()
#creating movie table
cur.execute(
'''CREATE TABLE IF NOT EXISTS movies(ID INTEGER PRIMARY KEY AUTOINCREMENT, TITLE TEXT NOT NULL)'''
)
cur.execute("INSERT INTO movies(TITLE) \
VALUES ('Die Hard 4.0')")
cur.execute("INSERT INTO movies(TITLE) \
VALUES ('John Wick')")
cur.execute("INSERT INTO movies(TITLE) \
VALUES ('John Wick 2')")
cur.execute(
'''CREATE TABLE IF NOT EXISTS movie_days(ID INTEGER PRIMARY KEY AUTOINCREMENT, movie_id INTEGER NOT NULL, day TEXT)'''
)
cur.execute("INSERT INTO movie_days(movie_id,day) \
VALUES (1,'TUE')")
cur.execute("INSERT INTO movie_days(movie_id,day) \
VALUES (1,'WED')")
cur.execute("INSERT INTO movie_days(movie_id,day) \
VALUES (1,'FRI')")
cur.execute("INSERT INTO movie_days(movie_id,day) \
VALUES (2,'MON')")
cur.execute("INSERT INTO movie_days(movie_id,day) \
VALUES (2,'WED')")
cur.execute("INSERT INTO movie_days(movie_id,day) \
VALUES (2,'THUR')")
cur.execute("INSERT INTO movie_days(movie_id,day) \
VALUES (2,'FRI')")
cur.execute("INSERT INTO movie_days(movie_id,day) \
VALUES (3,'FRI')")
cur.execute(
'''CREATE TABLE IF NOT EXISTS movie_timings(ID INTEGER PRIMARY KEY AUTOINCREMENT, day_id INTEGER NOT NULL, time TEXT)'''
)
cur.execute(
'''CREATE TABLE IF NOT EXISTS movie_booking ( `id` INTEGER PRIMARY KEY AUTOINCREMENT, `time_id` INTEGER NOT NULL, `row` INTEGER NOT NULL, `col` INTEGER NOT NULL, `username` TEXT NOT NULL )'''
)
cur.execute("INSERT INTO movie_timings(day_id,time) \
VALUES (1,'09:00')")
cur.execute("INSERT INTO movie_timings(day_id,time) \
VALUES (1,'11:30')")
cur.execute("INSERT INTO movie_timings(day_id,time) \
VALUES (2,'14:00')")
cur.execute("INSERT INTO movie_timings(day_id,time) \
VALUES (2,'20:00')")
cur.execute("INSERT INTO movie_timings(day_id,time) \
VALUES (3,'22:00')")
cur.execute("INSERT INTO movie_timings(day_id,time) \
VALUES (3,'22:00')")
cur.execute("INSERT INTO movie_timings(day_id,time) \
VALUES (4,'22:00')")
cur.execute("INSERT INTO movie_timings(day_id,time) \
VALUES (4,'22:00')")
cur.execute("INSERT INTO movie_timings(day_id,time) \
VALUES (5,'22:00')")
cur.execute("INSERT INTO movie_timings(day_id,time) \
VALUES (6,'22:00')")
cur.execute("INSERT INTO movie_timings(day_id,time) \
VALUES (7,'22:00')")
cur.execute("INSERT INTO movie_timings(day_id,time) \
VALUES (8,'22:00')")
conn.commit()
conn.close()
class CCManagerRoot(Tk):
dbifc = DBConnection()
user = User.current(dbifc)
def __init__(self, **kw):
super().__init__(**kw)
self.title("CQC - Kontroll diagram modul")
self.active_panel = None
self.active_toplevel = None
self.ccobject = ControlChart()
self.menubar = RootMenu(self)
self.config(menu=self.menubar)
self.menubar.lock()
self.chartholder = ChartHolder(self)
self.chartholder.update_image(None)
self.chartholder.pack(**pkw)
self.propspanel = None
self.properties_button = Button(
self,
text="Tulajdonságok megjelenítése",
state="disabled",
command=lambda: self.launch_propspanel(stage=None))
self.properties_button.pack(**pkw)
self.protocol("WM_DELETE_WINDOWS", self.teardown)
def launch_propspanel(self, stage=None):
if self.propspanel is not None:
self.propspanel.destroy()
self.propspanel = PropertiesPanel(self, self.ccobject, self.dbifc,
stage)
def savecc_cmd(self):
if self.ccobject.unsaved is None:
print("UNSAVED IS NONE! NOT SAVING!")
return
if self.ccobject.ccrec["id"] is None:
self.dbifc.push_object(self.ccobject)
else:
self.dbifc.update_cc(self.ccobject)
def newcc_cmd(self):
if self.ccobject.unsaved:
msg = ("A jelenlegi állapot nincs elmentve.", "Szeretnéd menteni?")
if tkmb.askyesno("Mentetlen adat!", "\n".join(msg)):
self.savecc_cmd()
wiz = self._build_stage()
if wiz is None:
return
self.launch_propspanel(wiz.stage)
self.wait_window(self.propspanel)
if self.propspanel.canceled:
return
self.ccobject.set_upstream_ids()
self.propspanel = None
IDs = self.dbifc.push_object(self.ccobject)
rex = self.ccobject.rec
for rectype, ID in IDs.items():
if rex[rectype]["id"] is None:
rex[rectype]["id"] = ID
else:
assert rex[rectype]["id"] == ID
self.chartholder.update_image(self.ccobject)
self.menubar.unlock()
self.properties_button.configure(state="active")
def opencc_cmd(self):
wiz = SelectionWizard(self,
creation_mode=False,
skipempties=True,
dbifc=self.dbifc)
self.wait_window(wiz)
if wiz.stage is None:
return
cc = ControlChart.from_database(
dbifc=self.dbifc,
ccID=wiz.selection["cc"],
)
self.ccobject = cc
self.chartholder.update_image(self.ccobject)
self.menubar.unlock()
self.properties_button.configure(state="active")
def deletecc_cmd(self):
msg = "Valóban törölni szeretnéd a kontroll diagramot?"
if not tkmb.askyesno("Törlés megerősítése", msg):
return
if self.ccobject.ID is not None:
self.dbifc.delete_cc(self.ccobject.ID)
path = self.ccobject.pkldump()
print("Backed up ControlChart object to", path)
self.ccobject = ControlChart()
self.chartholder.update_image(None)
self.menubar.lock()
def newpoints_cmd(self):
mtl = NewMeasurements(self, rown=3, title="Pontok bevitele")
self.wait_window(mtl)
print("VALUES : ", ", ".join(map(str, mtl.measure["value"])))
print("DATES : ", ", ".join(map(str, mtl.measure["date"])))
print("COMMENT: ", ", ".join(map(str, mtl.measure["comment"])))
mtl.measure.setall(cc_id=self.ccobject.ID,
staff_id=self.user["id"],
reference=False)
self.ccobject.meas.incorporate(mtl.measure.data)
self.dbifc.push_measurements(mtl.measure)
self.chartholder.update_image(self.ccobject)
def editpoints_cmd(self):
mtl = EditMeasurements(self,
self.ccobject.meas,
rown=10,
title="Pontok szerkesztése")
self.wait_window(mtl)
def _build_stage(self):
wiz = SelectionWizard(self,
creation_mode=True,
skipempties=False,
dbifc=self.dbifc)
self.wait_window(wiz)
if wiz.stage is None:
return
self.ccobject = ControlChart.build_stage(wiz.selection, wiz.stage,
self.dbifc)
return wiz
def teardown(self):
print("UI nice shutdown")
self.destroy()
