| /dports/databases/py-mysql-connector-python/mysql-connector-python-8.0.27/examples/ |
| H A D | transaction.py | 78 stmt_insert = "INSERT INTO names (name) VALUES (%s)"
79 cursor.executemany(stmt_insert, names)
104 cursor.executemany(stmt_insert, names)
|
| H A D | unicode.py | 71 stmt_insert = "INSERT INTO unicode (str) VALUES (%s)"
72 cursor.execute(stmt_insert, (unistr,))
|
| H A D | inserts.py | 66 stmt_insert = "INSERT INTO names (name, info, age) VALUES (%s, %s, %s)"
67 cur.executemany(stmt_insert, names)
|
| H A D | dates.py | 82 stmt_insert = ("INSERT INTO {0} (c1,c2,c3) VALUES "
86 cursor.execute(stmt_insert, data)
|
| /dports/sysutils/fluent-bit/fluent-bit-1.8.11/plugins/filter_checklist/ |
| H A D | checklist.c | 64 &ctx->stmt_insert,
90 sqlite3_bind_text(ctx->stmt_insert, 1, buf, len, 0);
93 ret = sqlite3_step(ctx->stmt_insert);
95 sqlite3_clear_bindings(ctx->stmt_insert);
96 sqlite3_reset(ctx->stmt_insert);
101 sqlite3_clear_bindings(ctx->stmt_insert);
102 sqlite3_reset(ctx->stmt_insert);
524 sqlite3_finalize(ctx->stmt_insert);
|
| H A D | checklist.h | 46 sqlite3_stmt *stmt_insert; member
|
| /dports/mail/bogofilter/bogofilter-1.2.5/src/ |
| H A D | datastore_sqlite.c | 30 sqlite3_stmt *stmt_insert; /**< prepared INSERT OR REPLACE for DB update */ member
432 if (dbh->stmt_insert) sqlite3_finalize(dbh->stmt_insert); in db_close()
523 if (!dbh->stmt_insert) in db_set_dbvalue()
524 dbh->stmt_insert = sqlprep(dbh, "INSERT OR REPLACE INTO bogofilter VALUES(?,?);", true); in db_set_dbvalue()
526 sqlite3_bind_blob(dbh->stmt_insert, 1, key->data, key->leng, SQLITE_STATIC); in db_set_dbvalue()
527 sqlite3_bind_blob(dbh->stmt_insert, 2, val->data, val->leng, SQLITE_STATIC); in db_set_dbvalue()
528 return sql_fastpath(dbh, "db_set_dbvalue", dbh->stmt_insert, NULL, 0); in db_set_dbvalue()
|
| /dports/mail/bogofilter-lmdb/bogofilter-1.2.5/src/ |
| H A D | datastore_sqlite.c | 30 sqlite3_stmt *stmt_insert; /**< prepared INSERT OR REPLACE for DB update */ member
432 if (dbh->stmt_insert) sqlite3_finalize(dbh->stmt_insert); in db_close()
523 if (!dbh->stmt_insert) in db_set_dbvalue()
524 dbh->stmt_insert = sqlprep(dbh, "INSERT OR REPLACE INTO bogofilter VALUES(?,?);", true); in db_set_dbvalue()
526 sqlite3_bind_blob(dbh->stmt_insert, 1, key->data, key->leng, SQLITE_STATIC); in db_set_dbvalue()
527 sqlite3_bind_blob(dbh->stmt_insert, 2, val->data, val->leng, SQLITE_STATIC); in db_set_dbvalue()
528 return sql_fastpath(dbh, "db_set_dbvalue", dbh->stmt_insert, NULL, 0); in db_set_dbvalue()
|
| /dports/mail/bogofilter-sqlite/bogofilter-1.2.5/src/ |
| H A D | datastore_sqlite.c | 30 sqlite3_stmt *stmt_insert; /**< prepared INSERT OR REPLACE for DB update */ member
432 if (dbh->stmt_insert) sqlite3_finalize(dbh->stmt_insert); in db_close()
523 if (!dbh->stmt_insert) in db_set_dbvalue()
524 dbh->stmt_insert = sqlprep(dbh, "INSERT OR REPLACE INTO bogofilter VALUES(?,?);", true); in db_set_dbvalue()
526 sqlite3_bind_blob(dbh->stmt_insert, 1, key->data, key->leng, SQLITE_STATIC); in db_set_dbvalue()
527 sqlite3_bind_blob(dbh->stmt_insert, 2, val->data, val->leng, SQLITE_STATIC); in db_set_dbvalue()
528 return sql_fastpath(dbh, "db_set_dbvalue", dbh->stmt_insert, NULL, 0); in db_set_dbvalue()
|
| /dports/mail/bogofilter-kc/bogofilter-1.2.5/src/ |
| H A D | datastore_sqlite.c | 30 sqlite3_stmt *stmt_insert; /**< prepared INSERT OR REPLACE for DB update */ member
432 if (dbh->stmt_insert) sqlite3_finalize(dbh->stmt_insert); in db_close()
523 if (!dbh->stmt_insert) in db_set_dbvalue()
524 dbh->stmt_insert = sqlprep(dbh, "INSERT OR REPLACE INTO bogofilter VALUES(?,?);", true); in db_set_dbvalue()
526 sqlite3_bind_blob(dbh->stmt_insert, 1, key->data, key->leng, SQLITE_STATIC); in db_set_dbvalue()
527 sqlite3_bind_blob(dbh->stmt_insert, 2, val->data, val->leng, SQLITE_STATIC); in db_set_dbvalue()
528 return sql_fastpath(dbh, "db_set_dbvalue", dbh->stmt_insert, NULL, 0); in db_set_dbvalue()
|
| /dports/databases/py-mysql-connector-python/mysql-connector-python-8.0.27/tests/cext/ |
| H A D | test_cext_cursor.py | 139 stmt_insert = "INSERT INTO {0} (col1,col2) VALUES (%s,%s)".format(tbl)
140 res = cur.execute(stmt_insert, (1, 100))
185 stmt_insert = "INSERT INTO {0} (col1,col2) VALUES (%s,%s)".format(tbl)
190 res = cur.executemany(stmt_insert, [(1, 100), (2, 200), (3, 300)])
364 stmt_insert = (
374 cur.executemany(stmt_insert, data)
420 stmt_insert = (
433 cur.executemany(stmt_insert, data)
|
| /dports/databases/py-mysql-connector-python/mysql-connector-python-8.0.27/tests/ |
| H A D | test_cursor.py | 569 stmt_insert = "INSERT INTO {0} (col1,col2) VALUES (%s,%s)".format(tbl)
571 res = self.cur.execute(stmt_insert, (1, 100))
634 stmt_insert = "INSERT INTO {0} (col1,col2) VALUES (%s,%s)".format(tbl)
639 res = self.cur.executemany(stmt_insert, [(1, 100), (2, 200), (3, 300)])
847 stmt_insert = (
857 self.cur.executemany(stmt_insert, data)
884 stmt_insert = (
897 self.cur.executemany(stmt_insert, data)
1242 stmt_insert = "INSERT INTO {table} (col1,col2) VALUES (%s, %s)".format(
1247 cur.executemany(stmt_insert, [(1, 100), (2, 200), (3, 300)])
|
| H A D | test_pep249.py | 408 stmt_insert = (
426 cur1.execute(stmt_insert, data)
|
| /dports/games/freeminer/freeminer-0.4.10.4/src/ |
| H A D | rollback.h | 96 sqlite3_stmt * stmt_insert; variable
|
| H A D | rollback.cpp | 113 SQLOK(sqlite3_finalize(stmt_insert)); in ~RollbackManager()
283 -1, &stmt_insert, NULL)); in initDatabase()
384 sqlite3_stmt * stmt_do = (row.id) ? stmt_replace : stmt_insert; in registerRow()
|
| /dports/games/minetest/minetest-5.4.1/src/ |
| H A D | rollback.h | 92 sqlite3_stmt * stmt_insert; variable
|
| H A D | rollback.cpp | 119 FINALIZE_STATEMENT(stmt_insert); in ~RollbackManager()
288 -1, &stmt_insert, NULL)); in initDatabase()
391 sqlite3_stmt * stmt_do = (row.id) ? stmt_replace : stmt_insert; in registerRow()
|
| /dports/databases/mariadb105-client/mariadb-10.5.15/libmariadb/unittest/libmariadb/ |
| H A D | ps.c | 2611 MYSQL_STMT *stmt_insert, *stmt_select; in test_insert_select() local
2629 stmt_insert= mysql_stmt_init(mysql); in test_insert_select()
2630 FAIL_IF(!stmt_insert, mysql_error(mysql)); in test_insert_select()
2631 rc= mysql_stmt_prepare(stmt_insert, SL(query)); in test_insert_select()
2632 check_stmt_rc(rc, stmt_insert); in test_insert_select()
2642 rc= mysql_stmt_execute(stmt_insert); in test_insert_select()
2643 check_stmt_rc(rc, stmt_insert); in test_insert_select()
2653 mysql_stmt_close(stmt_insert); in test_insert_select()
|
| /dports/databases/mariadb104-server/mariadb-10.4.24/libmariadb/unittest/libmariadb/ |
| H A D | ps.c | 2611 MYSQL_STMT *stmt_insert, *stmt_select; in test_insert_select() local
2629 stmt_insert= mysql_stmt_init(mysql); in test_insert_select()
2630 FAIL_IF(!stmt_insert, mysql_error(mysql)); in test_insert_select()
2631 rc= mysql_stmt_prepare(stmt_insert, SL(query)); in test_insert_select()
2632 check_stmt_rc(rc, stmt_insert); in test_insert_select()
2642 rc= mysql_stmt_execute(stmt_insert); in test_insert_select()
2643 check_stmt_rc(rc, stmt_insert); in test_insert_select()
2653 mysql_stmt_close(stmt_insert); in test_insert_select()
|
| /dports/databases/mariadb104-client/mariadb-10.4.24/libmariadb/unittest/libmariadb/ |
| H A D | ps.c | 2611 MYSQL_STMT *stmt_insert, *stmt_select; in test_insert_select() local
2629 stmt_insert= mysql_stmt_init(mysql); in test_insert_select()
2630 FAIL_IF(!stmt_insert, mysql_error(mysql)); in test_insert_select()
2631 rc= mysql_stmt_prepare(stmt_insert, SL(query)); in test_insert_select()
2632 check_stmt_rc(rc, stmt_insert); in test_insert_select()
2642 rc= mysql_stmt_execute(stmt_insert); in test_insert_select()
2643 check_stmt_rc(rc, stmt_insert); in test_insert_select()
2653 mysql_stmt_close(stmt_insert); in test_insert_select()
|
| /dports/databases/mariadb105-server/mariadb-10.5.15/libmariadb/unittest/libmariadb/ |
| H A D | ps.c | 2611 MYSQL_STMT *stmt_insert, *stmt_select; in test_insert_select() local
2629 stmt_insert= mysql_stmt_init(mysql); in test_insert_select()
2630 FAIL_IF(!stmt_insert, mysql_error(mysql)); in test_insert_select()
2631 rc= mysql_stmt_prepare(stmt_insert, SL(query)); in test_insert_select()
2632 check_stmt_rc(rc, stmt_insert); in test_insert_select()
2642 rc= mysql_stmt_execute(stmt_insert); in test_insert_select()
2643 check_stmt_rc(rc, stmt_insert); in test_insert_select()
2653 mysql_stmt_close(stmt_insert); in test_insert_select()
|
| /dports/databases/mariadb103-server/mariadb-10.3.34/libmariadb/unittest/libmariadb/ |
| H A D | ps.c | 2611 MYSQL_STMT *stmt_insert, *stmt_select; in test_insert_select() local
2629 stmt_insert= mysql_stmt_init(mysql); in test_insert_select()
2630 FAIL_IF(!stmt_insert, mysql_error(mysql)); in test_insert_select()
2631 rc= mysql_stmt_prepare(stmt_insert, SL(query)); in test_insert_select()
2632 check_stmt_rc(rc, stmt_insert); in test_insert_select()
2642 rc= mysql_stmt_execute(stmt_insert); in test_insert_select()
2643 check_stmt_rc(rc, stmt_insert); in test_insert_select()
2653 mysql_stmt_close(stmt_insert); in test_insert_select()
|
| /dports/databases/mariadb103-client/mariadb-10.3.34/libmariadb/unittest/libmariadb/ |
| H A D | ps.c | 2611 MYSQL_STMT *stmt_insert, *stmt_select; in test_insert_select() local
2629 stmt_insert= mysql_stmt_init(mysql); in test_insert_select()
2630 FAIL_IF(!stmt_insert, mysql_error(mysql)); in test_insert_select()
2631 rc= mysql_stmt_prepare(stmt_insert, SL(query)); in test_insert_select()
2632 check_stmt_rc(rc, stmt_insert); in test_insert_select()
2642 rc= mysql_stmt_execute(stmt_insert); in test_insert_select()
2643 check_stmt_rc(rc, stmt_insert); in test_insert_select()
2653 mysql_stmt_close(stmt_insert); in test_insert_select()
|
| /dports/databases/mariadb-connector-c/mariadb-connector-c-3.2.4-src/unittest/libmariadb/ |
| H A D | ps.c | 2614 MYSQL_STMT *stmt_insert, *stmt_select; in test_insert_select() local
2632 stmt_insert= mysql_stmt_init(mysql); in test_insert_select()
2633 FAIL_IF(!stmt_insert, mysql_error(mysql)); in test_insert_select()
2634 rc= mysql_stmt_prepare(stmt_insert, SL(query)); in test_insert_select()
2635 check_stmt_rc(rc, stmt_insert); in test_insert_select()
2645 rc= mysql_stmt_execute(stmt_insert); in test_insert_select()
2646 check_stmt_rc(rc, stmt_insert); in test_insert_select()
2656 mysql_stmt_close(stmt_insert); in test_insert_select()
|
| /dports/databases/mysql55-client/mysql-5.5.62/tests/ |
| H A D | mysql_client_test.c | 9597 MYSQL_STMT *stmt_insert, *stmt_select; in test_insert_select() local
9617 check_stmt(stmt_insert); in test_insert_select()
9625 rc= mysql_stmt_execute(stmt_insert); in test_insert_select()
9626 check_execute(stmt_insert, rc); in test_insert_select()
9636 mysql_stmt_close(stmt_insert); in test_insert_select()
9645 MYSQL_STMT *stmt_insert; in test_bind_nagative() local
9665 check_stmt(stmt_insert); in test_bind_nagative()
9676 check_execute(stmt_insert, rc); in test_bind_nagative()
9679 rc= mysql_stmt_execute(stmt_insert); in test_bind_nagative()
9680 check_execute(stmt_insert, rc); in test_bind_nagative()
[all …]
|