This function corrects the samples with an incorrect sex.
sex_correction(
data_connection,
start_year,
end_year,
program,
ocean,
country_code,
corrector,
action,
path_file = NULL
)list expected. Either output of the function postgresql_dbconnection, which must be done before using the sex_control.
integer expected. Starting year for the control.
integer expected. Ending year for the control.
character expected. Programs to be controlled. Example of the format for a program topiaid: "fr.ird.referential.ps.common.Program#1239832686262#0.31033946454061234".
character expected. Ocean to be controlled. Examples: 'Indian', 'Atlantic'...etc.
character expected. Countries on which control will be made. Examples: 'FRA', 'MUS'...etc.
character expected. First letter of the corrector's first name and last name. Examples: 'JMartin' for Jeanne Martin.
character expected. Type of action required when update queries are launched. COMMIT is used to definitively validate modifications and make them permanent in the database. ROLLBACK is used to undo changes made.
character expected. By default NULL. Path to save the final xlsx.
The function corrects sex in samples directly in the database and returns a xlsx file with the corrected samples.
Version 1.0