/**
   *
   * @param targetID  the ID of the user to receive the friend request
   */
  async sendUserFriendRequest(targetID: string): Promise<boolean> {
    try {
      await db
        .insert(friends)
        .values({
          user1_ID: this.userID,
          user2_ID: targetID,
          status: "pending",
        })
        .onConflictDoNothing({ target: [friends.user1_ID, friends.user2_ID] });

      log("social").debug(
        `user ${this.userID} sent friend request to user ${targetID}`,
      );
    } catch (e) {
      // if e is caused by targetID user not existing
      // return false
      // else
      log("social").error(
        `user '${this.userID}' failed to send friend request to user '${targetID}' %o`,
        e,
      );
      return false;
    }

    return true;
  }

  /**
   *
   * @param targetID  the ID of the user to receive the friend request
   */
  async sendUserFriendRequest(targetID: string): Promise<boolean> {
    try {
      await db
        .insert(friends)
        .values({
          user1_ID: this.userID,
          user2_ID: targetID,
          status: "pending",
        })
        .onConflictDoNothing({ target: [friends.user1_ID, friends.user2_ID] });

      log("social").debug(
        `user ${this.userID} sent friend request to user ${targetID}`,
      );
    } catch (e) {
      // if e is caused by targetID user not existing
      // return false
      // else
      log("social").error(
        `user '${this.userID}' failed to send friend request to user '${targetID}' %o`,
        e,
      );
      return false;
    }

    return true;
  }

{
[message]: 'insert or update on table "friends" violates foreign key constraint "friends_user2_user_id_fk"',
  length: 256,
  name: 'error',
  severity: 'ERROR',
  code: '23503',
  detail: 'Key (user2)=(hi) is not present in table "user".',
  hint: undefined,
  position: undefined,
  internalPosition: undefined,
  internalQuery: undefined,
  where: undefined,
  schema: 'public',
  table: 'friends',
  column: undefined,
  dataType: undefined,
  constraint: 'friends_user2_user_id_fk',
  file: 'ri_triggers.c',
  line: '2619',
  routine: 'ri_ReportViolation'
}

{
[message]: 'insert or update on table "friends" violates foreign key constraint "friends_user2_user_id_fk"',
  length: 256,
  name: 'error',
  severity: 'ERROR',
  code: '23503',
  detail: 'Key (user2)=(hi) is not present in table "user".',
  hint: undefined,
  position: undefined,
  internalPosition: undefined,
  internalQuery: undefined,
  where: undefined,
  schema: 'public',
  table: 'friends',
  column: undefined,
  dataType: undefined,
  constraint: 'friends_user2_user_id_fk',
  file: 'ri_triggers.c',
  line: '2619',
  routine: 'ri_ReportViolation'
}

import { z } from "zod";
import { WsSchema } from "./dist";

const schema = new WsSchema({
  TEST: z.object({}),
  MESSAGE: z.string(),
});


// Typescript should infer here that .data() should expect a string argument.

// Typescript is able to do so when the WsSchema class is imported from its source file, but it expects an argument of type 'unkown' when imported from the generated dist 

// this should not be valid and typescript should complain here, but it does not when importing from the dist folder
schema.send("MESSAGE").data({})

import { z } from "zod";
import { WsSchema } from "./dist";

const schema = new WsSchema({
  TEST: z.object({}),
  MESSAGE: z.string(),
});


// Typescript should infer here that .data() should expect a string argument.

// Typescript is able to do so when the WsSchema class is imported from its source file, but it expects an argument of type 'unkown' when imported from the generated dist 

// this should not be valid and typescript should complain here, but it does not when importing from the dist folder
schema.send("MESSAGE").data({})

import type { Metadata } from "next";
import "./globals.css";
import { SideNavBar } from "./_components/layout/SideNavBar";

export const metadata: Metadata = {
  title: "next Chessalyze",
  description: "chess with your friends!",
};

export default async function RootLayout({
  children,
}: Readonly<{
  children: React.ReactNode;
}>) {
  return (
    <html lang="en" className="h-full">
      <head></head>
      <body className="bg-stone-700 text-orange-50">
        <div className="flex h-screen w-full flex-row ">
          <SideNavBar />
          <div className="h-full w-full overflow-y-auto p-3 lg:p-5">
            {children}
          </div>
        </div>
      </body>
    </html>
  );
}

import type { Metadata } from "next";
import "./globals.css";
import { SideNavBar } from "./_components/layout/SideNavBar";

export const metadata: Metadata = {
  title: "next Chessalyze",
  description: "chess with your friends!",
};

export default async function RootLayout({
  children,
}: Readonly<{
  children: React.ReactNode;
}>) {
  return (
    <html lang="en" className="h-full">
      <head></head>
      <body className="bg-stone-700 text-orange-50">
        <div className="flex h-screen w-full flex-row ">
          <SideNavBar />
          <div className="h-full w-full overflow-y-auto p-3 lg:p-5">
            {children}
          </div>
        </div>
      </body>
    </html>
  );
}

const moves = pgTable(
  "moves",
  {
    gameID: varchar("game_id")
      .notNull()
      .references(() => games.id, { onDelete: "cascade" }),
    turn: integer("turn").notNull().unique(),  },
  (table) => {
    return {
      pk: primaryKey({ name: "id", columns: [table.gameID, table.turn] }),
    };
  },
);

const moves = pgTable(
  "moves",
  {
    gameID: varchar("game_id")
      .notNull()
      .references(() => games.id, { onDelete: "cascade" }),
    turn: integer("turn").notNull().unique(),  },
  (table) => {
    return {
      pk: primaryKey({ name: "id", columns: [table.gameID, table.turn] }),
    };
  },
);

export const moveTimestamps = pgTable("moveTimestamps", {
  move: varchar("move")
    .notNull()
    .references(() => //!What do i put here!)
    .primaryKey(),
});

export const moveTimestamps = pgTable("moveTimestamps", {
  move: varchar("move")
    .notNull()
    .references(() => //!What do i put here!)
    .primaryKey(),
});