Function createTriggers

scripts/migrate.js:224–293

(client)

};

const createTriggers = async (client) => {
  logger.info('⏰ Setting up automatic timestamps...');

  const triggers = [
    {
      table: 'guild_configs',
      name: 'update_guild_configs_timestamp'
    },
    {
      table: 'user_levels',
      name: 'update_user_levels_timestamp'
    },
    {
      table: 'user_economy',
      name: 'update_user_economy_timestamp'
    },
    {
      table: 'birthdays',
      name: 'update_birthdays_timestamp'
    },
    {
      table: 'tickets',
      name: 'update_tickets_timestamp'
    },
    {
      table: 'giveaways',
      name: 'update_giveaways_timestamp'
    },
    {
      table: 'reaction_roles',
      name: 'update_reaction_roles_timestamp'
    },
    {
      table: 'welcome_system',
      name: 'update_welcome_system_timestamp'
    },
    {
      table: 'counters',
      name: 'update_counters_timestamp'
    }
  ];

  for (const { table, name } of triggers) {
    try {
      
      await client.query(`
        CREATE OR REPLACE FUNCTION update_timestamp_${table}()
        RETURNS TRIGGER AS $$
        BEGIN
          NEW.updated_at = CURRENT_TIMESTAMP;
          RETURN NEW;
        END;
        $$ LANGUAGE plpgsql;
      `);

      await client.query(`
        DROP TRIGGER IF EXISTS ${name} ON ${table};
        CREATE TRIGGER ${name}