D
B
M
OOO
KK
cmd isn't a fan of single quotes.
GKKKwrangler devworkerd which doesn't have the changes merged.KO
E
E
EE
F
F
KF
CM
FF
JGG
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 ...'),
...
])Gawait 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') )
...
])GR
CMM
S... COLLATE UNICODE_NOCASE.
D
SS
US
> Maximum SQL statement length?SO
npx wrangler d1 execute dbname --command 'PRAGMA table_info(tablename)'Unknown argument: table_info(tablename)'cmdworkerdawait 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