使用Flask Python将点几何插入到PostGIS中

from flask import Flask, request
from geoalchemy2 import Geometry
from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker

app = Flask(__name__)

# 创建数据库连接
engine = create_engine('postgresql://username:password@localhost/database')
Session = sessionmaker(bind=engine)

# 定义路由
@app.route('/insert_point', methods=['POST'])
def insert_point():
    # 获取请求中的点坐标
    x = request.form.get('x')
    y = request.form.get('y')

    # 创建数据库会话
    session = Session()

    # 创建点几何对象
    point = 'POINT({} {})'.format(x, y)
    geom = Geometry(point, srid=4326)

    # 插入点几何数据到PostGIS中
    session.execute("INSERT INTO points (geom) VALUES (:geom)", {'geom': geom})

    # 提交事务并关闭会话
    session.commit()
    session.close()

    return 'Point inserted successfully'

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

CREATE TABLE points (
    id SERIAL PRIMARY KEY,
    geom GEOMETRY(Point, 4326)
);