Sparrow Posts - Answer Overflow

Sparrow

Explore posts from servers

•Created by Sparrow on 2/19/2025 in #help

how to model this query in drizzle

SELECT 
  tournaments.id, 
  tournaments.title, 
  tournaments.info, 
  tournaments.due_date, 
  tournaments.registration, 
  winner.name AS winner,
  runner_up.name AS runner_up,
  most_points.name AS most_points
FROM tournaments
INNER JOIN users AS winner ON tournaments.winner = winner.id
INNER JOIN users AS runner_up ON tournaments.runner_up = runner_up.id
INNER JOIN users AS most_points ON tournaments.most_points = most_points.id
WHERE tournaments.id = '45FobTao63vsRyc1N1';

SELECT 
  tournaments.id, 
  tournaments.title, 
  tournaments.info, 
  tournaments.due_date, 
  tournaments.registration, 
  winner.name AS winner,
  runner_up.name AS runner_up,
  most_points.name AS most_points
FROM tournaments
INNER JOIN users AS winner ON tournaments.winner = winner.id
INNER JOIN users AS runner_up ON tournaments.runner_up = runner_up.id
INNER JOIN users AS most_points ON tournaments.most_points = most_points.id
WHERE tournaments.id = '45FobTao63vsRyc1N1';

I currently have this:

  const tmp = await db
    .select({
      ...getTableColumns(tournaments_table),
      // id: tournaments_table.id,
      winner: tournaments_table.winner,
      runner_up: tournaments_table.runner_up,
      most_points: tournaments_table.most_points,
    })
    .from(tournaments_table)
    .innerJoin(users_table, eq(tournaments_table.winner, users_table.id))
    .innerJoin(users_table, eq(tournaments_table.runner_up, users_table.id))
    .innerJoin(users_table, eq(tournaments_table.most_points, users_table.id))
    .where(eq(tournaments_table.id, params.id));

  const tmp = await db
    .select({
      ...getTableColumns(tournaments_table),
      // id: tournaments_table.id,
      winner: tournaments_table.winner,
      runner_up: tournaments_table.runner_up,
      most_points: tournaments_table.most_points,
    })
    .from(tournaments_table)
    .innerJoin(users_table, eq(tournaments_table.winner, users_table.id))
    .innerJoin(users_table, eq(tournaments_table.runner_up, users_table.id))
    .innerJoin(users_table, eq(tournaments_table.most_points, users_table.id))
    .where(eq(tournaments_table.id, params.id));

but I get an error saying:

Error: Alias "users" is already used in this query

Error: Alias "users" is already used in this query

3 replies

PPrisma

•Created by Sparrow on 5/7/2024 in #help-and-questions

Prisma `AND` filter not working

await prisma.user.update({
where: {
    AND: [
        { id: req.params.id },
        { deleted: false },
      ],
},
//...
})

await prisma.user.update({
where: {
    AND: [
        { id: req.params.id },
        { deleted: false },
      ],
},
//...
})

this is my snippet, I am trying to update the user if the id is available and also the deleted is false.

3 replies

SSolidJS

•Created by Sparrow on 3/18/2023 in #support

Pass data from Express up to Solid

I have already install and run npm run build, How can I pass data from express to solid just as how I would do it for EJS or Handlebars???

5 replies

SSolidJS

•Created by Sparrow on 1/28/2023 in #support

I get `Invalid left-hand side in assignment expression.` when I assign a value.

I get the error above if I try to assign a value to selectedRate inside the onClick even with the arrow function removed, I still get an error.

const ratings = [1, 2, 3, 4, 5];

export default function Ratings() {
  const [selectedRate, setSelectedRate] = createSignal(0);

  return (
    <form action="thank-you.html">
        <ul class="rating-numbers flex">
        <For each={ratings}>
        {(rate) => <li onClick={() => setSelectedRate(selectedRate() = rate)}>{rate}</li>}
        </For>
    </ul>
     </form>
// ...

const ratings = [1, 2, 3, 4, 5];

export default function Ratings() {
  const [selectedRate, setSelectedRate] = createSignal(0);

  return (
    <form action="thank-you.html">
        <ul class="rating-numbers flex">
        <For each={ratings}>
        {(rate) => <li onClick={() => setSelectedRate(selectedRate() = rate)}>{rate}</li>}
        </For>
    </ul>
     </form>
// ...

2 replies

SSolidJS

•Created by Sparrow on 1/28/2023 in #support

For component not displaying values

What am I doing wrong here??

import { For } from "solid-js";

const ratings = [1, 2, 3, 4, 5];

export default function Ratings() {
   return (
      <form action="thank-you.html">
        <For each={ratings}>
        {(rate) => {
        <div>
        <input type="radio" name="rating" id={rate} />
        <label for={rate}>{rate}</label>
         </div>;
         }}
    </For>
      </form>
    );
}

import { For } from "solid-js";

const ratings = [1, 2, 3, 4, 5];

export default function Ratings() {
   return (
      <form action="thank-you.html">
        <For each={ratings}>
        {(rate) => {
        <div>
        <input type="radio" name="rating" id={rate} />
        <label for={rate}>{rate}</label>
         </div>;
         }}
    </For>
      </form>
    );
}

7 replies

Gaming

Programming