MyEMS /
myems
| @@ 3557-3597 (lines=41) @@ | ||
| 3554 | rows_parameters = cursor.fetchall() |
|
| 3555 | ||
| 3556 | parameter_result = list() |
|
| 3557 | if rows_parameters is not None and len(rows_parameters) > 0: |
|
| 3558 | for row in rows_parameters: |
|
| 3559 | constant = None |
|
| 3560 | point = None |
|
| 3561 | numerator_meter = None |
|
| 3562 | denominator_meter = None |
|
| 3563 | if row[2] == 'point': |
|
| 3564 | point = point_dict.get(row[4], None) |
|
| 3565 | constant = None |
|
| 3566 | numerator_meter = None |
|
| 3567 | denominator_meter = None |
|
| 3568 | elif row[2] == 'constant': |
|
| 3569 | constant = row[3] |
|
| 3570 | point = None |
|
| 3571 | numerator_meter = None |
|
| 3572 | denominator_meter = None |
|
| 3573 | elif row[2] == 'fraction': |
|
| 3574 | constant = None |
|
| 3575 | point = None |
|
| 3576 | # find numerator meter by uuid |
|
| 3577 | numerator_meter = meter_dict.get(row[5], None) |
|
| 3578 | if numerator_meter is None: |
|
| 3579 | numerator_meter = virtual_meter_dict.get(row[5], None) |
|
| 3580 | if numerator_meter is None: |
|
| 3581 | numerator_meter = offline_meter_dict.get(row[5], None) |
|
| 3582 | # find denominator meter by uuid |
|
| 3583 | denominator_meter = meter_dict.get(row[6], None) |
|
| 3584 | if denominator_meter is None: |
|
| 3585 | denominator_meter = virtual_meter_dict.get(row[6], None) |
|
| 3586 | if denominator_meter is None: |
|
| 3587 | denominator_meter = offline_meter_dict.get(row[6], None) |
|
| 3588 | ||
| 3589 | result = {"id": row[0], |
|
| 3590 | "name": row[1], |
|
| 3591 | "parameter_type": row[2], |
|
| 3592 | "constant": constant, |
|
| 3593 | "point": point, |
|
| 3594 | "numerator_meter": numerator_meter, |
|
| 3595 | "denominator_meter": denominator_meter} |
|
| 3596 | parameter_result.append(result) |
|
| 3597 | meta_result['parameters'] = parameter_result |
|
| 3598 | timezone_offset = int(config.utc_offset[1:3]) * 60 + int(config.utc_offset[4:6]) |
|
| 3599 | if config.utc_offset[0] == '-': |
|
| 3600 | timezone_offset = -timezone_offset |
|
| @@ 2886-2926 (lines=41) @@ | ||
| 2883 | rows_parameters = cursor.fetchall() |
|
| 2884 | ||
| 2885 | parameter_result = list() |
|
| 2886 | if rows_parameters is not None and len(rows_parameters) > 0: |
|
| 2887 | for row in rows_parameters: |
|
| 2888 | constant = None |
|
| 2889 | point = None |
|
| 2890 | numerator_meter = None |
|
| 2891 | denominator_meter = None |
|
| 2892 | if row[2] == 'point': |
|
| 2893 | point = point_dict.get(row[4], None) |
|
| 2894 | constant = None |
|
| 2895 | numerator_meter = None |
|
| 2896 | denominator_meter = None |
|
| 2897 | elif row[2] == 'constant': |
|
| 2898 | constant = row[3] |
|
| 2899 | point = None |
|
| 2900 | numerator_meter = None |
|
| 2901 | denominator_meter = None |
|
| 2902 | elif row[2] == 'fraction': |
|
| 2903 | constant = None |
|
| 2904 | point = None |
|
| 2905 | # find numerator meter by uuid |
|
| 2906 | numerator_meter = meter_dict.get(row[5], None) |
|
| 2907 | if numerator_meter is None: |
|
| 2908 | numerator_meter = virtual_meter_dict.get(row[5], None) |
|
| 2909 | if numerator_meter is None: |
|
| 2910 | numerator_meter = offline_meter_dict.get(row[5], None) |
|
| 2911 | # find denominator meter by uuid |
|
| 2912 | denominator_meter = meter_dict.get(row[6], None) |
|
| 2913 | if denominator_meter is None: |
|
| 2914 | denominator_meter = virtual_meter_dict.get(row[6], None) |
|
| 2915 | if denominator_meter is None: |
|
| 2916 | denominator_meter = offline_meter_dict.get(row[6], None) |
|
| 2917 | ||
| 2918 | result = {"id": row[0], |
|
| 2919 | "name": row[1], |
|
| 2920 | "parameter_type": row[2], |
|
| 2921 | "constant": constant, |
|
| 2922 | "point": point, |
|
| 2923 | "numerator_meter": numerator_meter, |
|
| 2924 | "denominator_meter": denominator_meter} |
|
| 2925 | parameter_result.append(result) |
|
| 2926 | meta_result['parameters'] = parameter_result |
|
| 2927 | ||
| 2928 | cursor.close() |
|
| 2929 | cnx.close() |
|
| @@ 2957-2997 (lines=41) @@ | ||
| 2954 | rows_parameters = cursor.fetchall() |
|
| 2955 | ||
| 2956 | parameters_result = list() |
|
| 2957 | if rows_parameters is not None and len(rows_parameters) > 0: |
|
| 2958 | for row in rows_parameters: |
|
| 2959 | constant = None |
|
| 2960 | point = None |
|
| 2961 | numerator_meter = None |
|
| 2962 | denominator_meter = None |
|
| 2963 | if row[2] == 'point': |
|
| 2964 | point = point_dict.get(row[4], None) |
|
| 2965 | constant = None |
|
| 2966 | numerator_meter = None |
|
| 2967 | denominator_meter = None |
|
| 2968 | elif row[2] == 'constant': |
|
| 2969 | constant = row[3] |
|
| 2970 | point = None |
|
| 2971 | numerator_meter = None |
|
| 2972 | denominator_meter = None |
|
| 2973 | elif row[2] == 'fraction': |
|
| 2974 | constant = None |
|
| 2975 | point = None |
|
| 2976 | # find numerator meter by uuid |
|
| 2977 | numerator_meter = meter_dict.get(row[5], None) |
|
| 2978 | if numerator_meter is None: |
|
| 2979 | numerator_meter = virtual_meter_dict.get(row[5], None) |
|
| 2980 | if numerator_meter is None: |
|
| 2981 | numerator_meter = offline_meter_dict.get(row[5], None) |
|
| 2982 | # find denominator meter by uuid |
|
| 2983 | denominator_meter = meter_dict.get(row[6], None) |
|
| 2984 | if denominator_meter is None: |
|
| 2985 | denominator_meter = virtual_meter_dict.get(row[6], None) |
|
| 2986 | if denominator_meter is None: |
|
| 2987 | denominator_meter = offline_meter_dict.get(row[6], None) |
|
| 2988 | ||
| 2989 | result = {"id": row[0], |
|
| 2990 | "name": row[1], |
|
| 2991 | "parameter_type": row[2], |
|
| 2992 | "constant": constant, |
|
| 2993 | "point": point, |
|
| 2994 | "numerator_meter": numerator_meter, |
|
| 2995 | "denominator_meter": denominator_meter} |
|
| 2996 | parameters_result.append(result) |
|
| 2997 | meta_result['parameters'] = parameters_result |
|
| 2998 | timezone_offset = int(config.utc_offset[1:3]) * 60 + int(config.utc_offset[4:6]) |
|
| 2999 | if config.utc_offset[0] == '-': |
|
| 3000 | timezone_offset = -timezone_offset |
|
| @@ 2359-2399 (lines=41) @@ | ||
| 2356 | rows_parameters = cursor.fetchall() |
|
| 2357 | ||
| 2358 | parameters_result = list() |
|
| 2359 | if rows_parameters is not None and len(rows_parameters) > 0: |
|
| 2360 | for row in rows_parameters: |
|
| 2361 | constant = None |
|
| 2362 | point = None |
|
| 2363 | numerator_meter = None |
|
| 2364 | denominator_meter = None |
|
| 2365 | if row[2] == 'point': |
|
| 2366 | point = point_dict.get(row[4], None) |
|
| 2367 | constant = None |
|
| 2368 | numerator_meter = None |
|
| 2369 | denominator_meter = None |
|
| 2370 | elif row[2] == 'constant': |
|
| 2371 | constant = row[3] |
|
| 2372 | point = None |
|
| 2373 | numerator_meter = None |
|
| 2374 | denominator_meter = None |
|
| 2375 | elif row[2] == 'fraction': |
|
| 2376 | constant = None |
|
| 2377 | point = None |
|
| 2378 | # find numerator meter by uuid |
|
| 2379 | numerator_meter = meter_dict.get(row[5], None) |
|
| 2380 | if numerator_meter is None: |
|
| 2381 | numerator_meter = virtual_meter_dict.get(row[5], None) |
|
| 2382 | if numerator_meter is None: |
|
| 2383 | numerator_meter = offline_meter_dict.get(row[5], None) |
|
| 2384 | # find denominator meter by uuid |
|
| 2385 | denominator_meter = meter_dict.get(row[6], None) |
|
| 2386 | if denominator_meter is None: |
|
| 2387 | denominator_meter = virtual_meter_dict.get(row[6], None) |
|
| 2388 | if denominator_meter is None: |
|
| 2389 | denominator_meter = offline_meter_dict.get(row[6], None) |
|
| 2390 | ||
| 2391 | result = {"id": row[0], |
|
| 2392 | "name": row[1], |
|
| 2393 | "parameter_type": row[2], |
|
| 2394 | "constant": constant, |
|
| 2395 | "point": point, |
|
| 2396 | "numerator_meter": numerator_meter, |
|
| 2397 | "denominator_meter": denominator_meter} |
|
| 2398 | parameters_result.append(result) |
|
| 2399 | meta_result['parameters'] = parameters_result |
|
| 2400 | ||
| 2401 | cursor.close() |
|
| 2402 | cnx.close() |
|
| @@ 742-782 (lines=41) @@ | ||
| 739 | last_index = 0 |
|
| 740 | is_finish_get_data = False |
|
| 741 | result = list() |
|
| 742 | if rows_parameters is not None and len(rows_parameters) > 0: |
|
| 743 | for row in rows_parameters: |
|
| 744 | constant = None |
|
| 745 | point = None |
|
| 746 | numerator_meter = None |
|
| 747 | denominator_meter = None |
|
| 748 | if row[2] == 'point': |
|
| 749 | point = point_dict.get(row[4], None) |
|
| 750 | constant = None |
|
| 751 | numerator_meter = None |
|
| 752 | denominator_meter = None |
|
| 753 | elif row[2] == 'constant': |
|
| 754 | constant = row[3] |
|
| 755 | point = None |
|
| 756 | numerator_meter = None |
|
| 757 | denominator_meter = None |
|
| 758 | elif row[2] == 'fraction': |
|
| 759 | constant = None |
|
| 760 | point = None |
|
| 761 | # find numerator meter by uuid |
|
| 762 | numerator_meter = meter_dict.get(row[5], None) |
|
| 763 | if numerator_meter is None: |
|
| 764 | numerator_meter = virtual_meter_dict.get(row[5], None) |
|
| 765 | if numerator_meter is None: |
|
| 766 | numerator_meter = offline_meter_dict.get(row[5], None) |
|
| 767 | # find denominator meter by uuid |
|
| 768 | denominator_meter = meter_dict.get(row[6], None) |
|
| 769 | if denominator_meter is None: |
|
| 770 | denominator_meter = virtual_meter_dict.get(row[6], None) |
|
| 771 | if denominator_meter is None: |
|
| 772 | denominator_meter = offline_meter_dict.get(row[6], None) |
|
| 773 | ||
| 774 | meta_result = {"id": row[0], |
|
| 775 | "name": row[1], |
|
| 776 | "parameter_type": row[2], |
|
| 777 | "constant": constant, |
|
| 778 | "point": point, |
|
| 779 | "numerator_meter": numerator_meter, |
|
| 780 | "denominator_meter": denominator_meter} |
|
| 781 | result.append(meta_result) |
|
| 782 | last_index = meta_result['id'] |
|
| 783 | ||
| 784 | cursor.close() |
|
| 785 | cnx.close() |
|
