Python DbManager.delete Examples

Example #1

File: data_layer.py Project: dodycs/TVShowProject

def unlike_a_tvshow(user_id, api_id):
    # UNLIKE TVSHOW
    tvshow = get_tvshow_by_api_id(api_id)
    db = DbManager()
    try:
        like = db.open().query(Like).filter(Like.user_id == user_id,
                                            Like.tvshow_id == tvshow.id).one()
        db.delete(like)
    except:
        return False

Example #2

def delete_quote(quote_id):
    try:
        db = DbManager()
        quote = db.open().query(Quote).filter(Quote.id == quote_id).one()
        return db.delete(quote)
    except:
        pass

Example #3

def delete_project(project_id):
    db = DbManager()
    # project = db.delete(get_project(project_id))
    project = db.open().query(Project).filter(Project.id == project_id).one()
    project = db.delete(project)

    db.close()
    return project

Example #4

File: data_layer.py Project: dodycs/coderemote-projectmanager

def delete_task(task_id):
    print('-------------------------------------------')
    print(task_id)
    db = DbManager()
    task = db.open().query(Task).filter(Task.id == task_id).one()
    task = db.delete(task)
    db.close()
    return task

Example #5

File: data_layer.py Project: sudiarth/LoginAndRegistration

def delete_like(movie_id):
    try:
        db = DbManager()
        show = db.open().query(Like).filter(Like.id == movie_id).one()
        like = db.delete(show)
        return like
    except:
        raise

Example #6

File: data_layer.py Project: dodycs/coderemote-lilquote

def delete_quote(quote_id):
    db = DbManager()
    quote = db.open().query(Quote).filter(Quote.id == quote_id).one()
    quote = db.delete(quote)
    db.close()
    return quote

Example #7

def delete_bill(bill_id):
    db = DbManager()
    bill = db.open().query(BillItem).filter(BillItem.id == bill_id).one()
    db.delete(bill)

Example #8

File: data_layer.py Project: nawikart/TVMaze

def _unlike(user_id, show_id):
    db = DbManager()
    like = db.open().query(Like).filter(Like.show_id == show_id).filter(Like.user_id == user_id).one()
    like = db.delete(like)
    db.close()
    return like    

Example #9

File: data_layer.py Project: sudiarth/Project-Manager

def delete_project(project_id):
    db = DbManager()
    project = db.delete(get_project(project_id))
    db.close()
    return project

Example #10

def unlike_tvshow(user_id, tvshow_api_id):
    db = DbManager()
    tvshow = get_tvshow_by_api_id(tvshow_api_id)
    like = db.open().query(Like).filter(Like.user_id == user_id, Like.tvshow_id == tvshow.id).one()
    db.delete(like)
    return like

Example #11

def dislike_film(user_id, film_id):
    db = DbManager()
    return db.delete(db.open().query(Like).filter(
        Like.user_id == user_id, Like.film_id == film_id).one())