/* ** Usage: sqlite_bind VM IDX VALUE FLAGS ** ** Sets the value of the IDX-th occurance of "?" in the original SQL ** string. VALUE is the new value. If FLAGS=="null" then VALUE is ** ignored and the value is set to NULL. If FLAGS=="static" then ** the value is set to the value of a static variable named ** "sqlite_static_bind_value". If FLAGS=="normal" then a copy ** of the VALUE is made. */ static int test_bind( void *NotUsed, Tcl_Interp *interp, /* The TCL interpreter that invoked this command */ int argc, /* Number of arguments */ char **argv /* Text of each argument */ ){ sqlite_vm *vm; int rc; int idx; if( argc!=5 ){ Tcl_AppendResult(interp, "wrong # args: should be \"", argv[0], " VM IDX VALUE (null|static|normal)\"", 0); return TCL_ERROR; } if( getVmPointer(interp, argv[1], &vm) ) return TCL_ERROR; if( Tcl_GetInt(interp, argv[2], &idx) ) return TCL_ERROR; if( strcmp(argv[4],"null")==0 ){ rc = sqlite_bind(vm, idx, 0, 0, 0); }else if( strcmp(argv[4],"static")==0 ){ rc = sqlite_bind(vm, idx, sqlite_static_bind_value, -1, 0); }else if( strcmp(argv[4],"normal")==0 ){ rc = sqlite_bind(vm, idx, argv[3], -1, 1); }else{ Tcl_AppendResult(interp, "4th argument should be " "\"null\" or \"static\" or \"normal\"", 0); return TCL_ERROR; } if( rc ){ char zBuf[50]; sprintf(zBuf, "(%d) ", rc); Tcl_AppendResult(interp, zBuf, sqlite_error_string(rc), 0); return TCL_ERROR; } return TCL_OK; }
static int cursor_bind(Value *vret, Value *v, RefNode *node) { RefCursor *rc = Value_vp(*v); Value v1 = v[1]; Value v2 = v[2]; int idx; const RefNode *type = fs->Value_type(v1); if (type == fs->cls_int) { idx = fs->Value_int64(v1, NULL); } else if (type == fs->cls_str) { RefStr *rs = Value_vp(v1); if (!str_has0(rs->c, rs->size)) { idx = sqlite3_bind_parameter_index(rc->stmt, rs->c); } else { idx = 0; } if (idx == 0) { fs->throw_errorf(mod_sqlite, "SQLiteError", "No parameters names %r", rs); return FALSE; } } else { fs->throw_error_select(THROW_ARGMENT_TYPE2__NODE_NODE_NODE_INT, fs->cls_int, fs->cls_str, type, 1); return FALSE; } if (!sqlite_bind(rc->stmt, idx, v2)) { return FALSE; } return TRUE; }
static int conn_prepare_sub(sqlite3_stmt **stmt, sqlite3 *conn, Value *v) { Value *v1 = v + 1; int argc = fg->stk_top - v1; RefStr *sql; int result; if (conn == NULL) { fs->throw_errorf(mod_sqlite, "SQLiteError", "Connection is not opened"); return FALSE; } sql = Value_vp(*v1); result = sqlite3_prepare_v2(conn, sql->c, -1, stmt, NULL); if (result != SQLITE_OK){ if (result != SQLITE_ERROR_USER) { fs->throw_errorf(mod_sqlite, "SQLiteError", "%s", sqlite3_errmsg(conn)); } return FALSE; } if (*stmt == NULL) { fs->throw_errorf(mod_sqlite, "SQLiteError", "SQL string is empty"); return FALSE; } if (argc > 1) { int i; if (argc == 2) { const RefNode *type = fs->Value_type(v[2]); if (type == fs->cls_list) { RefArray *ra = Value_vp(v[2]); for (i = 0; i < ra->size; i++) { if (!sqlite_bind(*stmt, i + 1, ra->p[i])) { return FALSE; } } return TRUE; } else if (type == fs->cls_map) { RefMap *rm = Value_vp(v[2]); for (i = 0; i < rm->entry_num; i++) { HashValueEntry *ep = rm->entry[i]; for (; ep != NULL; ep = ep->next) { RefStr *rs; int idx; if (fs->Value_type(ep->key) != fs->cls_str) { fs->throw_errorf(fs->mod_lang, "TypeError", "Map {Str:*, Str:* ...} required"); return FALSE; } rs = Value_vp(ep->key); if (rs->size > 0 && !str_has0(rs->c, rs->size)) { // 先頭が記号で始まらない場合は、:を補う char ch = rs->c[0]; if (isdigit_fox(ch) || isupper_fox(ch) || islower_fox(ch)) { char *ptr = malloc(rs->size + 2); sprintf(ptr, ":%.*s", rs->size, rs->c); idx = sqlite3_bind_parameter_index(*stmt, ptr); free(ptr); } else { idx = sqlite3_bind_parameter_index(*stmt, rs->c); } } else { idx = 0; } if (idx == 0) { fs->throw_errorf(mod_sqlite, "SQLiteError", "No parameters names %r", rs); return FALSE; } if (!sqlite_bind(*stmt, idx, ep->val)) { return FALSE; } } } return TRUE; } } for (i = 1; i < argc; i++) { if (!sqlite_bind(*stmt, i, v1[i])) { return FALSE; } } } return TRUE; }