Rich Prins Posts - Answer Overflow

Rich Prins

Explore posts from servers

RRailway TTCTheo's Typesafe Cult DTDrizzle Team

•Created by Rich Prins on 5/22/2024 in #help

question about partial query for joins

I am running a query for 'table1', and have an inner join for the user related to 'table1' by userId, but I wanted to limit the columns for user, becuase as my query stands now, I am leaking password hashes and that's obv unsafe. Can someone point me in the right direction? It's late and I have been digging in the docs for something to alleviate this but I am trying not to resolve to using raw sql template. Here is my query as it stands:

    const result = await db
        .select()
        .from(candidateProfileTable)
        .where(eq(candidateProfileTable.id, candidateId))
        .innerJoin(userTable, eq(candidateProfileTable.userId, userTable.id))
        .innerJoin(disciplineTable, eq(candidateProfileTable.disciplineId, disciplineTable.id))
        .innerJoin(regionTable, eq(candidateProfileTable.regionId, regionTable.id))
        .leftJoin(subRegionTable, eq(regionTable.id, subRegionTable.regionId));

    const result = await db
        .select()
        .from(candidateProfileTable)
        .where(eq(candidateProfileTable.id, candidateId))
        .innerJoin(userTable, eq(candidateProfileTable.userId, userTable.id))
        .innerJoin(disciplineTable, eq(candidateProfileTable.disciplineId, disciplineTable.id))
        .innerJoin(regionTable, eq(candidateProfileTable.regionId, regionTable.id))
        .leftJoin(subRegionTable, eq(regionTable.id, subRegionTable.regionId));

3 replies

RRailway

•Created by Rich Prins on 7/25/2023 in #✋｜help

Help getting Strapi service running locally

I spun up a strapi instance in Railway, and after I clone the repo, I seem to be having issues getting it running. I see that there is some config set up with variables for local development but it seems those are incorrect? Just looking to get help getting this running, as its not how I would normally spin up a strapi project, this just seemed quicker.

36 replies

RRailway

•Created by Rich Prins on 7/17/2023 in #✋｜help

Trying to deploy, getting yarn error

I kep getting this errorin the deploy logs after pushing to branch for a deploy: /bin/bash: line 1: yarn: command not found

43 replies

RRailway

•Created by Rich Prins on 7/11/2023 in #✋｜help

Billing for projects you are added to as guest

I have some projects that clients have made in their dashboard and added me as a guest, and I was wondering if since they show up for me, would they use my usage credits to run or just from the main account from which they were made? I am just a dev working on client projects so I need to be able to deploy these from my github

11 replies

RRailway

•Created by Rich Prins on 6/28/2023 in #✋｜help

Transferring project to a client's account

I want to spin up a node server for a data sync API, but I need to know if I can transfer the project to someone else's account after it is done so the client will handle billing for the project over its lifetime

13 replies

Gaming

Programming