2.3.3 • Published 5 years ago

koa-static-query v2.3.3

Weekly downloads
-
License
ISC
Repository
-
Last release
5 years ago
    const query = require('./db/query');

    app.use(static(path.join(process.cwd(),'public')));

    app.use(bodyparser());  //ctx.request.body

    app.use(router.routes());

    app.use(router.allowedMethods());

    let create_time = new Date();
    # search (vague) : 

    await query(`select *  from userlist where username like '%${key}%'`) 

    #     select : 

    await query('select * from userlist where username=?' ,[username])

    #     add :

    await query(insert into userlist (username,...)  values (?,...),[username,...])

    #     delete : 

    await query('delete from userlist where id=?',[id])

    #     update :

    await query('update userlist set username=?,.....  where username=?',[username,...])