Python设置仅当包含在GET请求中时的SQL查询参数

https://example.com/api?param1=value1&param2=value2

from flask import Flask, request

app = Flask(__name__)

@app.route('/query', methods=['GET'])
def query():
    param1 = request.args.get('param1')
    param2 = request.args.get('param2')

    if param1 and param2:
        # 执行SQL查询
        result = execute_sql_query(param1, param2)
        return {'result': result}
    else:
        return {'error': 'Missing parameters'}, 400

def execute_sql_query(param1, param2):
    # 这里可以连接数据库并执行SQL查询
    # 示例代码省略
    return f"Query executed with params: {param1}, {param2}"

if __name__ == '__main__':
    app.run(debug=True)

param1 = request.args.get('param1')
param2 = request.args.get('param2')

if not param1 or not param2:
    return {'error': 'Missing parameters'}, 400

from flask_sqlalchemy import SQLAlchemy

app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///example.db'
db = SQLAlchemy(app)

class ExampleModel(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(50))

@app.route('/query', methods=['GET'])
def query():
    param1 = request.args.get('param1')
    param2 = request.args.get('param2')

    if param1 and param2:
        results = ExampleModel.query.filter_by(name=param1, value=param2).all()
        return {'results': [result.name for result in results]}
    else:
        return {'error': 'Missing parameters'}, 400