Amur Posts - Answer Overflow

Amur

Explore posts from servers

RRailway TTCTheo's Typesafe Cult DTDrizzle Team

Posts Comments

DTDrizzle Team

•Created by Amur on 4/12/2024 in #help

Connection hangs in AWS Lambda when using response streaming

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

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
├── corepack@0.18.0
├── node-red@3.1.0
└── npm@9.6.7

➜  ttttttttt git:(main) ✗ npm ls -g
/Users/me/Library/Application Support/fnm/node-versions/v18.17.1/installation/lib
├── corepack@0.18.0
├── node-red@3.1.0
└── npm@9.6.7

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:
  cowsay@1.5.0
Ok to proceed? (y)

Need to install the following packages:
  cowsay@1.5.0
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

RRailway

•Created by Amur on 2/10/2023 in #✋｜help

Getting "Error adding service domain. Problem processing request." when trying to generate a domain.

Can't generate a domain even though this issue was fixed already apparently..

14 replies

Gaming

Programming