本文整理汇总了TypeScript中@ionic-native/sqlite.SQLiteObject类的典型用法代码示例。如果您正苦于以下问题:TypeScript SQLiteObject类的具体用法?TypeScript SQLiteObject怎么用?TypeScript SQLiteObject使用的例子?那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。
在下文中一共展示了SQLiteObject类的10个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的TypeScript代码示例。
示例1: resolve
this.openDatabase().then((db: SQLiteObject) => {
db.executeSql(query, []).then(() => {
resolve();
}).catch((err) => {
reject("Error while deleting record from table!");
})
}).catch((err) => {
开发者ID:sqlite-sync,项目名称:SQLite-sync.com,代码行数:7,代码来源:sqlite-sync.ts
示例2: resolve
(connection: SQLiteObject) => {
connection.executeSql(sql, paramSQL).then(
(result) => {
//console.log("===== Select tb_stepsumassure success size " + result.rows.length);
responseM.size = result.rows.length;
responseM.status = 0;
if (result.rows.length > 0) {
let objMs: Array<StepSumAssureM> = [];
var len = result.rows.length;
for (var index = 0; index < len; index++) {
let objM: StepSumAssureM = result.rows.item(index);
objMs.push(objM);
}
responseM.data = objMs;
resolve(responseM);
}
else {
responseM.size = 0;
responseM.status = 0;
resolve(responseM);
}
}
, (error) => {
console.log("!!!!!!!!!!!!!!!!!!!!!!!! ==> Select tb_stepsumassure error " + error.message);
reject(error);
}
)
}
开发者ID:warozz,项目名称:D3VMobiz,代码行数:30,代码来源:stepsumassure-service.ts
示例3: function
this.openDatabase().then((db: SQLiteObject) => {
db.transaction((tx: any) => {
Object.keys(data)
.sort()
.forEach(function(v,i){
if(i !== 0){
tx.executeSql(data[v],[], function (transaction, result) {
console.log("Creating object " + v + "...");
}, function (transaction, error) {
console.log("Object " + v + ": " + error.message + " (Code " + error.code + ")");
});
}
});
})
.then((res) => {
this.getTables().then((data) => {
resolve(data);
})
.catch((err) => {
reject("Error while getting data from table!");
});
})
.catch((err) => {
reject("Error while reinitializing subscriber!");
});
});
开发者ID:sqlite-sync,项目名称:SQLite-sync.com,代码行数:26,代码来源:sqlite-sync.ts
示例4: resolve
(connection: SQLiteObject) => {
connection.executeSql(sql, paramSQL).then(
(result) => {
//console.log("===== Select tb_packagedetail success size " + result.rows.length);
responseM.size = result.rows.length;
responseM.status = 0;
if (result.rows.length > 0) {
let objMs: Array<PackageDetailM> = [];
var len = result.rows.length;
for (var index = 0; index < len; index++) {
let objM: PackageDetailM = result.rows.item(index);
// console.log("CCCCCCCCC " + JSON.stringify(objM));
objMs.push(objM);
}
responseM.data = objMs;
responseM.size = objMs.length;
resolve(responseM);
}
else {
responseM.size = 0;
responseM.status = 0;
resolve(responseM);
}
}
, (error) => {
console.log("!!!!!!!!!!!!!!!!!!!!!!!! ==> Select tb_packagedetail error " + error.message);
reject(error);
}
)
}
开发者ID:warozz,项目名称:D3VMobiz,代码行数:32,代码来源:package-detail-service.ts
示例5: resolve
(connection: SQLiteObject) => {
connection.executeSql(sql, paramSQL).then(
(result) => {
//console.log("===== SELECT Agent SUCCESS size " + result.rows.length);
responseM.size = result.rows.length;
responseM.status = 0;
//console.log("BBBB = " + JSON.stringify(result.rows.item()));
if (result.rows.length > 0) {
let agents: Array<AgentModel> = [];
var len = result.rows.length;
for (var index = 0; index < len; index++) {
agents.push(result.rows.item(index));
}
responseM.data = agents;
resolve(responseM);
}
else {
responseM.size = 0;
responseM.status = 0;
resolve(responseM);
}
}
, (error) => {
console.log("===== SELECT Agent ERROR " + error.message);
reject(error);
}
)
}
开发者ID:warozz,项目名称:D3VMobiz,代码行数:31,代码来源:agent-service.ts
示例6: resolve
(connection: SQLiteObject) => {
connection.executeSql(sql, paramSQL).then(
(result) => {
console.log("===== Select tb_riderdetail success size " + result.rows.length);
responseM.size = result.rows.length;
responseM.status = 0;
if (result.rows.length > 0) {
let riderDetailMs: Array<RiderDetailM> = [];
var len = result.rows.length;
for (var index = 0; index < len; index++) {
let riderDetailM: RiderDetailM = result.rows.item(index);
riderDetailMs.push(riderDetailM);
}
responseM.data = riderDetailMs;
resolve(responseM);
}
else {
responseM.size = 0;
responseM.status = 0;
resolve(responseM);
}
}
, (error) => {
console.log("===== Select tb_riderdetail error " + error.message);
reject(error);
}
)
}
开发者ID:warozz,项目名称:D3VMobiz,代码行数:30,代码来源:riderdetail-service.ts
示例7: resolve
(connection: SQLiteObject) => {
connection.executeSql(sql, paramSQL).then(
(result) => {
responseM.size = result.rows.length;
responseM.status = 0;
if (result.rows.length > 0) {
let subDistrictMs: Array<ProvinceModel> = [];
var len = result.rows.length;
for (var index = 0; index < len; index++) {
subDistrictMs.push(result.rows.item(index));
}
responseM.data = subDistrictMs;
resolve(responseM);
}
else {
responseM.size = 0;
responseM.status = 0;
resolve(responseM);
}
}
, (error) => {
console.log("===== Select tb_province error " + error.message);
reject(error);
}
)
}
开发者ID:warozz,项目名称:D3VMobiz,代码行数:29,代码来源:province-service.ts
示例8: KEY
(connection: SQLiteObject) => {
let sql: string = `CREATE TABLE IF NOT EXISTS ` + TB_SQLITE.tb_mcaapplications +
`(
xx TEXT, xx TEXT, xx TEXT, xx TEXT, xx TEXT,
xx TEXT, xx TEXT, xx TEXT, xx TEXT, xx TEXT,
xx TEXT, xx TEXT, xx TEXT, xx TEXT, xx TEXT,
xx TEXT, xx TEXT, xx TEXT, xx TEXT, xx TEXT,
xx TEXT, xx TEXT, xx TEXT, xx TEXT, xx TEXT,
xx TEXT, xx TEXT, xx TEXT, xx TEXT, xx TEXT,
xx TEXT, xx TEXT, xx TEXT, xx TEXT, xx TEXT,
xx TEXT, xx TEXT, xx TEXT, xx TEXT, xx TEXT,
xx TEXT, xx TEXT, xx TEXT, xx TEXT, xx TEXT,
xx TEXT, xx TEXT, xx TEXT, xx TEXT, xx TEXT,
xx TEXT, xx TEXT, xx TEXT, xx TEXT, xx TEXT,
xx TEXT, xx TEXT, xx TEXT, xx TEXT, xx TEXT,
xx TEXT, xx TEXT, xx TEXT, xx TEXT, xx TEXT,
PRIMARY KEY (xx)
);`;
connection.executeSql(sql, []).then(
(result) => {
console.log("Create table " + TB_SQLITE.tb_mcaapplications + " successfully.");
resolve(result);
}
, (error) => {
console.log("!!!!!!!!!!!!!!!!!!!!!!!! ==> Create table " + TB_SQLITE.tb_mcaapplications + " error.");
reject(error);
}
)
}
开发者ID:warozz,项目名称:D3VMobiz,代码行数:33,代码来源:mcaapplications-servicel.ts
示例9: resolve
(connection: SQLiteObject) => {
connection.executeSql(sql, paramSQL).then(
(result) => {
responseM.status = 0;
if (result.rows.length > 0) {
let quatationMs: Array<QuotationModel> = [];
var len = result.rows.length;
for (var index = 0; index < len; index++) {
let quotationM: QuotationModel = result.rows.item(index);
//console.log("quotationM Select XML = " + JSON.stringify(quotationM));
quatationMs.push(quotationM);
}
responseM.size = quatationMs.length;
responseM.data = quatationMs;
resolve(responseM);
}
else {
responseM.data = [];
responseM.size = 0;
responseM.status = 0;
resolve(responseM);
}
}
, (error) => {
console.log("===== Select tb_quatation error " + JSON.stringify(error));
reject(error);
}
)
}
开发者ID:warozz,项目名称:D3VMobiz,代码行数:34,代码来源:quotation-service.ts
示例10: usuario
this.deleteUser().then( () => {
return db.executeSql('insert into usuario (name, email, address, neighborhood, postalCode, city, state, password, dateofbirth, _id) values (?,?,?,?,?,?,?,?,?,?)', [user.name, user.email, user.address, user.neighborhood, user.postalCode, user.city, user.state, user.password, user.dateofbirth, user._id])
.then( data => {
console.log(data);
})
.catch(error => console.log(error));
});
开发者ID:SrTristao,项目名称:avisemeapp,代码行数:7,代码来源:sqlservice.ts
注:本文中的@ionic-native/sqlite.SQLiteObject类示例由纯净天空整理自Github/MSDocs等源码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。 |
请发表评论