def action_delete(request):
token = jwt.decode(request['token'], 'secret', algorithm='HS256')
role = token['role']
if role == 'admin' or role == 'superAdmin':
database.delete(request['id'])
response = {'status': 0}
sock.sendto(bytearray(str(response), 'utf-8'),
('', int(token['port'])))
else:
send_error(token)
def delete_playlists(self):
playlists_id = ""
# Consultando os ID's das playlists
playlists = select(
f"SELECT id FROM playlists JOIN users_has_playlist ON users_has_playlist.playlist_id = playlists.id WHERE users_has_playlist.users_id = {self.__user_id}"
)
for playlist in playlists:
playlists_id += f"{playlist[0]}" if playlists_id == "" else f", {playlist[0]}"
# Apagando as playlists
delete("playlists", f"id IN ({playlists_id})")
def delete(self, db_connection):
if self.fragment_id is None:
return
sql = ("""
DELETE FROM fragments
WHERE
fragment_id = %(fragment_id)s
""")
params = {
'fragment_id': self.fragment_id
}
delete(db_connection, sql, params)
def _clear_metadata(self, db_connection):
if self.fragment_id is None:
return
sql = ("""
DELETE FROM metadata
WHERE
fragment_id = %(fragment_id)s
""")
params = {
'fragment_id': self.fragment_id
}
delete(db_connection, sql, params)
