daocha_serve/Source/server/pianguanPOIServer/sqlUtil.js

//查询所有
function tablelist(req) {
    let tablename = req.body.tablename;
    // let sql = `SELECT *
    // FROM public.pianguanall;`;
    let sql = `SELECT *,st_astext(geom) FROM ${tablename};`;
    return sql;
}

//查找指定数据
// function select(req) {
//     let typename = req.body.typename;
//     let tablename = req.body.tablename;

//     let sql = `SELECT * FROM public.${tablename}
//         WHERE typename like '${typename}%';`;
//     console.log(sql);
//     return sql;
// }
// 通用 通用 通用 通用 通用 通用 通用 通用 通用 通用 通用 通用 通用
//查
function select(req) {
    let tablename = req.body.tablename;
    let typename = req.body.typename;
    if (!tablename) return;
    // let value = req.body.value.replace(/\n|\r/g, "");
    // console.log(value);
    let sql = `SELECT *,st_astext(geom) FROM ${tablename}
           WHERE typename like '${typename}%';`;
    console.log(sql);
    return sql;
}


//save->WKT
function savewkt(req) {
    // UPDATE public."t_Y_dantihuaTest"
    // SET "DTgeoData"=ST_GeomFromText('POLYGON((121.415703 31.172893,121.415805 31.172664,121.416127 31.172751,121.41603 31.172976,121.415703 31.172893))',4490) 
    // where "DTid" = 1;
    let tbname = req.body.tbname;

    let sql = `UPDATE public.${tbname} SET "DTgeoData"=ST_GeomFromText('POLYGON((121.415 31.172,121.415 31.172,121.416 31.172,121.415 31.172))',4490) where "DTid" = 1;`
    return sql;
}
//get->WKT
function getwkt(req) {
    // UPDATE public."t_Y_dantihuaTest"
    // SET "DTgeoData"=ST_GeomFromText('POLYGON((121.415703 31.172893,121.415805 31.172664,121.416127 31.172751,121.41603 31.172976,121.415703 31.172893))',4490) 
    // where "DTid" = 1;
    let tbname = req.body.tbname;
    console.log(req.body);
}
/* ******************************************** */




module.exports = {
    tablelist,
    select,
    savewkt,
    getwkt
};