mysql-querystr v1.0.5

###基于mysql2 ts ###根据json对象生成对应的sql语句

//select
 let myallQueryStr = new AllQueryStr(myQuery);
        let { sqlStr, parameterData, page, queryResult } = await myallQueryStr.createSelectSql(
            {
                selectNameArr: ['account', 'password'], //字段名
                tableNameArr: ['admin'], //表名
                wheres: [
                    // {
                    //     key: 'account',
                    //     act: '=',
                    //     val: 'asd',
                    // }
                ],
                handleSort: {
                    sortOrder: 'desc',
                    sortColumnName: 'account',
                    defaultSortColumn: 'account',
                    defaultSortOrder: 'desc',
                },
                handlePage: {
                    page: 1,
                    pageSize: 10
                },
                configure: {
                    totalPage: true,
                    exQuery: true
                }
            },

        )



//inster
let { sqlStr, parameterData, queryResult } = await myallQueryStr.createInsertSql({
            values: [{
                key: 'account',
                val: 'account',
                isMust: true,
                notNull: true,
            }, {
                key: 'password',
                val: 'password',
                isMust: true,
                notNull: true,
            },
            {
                key: 'belong_stores_name',
                val: 'belong_stores_name',
                isMust: true,
                notNull: true,
            }
            ],
            from: 'admin',
            configure: {
                exQuery: true
            },
        }
        )

//update

   let myallQueryStr = new AllQueryStr(myQuery);
        let { sqlStr, parameterData, queryResult } = await myallQueryStr.createUpdateSql({
            values: [{
                key: 'account',
                val: 'account',
                isMust: true,
                notNull: true,
            }, {
                key: 'password',
                val: 'password',
                isMust: true,
                notNull: true,
            },
            {
                key: 'belong_stores_name',
                val: 'belong_stores_name',
                isMust: true,
                notNull: true,
            }
            ],
            wheres: [{
                key: 'account',
                act: '=',
                val: 'account',
                isMust:true
            }],
            from: 'admin',
            configure: {
                exQuery: true
            },
        }
        )


//delete
  let { sqlStr, parameterData, queryResult } = await myallQueryStr.createDeleteSql({
            wheres: [{
                key: 'account',
                act: '=',
                val: 'account',
                isMust:true
            }],
            from: 'admin',
            configure: {
                exQuery: true
            },
        }
        )