예제 #1
0
파일: server.py 프로젝트: Fuza322/ISOB-Labs
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)
예제 #2
0
    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})")
예제 #3
0
    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)
예제 #4
0
    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)