def registerNewUser(self):
databaseHandler = DatabaseHandler()
conn = databaseHandler.establishConnection()
c = databaseHandler.getCursor(conn)
c.execute("SELECT login_name FROM users WHERE login_name=?",
(self.log_in_name.get(), ))
row = c.fetchone()
if row != None:
messagebox.showerror("Error", "That login is already in use!")
conn.close()
return
if self.password.get() != self.repeat_password.get():
messagebox.showerror(
"Error",
"The repeated password is not the same as your new password")
conn.close()
return
hash_object = md5(self.password.get().encode())
md5_password = hash_object.hexdigest()
c.execute(
'''INSERT INTO users
(id, login_name, password, display_name)
VALUES
(?,?,?,?)''',
(None, self.log_in_name.get(), md5_password,
self.display_name.get()))
conn.commit()
messagebox.showinfo(
"Success", "You're successfully registered! Now you can log in!")
conn.close()
def __init__(self, consumer_key, consumer_secret, access_key, access_secret, database, server):
self.consumer_key = consumer_key
self.consumer_secret = consumer_secret
self.access_key = access_key
self.access_secret = access_secret
self.database = database
self.server = server
self.db_users = DatabaseHandler(self.database, self.server)
def markAsToWatch(self):
databaseHandler = DatabaseHandler()
conn = databaseHandler.establishConnection()
c = databaseHandler.getCursor(conn)
c.execute(
''' INSERT INTO users_movies(user_id,movie,favourite,score,status,poster_path)
VALUES(?,?,?,?,?,?) ''',
(Page.loginedUser[0], self.selectedMovie[1], 0, 0, "to_watch",
self.moviesPosters[self.selectedMovie[0]]))
conn.commit()
conn.close()
def loadAllToWatchMoviesAndLift(self):
databaseHandler = DatabaseHandler()
conn = databaseHandler.establishConnection()
c = databaseHandler.getCursor(conn)
c.execute("SELECT * FROM users_movies WHERE user_id=? AND status='to_watch'", (Page.loginedUser[0],))
rows = c.fetchall()
print(rows)
conn.close()
self.listbox.delete(0, tk.END)
self.moviesPosters = []
for r in rows:
self.listbox.insert(tk.END, r[1])
self.moviesPosters.append(r[5])
self.show()
def __init__(self):
self.site = None
self.module = None
self.dir = self.basedir = os.getcwd()
self.path = os.path.abspath(__file__)
self.modulename = None
self.HelpController = HelpController.HelpController()
self.Scanner = ScannerController.ScannerController()
self.Exploit = None
self.DatabaseHandler = DatabaseHandler.DatabaseHandler()
self.ExploitLoader = ExploitHandler.ExploitHandler()
try:
os.chdir(self.dir)
except:
pass
pass
def login(self):
databaseHandler = DatabaseHandler()
conn = databaseHandler.establishConnection()
c = databaseHandler.getCursor(conn)
hash_object = md5(self.password.get().encode())
md5_password = hash_object.hexdigest()
c.execute("SELECT * FROM users WHERE login_name=? AND password=?", (self.log_in_name.get(),md5_password))
row = c.fetchone()
print(row)
if row == None:
messagebox.showerror("Error", "Wrong login or password")
Page.loginedUser = (None,)
conn.close()
return
messagebox.showinfo("Success", "You're successfully login'd! Now you can create your lists!")
Page.loginedUser = row
conn.close()
# Boots everything up. GUI in future? # Now simply beginning sequence with config load from VkApiHandler import * from MsgHandler import * from ActionHandler import * from DatabaseHandler import * from CodeList import CODE_DICT, DB_NAME # Vk API info ACCESS_TOKEN = '0405278c1d9aa5b5962e158cfc6e036ebb3703d671d5042df8d9d807e1a6cbbb577effb424664c474efe6' API_VERSION = '5.130' GROUP_ID = 199935063 db_handler = DatabaseHandler(DB_NAME) vkapi_handler = VkApiHandler(ACCESS_TOKEN, API_VERSION, GROUP_ID, debug=True) act_handler = ActionHandler(vkapi_handler, db_handler, debug_mode=True) msg_handler = MsgHandler(CODE_DICT, COMMAND_SYMBOL, IGNORE_SYMBOL, act_handler) vkapi_handler.setMsgHandler(msg_handler) vkapi_handler.main_loop()
"-s",
"--save",
action="store_true",
help="Do you want to save the raw data to the mongodb or not?")
parser.add_argument("--test", action="store_true")
args = parser.parse_args()
r_event = threading.Event()
r_event.set()
up_event = threading.Event()
eventlist = [up_event]
if args.test is not True:
sonos, bulb = control_init()
if args.save:
save_mode = True
rawDBHandler = db.DatabaseHandler()
t1 = threading.Thread(target=dt.detect_status,
args=(config['readerIP'], config['readerPort'],
r_event, eventlist, rawDBHandler))
else:
save_mode = False
t1 = threading.Thread(target=dt.detect_status,
args=(
config['readerIP'],
config['readerPort'],
r_event,
eventlist,
))
resetThread = threading.Thread(target=dt.resetEPC, args=())
t1.start()
else:
self.disableBtns(self.b0, self.b1, self.b2, self.b3, self.b4)
threading.Timer(1.0, self.checkIfLoggedIn).start()
def enableBtns(self, *btns):
for btn in btns:
btn['state'] = tk.NORMAL
def disableBtns(self, *btns):
for btn in btns:
btn['state'] = tk.DISABLED
if __name__ == "__main__":
databaseHandler = DatabaseHandler()
databaseHandler.initAll()
root = tk.Tk()
main = MainView(root)
main.pack(side="top", fill="both", expand=True)
root.title("Movie Tracker")
root.geometry("1150x500")
warning = tk.Label(
root,
text=
"If you want to create and manage your lists of movies, you have to register and log in first!"
)
warning.config(font=("Courier", 12))
warning.pack()
main.checkIfLoggedIn()
