import { ContinuousRunnerResult, PgClient } from '@bmd-studio/genstack-pg';
import environment from '@bmd-studio/genstack-environment';

const {  
  POSTGRES_HIDDEN_SCHEMA_NAME, 
} = environment.env; 

export default (pgClient: PgClient): ContinuousRunnerResult => {
  return pgClient.query(` 
    CREATE OR REPLACE FUNCTION ${POSTGRES_HIDDEN_SCHEMA_NAME}.set_update_timestamp()
    RETURNS TRIGGER AS $$
    BEGIN
      NEW.updated_at = CURRENT_TIMESTAMP;
      RETURN NEW;
    END;
    $$ LANGUAGE plpgsql;    
  `); 
};