• Home
• tech.aroma
• aroma-data-operations
• 2.1
• source code
• insert_application.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_application.sql Maven / Gradle / Ivy

------------------------------------------------------------------------------
-- CREATES OR UPDATES AN APPLICATION
------------------------------------------------------------------------------

INSERT INTO applications (app_id, app_name, app_description, organization_id, programming_language, tier, time_of_token_expiration, app_icon_media_id, owners)
VALUES (?, ?, ?, ?, ?, ?, ?, ?, string_to_array(?, ',')::UUID[])
ON CONFLICT (app_id)
    DO UPDATE
        SET app_name                 = EXCLUDED.app_name,
            app_description          = EXCLUDED.app_description,
            organization_id          = EXCLUDED.organization_id,
            owners                   = EXCLUDED.owners,
            programming_language     = EXCLUDED.programming_language,
            time_last_updated        = now(),
            tier                     = EXCLUDED.tier,
            time_of_token_expiration = EXCLUDED.time_of_token_expiration,
            app_icon_media_id        = EXCLUDED.app_icon_media_id