| /external/python/cpython2/Doc/includes/sqlite3/ |
| execsql_fetchonerow.py | 6 SELECT = "select name_last, age from people order by age, name_last"
10 cur.execute(SELECT)
15 cur.execute(SELECT)
|
| simple_tableprinter.py | 5 SELECT = 'select * from %s order by age, name_last' % TABLE_NAME
10 cur.execute(SELECT)
|
| /external/python/cpython3/Doc/includes/sqlite3/ |
| execsql_fetchonerow.py | 6 SELECT = "select name_last, age from people order by age, name_last"
10 cur.execute(SELECT)
15 cur.execute(SELECT)
|
| simple_tableprinter.py | 5 SELECT = 'select * from %s order by age, name_last' % TABLE_NAME
10 cur.execute(SELECT)
|
| /external/autotest/contrib/ |
| remove_old_tests_in_tko.sql | 11 WHILE EXISTS (SELECT test_idx FROM tko_tests WHERE started_time < @cutoff_date LIMIT 1) DO
13 SELECT concat("Deleting 5k records in tko_tests older than ", @cutoff_date);
15 SELECT SLEEP(5);
22 WHILE EXISTS (SELECT test_idx FROM tko_tests where started_time IS NULL and finished_time < @cutoff_date LIMIT 1) DO
24 SELECT concat("Deleting 5k records in tko_tests with finished time older than ", @cutoff_date);
26 SELECT SLEEP(5);
35 WHILE EXISTS (SELECT job_idx FROM tko_jobs WHERE started_time < @cutoff_date LIMIT 1) DO
37 SELECT concat("Deleting 5k records in tko_jobs older than ", @cutoff_date);
39 SELECT SLEEP(5);
|
| /frameworks/support/room/compiler/src/test/kotlin/androidx/room/solver/query/ |
| QueryWriterTest.kt | 56 @Query("SELECT id FROM users")
62 final java.lang.String _sql = "SELECT id FROM users";
71 @Query("SELECT id FROM users WHERE name LIKE :name")
78 final java.lang.String _sql = "SELECT id FROM users WHERE name LIKE ?";
93 @Query("SELECT id FROM users WHERE id IN(:id1,:id2)")
100 final java.lang.String _sql = "SELECT id FROM users WHERE id IN(?,?)";
113 @Query("SELECT id FROM users WHERE id IN(:ids) AND age > :time")
121 _stringBuilder.append("SELECT id FROM users WHERE id IN(");
142 _stringBuilder.append("SELECT id FROM users WHERE id IN(");
166 @Query("SELECT id FROM users WHERE id IN(:ids) AND age > :time"
[all...] |
| /packages/apps/Contacts/src/com/android/contacts/logging/ |
| ListEvent.java | 46 public static final int SELECT = 3;
|
| /external/wpa_supplicant_8/hs20/server/www/ |
| spp.php | 53 $row = $db->query("SELECT password FROM users " .
56 $row = $db->query("SELECT osu_password FROM users " .
|
| /frameworks/support/room/compiler/src/test/kotlin/androidx/room/processor/ |
| DatabaseProcessorTest.kt | 91 @Query("SELECT * FROM user")
97 @Query("SELECT * FROM user where uid = :uid")
101 @Query("SELECT * FROM user where uid = :uid")
104 @Query("SELECT * FROM user where uid = :uid")
107 @Query("SELECT * FROM user")
111 @Query("SELECT * FROM user where uid = :uid")
140 @Query("SELECT * FROM book")
202 @Query("SELECT * FROM nonExistentTable")
247 @Query("SELECT nonExistingField FROM Book")
552 @Query("SELECT * FROM user where uid = :uid"
[all...] |
| DaoProcessorTest.kt | 72 @Query("select 1")
85 @Query("SELECT uid FROM User")
99 @Query("SELECT uid FROM User")
113 @Query("SELECT uid FROM User")
132 @Query("SELECT nonExistingField FROM User")
147 @Query("SELECT * from user")
174 @Query("SELECT * from user")
208 @Query("select * from user")
233 @Query("select * from user")
258 @Query("select * from user"
[all...] |
| QueryMethodProcessorTest.kt | 106 @Query("SELECT * from User")
120 @Query("SELECT * from User where uid = :x")
138 @Query("SELECT * from User where uid in (:ids)")
157 @Query("SELECT uid from User where uid = :id")
172 @Query("SELECT uid from User where uid = :id")
188 @Query("SELECT uid from User where uid = :id OR uid = :id")
206 @Query("SELECT uid from User where uid = :id OR uid = :uid")
227 @Query("SELECT uid from User where name = :bar AND uid = :id OR uid = :uid")
250 @Query("SELECT uid from User where name = :bar")
267 @Query("select * from User where uid = :_blah"
[all...] |
| /packages/providers/ContactsProvider/tests/assets/upgradeTest/ |
| contacts2_1108.sql | 139 CREATE VIEW view_data AS SELECT data._id AS _id,hash_id, raw_contact_id, raw_contacts.contact_id AS contact_id, raw_contacts.account_id,accounts.account_name AS account_name,accounts.account_type AS account_type,accounts.data_set AS data_set,(CASE WHEN accounts.data_set IS NULL THEN accounts.account_type ELSE accounts.account_type||'/'||accounts.data_set END) AS account_type_and_data_set,raw_contacts.sourceid AS sourceid,raw_contacts.backup_id AS backup_id,raw_contacts.version AS version,raw_contacts.dirty AS dirty,raw_contacts.sync1 AS sync1,raw_contacts.sync2 AS sync2,raw_contacts.sync3 AS sync3,raw_contacts.sync4 AS sync4, is_primary, is_super_primary, data_version, data.package_id,package AS res_package,data.mimetype_id,mimetype AS mimetype, is_read_only, data1, data2, data3, data4, data5, data6, data7, data8, data9, data10, data11, data12, data13, data14, data15, carrier_presence, data_sync1, data_sync2, data_sync3, data_sync4, contacts.custom_ringtone AS custom_ringtone,contacts.send_to_voicemail AS send_to_voicemail,contacts.last_time_contacted AS last_time_contacted,contacts.times_contacted AS times_contacted,contacts.starred AS starred,contacts.pinned AS pinned, name_raw_contact.display_name_source AS display_name_source, name_raw_contact.display_name AS display_name, name_raw_contact.display_name_alt AS display_name_alt, name_raw_contact.phonetic_name AS phonetic_name, name_raw_contact.phonetic_name_style AS phonetic_name_style, name_raw_contact.sort_key AS sort_key, name_raw_contact.phonebook_label AS phonebook_label, name_raw_contact.phonebook_bucket AS phonebook_bucket, name_raw_contact.sort_key_alt AS sort_key_alt, name_raw_contact.phonebook_label_alt AS phonebook_label_alt, name_raw_contact.phonebook_bucket_alt AS phonebook_bucket_alt, has_phone_number, name_raw_contact_id, lookup, photo_id, photo_file_id, CAST(EXISTS (SELECT _id FROM visible_contacts WHERE contacts._id=visible_contacts._id) AS INTEGER) AS in_visible_group, CAST(EXISTS (SELECT _id FROM default_directory WHERE contacts._id=default_directory._id) AS INTEGER) AS in_default_directory, status_update_id, contacts.contact_last_updated_timestamp, (CASE WHEN photo_file_id IS NULL THEN (CASE WHEN photo_id IS NULL OR photo_id=0 THEN NULL ELSE 'content://com.android.contacts/contacts/'||raw_contacts.contact_id|| '/photo' END) ELSE 'content://com.android.contacts/display_photo/'||photo_file_id END) AS photo_uri, (CASE WHEN photo_id IS NULL OR photo_id=0 THEN NULL ELSE 'content://com.android.contacts/contacts/'||raw_contacts.contact_id|| '/photo' END) AS photo_thumb_uri, 0 AS raw_contact_is_user_profile, groups.sourceid AS group_sourceid FROM data JOIN mimetypes ON (data.mimetype_id=mimetypes._id) JOIN raw_contacts ON (data.raw_contact_id=raw_contacts._id) JOIN accounts ON (raw_contacts.account_id=accounts._id) JOIN contacts ON (raw_contacts.contact_id=contacts._id) JOIN raw_contacts AS name_raw_contact ON(name_raw_contact_id=name_raw_contact._id) LEFT OUTER JOIN packages ON (data.package_id=packages._id) LEFT OUTER JOIN groups ON (mimetypes.mimetype='vnd.android.cursor.item/group_membership' AND groups._id=data.data1);
140 CREATE VIEW view_raw_contacts AS SELECT raw_contacts._id AS _id,contact_id, aggregation_mode, raw_contact_is_read_only, deleted, raw_contacts.metadata_dirty, display_name_source, display_name, display_name_alt, phonetic_name, phonetic_name_style, sort_key, phonebook_label, phonebook_bucket, sort_key_alt, phonebook_label_alt, phonebook_bucket_alt, 0 AS raw_contact_is_user_profile, custom_ringtone,send_to_voicemail,last_time_contacted,times_contacted,starred,pinned, raw_contacts.account_id,accounts.account_name AS account_name,accounts.account_type AS account_type,accounts.data_set AS data_set,(CASE WHEN accounts.data_set IS NULL THEN accounts.account_type ELSE accounts.account_type||'/'||accounts.data_set END) AS account_type_and_data_set,raw_contacts.sourceid AS sourceid,raw_contacts.backup_id AS backup_id,raw_contacts.version AS version,raw_contacts.dirty AS dirty,raw_contacts.sync1 AS sync1,raw_contacts.sync2 AS sync2,raw_contacts.sync3 AS sync3,raw_contacts.sync4 AS sync4 FROM raw_contacts JOIN accounts ON (raw_contacts.account_id=accounts._id);
141 CREATE VIEW view_contacts AS SELECT contacts._id AS _id,contacts.custom_ringtone AS custom_ringtone, name_raw_contact.display_name_source AS display_name_source, name_raw_contact.display_name AS display_name, name_raw_contact.display_name_alt AS display_name_alt, name_raw_contact.phonetic_name AS phonetic_name, name_raw_contact.phonetic_name_style AS phonetic_name_style, name_raw_contact.sort_key AS sort_key, name_raw_contact.phonebook_label AS phonebook_label, name_raw_contact.phonebook_bucket AS phonebook_bucket, name_raw_contact.sort_key_alt AS sort_key_alt, name_raw_contact.phonebook_label_alt AS phonebook_label_alt, name_raw_contact.phonebook_bucket_alt AS phonebook_bucket_alt, has_phone_number, name_raw_contact_id, lookup, photo_id, photo_file_id, CAST(EXISTS (SELECT _id FROM visible_contacts WHERE contacts._id=visible_contacts._id) AS INTEGER) AS in_visible_group, CAST(EXISTS (SELECT _id FROM default_directory WHERE contacts._id=default_directory._id) AS INTEGER) AS in_default_directory, status_update_id, contacts.contact_last_updated_timestamp, contacts.last_time_contacted AS last_time_contacted, contacts.send_to_voicemail AS send_to_voicemail, contacts.starred AS starred, contacts.pinned AS pinned, contacts.times_contacted AS times_contacted, (CASE WHEN photo_file_id IS NULL THEN (CASE WHEN photo_id IS NULL OR photo_id=0 THEN NULL ELSE 'content://com.android.contacts/contacts/'||contacts._id|| '/photo' END) ELSE 'content://com.android.contacts/display_photo/'||photo_file_id END) AS photo_uri, (CASE WHEN photo_id IS NULL OR photo_id=0 THEN NULL ELSE 'content://com.android.contacts/contacts/'||contacts._id|| '/photo' END) AS photo_thumb_uri, 0 AS is_user_profile FROM contacts JOIN raw_contacts AS name_raw_contact ON(name_raw_contact_id=name_raw_contact._id);
142 CREATE VIEW view_raw_entities AS SELECT contact_id, raw_contacts.deleted AS deleted,raw_contacts.metadata_dirty, is_primary, is_super_primary, data_version, data.package_id,package AS res_package,data.mimetype_id,mimetype AS mimetype, is_read_only, data1, data2, data3, data4, data5, data6, data7, data8, data9, data10, data11, data12, data13, data14, data15, carrier_presence, data_sync1, data_sync2, data_sync3, data_sync4, raw_contacts.account_id,accounts.account_name AS account_name,accounts.account_type AS account_type,accounts.data_set AS data_set,(CASE WHEN accounts.data_set IS NULL THEN accounts.account_type ELSE accounts.account_type||'/'||accounts.data_set END) AS account_type_and_data_set,raw_contacts.sourceid AS sourceid,raw_contacts.backup_id AS backup_id,raw_contacts.version AS version,raw_contacts.dirty AS dirty,raw_contacts.sync1 AS sync1,raw_contacts.sync2 AS sync2,raw_contacts.sync3 AS sync3,raw_contacts.sync4 AS sync4, data_sync1, data_sync2, data_sync3, data_sync4, raw_contacts._id AS _id, data._id AS data_id,raw_contacts.starred AS starred,0 AS raw_contact_is_user_profile,groups.sourceid AS group_sourceid FROM raw_contacts JOIN accounts ON (raw_contacts.account_id=accounts._id) LEFT OUTER JOIN data ON (data.raw_contact_id=raw_contacts._id) LEFT OUTER JOIN packages ON (data.package_id=packages._id) LEFT OUTER JOIN mimetypes ON (data.mimetype_id=mimetypes._id) LEFT OUTER JOIN groups ON (mimetypes.mimetype='vnd.android.cursor.item/group_membership' AND groups._id=data.data1);
143 CREATE VIEW view_entities AS SELECT raw_contacts.contact_id AS _id, raw_contacts.contact_id AS contact_id, raw_contacts.deleted AS deleted,raw_contacts.metadata_dirty, is_primary, is_super_primary, data_version, data.package_id,package AS res_package,data.mimetype_id,mimetype AS mimetype, is_read_only, data1, data2, data3, data4, data5, data6, data7, data8, data9, data10, data11, data12, data13, data14, data15, carrier_presence, data_sync1, data_sync2, data_sync3, data_sync4, raw_contacts.account_id,accounts.account_name AS account_name,accounts.account_type AS account_type,accounts.data_set AS data_set,(CASE WHEN accounts.data_set IS NULL THEN accounts.account_type ELSE accounts.account_type||'/'||accounts.data_set END) AS account_type_and_data_set,raw_contacts.sourceid AS sourceid,raw_contacts.backup_id AS backup_id,raw_contacts.version AS version,raw_contacts.dirty AS dirty,raw_contacts.sync1 AS sync1,raw_contacts.sync2 AS sync2,raw_contacts.sync3 AS sync3,raw_contacts.sync4 AS sync4, contacts.custom_ringtone AS custom_ringtone, name_raw_contact.display_name_source AS display_name_source, name_raw_contact.display_name AS display_name, name_raw_contact.display_name_alt AS display_name_alt, name_raw_contact.phonetic_name AS phonetic_name, name_raw_contact.phonetic_name_style AS phonetic_name_style, name_raw_contact.sort_key AS sort_key, name_raw_contact.phonebook_label AS phonebook_label, name_raw_contact.phonebook_bucket AS phonebook_bucket, name_raw_contact.sort_key_alt AS sort_key_alt, name_raw_contact.phonebook_label_alt AS phonebook_label_alt, name_raw_contact.phonebook_bucket_alt AS phonebook_bucket_alt, has_phone_number, name_raw_contact_id, lookup, photo_id, photo_file_id, CAST(EXISTS (SELECT _id FROM visible_contacts WHERE contacts._id=visible_contacts._id) AS INTEGER) AS in_visible_group (…)
[all...] |
| /external/apache-xml/src/main/java/org/apache/xpath/ |
| CachedXPathAPI.java | 111 * Use an XPath string to select a single node. XPath namespace
128 * Use an XPath string to select a single node.
151 * Use an XPath string to select a nodelist.
167 * Use an XPath string to select a nodelist.
190 * Use an XPath string to select a nodelist.
206 * Use an XPath string to select a nodelist.
288 XPath xpath = new XPath(str, null, prefixResolver, XPath.SELECT, null);
329 XPath xpath = new XPath(str, null, prefixResolver, XPath.SELECT, null);
|
| XPathAPI.java | 56 * Use an XPath string to select a single node. XPath namespace
73 * Use an XPath string to select a single node.
96 * Use an XPath string to select a nodelist.
112 * Use an XPath string to select a nodelist.
135 * Use an XPath string to select a nodelist.
151 * Use an XPath string to select a nodelist.
236 XPath xpath = new XPath(str, null, prefixResolver, XPath.SELECT, null);
277 XPath xpath = new XPath(str, null, prefixResolver, XPath.SELECT, null);
|
| /frameworks/support/room/compiler/src/main/kotlin/androidx/room/processor/ |
| QueryMethodProcessor.kt | 108 context.checker.check(resultBinder.adapter != null || query.type != QueryType.SELECT,
111 context.checker.check(query.type == QueryType.SELECT, executableElement,
116 QueryType.SELECT -> executableElement.hasAnnotation(Transaction::class)
120 if (query.type == QueryType.SELECT && !inTransaction) {
|
| /external/apache-xml/src/main/java/org/apache/xalan/templates/ |
| AVTPartXPath.java | 104 m_xpath = new XPath(val, null, nsNode, XPath.SELECT, liaison.getErrorListener());
|
| /frameworks/support/room/integration-tests/testapp/src/androidTest/java/androidx/room/integration/testapp/test/ |
| CollationTest.java | 171 @Query("SELECT * FROM CollateEntity ORDER BY localizedName ASC")
174 @Query("SELECT * FROM CollateEntity ORDER BY localizedName COLLATE UNICODE ASC")
177 @Query("SELECT * FROM CollateEntity ORDER BY unicodeName ASC")
180 @Query("SELECT * FROM CollateEntity ORDER BY unicodeName COLLATE LOCALIZED ASC")
|
| /external/ltp/testcases/network/nfsv4/locks/ |
| locktests.h | 56 #include <sys/select.h>
110 SELECT,
|
| /prebuilts/go/darwin-x86/src/database/sql/ |
| example_test.go | 17 rows, err := db.Query("SELECT name FROM users WHERE age=?", age)
37 err := db.QueryRow("SELECT username FROM users WHERE id=?", id).Scan(&username)
53 select id from users where age < ?; -- Populate temp table.
56 select
64 select
|
| /prebuilts/go/linux-x86/src/database/sql/ |
| example_test.go | 17 rows, err := db.Query("SELECT name FROM users WHERE age=?", age)
37 err := db.QueryRow("SELECT username FROM users WHERE id=?", id).Scan(&username)
53 select id from users where age < ?; -- Populate temp table.
56 select
64 select
|
| /prebuilts/gdb/darwin-x86/lib/python2.7/sqlite3/test/ |
| regression.py | 61 cursors[i].execute(" " * i + "select x from test")
67 cur.execute('select 1 as "foo bar [datetime]"')
70 cur.execute('select 1 as "foo baz"')
84 cur.execute("select 1 x union select " + str(i))
136 SELECT = "select * from foo"
140 con.execute(SELECT)
144 con.execute(SELECT)
171 cur.execute("select 4+5").fetchall(
[all...] |
| /prebuilts/gdb/linux-x86/lib/python2.7/sqlite3/test/ |
| regression.py | 61 cursors[i].execute(" " * i + "select x from test")
67 cur.execute('select 1 as "foo bar [datetime]"')
70 cur.execute('select 1 as "foo baz"')
84 cur.execute("select 1 x union select " + str(i))
136 SELECT = "select * from foo"
140 con.execute(SELECT)
144 con.execute(SELECT)
171 cur.execute("select 4+5").fetchall(
[all...] |
| /prebuilts/python/darwin-x86/2.7.5/lib/python2.7/sqlite3/test/ |
| regression.py | 61 cursors[i].execute(" " * i + "select x from test")
67 cur.execute('select 1 as "foo bar [datetime]"')
70 cur.execute('select 1 as "foo baz"')
84 cur.execute("select 1 x union select " + str(i))
136 SELECT = "select * from foo"
140 con.execute(SELECT)
144 con.execute(SELECT)
171 cur.execute("select 4+5").fetchall(
[all...] |
| /prebuilts/python/linux-x86/2.7.5/lib/python2.7/sqlite3/test/ |
| regression.py | 61 cursors[i].execute(" " * i + "select x from test")
67 cur.execute('select 1 as "foo bar [datetime]"')
70 cur.execute('select 1 as "foo baz"')
84 cur.execute("select 1 x union select " + str(i))
136 SELECT = "select * from foo"
140 con.execute(SELECT)
144 con.execute(SELECT)
171 cur.execute("select 4+5").fetchall(
[all...] |
| /packages/providers/ContactsProvider/tests/assets/testUnsynced/ |
| legacy_contacts.sql | 91 CREATE TRIGGER contact_methods_INSERT_typeAndLabel AFTER INSERT ON contact_methods WHEN (NEW.type != 0 AND NEW.label IS NOT NULL) OR (NEW.type = 0 AND NEW.label IS NULL) BEGIN SELECT RAISE (ABORT, 'exactly one of type or label must be set'); END;
92 CREATE TRIGGER contact_methods_UPDATE_typeAndLabel AFTER UPDATE ON contact_methods WHEN (NEW.type != 0 AND NEW.label IS NOT NULL) OR (NEW.type = 0 AND NEW.label IS NULL) BEGIN SELECT RAISE (ABORT, 'exactly one of type or label must be set'); END;
104 CREATE TRIGGER organizations_INSERT_typeAndLabel AFTER INSERT ON organizations WHEN (NEW.type != 0 AND NEW.label IS NOT NULL) OR (NEW.type = 0 AND NEW.label IS NULL) BEGIN SELECT RAISE (ABORT, 'exactly one of type or label must be set'); END;
105 CREATE TRIGGER organizations_UPDATE_typeAndLabel AFTER UPDATE ON organizations WHEN (NEW.type != 0 AND NEW.label IS NOT NULL) OR (NEW.type = 0 AND NEW.label IS NULL) BEGIN SELECT RAISE (ABORT, 'exactly one of type or label must be set'); END;
110 CREATE TRIGGER peopleLookupWithPhoneticName_insert AFTER INSERT ON people BEGIN SELECT _TOKENIZE('peopleLookupWithPhoneticName', new._id, GET_NORMALIZED_STRING(CASE WHEN (new.phonetic_name IS NOT NULL AND new.phonetic_name != '') THEN new.phonetic_name ELSE (CASE WHEN (new.name is NOT NULL AND new.name != '') THEN new.name ELSE '' END) END), ' ', 1);END;
111 CREATE TRIGGER peopleLookupWithPhoneticName_update UPDATE OF name, phonetic_name ON people BEGIN DELETE FROM peopleLookupWithPhoneticName WHERE source = new._id;SELECT _TOKENIZE('peopleLookupWithPhoneticName', new._id, GET_NORMALIZED_STRING(CASE WHEN (new.phonetic_name IS NOT NULL AND new.phonetic_name != '') THEN new.phonetic_name ELSE (CASE WHEN (new.name is NOT NULL AND new.name != '') THEN new.name ELSE '' END) END), ' ', 1);END;
112 CREATE TRIGGER peopleLookup_insert AFTER INSERT ON people BEGIN SELECT _TOKENIZE('peopleLookup', new._id, new.name, ' ', 1);END;
113 CREATE TRIGGER peopleLookup_update UPDATE OF name ON people BEGIN DELETE FROM peopleLookup WHERE source = new._id;SELECT _TOKENIZE('peopleLookup', new._id, new.name, ' ', 1);END;
115 CREATE TRIGGER phones_INSERT_typeAndLabel AFTER INSERT ON phones WHEN (NEW.type != 0 AND NEW.label IS NOT NULL) OR (NEW.type = 0 AND NEW.label IS NULL) BEGIN SELECT RAISE (ABORT, 'exactly one of type or label must be set'); END;
116 CREATE TRIGGER phones_UPDATE_typeAndLabel AFTER UPDATE ON phones WHEN (NEW.type != 0 AND NEW.label IS NOT NULL) OR (NEW.type = 0 AND NEW.label IS NULL) BEGIN SELECT RAISE (ABORT, 'exactly one of type or label must be set'); END
[all...] |
