export default {
  async fetch(request, env) {
    // Create a table
    await env.DB.exec(`CREATE TABLE IF NOT EXISTS users (
      id INTEGER PRIMARY KEY,
      name TEXT NOT NULL,
      email TEXT UNIQUE NOT NULL,
      created_at DATETIME DEFAULT CURRENT_TIMESTAMP
    )`);

    // Insert data
    const { results } = await env.DB.prepare(
      `INSERT INTO users (name, email) VALUES (?, ?)`
    ).bind('John Doe', 'john@example.com').run();

    // Query data
    const { results: users } = await env.DB.prepare(
      `SELECT * FROM users WHERE email = ?`
    ).bind('john@example.com').all();

    return new Response(JSON.stringify(users), {
      headers: { 'Content-Type': 'application/json' }
    });
  }
};