• Home
• tech.aroma
• aroma-data-operations
• 2.1
• source code
• insert_user.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

tech.aroma.sql.inserts.insert_user.sql Maven / Gradle / Ivy

------------------------------------------------------------------------------
-- CREATES OR UPDATES A USER
------------------------------------------------------------------------------
INSERT INTO users (user_id, first_name, middle_name, last_name, full_name, email, roles, birthdate, profile_image_id, github_profile)
VALUES (?, ?, ?, ?, ?, ?, string_to_array(?, ','), ?, ?, ?)
ON CONFLICT (user_id)
    DO UPDATE
        SET
            first_name        = EXCLUDED.first_name,
            middle_name       = EXCLUDED.middle_name,
            last_name         = EXCLUDED.last_name,
            full_name         = EXCLUDED.full_name,
            email             = EXCLUDED.email,
            roles             = Excluded.roles,
            gender            = EXCLUDED.gender,
            birthdate         = EXCLUDED.birthdate,
            profile_image_id  = EXCLUDED.profile_image_id,
            github_profile    = EXCLUDED.github_profile,
            time_last_updated = EXCLUDED.time_last_updated