January 2024 – Useful code

Month: January 2024

Simplifying Excel Tasks with Python: Data Handling and Testing Tutorial

Posted on January 25, 2024 by

Working with Python and Excel is actually quite handy, especially if you are into it. In this article, you can see how to create Excel files, write data and formulas into them and read these. Pretty much simple CRUD methods.…

Python API With Flask And Postman – Put and Delete Methods

Posted on January 16, 2024 by

Vitosh Posted in Python

In the previous article, the post and get API methods were presented. In this one, Put and Delete are coming. 🙂 Well, nothing that fancy, this is how these two methods look like:

# Update item by id
@app.route('/api/items/<int:item_id>', methods=['PUT'])
def update_item(item_id):
    data = request.get_json()
    updated_data = data.get('item') # Get the nested 'item' data

    if not updated_data:
        return jsonify({'error': 'No data provided'}), 400
    
    item = next((item for item in items if item['id'] == item_id), None)
    if item is None:
        return jsonify({'error': f'Item #{item_id} not found!'})

    # Update fields in the item (dummy db)
    for key, value in updated_data.items():
        if key in item:
            item[key] = value

    return jsonify({'message': 'Item updated successfully', 'item':item}), 200


# Delete item by id
@app.route('/api/items/<int:item_id>', methods=['DELETE'])
def delete_item(item_id):
    item_to_delete = next((item for item in items if item['id'] == item_id), None)

    if item_to_delete is None:
        return jsonify({'error': f'Item {item_id} not found!'}), 404
    items.remove(item_to_delete)

    return jsonify({'message': f'Item: {item_to_delete} has been deleted successfully!'}), 200

# Update item by id

@app.route('/api/items/<int:item_id>', methods=['PUT'])

def update_item(item_id):

data = request.get_json()

updated_data = data.get('item') # Get the nested 'item' data

if not updated_data:

return jsonify({'error': 'No data provided'}), 400

item = next((item for item in items if item['id'] == item_id), None)

if item is None:

return jsonify({'error': f'Item #{item_id} not found!'})

# Update fields in the item (dummy db)

for key, value in updated_data.items():

if key in item:

item[key] = value

return jsonify({'message': 'Item updated successfully', 'item':item}), 200

# Delete item by id

@app.route('/api/items/<int:item_id>', methods=['DELETE'])

def delete_item(item_id):

item_to_delete = next((item for item in items if item['id'] == item_id), None)

if item_to_delete is None:

return jsonify({'error': f'Item {item_id} not found!'}), 404

items.remove(item_to_delete)

return jsonify({'message': f'Item: {item_to_delete} has been deleted successfully!'}), 200

And, of course tests are a…

Tagged with: API, delete, Flask, put, Python, simple

Python API With Flask And Postman – Post and Get Methods

Posted on January 4, 2024 by

Vitosh Posted in Python

This is the second video for the “Python API with Flask” series, showing how to make POST and GET commands towards a dummy database, which is a python list in our case. We are using only CREATE and READ commands…

Tagged with: API, Flask, GET, POST, postman, Python, read all, youtube

Python – Make a simple API with Flask and Postman

Posted on January 2, 2024 by

Vitosh Posted in VBA \ Excel

Flask is actually really a powerful tool for making an API. In the video below, you would see how quickly I am building an API, that does four really simple functions. The functions are – saying “Hello”, multiplying a number by…

Tagged with: API, Flask, postman, Python, simple