Better-sqlite3 Aktualisieren Sie den Zeilenwert (SqliteError: unrecognized token: :“) ⇐ JavaScript

[Anonymous]

Code: Select all

const appSchemaTableQuery = `
CREATE TABLE IF NOT EXISTS app_schema (
id INTEGER PRIMARY KEY AUTOINCREMENT,
_c_url TEXT,
created_at DATETIME DEFAULT CURRENT_TIMESTAMP
);
`
db.exec(appSchemaTableQuery)

///////////////////////////////////////////////////////

Code: Select all

let _c_url = await fetch('api')
let _c_url_json = await _c_url.json()
let login_api = db.prepare(`UPDATE app_schema SET _c_url = ${_c_url_json.login_api}`)
console.log("login_api:", login_api)