本文整理汇总了TypeScript中ionic-native.SQLite.executeSql方法的典型用法代码示例。如果您正苦于以下问题：TypeScript SQLite.executeSql方法的具体用法？TypeScript SQLite.executeSql怎么用？TypeScript SQLite.executeSql使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类ionic-native.SQLite的用法示例。
在下文中一共展示了SQLite.executeSql方法的10个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的TypeScript代码示例。
示例1: tests
}).then(() => {
this.db.executeSql('CREATE TABLE IF NOT EXISTS tests (id INTEGER PRIMARY KEY AUTOINCREMENT, name Text, user_id Text, date TIMESTAMP)', {}).then((data) =>{
console.log("TESTS TABLE CREATED", JSON.stringify(data.res));
}, (error) => {
console.log("Error creating tests table", JSON.stringify(error.err));
});
this.db.executeSql('CREATE TABLE IF NOT EXISTS test_sections (id INTEGER PRIMARY KEY AUTOINCREMENT, section INTEGER, question TEXT, score TEXT, question_id INTEGER, test_id INTEGER, CONSTRAINT composite_id UNIQUE (section, question_id, test_id))', {}).then((data) =>{
console.log("TEST SECTIONS TABLE CREATED", JSON.stringify(data.res));
}, (error) => {
console.log("Error creating tests table", JSON.stringify(error.err));
});
}, (err) => {示例2: add
public add() {
this.database.executeSql("INSERT INTO user (firstname, lastname) VALUES (?, ?)", ['Alejandro', 'Romero']).then((data) => {
console.log("INSERTED: " + JSON.stringify(data));
}, (error) => {
console.log("ERROR: " + JSON.stringify(error));
});
}示例3: createTable
createTable(){
let sql = 'CREATE TABLE IF NOT EXISTS product(' +
'id INTEGER PRIMARY KEY AUTOINCREMENT, ' +
'type TEXT, ' +
'quantity INTEGER, ' +
'price TEXT, ' +
'name TEXT)';
return this.db.executeSql(sql, []);
}示例4: getAll
getAll(){
let query = 'SELECT * FROM product';
return this.db.executeSql(query, [])
.then(response => {
let products = [];
for (let index = 0; index < response.rows.length; index++) {
products.push(response.rows.item(index));
}
return Promise.resolve(products);
})
}示例5: refresh
public refresh() {
this.database.executeSql("SELECT * FROM user", {}).then((data) => {
this.user = [];
if(data.rows.length > 0) {
for(var i = 0; i < data.rows.length; i++) {
this.user.push({firstname: data.rows.item(i).firstname, lastname: data.rows.item(i).lastname});
}
}
}, (error) => {
console.log("ERROR: " + JSON.stringify(error));
});
}示例6: deleteAnswers
public deleteAnswers(id: number){
let sql = 'DELETE FROM test_sections WHERE test_id = ?';
return this.db.executeSql(sql, [id]);
}示例7: update
// Update an existing note with a given ID
public update(test: Test) {
let sql = 'UPDATE test_sections SET score = ? WHERE section = ? AND question_id = ? AND test_id = ?';
return this.db.executeSql(sql, [test.score, test.section, test.question_id, test.test_id]);
}示例8: add
// Save a new note to the DB
public add(test: Test) {
let sql = 'INSERT OR IGNORE INTO test_sections (section, question, score, question_id, test_id) VALUES (?, ?, ?, ?, ?)';
return this.db.executeSql(sql, [test.section, test.question, test.score, test.question_id, test.test_id]);
}示例9: getBySection
// Get tests by section and test id
public getBySection(section: number, id: number) {
let sql = 'SELECT * FROM test_sections WHERE section = ? and test_id = ? ORDER BY section ASC';
return this.db.executeSql(sql, [section, id]);
}示例10: getLast
public getLast(test_id: number) {
let sql = 'SELECT * FROM test_sections WHERE id = (SELECT MAX(id) FROM test_sections WHERE test_id = ?);';
return this.db.executeSql(sql, [test_id]);
}