Python State.delete方法代码示例

# 需要导入模块: from app.models.state import State [as 别名]
# 或者: from app.models.state.State import delete [as 别名]
 def tearDown(self):
     #delete all from users
     PlaceBook.delete().execute()
     Place.delete().execute()
     User.delete().execute()
     City.delete().execute()
     State.delete().execute()

# 需要导入模块: from app.models.state import State [as 别名]
# 或者: from app.models.state.State import delete [as 别名]
 def setUp(self):
     #connect to db and delete everyone in the users table
     PlaceBook.delete().execute()
     Place.delete().execute()
     User.delete().execute()
     City.delete().execute()
     State.delete().execute()

# 需要导入模块: from app.models.state import State [as 别名]
# 或者: from app.models.state.State import delete [as 别名]
def handle_state_id(state_id):
    '''Select the state with the id from the database and store as the variable
    `state` with a GET request method. Update the data of the particular state
    with a PUT request method. This will take the parameters passed and update
    only those values. Remove the state with this id from the database with
    a DELETE request method.

    Keyword arguments:
    state_id: The id of the state from the database.
    '''
    try:
        state = State.select().where(State.id == state_id).get()
    except State.DoesNotExist:
        return jsonify(msg="There is no state with this id."), 404

    if request.method == 'GET':
        return jsonify(state.to_dict()), 200

    elif request.method == 'DELETE':
        try:
            state = State.delete().where(State.id == state_id)
        except State.DoesNotExist:
            raise Exception("There is no state with this id.")
        state.execute()
        return jsonify(msg="State deleted successfully."), 200

# 需要导入模块: from app.models.state import State [as 别名]
# 或者: from app.models.state.State import delete [as 别名]
def del_state(id):
    id_check = State.select().where(State.id == id)
    if not id_check:
        return {'code': 404, 'msg': 'State not found'}, 404

    item = State.delete().where(State.id == id)
    item.execute()
    return {'code': 200, 'msg': 'Deleted successfully'}, 200

# 需要导入模块: from app.models.state import State [as 别名]
# 或者: from app.models.state.State import delete [as 别名]
def delete_state(state_id):
    """
    Delete the given state
    Deletes the given state in the database.
    ---
    tags:
        - State
    parameters:
        -
            in: path
            name: state_id
            type: string
            required: True
            description: ID of the state
    responses:
        200:
            description: State deleted successfully
            schema:
                $ref: '#/definitions/delete_amenity_delete_delete_200'
        404:
            description: State was not found
        500:
            description: Request could not be processed
    """
    try:
        ''' Check that state_id exists '''
        query = State.select().where(State.id == state_id)
        if not query.exists():
            raise LookupError('state_id')

        ''' Delete the given state '''
        delete_state = State.delete().where(State.id == state_id)
        delete_state.execute()
        response = {}
        response['code'] = 200
        response['msg'] = "State account was deleted"
        return response, 200
    except LookupError as e:
        abort(404)
    except Exception as error:
        abort(500)

# 需要导入模块: from app.models.state import State [as 别名]
# 或者: from app.models.state.State import delete [as 别名]
 def setUp(self):
     #connect to db and delete everyone in the cities table
     City.delete().execute()
     State.delete().execute()

# 需要导入模块: from app.models.state import State [as 别名]
# 或者: from app.models.state.State import delete [as 别名]
 def tearDown(self):
     #delete all from cities
     City.delete().execute()
     State.delete().execute()

# 需要导入模块: from app.models.state import State [as 别名]
# 或者: from app.models.state.State import delete [as 别名]
 def setUp(self):
     #connect to db and delete everyone in the states table
     State.delete().execute()

# 需要导入模块: from app.models.state import State [as 别名]
# 或者: from app.models.state.State import delete [as 别名]
 def tearDown(self):
     #delete all from states
     State.delete().execute()

# 需要导入模块: from app.models.state import State [as 别名]
# 或者: from app.models.state.State import delete [as 别名]
 def tearDown(self):
     #delete all from places
     Place.delete().execute()
     User.delete().execute()
     City.delete().execute()
     State.delete().execute()