Amur
Amur
Explore posts from servers
TTCTheo's Typesafe CultDTDrizzle Team
PostsComments
DTDrizzle Team
Created by Amur on 2/5/2025 in #help
Conditional queries with $dynamic
Is there a way to not execute the query yet within the if statement? 
  const countQuery = db
    .select({
      count: sql<number>`count(${recipeTable.id})`.mapWith(Number),
    })
    .from(recipeTable)
    .where(and(...where))
    .$dynamic();

  if (filters.language) {
    countQuery.leftJoin(
      recipeTranslationTable,
      and(eq(recipeTable.id, recipeTranslationTable.recipeId), eq(recipeTranslationTable.locale, filters.language)),
    );
  }
  const countQuery = db
    .select({
      count: sql<number>`count(${recipeTable.id})`.mapWith(Number),
    })
    .from(recipeTable)
    .where(and(...where))
    .$dynamic();

  if (filters.language) {
    countQuery.leftJoin(
      recipeTranslationTable,
      and(eq(recipeTable.id, recipeTranslationTable.recipeId), eq(recipeTranslationTable.locale, filters.language)),
    );
  }
2 replies
DTDrizzle Team
Created by Amur on 4/12/2024 in #help
Connection hangs in AWS Lambda when using response streaming
No description
1 replies
DTDrizzle Team
Created by Amur on 3/26/2024 in #help
Ignore foreign key violation on bulk insert
Is there a way to just skip the value, or even better make it null if one of the values from a bulk insert vauses a foreign key violation error for example i have this code, and the second element as a recipeId that doesn't exist so i would get a foreign key violation error Is there a way to just skip the second element or make recipeId null for the second element (recipeId is a nullable field) 
  await db.insert(menuItemTable).values([
    {
      menuId: 1,
      name: "test item 1",
      description: "item.description",
      price: 12, 
      recipeId: 8,
    },
    {
      menuId: 1,
      name: "test item 2",
      description: "item.description",
      price: 12, 
      recipeId: 12, // there is no recipe with id 12
    },
    {
      menuId: 1,
      name: "test item 3",
      description: "item.description",
      price: 12,
      recipeId: 8,
    },
  ]);
  await db.insert(menuItemTable).values([
    {
      menuId: 1,
      name: "test item 1",
      description: "item.description",
      price: 12, 
      recipeId: 8,
    },
    {
      menuId: 1,
      name: "test item 2",
      description: "item.description",
      price: 12, 
      recipeId: 12, // there is no recipe with id 12
    },
    {
      menuId: 1,
      name: "test item 3",
      description: "item.description",
      price: 12,
      recipeId: 8,
    },
  ]);
