本文整理匯總了TypeScript中mysql.IConnection類的典型用法代碼示例。如果您正苦於以下問題：TypeScript IConnection類的具體用法？TypeScript IConnection怎麽用？TypeScript IConnection使用的例子？那麽, 這裏精選的類代碼示例或許可以為您提供幫助。
在下文中一共展示了IConnection類的8個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的TypeScript代碼示例。
示例1: describe
describe("Book copy dao", function () {
let conn: IConnection;
before(function (done) {
DbConnection.initConnection("development");
conn = DbConnection.getConnection();
conn.query("CALL reset_db_for_test()", function (err) {
if (err) {
console.log(err);
throw err;
}
done();
//
});
});
it("should find 240 copies when find with no argument", function (done) {
BookCopy.dao.find({}, function (err, bookcopies) {
if (err) {
throw err;
}
bookcopies.should.have.length(240);
done();
});
});
/*
it("update with isbn argument should update 10 copies", function (done) {
let bookcopy = new BookCopy();
bookcopy.status = "BORROWED";
BookCopy.dao.update(bookcopy, {}, function (err, results) {
if (err) {
throw err;
}
console.log(results);
results.affectedRows.should.equal(1);
done();
});
});*/
});示例2: describe
describe("Book API: UPDATE", function () {
let url = "http://localhost:5000";
let conn: IConnection;
before(function (done) {
DbConnection.initConnection("development");
conn = DbConnection.getConnection();
conn.query("CALL reset_db_for_test()", function (err) {
if (err) {
console.log(err);
throw err;
}
done();
});
});
it("should save correctly formed book", function (done) {
let book = {
title: "TESTTEST", author: "TESTTEST", isbn: "isbn1",
pages: 5646, year: 2013, editorid: 1
};
request(url)
.put("/api/books")
.send(book)
.end(function (err, res) {
if (err) {
throw err;
}
res.status.should.equal(200);
request(url)
.get("/api/books?isbn=isbn1")
.end(function (err, res) {
if (err) {
throw err;
}
res.status.should.equal(200);
done();
});
});
});
it("should not save book with year in the future", function (done) {
let book = {
title: "TESTTEST", author: "TESTTEST", isbn: "isbn1",
pages: 5646, year: 2123, editorid: 1
};
request(url)
.put("/api/books")
.send(book)
.end(function (err, res) {
if (err) {
throw err;
}
res.status.should.equal(400);
done();
});
});
it("should not save book with editorid absent from database", function (done) {
let book = {
title: "test1", author: "test1", isbn: "isbnTEST2",
pages: 5646, year: 2123, editorid: 99999
};
request(url)
.put("/api/books")
.send(book)
.end(function (err, res) {
if (err) {
throw err;
}
res.status.should.equal(400);
done();
});
});
});示例3: reject
.then((result: T) => new Promise<T>((resolve, reject) => {
this.connection.commit(err => {
if (err) {
reject(err);
} else {
resolve(result);
}
});
}))示例4:
}, (err, outputs) => {
const header = this.getHeaderFile();
fs.write(fd, header + outputs.join("\n\n") + "\n", (err) => {
if (err) {
console.error(err.message);
process.exit(1);
}
});
connection.end();
});示例5: before
before(function (done) {
DbConnection.initConnection("development");
conn = DbConnection.getConnection();
conn.query("CALL reset_db_for_test()", function (err) {
if (err) {
console.log(err);
throw err;
}
done();
});
});示例6: generateModel
function generateModel(tableName){
// Get table detail
connection.query('DESC '+tableName, (err, result) => {
if (err){
console.log('Error getting structure of table '+tableName);
}
let parsedName = parseTableName(tableName);
let output = "";
if (config.baseModel) {
output += "import {BaseModel as "+config.baseModel.className+"} from \"./"+config.baseModel.fileName+"\";\r\n";
output += "import {IModelValidationRule} from \"./"+config.baseModel.fileName+"\";\r\n";
output += "\r\n";
}
output += "export interface I"+parsedName+" {\r\n";
for(let i=0;i<result.length;i++){
output += " "+result[i].Field+((result[i].Null === 'YES')?"?":"")+": "+getTSType(result[i].Type)+";\r\n";
}
output += "}\r\n";
output += "\r\n";
output += "export class "+parsedName+" "+((config.baseModel)?"extends "+config.baseModel.className:"")+" { \r\n";
output += " public static tableName: string = \"" + tableName+"\";\r\n";
output += "\r\n";
output += " public safe: String[] = [];\r\n";
output += "\r\n";
output += " public rules: IModelValidationRule[] = [];\r\n"; // @todo: If not using base model, this will yeld error
output += "\r\n";
output += " public attr: I" + parsedName + " = {\r\n";
for(let i=0;i<result.length;i++){
output += " "+result[i].Field+": undefined,\r\n";
}
output += " };\r\n";
output += "}\r\n";
fs.writeFile(program.output+tableName+'.ts',output,(err) => {
if (err) throw err;
console.log('Model for table '+tableName+' generated!');
});
});
}示例7: cb
getTables(cb:(error:any, tables?:string[]) => void) {
this.db.query('show tables', (err, result, fields) => {
if (err) {
return cb(err)
}
let field:string = fields[0].name;
let tables:string[] = [];
for (const info of result) {
let table = info[field];
tables.push(table);
}
cb(null, tables);
});
}示例8: initConnection
static initConnection(env: string) {
switch (env) {
case 'development':
this.dbConnection = mysql.createConnection(credentials.development.connection);
break;
case 'production':
this.dbConnection = mysql.createConnection(credentials.production.connection);
break;
default:
throw new Error('Unknown execution environment: ' + env);
}
this.dbConnection.connect();
}