本文整理匯總了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) => {示例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);
}
)
}示例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!");
});
});示例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);
}
)
}示例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);
}
)
}示例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);
}
)
}示例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);
}
)
}示例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);
}
)
}示例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);
}
)
}示例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));
});