UpdateStudentProfile
Oleg Zech redigerade denna sida 3 år sedan
create or replace function api."UpdateStudentProfile"
    (
          _student             name  -- THIS WILL NOT UPDATE (OF COURSE). SELECT THE STUDENT FOR UPDATING  
      --------------------------------------------------------------
      -- SEND ONLY FIELD YOU WANT TU UPDATE, NOT ALL AT ONCE
      ---------------------------------------------------------------
        , _first_name          text default null
        , _last_name           text default null
        , _gender              gender default null
        , _email               email default null
        , _reg_no              int default null
        , _data                jsonb default null
        , _class               uuid default null
        , _mobile              mobile default null
        , _nationality         country_code default null
        , _citizenship         country_code default null
        , _birth_date          date default null
        , _birth_place         text default null
        , _reg_num             text default null
        , _school              capitalshorttext default null
        , _school_year         school_year default null
        , _class_grade         text default null
        , _class_section       text default null
        , _class_level         int default null
        , _registration_date   date default null
        , _father_last_name    text default null
        , _father_first_name   text default null
        , _father_mobile       mobile default null
        , _father_email        email default null
        , _mother_last_name    text default null
        , _mother_first_name   text default null
        , _mother_mobile       mobile default null
        , _mother_email        email default null
        , _guardian_last_name  text default null
        , _guardian_first_name text default null
        , _guardian_mobile     mobile default null
        , _guardian_email      email default null
        , _address             text default null
        , _city                text default null
        , _zip                 text default null
        , _emergency_mobile    mobile default null
    )