const query = db
    .selectFrom("Anime")
    .leftJoin("VoteAnime", "Anime.id", "votedForId")
    .select([
      "Anime.id",
      "Anime.name",
      "Anime.imageUrl",
      count("VoteAnime.votedForId").as("VoteFor"),
      count("VoteAnime.votedAgainstId").as("VoteAgainst"),
    ])
    .groupBy("Anime.id")
    .execute();

const query = db
    .selectFrom("Anime")
    .leftJoin("VoteAnime", "Anime.id", "votedForId")
    .select([
      "Anime.id",
      "Anime.name",
      "Anime.imageUrl",
      count("VoteAnime.votedForId").as("VoteFor"),
      count("VoteAnime.votedAgainstId").as("VoteAgainst"),
    ])
    .groupBy("Anime.id")
    .execute();

ts await ctx.prisma.voteAnime.create({
          data: {
            votedAgainstId: input.votedAgainst,
            votedForId: input.votedFor,
          },
        });

ts await ctx.prisma.voteAnime.create({
          data: {
            votedAgainstId: input.votedAgainst,
            votedForId: input.votedFor,
          },
        });

ts const result = await ctx.db
          .insertInto("VoteAnime")
          .values({
            votedAgainstId: input.votedAgainst,
            votedForId: input.votedFor,
          })
          .executeTakeFirst();

ts const result = await ctx.db
          .insertInto("VoteAnime")
          .values({
            votedAgainstId: input.votedAgainst,
            votedForId: input.votedFor,
          })
          .executeTakeFirst();

const [lastCol, lastRow] = getMoveLocation(lastSquares, squares)

const [lastCol, lastRow] = getMoveLocation(lastSquares, squares)

Type 'number[] | undefined' must have a '[Symbol.iterator]()' method that returns an iterator.

Type 'number[] | undefined' must have a '[Symbol.iterator]()' method that returns an iterator.

import ws from 'ws';
const wss = new ws.Server({
  port: 3001,
but wss has type? ws.Server<ws.WebSocket> 
});

import ws from 'ws';
const wss = new ws.Server({
  port: 3001,
but wss has type? ws.Server<ws.WebSocket> 
});

const addTodo = api.todos.createTodo.useMutation({
    async onMutate(newTodo) {
      // Cancel outgoing fetches (so they don't overwrite our optimistic update)
      await utils.todos.getAllTodos.cancel();

      // Get the data from the queryCache
      const prevData = utils.todos.getAllTodos.getData();

      // Optimistically update the data with our new post
      utils.todos.getAllTodos.setData(
        undefined,
        (old) => [...(old as Todo[]), newTodo] as Todo[]
      );

      // Return the previous data so we can revert if something goes wrong
      return { prevData };
    },
    onError(err, newPost, ctx) {
      // If the mutation fails, use the context-value from onMutate
      utils.todos.getAllTodos.setData(undefined, ctx?.prevData);
    },
    onSettled() {
      // Sync with server once mutation has settled
      void utils.todos.getAllTodos.invalidate();
    },
  });

const addTodo = api.todos.createTodo.useMutation({
    async onMutate(newTodo) {
      // Cancel outgoing fetches (so they don't overwrite our optimistic update)
      await utils.todos.getAllTodos.cancel();

      // Get the data from the queryCache
      const prevData = utils.todos.getAllTodos.getData();

      // Optimistically update the data with our new post
      utils.todos.getAllTodos.setData(
        undefined,
        (old) => [...(old as Todo[]), newTodo] as Todo[]
      );

      // Return the previous data so we can revert if something goes wrong
      return { prevData };
    },
    onError(err, newPost, ctx) {
      // If the mutation fails, use the context-value from onMutate
      utils.todos.getAllTodos.setData(undefined, ctx?.prevData);
    },
    onSettled() {
      // Sync with server once mutation has settled
      void utils.todos.getAllTodos.invalidate();
    },
  });

const CreateTodo = ({ addTodo }: ???) => {}

const CreateTodo = ({ addTodo }: ???) => {}

