Lines Matching refs:executeSqlAsync

626           await tx.executeSqlAsync('DROP TABLE IF EXISTS Users;', []);
627 await tx.executeSqlAsync(
653 await tx.executeSqlAsync('INSERT INTO Users (name) VALUES (?)', [userName]);
654 const result = await tx.executeSqlAsync('SELECT * FROM Users LIMIT 1');
663 await tx.executeSqlAsync('DROP TABLE IF EXISTS foo;', []);
664 await tx.executeSqlAsync('create table foo (a primary key, b INTEGER);', []);
665 await tx.executeSqlAsync('select crsql_as_crr("foo");', []);
666 await tx.executeSqlAsync('insert into foo (a,b) values (?, ?);', [1, 2]);
667 await tx.executeSqlAsync('insert into foo (a,b) values (?, ?);', [3, 4]);
668 const result = await tx.executeSqlAsync('select * from crsql_changes;', []);
681 await tx.executeSqlAsync('DROP TABLE IF EXISTS Users;', []);
682 await tx.executeSqlAsync(
690 tx.executeSqlAsync('INSERT INTO Users (name) VALUES (?)', ['aaa']),
691 tx.executeSqlAsync('INSERT INTO Users (name) VALUES (?)', ['bbb']),
692 tx.executeSqlAsync('INSERT INTO Users (name) VALUES (?)', ['ccc']),
695 const result = await tx.executeSqlAsync('SELECT COUNT(*) FROM Users');
710 await tx.executeSqlAsync('DROP TABLE IF EXISTS Users;', []);
727 await tx.executeSqlAsync('DROP TABLE IF EXISTS Users;', []);
728 await tx.executeSqlAsync(
734 await tx.executeSqlAsync('INSERT INTO Users (name) VALUES (?)', ['aaa']);
737 const result = await tx.executeSqlAsync('SELECT COUNT(*) FROM Users');
744 await tx.executeSqlAsync('INSERT INTO Users (name) VALUES (?)', ['bbb']);
745 await tx.executeSqlAsync('INSERT INTO Users (name) VALUES (?)', ['ccc']);
747 await tx.executeSqlAsync(null);
752 const result = await tx.executeSqlAsync('SELECT COUNT(*) FROM Users');
761 await tx.executeSqlAsync('DROP TABLE IF EXISTS SomeTable;', []);
762 await tx.executeSqlAsync(
767 let result = await tx.executeSqlAsync('PRAGMA table_info(SomeTable);', []);
772 await tx.executeSqlAsync('PRAGMA case_sensitive_like = true;', []);
774 await tx.executeSqlAsync('PRAGMA user_version = 123;', []);
775 result = await tx.executeSqlAsync('PRAGMA user_version;', []);