
cmd isn't a fan of single quotes.wrangler devworkerd which doesn't have the changes merged.


await db.batch([
db.prepare('UPDATE sessions SET updated=CURRENT_TIMESTAMP WHERE id_session=?1')
.bind(session)
.expect({ meta: { changes: 1 } }),
db.prepare('SELECT * FROM ...'),
...
])await db.batch([
db.prepare('UPDATE sessions SET updated=CURRENT_TIMESTAMP WHERE id_session=?1 RETURNING *')
.bind(session)
.expect({ meta: { changes: 1 } })
.set({ user: 'id_user' }), // Or user: [ 'id_user', 0 ] to indicate a position in the results array
db.prepare('SELECT * FROM users WHERE id_user=?1').bind( db.get('user') )
...
])
... COLLATE UNICODE_NOCASE.
> Maximum SQL statement length?npx wrangler d1 execute dbname --command 'PRAGMA table_info(tablename)'Unknown argument: table_info(tablename)'cmdawait db.batch([
db.prepare('UPDATE sessions SET updated=CURRENT_TIMESTAMP WHERE id_session=?1')
.bind(session)
.expect({ meta: { changes: 1 } }),
db.prepare('SELECT * FROM ...'),
...
])await db.batch([
db.prepare('UPDATE sessions SET updated=CURRENT_TIMESTAMP WHERE id_session=?1 RETURNING *')
.bind(session)
.expect({ meta: { changes: 1 } })
.set({ user: 'id_user' }), // Or user: [ 'id_user', 0 ] to indicate a position in the results array
db.prepare('SELECT * FROM users WHERE id_user=?1').bind( db.get('user') )
...
])... COLLATE UNICODE_NOCASE Cannot create a string longer than 0x1fffffe8 characters> Maximum SQL statement length