mybatis3 mapper
mybatis3 mapper
Support
- select, upate, delete, insert
- include
- if
- choose, when, otherwise
- trim, where, set
- foreach
- bind
Usage
var mybatis3 = mybatis3 const Board = mybatis3Board
example
insert
// Read files in custom folders
.
├── xmls
│ └── basic.xml
└── app.js
// basic.xml INSERT INTO TBL_BOARD(BRDTITLE, BRDMEMO, BRDWRITER, BRDDATE) VALUES (:brdtitle, :brdmemo, :brdwriter, NOW())
var mybatis3 = mybatis3 var Board = mybatis3var params = brdtitle: 'test board' brdmemo: 'test' brdwriter: 'james kim' // 1. get queryBoard// INSERT INTO TBL_BOARD(BRDTITLE, BRDMEMO, BRDWRITER, BRDDATE) VALUES ('test board', 'test', 'james kim', NOW()) // 2. execute-1, auto releasevar conn = // mysql connection, has `query, release` methodBoard // executed resultBoardlastQuery // can access last query by `lastQuery` getter // 3. execute-2var pool = // mysql connection pool, has `query` methodmybatis3Board // executed resultBoardlastQuery // can access last query by `lastQuery` getter // 4. transactionvar pool = // mysql connection pool, has `getConnection` methodmybatis3mybatis3
more example
see test https://github.com/pruge/mybatis3/tree/master/test
basic
WHERE id=:brdno WHERE id=:brdno SELECT * FROM TBL_BOARD INSERT INTO TBL_BOARD(BRDTITLE, BRDMEMO, BRDWRITER, BRDDATE) VALUES (:brdtitle, :brdmemo, :brdwriter, NOW()) UPDATE TBL_BOARD SET BRDTITLE=:brdtitle, BRDMEMO=:brdmemo, BRDWRITER=:brdwriter DELETE FROM TBL_BOARD
if
INSERT INTO TBL_BOARD(BRDTITLE, BRDMEMO, BRDWRITER, BRDDATE) VALUES (:brdtitle, :brdmemo, :brdwriter, NOW()) ORDER BY created DESC ORDER BY created DESC ORDER BY created DESC TEST
choose, when, otherwise
SELECT * FROM BLOG WHERE state = ‘ACTIVE’ AND title like :title AND author_name like :author.name AND featured = 1
foreach
SELECT * FROM POST P WHERE ID in :item
trim, where, set
SELECT * FROM BLOG state = :state AND title like :title AND author_name like :author.name SELECT * FROM BLOG state = :state AND title like :title AND author_name like :author.name update Author username=:username, password=:password, email=:email, bio=:bio where id=:id
bind
SELECT * FROM BLOG WHERE title LIKE :pattern