Tbody
Items.map(Item => (<ItemComponent Item={item}/>) 
Tbody

Tbody
Items.map(Item => (<ItemComponent Item={item}/>) 
Tbody

 delete: protectedProcedure
  .input(z.object({
    postId: z.string(),
  }))
  .mutation(async ({ctx, input}) => {
    await ctx.prisma.post.delete({
      where: {
        id: input.postId,
      }
    })
  }),
});

 delete: protectedProcedure
  .input(z.object({
    postId: z.string(),
  }))
  .mutation(async ({ctx, input}) => {
    await ctx.prisma.post.delete({
      where: {
        id: input.postId,
      }
    })
  }),
});

const { data: recentData } = trpc.recent.getRecent.useQuery();
  const { data: trendingData } = trpc.trending.getTrending.useQuery();

const { data: recentData } = trpc.recent.getRecent.useQuery();
  const { data: trendingData } = trpc.trending.getTrending.useQuery();

// Create an item
.mutation(async ({ ctx, input }) => {
      try {
        await ctx.prisma.coin.create({data: ...})}

// Then get all the items
getAll: publicProcedure.query(async ({ ctx }) => {
      try {
        return await ctx.prisma.coin.findMany({
          where: {userId: ctx.session?.user?.id}

// Create an item
.mutation(async ({ ctx, input }) => {
      try {
        await ctx.prisma.coin.create({data: ...})}

// Then get all the items
getAll: publicProcedure.query(async ({ ctx }) => {
      try {
        return await ctx.prisma.coin.findMany({
          where: {userId: ctx.session?.user?.id}

model Coin {
  id                          String   @id @default(cuid())
  createdAt                   DateTime @default(now())
  name                        String
  other stuff but not important
}
model User {
  id            String    @id @default(cuid())
  name          String?
  email         String?   @unique
  emailVerified DateTime?
  image         String?
  accounts      Account[]
  sessions      Session[]
  coins         Coin[]
}

model Coin {
  id                          String   @id @default(cuid())
  createdAt                   DateTime @default(now())
  name                        String
  other stuff but not important
}
model User {
  id            String    @id @default(cuid())
  name          String?
  email         String?   @unique
  emailVerified DateTime?
  image         String?
  accounts      Account[]
  sessions      Session[]
  coins         Coin[]
}

const { data: getCoin } = trpc.coin.getCoin.useQuery({ name: id });

const { data: getCoin } = trpc.coin.getCoin.useQuery({ name: id });

symbol: string;
    name: string;
    image: {
        large: string;
    };
    market_cap_rank: number;
    links: {
        homepage: string[];
    ...

symbol: string;
    name: string;
    image: {
        large: string;
    };
    market_cap_rank: number;
    links: {
        homepage: string[];
    ...

<CoinInfo getCoin={getCoin} />

<CoinInfo getCoin={getCoin} />

 export const CoinInfo = ({ getCoin }) => 

 export const CoinInfo = ({ getCoin }) => 

const PokemonResult = z.object({
    forms: z.array(z.object({
        name: z.string(),
        url: z.string(),
    })),
    base_experience: z.number(),
})

const PokemonResult = z.object({
    forms: z.array(z.object({
        name: z.string(),
        url: z.string(),
    })),
    base_experience: z.number(),
})

export const pokeRouter = router({
  getByName: publicProcedure
  .input(z.object({ name: z.string()}))
    .query(async ({ input }) => {
      const pokemon = await fetch(`https://pokeapi.co/api/v2/pokemon/${input.name}`).then(res =>
      res.json());
      const parsedData = PokemonResult.parse(pokemon);

      return parsedData;
    }),
})

export const pokeRouter = router({
  getByName: publicProcedure
  .input(z.object({ name: z.string()}))
    .query(async ({ input }) => {
      const pokemon = await fetch(`https://pokeapi.co/api/v2/pokemon/${input.name}`).then(res =>
      res.json());
      const parsedData = PokemonResult.parse(pokemon);

      return parsedData;
    }),
})

export const coinRouter = router({
  getCoin: publicProcedure
  .input(z.object({ name: z.any()}))
    .query(async ({ input }) => {
      const coin:Coin = await fetch(`https://api.coingecko.com/api/v3/coins/${input.name}`).then(res =>
      res.json());
      return coin     
    }),
})

export const coinRouter = router({
  getCoin: publicProcedure
  .input(z.object({ name: z.any()}))
    .query(async ({ input }) => {
      const coin:Coin = await fetch(`https://api.coingecko.com/api/v3/coins/${input.name}`).then(res =>
      res.json());
      return coin     
    }),
})