await db
      .update(email)
      .set({ status: "sending", messageId: res.MessageId })
      .where(eq(email.emailId, msg.emailId))

export const emailStatus = pgEnum("EmailStatus", [
    "none",
    "sending",
    "sent",
    "cancelled",
])
export const email = pgTable(
    "email",
    {
        emailId: serial().primaryKey(),
        status: emailStatus().default("none"),
    },,
)

await db
      .update(email)
      .set({ status: "sending", messageId: res.MessageId })
      .where(eq(email.emailId, msg.emailId))

export const emailStatus = pgEnum("EmailStatus", [
    "none",
    "sending",
    "sent",
    "cancelled",
])
export const email = pgTable(
    "email",
    {
        emailId: serial().primaryKey(),
        status: emailStatus().default("none"),
    },,
)

/*
 SQLite does not support "Creating foreign key on existing column" out of the box, we do not generate automatic migration for that, so it has to be done manually
 Please refer to: https://www.techonthenet.com/sqlite/tables/alter_table.php
                  https://www.sqlite.org/lang_altertable.html

 Due to that we don't generate migration automatically and it has to be done manually
*/--> statement-breakpoint

/*
 SQLite does not support "Creating foreign key on existing column" out of the box, we do not generate automatic migration for that, so it has to be done manually
 Please refer to: https://www.techonthenet.com/sqlite/tables/alter_table.php
                  https://www.sqlite.org/lang_altertable.html

 Due to that we don't generate migration automatically and it has to be done manually
*/--> statement-breakpoint

CREATE TABLE ReportCategory (
    reportId   TEXT,
    categoryId TEXT,
    PRIMARY KEY (reportId, categoryId)
);

INSERT INTO ReportCategory VALUES
    ("one", "hacking"),
    ("one", "griefing"),
    ("two", "griefing"),
    ("three", "hacking")
;

SELECT * FROM ReportCategory;
-- one|hacking
-- one|griefing
-- two|griefing
-- three|hacking

-- this statement should error
-- UPDATE ReportCategory SET categoryId="hacking" WHERE categoryId="griefing" ON CONFLICT IGNORE;

-- this will work
UPDATE OR IGNORE ReportCategory SET categoryId="hacking" WHERE categoryId="griefing";

SELECT * FROM ReportCategory;
-- one|hacking
-- one|griefing
-- two|hacking
-- three|hacking

CREATE TABLE ReportCategory (
    reportId   TEXT,
    categoryId TEXT,
    PRIMARY KEY (reportId, categoryId)
);

INSERT INTO ReportCategory VALUES
    ("one", "hacking"),
    ("one", "griefing"),
    ("two", "griefing"),
    ("three", "hacking")
;

SELECT * FROM ReportCategory;
-- one|hacking
-- one|griefing
-- two|griefing
-- three|hacking

-- this statement should error
-- UPDATE ReportCategory SET categoryId="hacking" WHERE categoryId="griefing" ON CONFLICT IGNORE;

-- this will work
UPDATE OR IGNORE ReportCategory SET categoryId="hacking" WHERE categoryId="griefing";

SELECT * FROM ReportCategory;
-- one|hacking
-- one|griefing
-- two|hacking
-- three|hacking

GET /reports
GET /reports/:id
POST /reports
GET /communities
GET /communities/:id

GET /reports
GET /reports/:id
POST /reports
GET /communities
GET /communities/:id

// option 1
const reportsRoute = await env.BACKEND.getReports()
const reports = await reportsRoute.getReport("id")

// option 2
const reports = await env.BACKEND.reports.getReport("id")

// option 1
const reportsRoute = await env.BACKEND.getReports()
const reports = await reportsRoute.getReport("id")

// option 2
const reports = await env.BACKEND.reports.getReport("id")

const data = await prisma.Committee.findMany({
    include: {
        countries: true,
    },
})

{
  id: number
  ...

  countries: {
    id: number
    committeeId: number
    ...
  }[]
}

const data = await prisma.Committee.findMany({
    include: {
        countries: true,
    },
})

{
  id: number
  ...

  countries: {
    id: number
    committeeId: number
    ...
  }[]
}