一、网站结构如下:
注意html页面需要放在名为templates的文件夹下,这是flask的规定。
二、Postgis操作
位于pgConnect.py中,代码如下:
#encoding: utf-8
import psycopg2
def insertGeo(start_time,end_time,reg_name,reg_radius,valid_time,reg_gov,guid,geom):
conn = psycopg2.connect(database="noFly",user="postgres",password="123",host="192.168.0.236",port="5433")
cur = conn.cursor()
sql="insert into tablename (is_enable,start_time,end_time,reg_name,reg_radius,valid_time,reg_gov,guid,geom) values ('1','{0}','{1}','{2}',{3},'{4}','{5}','{6}',ST_GeomFromGeoJson('{7}'))".format(start_time,end_time,reg_name,reg_radius,valid_time,reg_gov,guid,geom)
print(sql)
cur.execute(sql)
conn.c