1 replies
DTDrizzle Team
Created by Amur on 2/22/2024 in #help
Postgrest inserting json array results in stringified array
I'm trying to insert a an array of objects as a json array but it always ends up being strinfied if it would be just a json then i can do sql${recipeData.notes}::jsonb` but that doesn't work with arrays (cannot cast type record to jsonb`)
5 replies
DTDrizzle Team
Created by Amur on 2/20/2024 in #help
Drizzle-zod not inferring array field as array
No description
1 replies
TTCTheo's Typesafe Cult
Created by Amur on 11/22/2023 in #questions
Can't delete globally installed npm package
i want to delete the serverless.js npm package that's installed globally if i run serverless --version i see that there is a version installed globally 
serverless --version            
Running "serverless" from node_modules
Framework Core: 3.37.0 (local) 3.22.0 (global)
Plugin: 7.2.0
SDK: 4.5.1
serverless --version            
Running "serverless" from node_modules
Framework Core: 3.37.0 (local) 3.22.0 (global)
Plugin: 7.2.0
SDK: 4.5.1
if i run npm ls -g it's not in the list 
➜  ttttttttt git:(main) ✗ npm ls -g
/Users/me/Library/Application Support/fnm/node-versions/v18.17.1/installation/lib
➜  ttttttttt git:(main) ✗ npm ls -g
/Users/me/Library/Application Support/fnm/node-versions/v18.17.1/installation/lib
I switched to all installed node versions, checked npm ls -g for all but serverless wasn't in the list for any of them I'm thinking, maybe i installed serverless.js globally when i was still using nvm instead of fnm Is there a way to check the globally installed npm packages that were installed when i was using nvm ? 🤔
2 replies
TTCTheo's Typesafe Cult
Created by Amur on 11/6/2023 in #questions
Can npx execute packages without having the package installed?
In a lot of places i see people saying that npx can execute packages without instlalling them but whenever i try to exeute a package i get Need to install the following packages. example npx cowsay 'wow' 
Need to install the following packages:
Ok to proceed? (y)
Need to install the following packages:
Ok to proceed? (y)
3 replies
DTDrizzle Team
Created by Amur on 9/15/2023 in #help
Add drizzle-kit check as a pre-commit hook
Is there a way to add drizzle-kit check as a pre-commit hook with husky that would actually prevent the commit if something is wrong with my migrations? Currently i can add it but it won't prevent commiting
1 replies
DTDrizzle Team
Created by Amur on 9/6/2023 in #help
Type of `tx` when using `db.transactions`
I want to use helper functions within db.transactions but I can't get the type of tx working so basically i don't know how to type tx in the updateUserNotifications function 
const updateUserNotifications = async (
  userId: UpdateUserAttributes["id"],
  notifications: Required<UpdateUserAttributes>["notifications"],
  // eslint-disable-next-line @typescript-eslint/no-explicit-any
  tx: any, // TODO: what's the type of this
) => {
  // check if user has a notification settings record
  const userNotificationSettings = await tx.select().from(userNotifications).where(eq(users.id, userId));

  // create user notification settings record if it doesn't exist
  if (!userNotificationSettings.length) {
    await tx.insert(userNotifications).values({
      userId,
      favorites: notifications.favorites,
    });
  }

  await tx.update(userNotifications).set({ favorites: notifications.favorites }).where(eq(users.id, userId));
};

export const updateUser = async (userAttributes: UpdateUserAttributes) => {
  await db.transaction(async (tx) => {
    // update user notification settings
    if (userAttributes.notifications) {
      await updateUserNotifications(userAttributes.id, userAttributes.notifications, tx);
    }
  });
};
const updateUserNotifications = async (
  userId: UpdateUserAttributes["id"],
  notifications: Required<UpdateUserAttributes>["notifications"],
  // eslint-disable-next-line @typescript-eslint/no-explicit-any
  tx: any, // TODO: what's the type of this
) => {
  // check if user has a notification settings record
  const userNotificationSettings = await tx.select().from(userNotifications).where(eq(users.id, userId));

  // create user notification settings record if it doesn't exist
  if (!userNotificationSettings.length) {
    await tx.insert(userNotifications).values({
      userId,
      favorites: notifications.favorites,
    });
  }

  await tx.update(userNotifications).set({ favorites: notifications.favorites }).where(eq(users.id, userId));
};

export const updateUser = async (userAttributes: UpdateUserAttributes) => {
  await db.transaction(async (tx) => {
    // update user notification settings
    if (userAttributes.notifications) {
      await updateUserNotifications(userAttributes.id, userAttributes.notifications, tx);
    }
  });
};
19 replies
DTDrizzle Team
Created by Amur on 9/6/2023 in #help
Update relationship within 1 query
is it possible to update relationships? for example i have a one to one relationship between users and notifications but i couldn't find any example of how i could update the notifications of a user in 1 query 
 const updateduser = await db
    .update(users)
    .set({ email: userAttributes.email }) //i would expect `notifications` to be an option in `set` 
    .where(eq(users.id, userAttributes.id))
    .returning();
 const updateduser = await db
    .update(users)
    .set({ email: userAttributes.email }) //i would expect `notifications` to be an option in `set` 
    .where(eq(users.id, userAttributes.id))
    .returning();
same question goes for many to many relationships lets say i have a many to many between users and interests i want to update the user attributes and the interests of the user do i have to: 1. update user attributes 2. delete the current interests of the user from the association table 3. insert updated interests of the user
5 replies
DTDrizzle Team
Created by Amur on 8/29/2023 in #help
Is it possible to do lateral sub-query join without relational queries?
I'm trying to rewrite the same query that the relation query builder does behind the scenes but not sure if it's possible If i log the query this is what i get 
select "articles"."id", "articles"."title", "articles_keywords"."data" as "keywords" from "articles" 
left join lateral (select coalesce(json_agg(json_build_array("articles_keywords"."article_id", "articles_keywords"."keyword_value")), '[]'::json) 
as "data" from "article_keyword_association_table" "articles_keywords" 
where "articles_keywords"."article_id" = "articles"."id") "articles_keywords" on true 
where "articles"."id" in ('ec9ffb05-dfa0-455f-a71c-46ece3dc28a8', 'e56a9ae6-2373-4ad7-8d59-a76c7809d8ec') 
select "articles"."id", "articles"."title", "articles_keywords"."data" as "keywords" from "articles" 
left join lateral (select coalesce(json_agg(json_build_array("articles_keywords"."article_id", "articles_keywords"."keyword_value")), '[]'::json) 
as "data" from "article_keyword_association_table" "articles_keywords" 
where "articles_keywords"."article_id" = "articles"."id") "articles_keywords" on true 
where "articles"."id" in ('ec9ffb05-dfa0-455f-a71c-46ece3dc28a8', 'e56a9ae6-2373-4ad7-8d59-a76c7809d8ec')
I would like to do the same logic with the query builder becauase the relational queries there are certain things i cant do
3 replies
DTDrizzle Team
Created by Amur on 8/22/2023 in #help
DB connections hangs after successful execution in Lambda locally
I'm testing my lambda functions locally with sls invoke local -f hello. after returning a success response, my execution doesnt end attached a video that shows the behaviour if i remove the db query then it works fine
22 replies
DTDrizzle Team
Created by Amur on 8/10/2023 in #help
Error: Can't find meta/_journal.json file when trying to apply migrations in a lambda
11 replies
DTDrizzle Team
Created by Amur on 7/24/2023 in #help
order by array_position does not order the records in postgres
Using array_positions either throws error or ignores the order If i try to do it this way i get an function array_position(record, character varying) does not exist error 
const articleData = await db
    .select()
    .from(articles)
    .where(inArray(articles.id, idsToInclude))
      .orderBy(sql`array_position(${idsToInclude}, ${articles.id})`);
const articleData = await db
    .select()
    .from(articles)
    .where(inArray(articles.id, idsToInclude))
      .orderBy(sql`array_position(${idsToInclude}, ${articles.id})`);
If i join the array elements then I don't get an error but the order does not change 
const ids = "'f02d422b-c8c7-49df-9240-1dcb5a9f4342','7cf70ee0-2e4c-4360-aa5d-8230973b7ec3','367c861c-3f46-4d1a-b1ac-3a25c13121bd','348ad8ab-e7e1-4bf0-b762-c7df0d9e3a75'";

const articleData = await db
    .select()
    .from(articles)
    .where(inArray(articles.id, idsToInclude))
    .orderBy(sql`array_position(ARRAY[${a}], ${articles.id})`);
const ids = "'f02d422b-c8c7-49df-9240-1dcb5a9f4342','7cf70ee0-2e4c-4360-aa5d-8230973b7ec3','367c861c-3f46-4d1a-b1ac-3a25c13121bd','348ad8ab-e7e1-4bf0-b762-c7df0d9e3a75'";

const articleData = await db
    .select()
    .from(articles)
    .where(inArray(articles.id, idsToInclude))
    .orderBy(sql`array_position(ARRAY[${a}], ${articles.id})`);
However, If I hardcode the ids I get the correct order 
const articleData = await db
    .select()
    .from(articles)
    .where(inArray(articles.id, idsToInclude))
      .orderBy(sql`array_position(ARRAY[
      'f02d422b-c8c7-49df-9240-1dcb5a9f4342',
      '7cf70ee0-2e4c-4360-aa5d-8230973b7ec3',
      '367c861c-3f46-4d1a-b1ac-3a25c13121bd',
      '348ad8ab-e7e1-4bf0-b762-c7df0d9e3a75'
    ], ${articles.id})`);
const articleData = await db
    .select()
    .from(articles)
    .where(inArray(articles.id, idsToInclude))
      .orderBy(sql`array_position(ARRAY[
      'f02d422b-c8c7-49df-9240-1dcb5a9f4342',
      '7cf70ee0-2e4c-4360-aa5d-8230973b7ec3',
      '367c861c-3f46-4d1a-b1ac-3a25c13121bd',
      '348ad8ab-e7e1-4bf0-b762-c7df0d9e3a75'
    ], ${articles.id})`);
2 replies
DTDrizzle Team
Created by Amur on 7/10/2023 in #help
Including more than 1 relation in query throws error
If i try to include more than 1 relation i get an error 👇 
{
    "errorMessage": "could not identify an equality operator for type json",
    "errorType": "Hw",
    "stackTrace": [
        "error: could not identify an equality operator for type json",
        "    at /serverless-app/eosw-ts/.esbuild/.build/eosw/api/edition.js:2:12873",
        "    at processTicksAndRejections (node:internal/process/task_queues:96:5)",
        "    at async /serverless-app/eosw-ts/.esbuild/.build/eosw/api/edition.js:59:42969",
        "    at async EQe (/serverless-app/eosw-ts/.esbuild/.build/eosw/api/edition.js:59:63260)"
    ]
}
{
    "errorMessage": "could not identify an equality operator for type json",
    "errorType": "Hw",
    "stackTrace": [
        "error: could not identify an equality operator for type json",
        "    at /serverless-app/eosw-ts/.esbuild/.build/eosw/api/edition.js:2:12873",
        "    at processTicksAndRejections (node:internal/process/task_queues:96:5)",
        "    at async /serverless-app/eosw-ts/.esbuild/.build/eosw/api/edition.js:59:42969",
        "    at async EQe (/serverless-app/eosw-ts/.esbuild/.build/eosw/api/edition.js:59:63260)"
    ]
}
This is the query 👇 
  await db.query.magazines.findFirst({
    where: eq(magazines.id, "faa66220-0165-48f6-9895-afdab22d160d"),
    with: {
      editions: true,
      publisher: true,
    },
  });
  await db.query.magazines.findFirst({
    where: eq(magazines.id, "faa66220-0165-48f6-9895-afdab22d160d"),
    with: {
      editions: true,
      publisher: true,
    },
  });
If i remove either editions: true or publisher: true then it works
2 replies
DTDrizzle Team
Created by Amur on 7/7/2023 in #help
Create database if not exists
Is there a way to have create a database if it not exists? After i create my schema and a run the first migration, i would expect drizzle to create a database that's specified in my connection string if it doesn't exist
3 replies