% wyekstrahowane z bazy danych SQL dla grupy EASY02
% wywołanie: python extract_dzn.py -H localhost -P 5432 -d jss_db -u postgres -p postgres -o c:\jss-saas-backend\app\data_import_from_sql\easy02_test6.dzn -g EASY02
no_mach = 7;
no_jobs = 10;
no_task = 29;
no_optt = 203;
tasks = [1..3, 4..5, 6..8, 9..11, 12..14, 15..17, 18..20, 21..23, 24..26, 27..29];
optts = [1..7, 8..14, 15..21, 22..28, 29..35, 36..42, 43..49, 50..56, 57..63, 64..70, 71..77, 78..84, 85..91, 92..98, 99..105, 106..112, 113..119, 120..126, 127..133, 134..140, 141..147, 148..154, 155..161, 162..168, 169..175, 176..182, 183..189, 190..196, 197..203];
optt_mach = [1, 2, 3, 4, 5, 6, 7, 1, 2, 3, 4, 5, 6, 7, 1, 2, 3, 4, 5, 6, 7, 1, 2, 3, 4, 5, 6, 7, 1, 2, 3, 4, 5, 6, 7, 1, 2, 3, 4, 5, 6, 7, 1, 2, 3, 4, 5, 6, 7, 1, 2, 3, 4, 5, 6, 7, 1, 2, 3, 4, 5, 6, 7, 1, 2, 3, 4, 5, 6, 7, 1, 2, 3, 4, 5, 6, 7, 1, 2, 3, 4, 5, 6, 7, 1, 2, 3, 4, 5, 6, 7, 1, 2, 3, 4, 5, 6, 7, 1, 2, 3, 4, 5, 6, 7, 1, 2, 3, 4, 5, 6, 7, 1, 2, 3, 4, 5, 6, 7, 1, 2, 3, 4, 5, 6, 7, 1, 2, 3, 4, 5, 6, 7, 1, 2, 3, 4, 5, 6, 7, 1, 2, 3, 4, 5, 6, 7, 1, 2, 3, 4, 5, 6, 7, 1, 2, 3, 4, 5, 6, 7, 1, 2, 3, 4, 5, 6, 7, 1, 2, 3, 4, 5, 6, 7, 1, 2, 3, 4, 5, 6, 7, 1, 2, 3, 4, 5, 6, 7, 1, 2, 3, 4, 5, 6, 7, 1, 2, 3, 4, 5, 6, 7];
optt_dur = [1, 4, 6, 9, 3, 5, 2, 8, 9, 5, 4, 1, 1, 3, 4, 8, 10, 4, 11, 4, 3, 6, 9, 8, 6, 5, 10, 3, 2, 10, 4, 5, 9, 8, 4, 15, 4, 8, 4, 8, 7, 1, 9, 6, 1, 10, 7, 1, 6, 11, 2, 7, 5, 2, 3, 14, 2, 8, 5, 8, 9, 4, 3, 5, 3, 8, 1, 9, 3, 6, 1, 2, 6, 4, 1, 7, 2, 7, 1, 8, 5, 4, 3, 9, 2, 4, 5, 10, 6, 4, 9, 5, 1, 7, 1, 6, 6, 2, 8, 7, 4, 56, 9, 8, 4, 5, 14, 1, 9, 6, 5, 8, 3, 5, 2, 5, 4, 5, 7, 5, 6, 3, 6, 5, 15, 2, 6, 5, 4, 9, 5, 4, 3, 9, 8, 2, 8, 6, 1, 7, 6, 1, 4, 1, 10, 4, 3, 11, 13, 9, 8, 9, 10, 8, 4, 2, 7, 8, 3, 10, 7, 12, 5, 4, 5, 4, 5, 5, 4, 2, 15, 99, 4, 7, 3, 9, 5, 11, 2, 5, 4, 2, 9, 4, 13, 10, 7, 6, 8, 4, 3, 25, 3, 8, 1, 2, 1, 2, 6, 11, 13, 3, 5];

first_day_of_schedule = "17.08.2026";
first_shift_start_time = ["08:00", "16:00"];
task_desc = ["Cięcie", "Montaż", "Kontrola jakości", "Cięcie", "Kontrola jakości", "Cięcie", "Montaż", "Kontrola jakości", "Cięcie", "Montaż", "Kontrola jakości", "Cięcie", "Montaż", "Kontrola jakości", "Cięcie", "Montaż", "Kontrola jakości", "Cięcie", "Montaż", "Kontrola jakości", "Cięcie", "Montaż", "Kontrola jakości", "Cięcie", "Montaż", "Kontrola jakości", "Cięcie", "Montaż", "Kontrola jakości"];
task_opno = ["10", "20", "30", "10", "20", "10", "20", "30", "10", "20", "30", "10", "20", "30", "10", "20", "30", "10", "20", "30", "10", "20", "30", "10", "20", "30", "10", "20", "30"];
machine_desc = ["Piła taśmowa", "Tokarka CNC", "Frezarka CNC", "Wiertarka pionowa", "Prasa krawędziowa", "Robot spawalniczy", "Szlifierka płaszczyzn"];
job_desc = ["EASY02-001 100 sz", "EASY02-002 200 sz", "EASY02-003 300 sz", "EASY02-004 400 sz", "EASY02-005 500 sz", "EASY02-006 600 sz", "EASY02-007 700 sz", "EASY02-008 800 sz", "EASY02-009 900 sz", "EASY02-010 1000 sz"];