% wyekstrahowane z bazy danych SQL dla grupy MED10
% 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\med10_test6.dzn -g MED10
no_mach = 12;
no_jobs = 10;
no_task = 100;
no_optt = 120;
tasks = [1..10, 11..20, 21..30, 31..40, 41..50, 51..60, 61..70, 71..80, 81..90, 91..100];
optts = [1..2, {3}, {4}, {5}, {6}, {7}, {8}, 9..10, {11}, {12}, 13..14, {15}, {16}, {17}, {18}, {19}, {20}, {21}, 22..23, {24}, {25}, 26..27, {28}, {29}, {30}, {31}, 32..33, {34}, {35}, {36}, {37}, {38}, 39..40, {41}, {42}, {43}, 44..45, {46}, {47}, {48}, {49}, 50..51, {52}, {53}, {54}, {55}, {56}, 57..58, {59}, {60}, {61}, {62}, {63}, {64}, {65}, {66}, 67..68, {69}, {70}, 71..72, {73}, 74..75, {76}, {77}, {78}, {79}, {80}, {81}, 82..83, {84}, {85}, 86..87, {88}, {89}, {90}, {91}, {92}, {93}, 94..95, {96}, 97..98, {99}, {100}, {101}, {102}, {103}, {104}, 105..106, {107}, {108}, {109}, 110..111, {112}, {113}, {114}, {115}, {116}, {117}, {118}, 119..120];
optt_mach = [1, 11, 2, 3, 4, 5, 6, 7, 8, 12, 9, 10, 1, 11, 3, 5, 10, 4, 2, 7, 6, 8, 12, 9, 2, 1, 11, 4, 3, 9, 6, 8, 12, 7, 10, 5, 2, 3, 1, 11, 5, 7, 9, 8, 12, 4, 10, 6, 3, 1, 11, 2, 6, 4, 5, 9, 8, 12, 10, 7, 3, 2, 6, 4, 9, 10, 1, 11, 7, 5, 8, 12, 2, 1, 11, 4, 3, 7, 6, 10, 9, 8, 12, 5, 3, 1, 11, 2, 6, 5, 7, 9, 10, 8, 12, 4, 1, 11, 2, 4, 6, 3, 10, 7, 8, 12, 5, 9, 2, 1, 11, 3, 7, 9, 10, 6, 4, 5, 8, 12];
optt_dur = [29, 29, 78, 9, 36, 49, 11, 62, 56, 56, 44, 21, 43, 43, 90, 75, 11, 69, 28, 46, 46, 72, 72, 30, 91, 85, 85, 39, 74, 90, 10, 12, 12, 89, 45, 33, 81, 95, 71, 71, 99, 9, 52, 85, 85, 98, 22, 43, 14, 6, 6, 22, 61, 26, 69, 21, 49, 49, 72, 53, 84, 2, 52, 95, 48, 72, 47, 47, 65, 6, 25, 25, 46, 37, 37, 61, 13, 32, 21, 32, 89, 30, 30, 55, 31, 86, 86, 46, 74, 32, 88, 19, 48, 36, 36, 79, 76, 76, 69, 76, 51, 85, 11, 40, 89, 89, 26, 74, 85, 13, 13, 61, 7, 64, 76, 47, 52, 90, 45, 45];

first_day_of_schedule = "17.08.2026";
first_shift_start_time = ["06:30"];
task_desc = ["Cięcie", "Toczenie", "Frezowanie", "Wiercenie", "Szlifowanie", "Spawanie", "Gięcie", "Montaż części", "Kontrola jakości", "Pakowanie", "Cięcie", "Toczenie", "Frezowanie", "Wiercenie", "Szlifowanie", "Spawanie", "Gięcie", "Montaż części", "Kontrola jakości", "Pakowanie", "Cięcie", "Toczenie", "Frezowanie", "Wiercenie", "Szlifowanie", "Spawanie", "Gięcie", "Montaż części", "Kontrola jakości", "Pakowanie", "Cięcie", "Toczenie", "Frezowanie", "Wiercenie", "Szlifowanie", "Spawanie", "Gięcie", "Montaż części", "Kontrola jakości", "Pakowanie", "Cięcie", "Toczenie", "Frezowanie", "Wiercenie", "Szlifowanie", "Spawanie", "Gięcie", "Montaż części", "Kontrola jakości", "Pakowanie", "Cięcie", "Toczenie", "Frezowanie", "Wiercenie", "Szlifowanie", "Spawanie", "Gięcie", "Montaż części", "Kontrola jakości", "Pakowanie", "Cięcie", "Toczenie", "Frezowanie", "Wiercenie", "Szlifowanie", "Spawanie", "Gięcie", "Montaż części", "Kontrola jakości", "Pakowanie", "Cięcie", "Toczenie", "Frezowanie", "Wiercenie", "Szlifowanie", "Spawanie", "Gięcie", "Montaż części", "Kontrola jakości", "Pakowanie", "Cięcie", "Toczenie", "Frezowanie", "Wiercenie", "Szlifowanie", "Spawanie", "Gięcie", "Montaż części", "Kontrola jakości", "Pakowanie", "Cięcie", "Toczenie", "Frezowanie", "Wiercenie", "Szlifowanie", "Spawanie", "Gięcie", "Montaż części", "Kontrola jakości", "Pakowanie"];
task_opno = ["10", "20", "30", "40", "50", "60", "70", "80", "90", "100", "10", "20", "30", "40", "50", "60", "70", "80", "90", "100", "10", "20", "30", "40", "50", "60", "70", "80", "90", "100", "10", "20", "30", "40", "50", "60", "70", "80", "90", "100", "10", "20", "30", "40", "50", "60", "70", "80", "90", "100", "10", "20", "30", "40", "50", "60", "70", "80", "90", "100", "10", "20", "30", "40", "50", "60", "70", "80", "90", "100", "10", "20", "30", "40", "50", "60", "70", "80", "90", "100", "10", "20", "30", "40", "50", "60", "70", "80", "90", "100", "10", "20", "30", "40", "50", "60", "70", "80", "90", "100"];
machine_desc = ["Piła taśmowa", "Tokarka CNC", "Frezarka CNC", "Wiertarka pionowa", "Prasa krawędziowa", "Robot spawalniczy", "Szlifierka płaszczyzn", "Linia lakiernicza", "Stanowisko montażu", "Gniazdo nitowania", "Wytaczarka CNC", "Stanowisko pomiarowe"];
job_desc = ["MED10-001 100 sz", "MED10-002 200 sz", "MED10-003 300 sz", "MED10-004 400 sz", "MED10-005 500 sz", "MED10-006 600 sz", "MED10-007 700 sz", "MED10-008 800 sz", "MED10-009 900 sz", "MED10-010 1000 sz"];