本文整理汇总了TypeScript中mysql.IConnection.query方法的典型用法代码示例。如果您正苦于以下问题:TypeScript IConnection.query方法的具体用法?TypeScript IConnection.query怎么用?TypeScript IConnection.query使用的例子?那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类mysql.IConnection
的用法示例。
在下文中一共展示了IConnection.query方法的6个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的TypeScript代码示例。
示例1: 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();
});
});
示例2: reject
return new Promise<T[]>((resolve, reject) => {
this.debug(query, args);
this.connection.query(query, args, (err: any, rows: T[]) => {
if (err) {
reject(new SqlException(err));
return;
}
resolve(rows);
});
});
示例3: 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!');
});
});
}
示例4: getTables
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);
});
}
示例5: describe
describe(table:string, cb?) {
this.db.query('DESCRIBE ??', [table], cb);
}
示例6: generateModels
if (program.all) {
// Get list of tables
let query = squel
.select()
.field('table_name')
.from('information_schema.tables')
.where('table_schema=?',config.db.database)
.toString();
connection.query(query, (err, result) => {
if (err){
console.log('Error getting tables');
process.exit(1);
}
let tables = [];
for(let i=0;i<result.length;i++){
tables.push(result[i].table_name);
}
generateModels(tables);
});
} else {
generateModels(program.tables.split(','));
}
function generateModels(tables){
for(let i=0;i<tables.length;i++){
generateModel(tables[i]);
}
}