def delete(self):
try:
payload = json.loads(request.data.decode())
user_name = payload["user_name"]
database.deleteUser(user_name)
return make_response(
jsonify({
'title': "User Deleted Successfully",
"status": HTTPStatus.OK
}),
HTTPStatus.OK,
)
except Exception as e:
return make_response(
jsonify({
'title': "Unsuccessful from user deletion",
"status": HTTPStatus.BAD_REQUEST,
"error": {
"message": str(e)
}
}),
HTTPStatus.BAD_REQUEST,
)
def voiceCommand(self):
#restricts guests from using this function
if self.ww.name == None:
self.label.setText('You must be logged in to use this function.')
return
self.label.setText('Please say a command.')
#turns on microphone and returns audio as a string
self.r = sr.Recognizer()
with sr.Microphone() as source:
audio = self.r.listen(source)
#defines the logic for each type of voice command
if 'go to' in self.r.recognize_google(audio):
self.textbox.setText('')
items = self.r.recognize_google(audio).split()
self.goto(items[2].lower())
elif 'clear data' in self.r.recognize_google(audio):
self.textbox.setText('')
database.deleteUser(self.ww.name)
database.addUser(self.ww.name)
self.ww.websites = ['google https://www.google.com/']
self.ww.websitesDictionary = {'google': 'https://www.google.com/'}
self.ww.homeScreen()
elif 'add site' in self.r.recognize_google(audio):
self.textbox.setText('')
self.ww.addSite()
self.label.setText('Done')
elif 'go home' in self.r.recognize_google(audio):
self.ww.homeScreen()
self.label.setText('')
def deleteUser(self,data):
# Initialize response
response = responses.Responses()
MAC = data["MAC"]
dbFunction = database.getMAC(MAC)
if dbFunction.count() == 0:
response.setResponse("response",False)
else:
database.deleteUser(MAC)
response.setResponse("response",True)
return response
def speak(request, userID, userInfo="", msg="", answ="", attach=""):
# Специальные команды бота
# #Учим бота новым словам
if msg[:6] == "/teach":
pos = msg.find("?")
newMsg = msg[7:pos].replace(" ", "")
newAnsw = msg[pos + 1:]
database.insert("answer", ["msg", "answ"], [newMsg, newAnsw])
answ = "Я добавил новый запрос '{0}', давай попробуй =)".format(newMsg)
# #Вывести список всех команд
elif msg == "/list":
answ = database.get("answer", ["msg"])
# #Узнать в какой я группе
elif msg == "/whoAmI":
answ = """Вы относитесь к группе {0}""".format(
database.getGroup(str(userID))[0]["groupName"])
# #Посмотреть список пользователей
elif msg == "/whoAreThey":
answ = """Пользователи:\n"""
for i in database.getGroup():
answ += """id: {0}, group: {1}\n""".format(i["id"], i["groupName"])
elif msg == "/changeMe":
# 1) Удалить пользователя из базы
database.deleteUser(userID)
# 2) Вызвать клавиатуру
keyboardStart(request, userID)
return 1
# Поиск ответа в базе
if answ == "":
for i in database.get("answer"):
if msg == i["msg"]:
answ = i["answ"]
break
else:
answ = "Я не знаю такой команды. Можешь научить меня используя команду /teach ЗАПРОС ? ОТВЕТ"
sendAnswer(userID, answ, attach)
def del_user(id):
# Check if specified ID is an integer
if not function.isInt(id):
return jsonify({"error": "id is not an integer"}), 400
# Check if token identity corresponds to the user being deleted
if not (int(id) == get_jwt_identity()):
return jsonify({"error": "Not allowed to delete this user"}), 403
# Check if user actually exists
user = database.getUserByID(id)
if user is None:
return jsonify({"error": "Specified user does not exist"})
# Delete user
if database.deleteUser(id):
return jsonify({"Info": "User deleted successfully"}), 200
else:
return jsonify({"erorr": "Something went wrong deleting user"}), 500
def callMenuZalogowane(self): # po pomyślnym zalogowaniu tudzież rejestracji odpala się to menu
print() # dla lepszej przejrzystości
while True: # nieskończona pętla po to aby użytkownik cały czas miał menu przed sobą, żeby wyjść z niego
# trzeba wybrać odpowiedni numer
wyborUzytkownika = int(input(self.menuZalogowanegoUzytkownika)) # wybor użytkownika co chce robić
if wyborUzytkownika == 1: # szukanie piosenki (zapytanie do bazy wyswietla piosenkę i jej szczegóły)
# otherwise error
wybor = input("Wyszukiwana fraza: ") # album, artysta, nazwa piosenki trzeba dobrze napisac
# ponieważ inczej nie znajdzie DO POPRAWY
print("\n"*50) # czyszczenie command prompta DO POPRAWY
sprawdzCzyBylJakisOdzew = 0
for song in database.searchForSongs(wybor):
print("Znaleziono utwor nalezacy do playlisty " + song['genre.name'])
print("wykonawca: " + song['name'])
self.aktualnieOdtwarzanaPiosenka = song['song_id']
self.aktualnaPlaylista = song['genre.name']
print("tytul: " + song['title'])
print("album: " + song['album.name'])
print("rok wydania: " + str(song['year']))
print("liczba polubien: " + str(song['likes_count']))
sprawdzCzyBylJakisOdzew = 1
break
if sprawdzCzyBylJakisOdzew == 0:
print(colored("Brak wynikow", 'red'))
print("Co chcialbys zrobic z piosenka? 1 - SLUCHAJ, 2 - KONTYNUUJ")
wybor = input("Twoj wybor: ")
if wyborUzytkownika == 1: # Słuchanie danej piosenki z opcja polubienia
print("\n" * 50)
print("Aktualnie odtwarzana piosenka: ")
playingSong = database.getSongById(self.aktualnieOdtwarzanaPiosenka)
print("wykonawca: " + playingSong['name'])
print("tytul: " + playingSong['title'])
print("liczba polubien: " + str(playingSong['likes_count']))
print()
print("Pozostale piosenki w playliscie:")
print("id\twykonawca\ttytul")
for playlistSongs in database.getAllPlaylistSongs(self.aktualnaPlaylista, self.aktualnieOdtwarzanaPiosenka):
print(str(playlistSongs['song_id']) + "\t" + playlistSongs['name'] + "\t" + playlistSongs['title'])
print("Co chcesz zrobic? 1 - DODANIE PIOSENKI DO ULUBIONYCH, 2 - PRZEJSCIE DO SLUCHANIA KOLEJNEJ PIOSENKI, 3 - WYJSCIE")
wybor = int(input("Twoja decyzja: "))
if wybor == 1: # dodanie do ulubionych
database.addToLikedSongs(str(self.aktualnieOdtwarzanaPiosenka), self.loginZalogowanegoUzytkownika)
print("Dodano utwor do ulubionych")
print("\n" * 50) # wyczyszczenie okna po dodaniu do ulubionych
###############################################################
print("Aktualnie odtwarzana piosenka: ")
playingSong = database.getSongById(self.aktualnieOdtwarzanaPiosenka)
print("wykonawca: " + playingSong['name'])
print("tytul: " + playingSong['title'])
print("liczba polubien: " + str(playingSong['likes_count']))
print()
print("Pozostale piosenki w playliscie:")
print("id\twykonawca\ttytul")
for playlistSongs in database.getAllPlaylistSongs(self.aktualnaPlaylista, self.aktualnieOdtwarzanaPiosenka):
print(str(playlistSongs['song_id']) + "\t" + playlistSongs['name'] + "\t" + playlistSongs[
'title'])
print("Co chcesz zrobic? 1 - PRZEJSCIE DO SLUCHANIA KOLEJNEJ PIOSENKI, 2 - WYJSCIE")
wybor = input("Twoja decyzja to 2: ")
wybor = 2 # XD
elif wybor == 2: # powrot do menu
print("\tPowrot do menu...")
else:
print("\tNiepoprawny wybor")
#if piosenke_znaleziono
#kolejny if co chcesz z nia zrobic albo posluchac, albo dodac do ulubionych
#dodanie do ulubionych
#sluchanie (emulacja sluchania piosenki, wyjscie z niej, pauza)
#usuniecie z ulubionych
#dodanie artysty do plubionych
elif wyborUzytkownika == 2: # wyświetlenie polubionych piosenek
print("\n" * 50)
print("LISTA ULUBIONYCH PIOSENEK")
print()
print("id\twykonawca\ttytul\tliczba polubien")
for likedSong in database.getAllLikedSongs(self.loginZalogowanegoUzytkownika):
print(likedSong['song_id'], "\t", likedSong['name'], "\t", likedSong['title'], "\t",
likedSong['album.name'], "\t", likedSong['year'], "\t", likedSong['genre.name'])
#wylistowanie polubionych piosenek, sluchanie ich, usuniecie z polubionych
#wyjscie do menu
print("Czy chcesz usunac jakiegos piosenke z listy polubionych? 1 - TAK, 2 - NIE")
wybor = int(input("Twoj wybor: "))
if wybor == 1: # usuwamy z listy
piosenkaDoUsunieciaID = int(input("ID piosenki do usuniecia: "))
database.deleteFromLikedSongs(str(piosenkaDoUsunieciaID), self.loginZalogowanegoUzytkownika)
print(colored("Usunieto wybrana piosenke z ulubionych", 'green'))
elif wybor == 2:
print("\n" * 50)
pass
else:
print(colored("Niepoprawny wybor", 'red'))
elif wyborUzytkownika == 3: # wyswietlnie ulubionych artystów użytkownika
print("\n"*50)
print("LISTA ULUBIONYCH ARTYSTOW")
print()
print("id\twykonawca")
for artist in database.getAllLikedArtists(self.loginZalogowanegoUzytkownika):
print(artist['artist_id'], "\t", artist['name'])
print("Czy chcesz usunac jakiegos artyste z listy polubionych? 1 - TAK, 2 - NIE")
wybor = int(input("Twoj wybor: "))
if wybor == 1: # usuwamy z listy
artystaDoUsunieciaID = int(input("ID artysty do usuniecia: "))
database.deleteFromLikedArtist(artystaDoUsunieciaID, self.loginZalogowanegoUzytkownika)
elif wybor == 2:
print("\n" * 50)
pass
else:
print(colored("Niepoprawny wybor", 'red'))
#tutaj przeniesienie opcji: usun z listy ulubionych artystow
elif wyborUzytkownika == 4: # wyjscie z programu (biblioteka muzyczna)
print("\tWychodzenie z programu...")
exit()
elif wyborUzytkownika == 5: # usuniecie konta
wybor = int(input("\tCzy na pewno chcesz usunac uzytkownika? 1 - TAK, 2 - NIE: "))
if wybor == 1: # chce usunac konto
print("\tUsuwanie uzytkownika...")
database.deleteUser(self.loginZalogowanegoUzytkownika)
self.callMenu(self)
elif wybor == 2: # nie chce usuwac
print("\tWracanie do menu")
break
else:
print("\tNiepoprawny wybor")
elif wyborUzytkownika == 6: # zmiana uzytkownika
print("\tPodaj login oraz haslo uzytkownika")
login = input("\tLogin: "******"\tHaslo: ")
# sprawdzenie czy uzytkownik o podanym loginie istnieje i czy haslo jest poprawne
for uzytkownik in database.getAllLogins():
if login == uzytkownik["login"]:
print(colored("\tPodany uzytkownik istnieje, zmienianie konta...", 'green'))
self.loginZalogowanegoUzytkownika = login # do ewentualnego usuniecia konta
break
print(colored("\tUzytkownik o podanej nazwie nie istnieje", 'red'))
else: # wybranie niewlasciwej opcji i powrot
print(colored("\tWybrales niewlasciwa opcje", 'red'))
def deleteUser(username):
with database.connect() as conn:
database.deleteUser(conn, username)
return redirect("/manage")
def devGo(self):
#this boolean is used to restrict guests from using certain features
cantUse = False
if self.ww.name == None:
cantUse = True
self.label.setText('')
#lists the different commands
if self.textbox.text() == 'help':
self.textbox.setText('')
self.label.setText('Commands: addSite, addUser(name), clearData, deleteUser, clear')
#Adds site to the current user's list of sites
elif self.textbox.text() == 'addSite':
if cantUse:
self.textbox.setText('')
self.label.setText('You must be logged in to use this function.')
return
self.textbox.setText('')
self.ww.addSite()
#clears user preferences
elif self.textbox.text() == 'clearData':
if cantUse:
self.textbox.setText('')
self.label.setText('You must be logged in to use this function.')
return
self.textbox.setText('')
database.deleteUser(self.ww.name)
database.addUser(self.ww.name)
self.ww.websites = ['google https://www.google.com/']
self.ww.websitesDictionary = {'google': 'https://www.google.com/'}
self.ww.homeScreen()
#adds a new user to the database and takes images to use for recognition
elif self.textbox.text()[0:7] == 'addUser':
name = self.textbox.text()[8:-1]
_thread.start_new_thread(face_recognize.addUser, (name, ))
self.ww.name = name.title()
database.addUser(name.title())
self.textbox.setText('')
self.ww.homeScreen()
#removes user from image database and websites database
elif self.textbox.text() == 'deleteUser':
if cantUse:
self.textbox.setText('')
self.label.setText('You must be logged in to use this function.')
return
self.textbox.setText('')
database.deleteUser(self.ww.name)
self.ww.websites = ['google https://www.google.com/']
self.ww.websitesDictionary = {'google': 'https://www.google.com/'}
create_database.deleteUser(self.ww.name)
self.ww.name = None
self.ww.homeScreen()
#tool used for debuggin in development
elif self.textbox.text()[0:15] == 'deleteUserAdmin':
tempName = self.textbox.text()[16:-1]
database.deleteUser(tempName)
create_database.deleteUser(tempName)
self.ww.homeScreen()
#clears the label
elif self.textbox.text() == 'clear':
self.textbox.setText('')
self.label.setText('')
def bot(request):
body = json.loads(request.body)
def SendAnswer(userID, msg, keyboard=""):
vkAPI.messages.send(user_id=userID,
message=msg,
keyboard=keyboard,
random_id=random.randint(1, 99999999999999),
v=5.103)
print(body)
if body == {"type": "confirmation", "group_id": 194135917}:
return HttpResponse('5ba3cbbe')
if body["type"] == "message_new":
msg = body["object"]["message"]["text"]
userID = body["object"]["message"]["from_id"]
name_us = vkAPI.users.get(user_ids=userID, v=5.103)
name_user = name_us[0]["first_name"]
tag_rep = (msg).split(" ", maxsplit=1)
answ = ""
gpid = -1
gpname = ""
if "payload" in body["object"]["message"]:
payload = body["object"]["message"]["payload"]
def keyboardStart(request, userID):
answ = "Привет! Выбери свою группу пользователя!"
keyboard = json.dumps({
"one_time":
True,
"buttons": [[{
"action": {
"type": "text",
"label": "Администратор",
"payload": """{"command":"admin"}"""
},
"color": "negative"
}],
[{
"action": {
"type": "text",
"label": "Программист",
"payload": """{"command":"program"}"""
},
"color": "positive"
}],
[{
"action": {
"type": "text",
"label": "Труп",
"payload": """{"command":"person"}"""
},
"color": "primary"
}]]
})
SendAnswer(userID, answ, keyboard)
if msg == "Привет":
name_us = vkAPI.users.get(user_ids=userID, v=5.103)
answ = "Привет " + name_user + ", я Твой самый лучший друг, я сниму с тебя скальп 💀 💀 💀 :)"
SendAnswer(userID, answ)
elif msg == "/whoAmI":
answ = """Вы относитесь к группе {0}""".format(
database.getGroup(str(userID))[0]["GroupName"])
SendAnswer(userID, answ)
elif msg == "/changeMeNow":
database.deleteUser(userID)
keyboardStart(request, userID)
return 1
elif tag_rep[0] == "/say":
answ = tag_rep[1]
SendAnswer(userID, answ)
elif payload == """{"command":"start"}""":
keyboardStart(request, userID)
elif payload == """{"command":"admin"}""":
gpid = str(1)
gpname = "Администратор"
database.insert("user", ["id, groupId"], [str(userID), gpid])
answ = "Вы были добавлены в группу {0}".format(gpname)
SendAnswer(userID, answ)
elif payload == """{"command":"program"}""":
gpid = str(2)
gpname = "Программист"
database.insert("user", ["id, groupId"], [str(userID), gpid])
answ = "Вы были добавлены в группу {0}".format(gpname)
elif payload == """{"command":"person"}""":
gpid = str(3)
gpname = "Труп"
database.insert("user", ["id, groupId"], [str(userID), gpid])
answ = "Вы были добавлены в группу {0}".format(gpname)
else:
conn = sqlite3.connect("db.sqlite")
cur = conn.cursor()
query = """ SELECT * FROM answers """
cur.execute(query)
answer = cur.fetchall()
conn.close()
for i in range(len(answer)):
if answer[i][1] == msg:
answ = answer[i][2]
SendAnswer(userID, answ)
# elif body ["object"]["message"]["text"]=="Какой сейчас час?":
# msg = "Час убивать!!!"
# vkAPI.messages.send(user_id=userID, message=msg, random_id=random.randint(1, 99999999999999), v=5.103)
# elif body ["object"]["message"]["text"]=="Почему ты злой?":
# msg = "Я не злой, это ты просто скоро будешь мёртвым"
# vkAPI.messages.send(user_id=userID, message=msg, random_id=random.randint(1, 99999999999999), v=5.103)
# elif body ["object"]["message"]["text"]=="Я ухожу":
# msg = " Беги, беги, далеко не убежишь."
# vkAPI.messages.send(user_id=userID, message=msg, random_id=random.randint(1, 99999999999999), v=5.103)
# elif body ["object"]["message"]["text"]=="/help":
# msg = "Я тебе не Сири, чтобы показывать что у меня внутри."
# vkAPI.messages.send(user_id=userID, message=msg, random_id=random.randint(1, 99999999999999), v=5.103)
# if msg=="/help":
# conn = sqlite3.connect("db.sqlite")
# cur = conn.cursor()
# query =""" SELECT * FROM answers """
# cur.execute(query)
# answer = cur.fetchall()
# conn.close()
# for i in range(len(answer)):
# if answer[i][1]==msg:
# answ=answer[i][2]
# SendAnswer(userID, answ)
# elif msg=="Какой сейчас час?":
# conn = sqlite3.connect("db.sqlite")
# cur = conn.cursor()
# query =""" SELECT * FROM answers """
# cur.execute(query)
# answer = cur.fetchall()
# conn.close()
# for i in range(len(answer)):
# if answer[i][1]==msg:
# answ=answer[i][2]
# SendAnswer(userID, answ)
#name_us = vkAPI.users.get(access_token = token, user_ids = userID, v=5.103)
#name_us=json.loads(vkAPI.users.get(userID))
#print(name_us[0]["first_name"])
return HttpResponse("ok")
def deleteUser(self):
database.deleteUser(self.user['key'])
return REDIRECT % {'title': "User Delete", 'text': "User has been Deleted"}
def render_GET(self, request):
database.deleteUser(self.user['key'])
return REDIRECT % {'title': "User Delete", 'text': "User has been Deleted"}
#import database.py
from database import userExists, deleteUser, insertUser, getMainPage
print('userExists("adducin")=' + str(userExists('adducin')))
print('userExists("test2")=' + str(userExists('test2')))
print('trying to delete user "test2"')
deleteUser('test2')
print('userExists("test2")=' + str(userExists('test2')))
print('trying to insert user "test2"')
insertUser('test2', 'test2Pass', 'Test', '2', 'Test User 2 Desc',
'Hello World.pdf')
print('userExists("test2")=' + str(userExists('test2')))
print('Database contents:')
getMainPage()
def deleteUser(self):
database.deleteUser(self.user['key'])
return REDIRECT % {
'title': "User Delete",
'text': "User has been Deleted"
}
def render_GET(self, request):
database.deleteUser(self.user['key'])
return REDIRECT % {
'title': "User Delete",
'text': "User has been Deleted"
}
