/**
 * This class is generated by jOOQ
 */
package classes.routines;


import classes.Public;

import java.sql.Date;

import javax.annotation.Generated;

import org.jooq.Parameter;
import org.jooq.impl.AbstractRoutine;


/**
 * This class is generated by jOOQ.
 */
@Generated(
    value = {
        "http://www.jooq.org",
        "jOOQ version:3.8.6"
    },
    comments = "This class is generated by jOOQ"
)
@SuppressWarnings({ "all", "unchecked", "rawtypes" })
public class UpdatePerson extends AbstractRoutine<java.lang.Void> {

    private static final long serialVersionUID = 786042838;

    /**
     * The parameter <code>public.update_person.p_id</code>.
     */
    public static final Parameter<Integer> P_ID = createParameter("p_id", org.jooq.impl.SQLDataType.INTEGER, false, false);

    /**
     * The parameter <code>public.update_person.lastname</code>.
     */
    public static final Parameter<String> LASTNAME = createParameter("lastname", org.jooq.impl.SQLDataType.CLOB, false, false);

    /**
     * The parameter <code>public.update_person.firstname</code>.
     */
    public static final Parameter<String> FIRSTNAME = createParameter("firstname", org.jooq.impl.SQLDataType.CLOB, false, false);

    /**
     * The parameter <code>public.update_person.secondname</code>.
     */
    public static final Parameter<String> SECONDNAME = createParameter("secondname", org.jooq.impl.SQLDataType.CLOB, false, false);

    /**
     * The parameter <code>public.update_person.dateofbirth</code>.
     */
    public static final Parameter<Date> DATEOFBIRTH = createParameter("dateofbirth", org.jooq.impl.SQLDataType.DATE, false, false);

    /**
     * The parameter <code>public.update_person.in_sex</code>.
     */
    public static final Parameter<String> IN_SEX = createParameter("in_sex", org.jooq.impl.SQLDataType.CHAR, false, false);

    /**
     * The parameter <code>public.update_person.placeofbirth</code>.
     */
    public static final Parameter<String> PLACEOFBIRTH = createParameter("placeofbirth", org.jooq.impl.SQLDataType.CLOB, false, false);

    /**
     * The parameter <code>public.update_person.in_address</code>.
     */
    public static final Parameter<String> IN_ADDRESS = createParameter("in_address", org.jooq.impl.SQLDataType.CLOB, false, false);

    /**
     * The parameter <code>public.update_person.in_phone</code>.
     */
    public static final Parameter<String> IN_PHONE = createParameter("in_phone", org.jooq.impl.SQLDataType.CLOB, false, false);

    /**
     * The parameter <code>public.update_person.in_photo</code>.
     */
    public static final Parameter<byte[]> IN_PHOTO = createParameter("in_photo", org.jooq.impl.SQLDataType.BLOB, false, false);

    /**
     * The parameter <code>public.update_person.passport_serial</code>.
     */
    public static final Parameter<Integer> PASSPORT_SERIAL = createParameter("passport_serial", org.jooq.impl.SQLDataType.INTEGER, false, false);

    /**
     * The parameter <code>public.update_person.passport_id</code>.
     */
    public static final Parameter<Integer> PASSPORT_ID = createParameter("passport_id", org.jooq.impl.SQLDataType.INTEGER, false, false);

    /**
     * The parameter <code>public.update_person.in_timetable</code>.
     */
    public static final Parameter<String[]> IN_TIMETABLE = createParameter("in_timetable", org.jooq.impl.SQLDataType.CHAR.getArrayDataType(), false, false);

    /**
     * The parameter <code>public.update_person.in_position_name</code>.
     */
    public static final Parameter<String> IN_POSITION_NAME = createParameter("in_position_name", org.jooq.impl.SQLDataType.CLOB, false, false);

    /**
     * Create a new routine call instance
     */
    public UpdatePerson() {
        super("update_person", Public.PUBLIC);

        addInParameter(P_ID);
        addInParameter(LASTNAME);
        addInParameter(FIRSTNAME);
        addInParameter(SECONDNAME);
        addInParameter(DATEOFBIRTH);
        addInParameter(IN_SEX);
        addInParameter(PLACEOFBIRTH);
        addInParameter(IN_ADDRESS);
        addInParameter(IN_PHONE);
        addInParameter(IN_PHOTO);
        addInParameter(PASSPORT_SERIAL);
        addInParameter(PASSPORT_ID);
        addInParameter(IN_TIMETABLE);
        addInParameter(IN_POSITION_NAME);
    }

    /**
     * Set the <code>p_id</code> parameter IN value to the routine
     */
    public void setPId(Integer value) {
        setValue(P_ID, value);
    }

    /**
     * Set the <code>lastname</code> parameter IN value to the routine
     */
    public void setLastname(String value) {
        setValue(LASTNAME, value);
    }

    /**
     * Set the <code>firstname</code> parameter IN value to the routine
     */
    public void setFirstname(String value) {
        setValue(FIRSTNAME, value);
    }

    /**
     * Set the <code>secondname</code> parameter IN value to the routine
     */
    public void setSecondname(String value) {
        setValue(SECONDNAME, value);
    }

    /**
     * Set the <code>dateofbirth</code> parameter IN value to the routine
     */
    public void setDateofbirth(Date value) {
        setValue(DATEOFBIRTH, value);
    }

    /**
     * Set the <code>in_sex</code> parameter IN value to the routine
     */
    public void setInSex(String value) {
        setValue(IN_SEX, value);
    }

    /**
     * Set the <code>placeofbirth</code> parameter IN value to the routine
     */
    public void setPlaceofbirth(String value) {
        setValue(PLACEOFBIRTH, value);
    }

    /**
     * Set the <code>in_address</code> parameter IN value to the routine
     */
    public void setInAddress(String value) {
        setValue(IN_ADDRESS, value);
    }

    /**
     * Set the <code>in_phone</code> parameter IN value to the routine
     */
    public void setInPhone(String value) {
        setValue(IN_PHONE, value);
    }

    /**
     * Set the <code>in_photo</code> parameter IN value to the routine
     */
    public void setInPhoto(byte[] value) {
        setValue(IN_PHOTO, value);
    }

    /**
     * Set the <code>passport_serial</code> parameter IN value to the routine
     */
    public void setPassportSerial(Integer value) {
        setValue(PASSPORT_SERIAL, value);
    }

    /**
     * Set the <code>passport_id</code> parameter IN value to the routine
     */
    public void setPassportId(Integer value) {
        setValue(PASSPORT_ID, value);
    }

    /**
     * Set the <code>in_timetable</code> parameter IN value to the routine
     */
    public void setInTimetable(String[] value) {
        setValue(IN_TIMETABLE, value);
    }

    /**
     * Set the <code>in_position_name</code> parameter IN value to the routine
     */
    public void setInPositionName(String value) {
        setValue(IN_POSITION_NAME, value);
    }
}