select ST_AsText(geography) from mall_business
"templateSql": {
"message": {
"delete": "删除:总数{0}条,成功{1}条,失败{2}条。",
"update": "更新:总数{0}条,成功{1}条,失败{2}条。",
"edit": "修改:总数{0}条,成功{1}条,失败{2}条。",
"add": "新增:总数{0}条,成功{1}条,失败{2}条。",
"batSave": "批量保存:总数{0}条,新增成功{1}条,新增失败{2}条,删除成功{3}条,删除失败{4}条,修改成功{5}条,修改失败{6}条。",
"treeSave": "信息分配:总数{0}条,新增成功{1}条,新增失败{2}条,删除成功{3}条,删除失败{4}条,修改成功{5}条,修改失败{6}条。"
},
"updateSql": "update {table_name} set {u_column} where {primary_where_sql}",
"deleteSql": "delete from {table_name} where {primary_where_sql}",
"insertSql": "insert into {table_name} ({i_column}) values ({i_column_value});",
"insertSqlReturn": "{insertSql}",
//"iterationSql": "with temp as (select {iteration_id} ID,{iteration_parent_id} PARENT_ID from {table_name} WHERE {iteration_id}=@{iteration_id_value} {where_sql} UNION ALL select T0.{iteration_id} ID,T0.{iteration_parent_id} PARENT_ID from temp,{table_name} T0 WHERE temp.{iteration_id}=T0.{iteration_parent_id} {where_sql_t0}) select ID VALUE from temp;",
"insertSort": "(select min(tb_sort.sort_id) from (select (IFNULL(min({insert_sort_name}),99999999)-3) sort_id from {table_name} where {insert_sort_name}>1000) tb_sort)",
"clickSql": " update {table_name} set {u_column}=IFNULL({u_column},0)+1 where {primary_where_sql}",
//特殊属性集成
"dateDiffSort": "(case when TIMESTAMPDIFF(MINUTE,{date_diff_column},@_currentDate)<{date_diff_minute} then 0 else 1 end)",
"dateDiffValue": "TIMESTAMPDIFF(MINUTE,{date_diff_column},@_currentDate)",
"geographyFromText": "ST_GeomFromText(@stFromText)",
"geographyAsText": "ST_AsText({st_col_name}) {st_col_name}",
"geographySrid": 4326,
"geographyWkid": 4326,
"geographyPoint": "'POINT({st_lng} {st_lat})'",
"geographyLine": "LINESTRING({st_line}))",
"geographyPolygon": "POLYGON(({st_area}))",
"geographyDistance": "ST_DISTANCE_SPHERE(ST_GeomFromText(@stStartLngLat),ST_GeomFromText(@stEndLngLat))",
"geographyDbDistance": "ST_DISTANCE_SPHERE({st_geography},ST_GeomFromText(@stEndLngLat))",
"geographyArea": "ST_Area(ST_GeomFromText(@stPolygon))",
"geographyDbArea": "({st_geography})",
"nullSql": "IFNULL({null_o},{null_new})"
},
文档更新时间: 2022-01-12 11:59 作者:admin