bun + D1 + cloudflare workers, 環境作成

mkdir project1
cd project1

bun init

bun add -d @cloudflare/workers-types wrangler
bun add -d better-sqlite3

bunx wrangler login

bunx wrangler d1 create my-d1

name = "project1"
main = "src/index.ts"
compatibility_date = "2023-09-01"
node_compat = true

[vars]
API_KEY = "123"

[[ d1_databases ]]
binding = "DB" # i.e. available in your Worker on env.DB
database_name = "my-d1"
database_id = "1234"

....

  "scripts": {
    "start": "wrangler dev",
    "deploy": "wrangler publish",
    "test": "vitest"
  }
....

export default {
	async fetch(request, env) {
	  const { pathname } = new URL(request.url);
	  console.log(env.DB);
  
	  if (pathname === "/api/cunstomer") {
		const { results } = await env.DB.prepare(
		  "SELECT * FROM Customers WHERE id > ?"
		)
		  .bind(0)
		  .all();
		return Response.json(results);
	  }
	  // …
	  return new Response("Call /api/users to display users over 30 years old");
	},
  };

DROP TABLE IF EXISTS Customers;
CREATE TABLE Customers (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  createdAt TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
  updatedAt TIMESTAMP(3) NULL,
  CompanyName TEXT NOT NULL,
  ContactName TEXT NOT NULL
);

INSERT INTO Customers (CompanyName, ContactName) VALUES ('Alfreds Futterkiste', 'Maria Anders');
INSERT INTO Customers (CompanyName, ContactName) VALUES ('Around the Horn', 'Thomas Hardy');
INSERT INTO Customers (CompanyName, ContactName) VALUES ('Bs Beverages', 'Victoria Ashworth');

bunx wrangler d1 execute my-d1 --local --file=./schema.sql

#test
bunx wrangler d1 execute my-d1 --local --command='SELECT * FROM Customers'

bunx wrangler d1 execute my-d1 --file=./schema.sql

# test
bunx wrangler d1 execute my-d1 --command='SELECT * FROM Customers'

bun run start

curl http://127.0.0.1:8787/api/cunstomer

bunx wrangler publish

{
  "name": "bun_5d1",
  "module": "src/index.ts",
  "type": "module",
  "devDependencies": {
    "@cloudflare/workers-types": "^4.20230914.0",
    "better-sqlite3": "^8.6.0",
    "bun-types": "latest",
    "wrangler": "^3.9.0"
  },
  "peerDependencies": {
    "typescript": "^5.0.0"
  },
  "scripts": {
    "start": "wrangler dev",
    "deploy": "wrangler publish",
    "test": "vitest"
  }
}