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