Drizzle TeamDT
Drizzle Team•16mo ago
Mike

drizzle-kit generate doesn't run custom sql

In addition to my 
schema.ts
 file to define tables, I also have functions_and_triggers.ts to create functions and triggers for Supabase
export const customAccessTokenHook = async () => {
  await db.execute(sql`
    CREATE OR REPLACE FUNCTION public.custom_access_token_hook(event jsonb)
    RETURNS jsonb
    LANGUAGE plpgsql
    AS $$
    BEGIN
       // do stuff here
    END;
    $$;
  `);
};

However when I run drizzle-kit generate it only runs the table creation and not the other file
Here's my drizzle.config.ts
export default defineConfig({
  dialect: 'postgresql',
  schemaFilter: ['public'],
  schema: './src/lib/db/schema/*',
  out: './supabase/migrations',
  dbCredentials: {
    url: process.env.DATABASE_URL || 'postgresql://postgres:postgres@127.0.0.1:54322/postgres'
  }
});
Was this page helpful?