本文整理汇总了TypeScript中@nodulus/data.query函数的典型用法代码示例。如果您正苦于以下问题:TypeScript query函数的具体用法?TypeScript query怎么用?TypeScript query使用的例子?那么, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了query函数的5个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的TypeScript代码示例。
示例1: function
dal.query(query, { "email": user.Email }, function (exuser: any) {
if (exuser.length == 0) {
var query = "INSERT INTO users email=@email,password=@password;";
dal.query(query, { "email": user.Email, "password": user.Password }, function (user: any) {
callback(user.result.upserted[0]);
});
}
else {
user = { error: { message: "user exists" } };
callback(user);
}
});
示例2: register
public static register(user: any, callback: Function): void {
var query = "SELECT * FROM users WHERE email=@email;";
dal.query(query, { "email": user.Email }, function (exuser: any) {
if (exuser.length == 0) {
var query = "INSERT INTO users email=@email,password=@password;";
dal.query(query, { "email": user.Email, "password": user.Password }, function (user: any) {
callback(user.result.upserted[0]);
});
}
else {
user = { error: { message: "user exists" } };
callback(user);
}
});
}
示例3: login
public static login(email: string, password: string, callback: Function): void {
var query = "SELECT * FROM users WHERE email=@email AND password=@password;";
dal.query(query, { "email": email, "password": password }, function (user: any) {
if (user.length == 0) {
user = { error: { message: "not found" } };
callback(user);
}
else {
callback(user[0]);
}
});
}
示例4: function
}).delete(function (req: any, res: any) {
if (!req.body) return res.sendStatus(400);
var entity = req.params[0];
var and = " AND ";
var query = "DELETE FROM " + entity + " WHERE ";
if (req.query != null) {
for (var key in req.query) {
if (key !== "")
query += key + "=@" + key + and;
}
}
dal.query(query, req.query, function (apiResult: any) {
var data = { items: apiResult.ops }
res.end(JSON.stringify(data));
});
});
示例5: require
.post(function (req: any, res: any) {
if (!req.body) return res.sendStatus(400);
var entity = req.params[0];
var and = ",";
var query = "INSERT INTO " + entity + " ";
var body = req.body;
if (body.data !== undefined)
body = JSON.parse(body.data);
if (body.length !== undefined) {
for (var i = 0; i < body.length; i++) {
if (!config.appSettings.database.mongodb && config.appSettings.database.mongodb.useObjectId) {
// searchCommand.$query["_id"] = ObjectID(searchCommand.$query["_id"]);
// }
if (body[i].Id !== undefined) {
body[i]._id = body[i].Id;
}
else {
if (!body[i]._id || body[i]._id === null || body[i]._id === "")
body[i]._id = require("node-uuid").v4();
}
}
this.cleanEntityFramework(body[i], 0);
//if (body[i] != null) {
// for (var key in body[i]) {
// if (key.indexOf("$") == 0 || key == "EntityKey") {
// delete body[i][key];
// continue;
// }
// if (Array.isArray(body[i][key])) {
// for (var x = 0; x < body[i][key].length; x++) {
// var subObj = body[i][key][x];
// for (var subkey in subObj) {
// if (subkey.indexOf("$") == 0 || subkey == "EntityKey") {
// delete subObj[subkey];
// continue;
// }
// }
// }
// }
// query += key + "=@" + key + and;
// }
//}
dal.query(query, body[i], function (apiResult: any) {
var data = { items: apiResult.ops }
global["eventServer"].emit(entity + " UPDATE");
if (i == body.length)
res.end(JSON.stringify(data));
});
}
}
else {
if (config.appSettings.database.mongodb && !config.appSettings.database.mongodb.useObjectId) {
body._id = require("node-uuid").v4();
}
if (body != null) {
for (var key in body) {
query += key + "=@" + key + and;
}
}
dal.query(query, body, function (apiResult: any) {
var data = { items: apiResult.ops }
global["eventServer"].emit(entity + " UPDATE", data);
res.end(JSON.stringify(data));
});
}
})