@morpheus/addon-db 라이브러리에서 제공되는 모듈
Before
M.db.create
DB 파일을 생성한다.
Parameters
path
stringReturn
Promise<Object>
"SUCCESS" | "FAIL"Object
stringstringstringstringstringstringstringUsage
import * as MDb from "@morpheus/addon-db";
MDb.create("db_name").then((result) => {
console.log(result);
});
Before
M.db.remove
DB 파일을 삭제한다.
Parameters
path
stringReturn
Promise<Object>
"SUCCESS" | "FAIL"Object
stringstringstringstringstringstringstringUsage
import * as MDb from "@morpheus/addon-db";
MDb.remove("db_name").then((result) => {
console.log(result);
});
Before
M.db.open
DB 파일을 연결한다.
Parameters
path
stringReturn
Promise<Object>
"SUCCESS" | "FAIL"Object
stringstringstringstringstringstringstringUsage
import * as MDb from "@morpheus/addon-db";
MDb.open("db_name").then((result) => {
console.log(result);
});
Before
M.db.close
DB 파일을 연결을 해제한다.
Parameters
path
stringReturn
Promise<Object>
"SUCCESS" | "FAIL"Object
stringstringstringstringstringstringstringUsage
import * as MDb from "@morpheus/addon-db";
MDb.close("db_name").then((result) => {
console.log(result);
});
Before
M.db.close
DB 파일을 연결을 해제한다.
Parameters
options
Obejct
stringstringbooleanbooleanReturn
Promise<Object>
"SUCCESS" | "FAIL"Object
stringstringstringstringstringstringstringstring[]numberstring[]string[]any[]any[]Usage
import * as MDb from "@morpheus/addon-db";
const sql =
"CREATE TABLE books (id INTEGER PRIMARY KEY, title varchar(255) not null, author varchar(255) not null )";
MDb.execute({ path: "db_name", sql }).then((result) => {
console.log(result);
});
import * as MDb from "@morpheus/addon-db";
const sql =
'INSERT INTO books (title, author) values ("제목1", "작가1");INSERT INTO books (title, author) values ("제목2", "작가2")';
MDb.execute({ path: "db_name", sql, multiple: true }).then((result) => {
console.log(result);
});