migrations/006_fix_user_registration_function.sql at main · scanash.com/aethel

scanash.com / aethel

Aethel Bot OSS repository! aethel.xyz

bot fun ai discord discord-bot aethel

aethel / migrations / 006_fix_user_registration_function.sql

at main 429 B view raw

 1DROP FUNCTION IF EXISTS ensure_user_registered(text, text, character varying);
 2
 3CREATE OR REPLACE FUNCTION ensure_user_registered(
 4    p_user_id TEXT,
 5    p_user_tag TEXT DEFAULT NULL,
 6    p_language VARCHAR(10) DEFAULT 'en'
 7) RETURNS VOID AS $$
 8BEGIN
 9    INSERT INTO users (user_id, language, created_at)
10    VALUES (p_user_id, p_language, CURRENT_TIMESTAMP)
11    ON CONFLICT (user_id) DO NOTHING;
12    
13END;
14$$ LANGUAGE plpgsql;