pip install bottle
pip install <database_driver>
python
from bottle import Bottle, route, run, request
import <database_driver>
python
db = <database_driver>.connect(host='<host>', user='<username>', password='<password>', database='<database_name>')
cursor = db.cursor()
python
app = Bottle()
@app.route('/users')
def get_users():
cursor.execute("SELECT * FROM users")
result = cursor.fetchall()
return {'users': result}
@app.route('/users/<id:int>')
def get_user(id):
cursor.execute(f"SELECT * FROM users WHERE id = {id}")
result = cursor.fetchone()
return {'user': result}
@app.route('/users', method='POST')
def create_user():
name = request.forms.get('name')
age = request.forms.get('age')
cursor.execute(f"INSERT INTO users (name, age) VALUES ('{name}', {age})")
db.commit()
return {'message': 'User created successfully'}
python
if __name__ == '__main__':
run(app, host='<host>', port=<port>)