We haven’t communicated any upper bound. We just have limits during alpha.
We haven’t communicated any upper bound. We just have limits during alpha.
no such table error. wrangler d1 info shows table count correctly. Any ideas what I'm doing wrong?wrangler dev --remote works, so I'm guessing that this is related to local env.
Do not know how to serialize a BigIntD1_ERROR: SqliteError: no such table: Casts
npx wrangler@3.4 <your commands> and report backD1Database const value = 0;
let d1Response: any;
await this.state.storage.transaction(async (txn) => {
try {
txn.put('value', this.value);
const stmt = this.db
.prepare(`INSERT INTO items (itemData) VALUES (?) RETURNING *`)
.bind(JSON.stringify({ value }));
d1Response = await stmt.all();
} catch (e) {
console.error(e);
txn.rollback();
throw e;
}
});CREATE TABLE Casts (
id int8 NOT NULL PRIMARY KEY,
created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
updated_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
deleted_at timestamp,
timestamp timestamp NOT NULL,
fid int8 NOT NULL,
hash bytea NOT NULL,
parent_hash bytea,
parent_fid int8,
parent_url text,
text text NOT NULL,
embeds text NOT NULL DEFAULT '{}',
mentions int8 NOT NULL DEFAULT '{}',
mentions_positions int2 NOT NULL DEFAULT '{}'
);const result = req.context.db.prepare("SELECT * from accounts");
const rows = await result.all();
console.log(rows);Error: D1_ERROR
at D1Database._send (C:\Users\hasx\OneDrive\Dokumentumok\Rókales\foxadopt\node_modules\@miniflare\d1\src\d1js.ts:148:13)
at D1PreparedStatement.all (C:\Users\hasx\OneDrive\Dokumentumok\Rókales\foxadopt\node_modules\@miniflare\d1\src\d1js.ts:242:7)
... 7 lines matching cause stack trace ...
at C:\Users\hasx\AppData\OneDrive\Dokumentumok\Rókales\foxadopt\functions\[[path]].js:3446:92 {
[cause]: Error: Error: SqliteError: no such table: accounts