Home
last modified time | relevance | path

Searched refs:sql (Results 1 – 25 of 57) sorted by relevance

123

/third_party/boost/libs/geometry/example/with_external_libs/
Dx03_d_soci_example.cpp44 soci::session sql(soci::postgresql, "dbname=ggl user=ggl password=ggl"); in main() local
47 sql << "DELETE FROM geometry_columns WHERE f_table_name = 'parcels'"; in main()
48 sql << "DROP TABLE IF EXISTS parcels CASCADE"; in main()
49 sql << "CREATE TABLE parcels (id INTEGER)"; in main()
50 sql << "SELECT AddGeometryColumn('parcels', 'geom', -1, 'GEOMETRY', 2)"; in main()
53sql << "INSERT INTO parcels VALUES(1, ST_GeomFromText('POLYGON ((10 10, 10 20, 20 20, 20 15, 10 10… in main()
54sql << "INSERT INTO parcels VALUES(2, ST_GeomFromText('POLYGON ((0 0, 4 0, 4 4, 0 4, 0 0))', -1))"; in main()
55sql << "INSERT INTO parcels VALUES(3, ST_GeomFromText('POLYGON((1 1,2 1,2 2,1 2,1 1))', -1))"; in main()
58 …soci::rowset<std::string> rows = (sql.prepare << "SELECT encode(ST_AsBinary(geom), 'hex') AS wkb F… in main()
Dx03_c_soci_example.cpp86 soci::session sql(soci::postgresql, "dbname=ggl user=ggl password=ggl"); in main() local
89 sql << "DELETE FROM geometry_columns WHERE f_table_name = 'trees'"; in main()
90 sql << "DROP TABLE IF EXISTS trees CASCADE"; in main()
91 sql << "CREATE TABLE trees (id INTEGER)"; in main()
92 sql << "SELECT AddGeometryColumn('trees', 'geom', -1, 'POINT', 2)"; in main()
95 sql << "INSERT INTO trees VALUES(1, ST_GeomFromText('POINT(1.23 2.34)', -1))"; in main()
96 sql << "INSERT INTO trees VALUES(2, ST_GeomFromText('POINT(3.45 4.56)', -1))"; in main()
97 sql << "INSERT INTO trees VALUES(3, ST_GeomFromText('POINT(5.67 6.78)', -1))"; in main()
98 sql << "INSERT INTO trees VALUES(4, ST_GeomFromText('POINT(7.89 9.01)', -1))"; in main()
102 …soci::rowset<tree> rows = (sql.prepare << "SELECT id, encode(ST_AsBinary(geom), 'hex') AS wkb FROM… in main()
Dx03_a_soci_example.cpp47 soci::session sql(soci::postgresql, "dbname=ggl user=ggl password=ggl"); in main() local
50 sql << "select count(*) from cities", soci::into(count); in main()
56 = sql.prepare << "select x(location),y(location) from cities"; in main()
Dx03_b_soci_example.cpp77 soci::session sql(soci::postgresql, "dbname=ggl user=ggl password=ggl"); in main() local
82 soci::rowset<city> rows = sql.prepare << "select name,astext(location) as wkt from cities"; in main()
/third_party/libwebsockets/lib/misc/
Dlws-struct-sqlite.c250 char *sql; in _lws_struct_sq3_ser_one() local
325 sql = malloc(sql_est); in _lws_struct_sq3_ser_one()
326 if (!sql) in _lws_struct_sq3_ser_one()
329 m = lws_snprintf(sql, sql_est, "insert into %s(_lws_idx, ", in _lws_struct_sq3_ser_one()
348 m += lws_snprintf(sql + m, sql_est - (unsigned int)m, in _lws_struct_sq3_ser_one()
353 m += lws_snprintf(sql + m, sql_est - (unsigned int)m, ") values(%u, ", idx); in _lws_struct_sq3_ser_one()
377 m += lws_snprintf(sql + m, sql_est - (unsigned int)m, "%lld", in _lws_struct_sq3_ser_one()
380 m += lws_snprintf(sql + m, sql_est - (unsigned int)m, "%llu", in _lws_struct_sq3_ser_one()
385 sql[m++] = '\''; in _lws_struct_sq3_ser_one()
386 lws_sql_purify(sql + m, (const char *)&stb[map[n].ofs], in _lws_struct_sq3_ser_one()
[all …]
/third_party/mindspore/mindspore/ccsrc/minddata/mindrecord/io/
Dshard_index_generator.cc129 Status ShardIndexGenerator::ExecuteSQL(const std::string &sql, sqlite3 *db, const std::string &succ… in ExecuteSQL() argument
131 int rc = sqlite3_exec(db, common::SafeCStr(sql), Callback, nullptr, &z_err_msg); in ExecuteSQL()
196 std::string sql = "DROP TABLE IF EXISTS SHARD_NAME;"; in CreateShardNameTable() local
197 RETURN_IF_NOT_OK(ExecuteSQL(sql, db, "drop table successfully.")); in CreateShardNameTable()
198 sql = "CREATE TABLE SHARD_NAME(NAME TEXT NOT NULL);"; in CreateShardNameTable()
199 RETURN_IF_NOT_OK(ExecuteSQL(sql, db, "create table successfully.")); in CreateShardNameTable()
200 sql = "INSERT INTO SHARD_NAME (NAME) VALUES (:SHARD_NAME);"; in CreateShardNameTable()
202 if (sqlite3_prepare_v2(db, common::SafeCStr(sql), -1, &stmt, 0) != SQLITE_OK) { in CreateShardNameTable()
207 RETURN_STATUS_UNEXPECTED("SQL error: could not prepare statement, sql: " + sql); in CreateShardNameTable()
233 std::string sql = "DROP TABLE IF EXISTS INDEXES;"; in CreateDatabase() local
[all …]
Dshard_reader.cc143 string sql = "SELECT NAME from SHARD_NAME;"; in VerifyDataset() local
146 if (sqlite3_exec(*db, common::SafeCStr(sql), SelectCallback, &name, &errmsg) != SQLITE_OK) { in VerifyDataset()
148 oss << "Failed to execute sql [ " << sql + " ], " << errmsg; in VerifyDataset()
407 Status ShardReader::ReadAllRowsInShard(int shard_id, const std::string &sql, const std::vector<std:… in ReadAllRowsInShard() argument
413 int rc = sqlite3_exec(db, common::SafeCStr(sql), SelectCallback, &labels, &errmsg); in ReadAllRowsInShard()
416 oss << "Failed to execute sql [ " << sql + " ], " << errmsg; in ReadAllRowsInShard()
457 std::string sql = "SELECT DISTINCT " + *fn_ptr + " FROM INDEXES"; in GetAllClasses() local
460 …threads[x] = std::thread(&ShardReader::GetClassesInShard, this, database_paths_[x], x, sql, catego… in GetAllClasses()
469 void ShardReader::GetClassesInShard(sqlite3 *db, int shard_id, const std::string &sql, in GetClassesInShard() argument
476 int ret = sqlite3_exec(db, common::SafeCStr(sql), SelectCallback, &columns, &errmsg); in GetClassesInShard()
[all …]
Dshard_segment.cc41 std::string sql = "PRAGMA table_info(INDEXES);"; in GetCategoryFields() local
45 …int rc = sqlite3_exec(database_paths_[0], common::SafeCStr(sql), SelectCallback, &field_names, &er… in GetCategoryFields()
48 oss << "Failed to execute sql [ " << common::SafeCStr(sql) << " ], " << errmsg; in GetCategoryFields()
101 std::string sql = "SELECT " + current_category_field_ + ", COUNT(" + current_category_field_ + in WrapCategoryInfo() local
108 … if (sqlite3_exec(db, common::SafeCStr(sql), SelectCallback, &field_count, &errmsg) != SQLITE_OK) { in WrapCategoryInfo()
110 oss << "Failed to execute sql [ " << common::SafeCStr(sql) << " ], " << errmsg; in WrapCategoryInfo()
/third_party/python/Modules/_sqlite/clinic/
Dcursor.c.h43 pysqlite_cursor_execute_impl(pysqlite_Cursor *self, PyObject *sql,
50 PyObject *sql; in pysqlite_cursor_execute() local
63 sql = args[0]; in pysqlite_cursor_execute()
69 return_value = pysqlite_cursor_execute_impl(self, sql, parameters); in pysqlite_cursor_execute()
85 pysqlite_cursor_executemany_impl(pysqlite_Cursor *self, PyObject *sql,
92 PyObject *sql; in pysqlite_cursor_executemany() local
105 sql = args[0]; in pysqlite_cursor_executemany()
107 return_value = pysqlite_cursor_executemany_impl(self, sql, seq_of_parameters); in pysqlite_cursor_executemany()
Dconnection.c.h404 pysqlite_connection_execute_impl(pysqlite_Connection *self, PyObject *sql,
411 PyObject *sql; in pysqlite_connection_execute() local
424 sql = args[0]; in pysqlite_connection_execute()
430 return_value = pysqlite_connection_execute_impl(self, sql, parameters); in pysqlite_connection_execute()
447 PyObject *sql, PyObject *parameters);
453 PyObject *sql; in pysqlite_connection_executemany() local
466 sql = args[0]; in pysqlite_connection_executemany()
468 return_value = pysqlite_connection_executemany_impl(self, sql, parameters); in pysqlite_connection_executemany()
/third_party/python/Lib/sqlite3/
Ddump.py31 for table_name, type, sql in schema_res.fetchall():
46 yield('{0};'.format(sql))
67 for name, type, sql in schema_res.fetchall():
68 yield('{0};'.format(sql))
/third_party/libsnd/regtest/
Ddatabase.c45 { sqlite3 *sql ; member
96 if ((err = sqlite3_open (db_name, &(db->sql))) != 0) in db_open()
97 { printf ("Can't open database: %s\n", sqlite3_errmsg (db->sql)) ; in db_open()
98 sqlite3_close (db->sql) ; in db_open()
126 err = sqlite3_exec (db->sql, cmd, callback, 0, &errmsg) ; in db_create()
130 sqlite3_close (db->sql) ; in db_create()
142 sqlite3_close (db->sql) ; in db_close()
164 err = sqlite3_exec (db->sql, db->cmdbuf, (sqlite3_callback) count_callback, db, &errmsg) ; in db_file_exists()
212 err = sqlite3_exec (db->sql, db->cmdbuf, callback, 0, &errmsg) ; in db_add_file()
253 err = sqlite3_exec (db->sql, db->cmdbuf, (sqlite3_callback) ekey_max_callback, db, &errmsg) ; in db_check_all()
[all …]
/third_party/ltp/tools/sparse/sparse-src/
Dsemind.c464 static inline void sqlite_prepare(const char *sql, sqlite3_stmt **stmt) in sqlite_prepare() argument
468 ret = sqlite3_prepare_v2(semind_db, sql, -1, stmt, NULL); in sqlite_prepare()
470 semind_error(1, 0, "unable to prepare query: %s: %s", sqlite3_errmsg(semind_db), sql); in sqlite_prepare()
474 static inline void sqlite_prepare_persistent(const char *sql, sqlite3_stmt **stmt) in sqlite_prepare_persistent() argument
478 ret = sqlite3_prepare_v3(semind_db, sql, -1, SQLITE_PREPARE_PERSISTENT, stmt, NULL); in sqlite_prepare_persistent()
480 semind_error(1, 0, "unable to prepare query: %s: %s", sqlite3_errmsg(semind_db), sql); in sqlite_prepare_persistent()
501 static void sqlite_command(const char *sql) in sqlite_command() argument
504 sqlite_prepare(sql, &stmt); in sqlite_command()
524 char *sql; in set_db_version() local
530 sql = sqlite3_str_finish(query); in set_db_version()
[all …]
/third_party/python/Modules/_sqlite/
Dstatement.c52 pysqlite_statement_create(pysqlite_Connection *connection, PyObject *sql) in pysqlite_statement_create() argument
60 assert(PyUnicode_Check(sql)); in pysqlite_statement_create()
62 sql_cstr = PyUnicode_AsUTF8AndSize(sql, &sql_cstr_len); in pysqlite_statement_create()
66 Py_TYPE(sql)->tp_name); in pysqlite_statement_create()
83 self->sql = Py_NewRef(sql); in pysqlite_statement_create()
414 Py_CLEAR(self->sql); in stmt_clear()
422 Py_VISIT(self->sql); in stmt_traverse()
Dstatement.h37 PyObject* sql; member
45 pysqlite_Statement *pysqlite_statement_create(pysqlite_Connection *connection, PyObject *sql);
Dconnection.c1372 PyObject* sql; in pysqlite_connection_call() local
1383 if (!PyArg_ParseTuple(args, "U", &sql)) in pysqlite_connection_call()
1388 statement = pysqlite_statement_create(self, sql); in pysqlite_connection_call()
1420 pysqlite_connection_execute_impl(pysqlite_Connection *self, PyObject *sql, in pysqlite_connection_execute_impl() argument
1433 result = _PyObject_CallMethodIdObjArgs(cursor, &PyId_execute, sql, parameters, NULL); in pysqlite_connection_execute_impl()
1456 PyObject *sql, PyObject *parameters) in pysqlite_connection_executemany_impl() argument
1468 result = _PyObject_CallMethodIdObjArgs(cursor, &PyId_executemany, sql, in pysqlite_connection_executemany_impl()
/third_party/wpa_supplicant/wpa_supplicant-2.9/src/radius/
Dradius_server.c404 const char *sql = in db_table_create_sim_provisioning() local
414 if (sqlite3_exec(db, sql, NULL, NULL, &err) != SQLITE_OK) { in db_table_create_sim_provisioning()
451 char *sql; in srv_log() local
452 sql = sqlite3_mprintf("INSERT INTO authlog" in srv_log()
459 if (sql) { in srv_log()
460 if (sqlite3_exec(sess->server->db, sql, NULL, NULL, in srv_log()
465 sqlite3_free(sql); in srv_log()
835 char *sql; in radius_srv_hs20_t_c_pending() local
855 sql = sqlite3_mprintf("INSERT OR REPLACE INTO pending_tc (mac_addr,identity) VALUES (%Q,%Q)", in radius_srv_hs20_t_c_pending()
858 if (!sql) in radius_srv_hs20_t_c_pending()
[all …]
/third_party/wpa_supplicant/wpa_supplicant-2.9_standard/src/radius/
Dradius_server.c261 const char *sql = in db_table_create_sim_provisioning() local
271 if (sqlite3_exec(db, sql, NULL, NULL, &err) != SQLITE_OK) { in db_table_create_sim_provisioning()
308 char *sql; in srv_log() local
309 sql = sqlite3_mprintf("INSERT INTO authlog" in srv_log()
316 if (sql) { in srv_log()
317 if (sqlite3_exec(sess->server->db, sql, NULL, NULL, in srv_log()
322 sqlite3_free(sql); in srv_log()
668 char *sql; in radius_srv_hs20_t_c_pending() local
688 sql = sqlite3_mprintf("INSERT OR REPLACE INTO pending_tc (mac_addr,identity) VALUES (%Q,%Q)", in radius_srv_hs20_t_c_pending()
691 if (!sql) in radius_srv_hs20_t_c_pending()
[all …]
/third_party/python/Lib/sqlite3/test/
Dhooks.py70 sql = """
79 result = con.execute(sql).fetchall()
85 result = con.execute(sql).fetchall()
94 sql = """
103 result = con.execute(sql).fetchall()
/third_party/python/PC/clinic/
D_msi.c.h552 _msi_Database_OpenView_impl(msiobj *self, const Py_UNICODE *sql);
558 const Py_UNICODE *sql; in _msi_Database_OpenView() local
565 sql = _PyUnicode_AsUnicode(arg); in _msi_Database_OpenView()
567 sql = PyUnicode_AsWideCharString(arg, NULL); in _msi_Database_OpenView()
569 if (sql == NULL) { in _msi_Database_OpenView()
572 return_value = _msi_Database_OpenView_impl(self, sql); in _msi_Database_OpenView()
577 PyMem_Free((void *)sql); in _msi_Database_OpenView()
/third_party/mindspore/mindspore/ccsrc/minddata/mindrecord/include/
Dshard_reader.h220 …Status ReadAllRowsInShard(int shard_id, const std::string &sql, const std::vector<std::string> &co…
241 Status QueryWithCriteria(sqlite3 *db, const string &sql, const string &criteria,
285 void GetClassesInShard(sqlite3 *db, int shard_id, const std::string &sql,
/third_party/libsoup/libsoup/
Dsoup-cookie-jar-db.c211 const char *sql, in exec_query_with_try_create_table() argument
219 if (sqlite3_exec (db, sql, callback, argument, &error)) { in exec_query_with_try_create_table()
Dsoup-hsts-enforcer-db.c194 const char *sql, in exec_query_with_try_create_table() argument
202 if (sqlite3_exec (db, sql, callback, argument, &error)) { in exec_query_with_try_create_table()
/third_party/skia/platform_tools/android/apps/skottie/
Drun_perf.sh55 ./trace_processor --run-metrics=skottie_metric.sql --metrics-output=json trace > out/data_${rendere…
/third_party/node/deps/npm/node_modules/color-name/
D.npmignore33 *.sql

123