refractor Planetscale to Neon

[Codehagen]

Description

This Pull Request initiates the migration from PlanetScale to Neon for our database needs. It is currently in draft status and provides initial setup and migration steps.

1. Create an account at Noen Tech to start using their database services.
2. Update your local environment with the Neon connection URL in the .env file.
3. Run pnpm db:push
4. Confirm that the tables are populated correctly by checking the database through the Neon web interface. You can view the expected results in the following screenshot:
   

Remaining Tasks:

• Update so that when a user has signed in, this goes into the database.
• Update the user login function to adapt to the database structure.
• Test the new authentication flow.

Optional tasks

• Enhance the seed.ts script to populate the database with default data necessary for initial testing and setup.

Completion Criteria:

This PR will be considered complete when a user can sign in and their data is verifiably inserted into the database as reflected in the Neon tables.

What type of PR is this? (check all applicable)

• 💡 Feature
• 🐛 Bug Fix
• 📝 Documentation Update
• 🎨 Style
• 🧑‍💻 Code Refactor
• 🔥 Performance Improvements
• ✅ Test
• 🤖 Build
• 🔁 CI
• 📦 Chore (Release)
• ⏩ Revert

[vercel]

The latest updates on your projects. Learn more about Vercel for Git ↗︎

Name	Status	Preview	Comments	Updated (UTC)
badget	✅ Ready (Inspect)	Visit Preview	💬 Add feedback	May 11, 2024 9:48am

[Codehagen]

@shouryan01 wanna continue on this? ✨

[Codehagen]

Assigned this to you @shouryan01 - Ok? 🔥

[Codehagen]

We are almost there i think @shouryan01.
When I'm trying to add an asset I get this error:

www:dev: Error in tRPC handler (edge) on path account.addAccount
www:dev:  [TRPCError: column reference "name" is ambiguous] {
www:dev:   code: 'INTERNAL_SERVER_ERROR',
www:dev:   name: 'TRPCError'
www:dev: }

The file is under /packages/api/src/router/account.ts. And I think its a error that has something with this:

      await db.transaction(async (tx) => {
        await tx
          .insert(schema.balance)
          .values({
            accountId: BigInt(accountQuery.insertId),
            currencyIso: createAccountSchema.parse(opts.input).currencyIso,
            amount: createAccountSchema.parse(opts.input).amount ?? 0,
            date: new Date(),
            type: "AVAILABLE",
            originalPayload: createAccountSchema.parse(opts.input),
          })
          .onConflictDoUpdate({
            target: schema.balance.id,
            set: {
              amount: sql`amount`,
              date: sql`date`,
            },
          });

Im getting this error for this function:

No overload matches this call.
  Overload 2 of 2, '(values: { type: SQL<unknown> | "AVAILABLE" | "BOOKED" | "EXPECTED" | Placeholder<string, any>; currencyIso: string | SQL<unknown> | Placeholder<string, any>; ... 7 more ...; accountId?: string | ... 3 more ... | undefined; }[]): PgInsertBase<...>', gave the following error.
    Object literal may only specify known properties, and 'accountId' does not exist in type '{ type: SQL<unknown> | "AVAILABLE" | "BOOKED" | "EXPECTED" | Placeholder<string, any>; currencyIso: string | SQL<unknown> | Placeholder<string, any>; ... 7 more ...; accountId?: string | ... 3 more ... | undefined; }[]'.

[Codehagen]

Hello, tried it and got these errors @shouryan01 :

1. Pressed Add asset.
2. Pressed Real Estate
3. Made up some names and pressed submit