trouble creating Enum
Hi everyone, here's my code:
I'm getting the errors:
I'm doing exactly the same thing on other tables, not sure what i'm doing wrong here...
Thanks for any help
import { paymentPlansNames } from 'misc/payment-plans';
import { pgTable, pgEnum, json, varchar } from 'drizzle-orm/pg-core';
import { bigint, bigserial } from 'drizzle-orm/pg-core';
import { relations } from 'drizzle-orm';
console.log(paymentPlansNames); // [ "Subscription Starter", "Subscription Pro" ]
const subscriptionPlanEnum = pgEnum('subscription_name', paymentPlansNames);
const frequencyEnum = pgEnum('frequency', ['monthly', 'yearly']);
export const Subscriptions = pgTable('subscriptions', {
id: bigserial('id', { mode: 'number' }).primaryKey(),
companyId: bigint('company_id', { mode: 'number' }),
customerId: bigint('customer_id', { mode: 'number' }),
subscriptionId: varchar('subscription_id', { length: 256 }),
subscriptionName: subscriptionPlanEnum('subscription_name'),
frequency: frequencyEnum('frequency'),
// trialStart: bigint('trial_start', { mode: 'number' }),
// trialEnd: bigint('trial_end', { mode: 'number' }),
currentPeriodStart: bigint('current_period_start', { mode: 'number' }),
currentPeriodEnd: bigint('current_period_end', { mode: 'number' }),
canceledAt: bigint('canceled_at', { mode: 'number' }),
// canceledAtPeriodEnd: bigint('canceled_at_period_end', { mode: 'number' }),
// createdAt: bigint('created_at', { mode: 'number' }),
// updatedAt: bigint('updated_at', { mode: 'number' }),
});import { paymentPlansNames } from 'misc/payment-plans';
import { pgTable, pgEnum, json, varchar } from 'drizzle-orm/pg-core';
import { bigint, bigserial } from 'drizzle-orm/pg-core';
import { relations } from 'drizzle-orm';
console.log(paymentPlansNames); // [ "Subscription Starter", "Subscription Pro" ]
const subscriptionPlanEnum = pgEnum('subscription_name', paymentPlansNames);
const frequencyEnum = pgEnum('frequency', ['monthly', 'yearly']);
export const Subscriptions = pgTable('subscriptions', {
id: bigserial('id', { mode: 'number' }).primaryKey(),
companyId: bigint('company_id', { mode: 'number' }),
customerId: bigint('customer_id', { mode: 'number' }),
subscriptionId: varchar('subscription_id', { length: 256 }),
subscriptionName: subscriptionPlanEnum('subscription_name'),
frequency: frequencyEnum('frequency'),
// trialStart: bigint('trial_start', { mode: 'number' }),
// trialEnd: bigint('trial_end', { mode: 'number' }),
currentPeriodStart: bigint('current_period_start', { mode: 'number' }),
currentPeriodEnd: bigint('current_period_end', { mode: 'number' }),
canceledAt: bigint('canceled_at', { mode: 'number' }),
// canceledAtPeriodEnd: bigint('canceled_at_period_end', { mode: 'number' }),
// createdAt: bigint('created_at', { mode: 'number' }),
// updatedAt: bigint('updated_at', { mode: 'number' }),
});I'm getting the errors:
error: type "frequency" does not existerror: type "frequency" does not existerror: type "subscription_name" does not existerror: type "subscription_name" does not existI'm doing exactly the same thing on other tables, not sure what i'm doing wrong here...
Thanks for any help
Solution
export const subscriptionPlanEnum = pgEnum('subscription_name', paymentPlansNames);
export const frequencyEnum = pgEnum('frequency', ['monthly', 'yearly']);export const subscriptionPlanEnum = pgEnum('subscription_name', paymentPlansNames);
export const frequencyEnum = pgEnum('frequency', ['monthly', 'yearly']);