diff options
author | Gustavo Duarte <gustavo@GusHP.(none)> | 2013-04-01 14:58:22 (GMT) |
---|---|---|
committer | Gustavo Duarte <gustavo@GusHP.(none)> | 2013-04-01 14:58:22 (GMT) |
commit | fad4ec50ee9040f96cd242abec55016e7f8f55cf (patch) | |
tree | 98f5b1d9fae8f879f8db15138e31a463f980f214 | |
parent | e6843750df1e81a1894a3a10a0879756beca8a3a (diff) |
+ Ordering files tasks
+ Add stats-consolidation.cron as sample file for cron configuration.
-rw-r--r-- | docs/mer.dia | bin | 0 -> 3112 bytes | |||
-rw-r--r-- | docs/mer.jpeg | 1379 | ||||
-rw-r--r-- | docs/mer.png | bin | 0 -> 20006 bytes | |||
-rw-r--r-- | sql/proc_get_act_most_used.sql | 17 | ||||
-rw-r--r-- | src/__init__.py (renamed from sugar_stats_consolidation/__init__.py) | 0 | ||||
-rw-r--r-- | src/build/lib.linux-x86_64-2.7/stats_consolidation/__init__.py (renamed from sugar_stats_consolidation/build/lib.linux-x86_64-2.7/stats_consolidation/__init__.py) | 0 | ||||
-rw-r--r-- | src/build/lib.linux-x86_64-2.7/stats_consolidation/consolidation.py (renamed from sugar_stats_consolidation/build/lib.linux-x86_64-2.7/stats_consolidation/consolidation.py) | 0 | ||||
-rw-r--r-- | src/build/lib.linux-x86_64-2.7/stats_consolidation/db.py (renamed from sugar_stats_consolidation/build/lib.linux-x86_64-2.7/stats_consolidation/db.py) | 0 | ||||
-rw-r--r-- | src/build/lib.linux-x86_64-2.7/stats_consolidation/rrd_files.py (renamed from sugar_stats_consolidation/build/lib.linux-x86_64-2.7/stats_consolidation/rrd_files.py) | 0 | ||||
-rw-r--r-- | src/build/lib.linux-x86_64-2.7/stats_consolidation/setup.py (renamed from sugar_stats_consolidation/build/lib.linux-x86_64-2.7/stats_consolidation/setup.py) | 0 | ||||
-rw-r--r-- | src/build/lib.linux-x86_64-2.7/stats_consolidation/test_cons.py (renamed from sugar_stats_consolidation/build/lib.linux-x86_64-2.7/stats_consolidation/test_cons.py) | 0 | ||||
-rw-r--r-- | src/build/lib.linux-x86_64-2.7/stats_consolidation/test_db.py (renamed from sugar_stats_consolidation/build/lib.linux-x86_64-2.7/stats_consolidation/test_db.py) | 0 | ||||
-rw-r--r-- | src/build/lib.linux-x86_64-2.7/stats_consolidation/test_rrd.py (renamed from sugar_stats_consolidation/build/lib.linux-x86_64-2.7/stats_consolidation/test_rrd.py) | 0 | ||||
-rw-r--r-- | src/consolidation.py (renamed from sugar_stats_consolidation/consolidation.py) | 0 | ||||
-rwxr-xr-x | src/consolidation_run (renamed from sugar_stats_consolidation/consolidation_run) | 0 | ||||
-rw-r--r-- | src/db.py (renamed from sugar_stats_consolidation/db.py) | 0 | ||||
-rw-r--r-- | src/rrd_files.py (renamed from sugar_stats_consolidation/rrd_files.py) | 0 | ||||
-rwxr-xr-x | src/run.sh (renamed from sugar_stats_consolidation/run.sh) | 0 | ||||
-rw-r--r-- | stats-consolidation.cron | 4 |
19 files changed, 1400 insertions, 0 deletions
diff --git a/docs/mer.dia b/docs/mer.dia Binary files differnew file mode 100644 index 0000000..f6f4ea0 --- /dev/null +++ b/docs/mer.dia diff --git a/docs/mer.jpeg b/docs/mer.jpeg new file mode 100644 index 0000000..cebda66 --- /dev/null +++ b/docs/mer.jpeg @@ -0,0 +1,1379 @@ +<?xml version="1.0" encoding="UTF-8"?> +<dia:diagram xmlns:dia="http://www.lysator.liu.se/~alla/dia/"> + <dia:diagramdata> + <dia:attribute name="background"> + <dia:color val="#ffffff"/> + </dia:attribute> + <dia:attribute name="pagebreak"> + <dia:color val="#000099"/> + </dia:attribute> + <dia:attribute name="paper"> + <dia:composite type="paper"> + <dia:attribute name="name"> + <dia:string>#A4#</dia:string> + </dia:attribute> + <dia:attribute name="tmargin"> + <dia:real val="2.8222000598907471"/> + </dia:attribute> + <dia:attribute name="bmargin"> + <dia:real val="2.8222000598907471"/> + </dia:attribute> + <dia:attribute name="lmargin"> + <dia:real val="2.8222000598907471"/> + </dia:attribute> + <dia:attribute name="rmargin"> + <dia:real val="2.8222000598907471"/> + </dia:attribute> + <dia:attribute name="is_portrait"> + <dia:boolean val="true"/> + </dia:attribute> + <dia:attribute name="scaling"> + <dia:real val="1"/> + </dia:attribute> + <dia:attribute name="fitto"> + <dia:boolean val="false"/> + </dia:attribute> + </dia:composite> + </dia:attribute> + <dia:attribute name="grid"> + <dia:composite type="grid"> + <dia:attribute name="width_x"> + <dia:real val="1"/> + </dia:attribute> + <dia:attribute name="width_y"> + <dia:real val="1"/> + </dia:attribute> + <dia:attribute name="visible_x"> + <dia:int val="1"/> + </dia:attribute> + <dia:attribute name="visible_y"> + <dia:int val="1"/> + </dia:attribute> + <dia:composite type="color"/> + </dia:composite> + </dia:attribute> + <dia:attribute name="color"> + <dia:color val="#d8e5e5"/> + </dia:attribute> + <dia:attribute name="guides"> + <dia:composite type="guides"> + <dia:attribute name="hguides"/> + <dia:attribute name="vguides"/> + </dia:composite> + </dia:attribute> + </dia:diagramdata> + <dia:layer name="Background" visible="true" active="true"> + <dia:object type="ER - Entity" version="0" id="O0"> + <dia:attribute name="obj_pos"> + <dia:point val="9.22343,12.7401"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="9.18343,12.7001;12.7759,14.662"/> + </dia:attribute> + <dia:attribute name="elem_corner"> + <dia:point val="9.22343,12.7401"/> + </dia:attribute> + <dia:attribute name="elem_width"> + <dia:real val="3.5124999999999997"/> + </dia:attribute> + <dia:attribute name="elem_height"> + <dia:real val="1.8819444105029106"/> + </dia:attribute> + <dia:attribute name="border_width"> + <dia:real val="0.079999998211860657"/> + </dia:attribute> + <dia:attribute name="border_color"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="inner_color"> + <dia:color val="#ffffff"/> + </dia:attribute> + <dia:attribute name="name"> + <dia:string>#Usage#</dia:string> + </dia:attribute> + <dia:attribute name="weak"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="associative"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="font"> + <dia:font family="monospace" style="0" name="Courier"/> + </dia:attribute> + <dia:attribute name="font_height"> + <dia:real val="0.88194441050291061"/> + </dia:attribute> + </dia:object> + <dia:object type="ER - Attribute" version="0" id="O1"> + <dia:attribute name="obj_pos"> + <dia:point val="0.911129,8.53643"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="0.886129,8.51143;7.66113,10.267"/> + </dia:attribute> + <dia:attribute name="elem_corner"> + <dia:point val="0.911129,8.53643"/> + </dia:attribute> + <dia:attribute name="elem_width"> + <dia:real val="6.7249999999999996"/> + </dia:attribute> + <dia:attribute name="elem_height"> + <dia:real val="1.7055555284023285"/> + </dia:attribute> + <dia:attribute name="border_width"> + <dia:real val="0.05000000074505806"/> + </dia:attribute> + <dia:attribute name="border_color"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="inner_color"> + <dia:color val="#ffffff"/> + </dia:attribute> + <dia:attribute name="name"> + <dia:string>#ts (TimeStamp)#</dia:string> + </dia:attribute> + <dia:attribute name="key"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="weak_key"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="derived"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="multivalued"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="font"> + <dia:font family="monospace" style="0" name="Courier"/> + </dia:attribute> + <dia:attribute name="font_height"> + <dia:real val="0.70555552840232849"/> + </dia:attribute> + </dia:object> + <dia:object type="ER - Attribute" version="0" id="O2"> + <dia:attribute name="obj_pos"> + <dia:point val="1.09593,10.6098"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="1.07093,10.5848;6.49593,12.3403"/> + </dia:attribute> + <dia:attribute name="elem_corner"> + <dia:point val="1.09593,10.6098"/> + </dia:attribute> + <dia:attribute name="elem_width"> + <dia:real val="5.375"/> + </dia:attribute> + <dia:attribute name="elem_height"> + <dia:real val="1.7055555284023285"/> + </dia:attribute> + <dia:attribute name="border_width"> + <dia:real val="0.05000000074505806"/> + </dia:attribute> + <dia:attribute name="border_color"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="inner_color"> + <dia:color val="#ffffff"/> + </dia:attribute> + <dia:attribute name="name"> + <dia:string>#user_hash #</dia:string> + </dia:attribute> + <dia:attribute name="key"> + <dia:boolean val="true"/> + </dia:attribute> + <dia:attribute name="weak_key"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="derived"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="multivalued"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="font"> + <dia:font family="monospace" style="0" name="Courier"/> + </dia:attribute> + <dia:attribute name="font_height"> + <dia:real val="0.70555552840232849"/> + </dia:attribute> + </dia:object> + <dia:object type="ER - Attribute" version="0" id="O3"> + <dia:attribute name="obj_pos"> + <dia:point val="0.956518,12.7155"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="0.931518,12.6905;6.35652,14.446"/> + </dia:attribute> + <dia:attribute name="elem_corner"> + <dia:point val="0.956518,12.7155"/> + </dia:attribute> + <dia:attribute name="elem_width"> + <dia:real val="5.375"/> + </dia:attribute> + <dia:attribute name="elem_height"> + <dia:real val="1.7055555284023285"/> + </dia:attribute> + <dia:attribute name="border_width"> + <dia:real val="0.05000000074505806"/> + </dia:attribute> + <dia:attribute name="border_color"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="inner_color"> + <dia:color val="#ffffff"/> + </dia:attribute> + <dia:attribute name="name"> + <dia:string>#start_date#</dia:string> + </dia:attribute> + <dia:attribute name="key"> + <dia:boolean val="true"/> + </dia:attribute> + <dia:attribute name="weak_key"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="derived"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="multivalued"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="font"> + <dia:font family="monospace" style="0" name="Courier"/> + </dia:attribute> + <dia:attribute name="font_height"> + <dia:real val="0.70555552840232849"/> + </dia:attribute> + </dia:object> + <dia:object type="ER - Attribute" version="0" id="O4"> + <dia:attribute name="obj_pos"> + <dia:point val="0.88195,15.0263"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="0.85695,15.0013;7.29445,16.7568"/> + </dia:attribute> + <dia:attribute name="elem_corner"> + <dia:point val="0.88195,15.0263"/> + </dia:attribute> + <dia:attribute name="elem_width"> + <dia:real val="6.3875000000000002"/> + </dia:attribute> + <dia:attribute name="elem_height"> + <dia:real val="1.7055555284023285"/> + </dia:attribute> + <dia:attribute name="border_width"> + <dia:real val="0.05000000074505806"/> + </dia:attribute> + <dia:attribute name="border_color"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="inner_color"> + <dia:color val="#ffffff"/> + </dia:attribute> + <dia:attribute name="name"> + <dia:string>#resource_name#</dia:string> + </dia:attribute> + <dia:attribute name="key"> + <dia:boolean val="true"/> + </dia:attribute> + <dia:attribute name="weak_key"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="derived"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="multivalued"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="font"> + <dia:font family="monospace" style="0" name="Courier"/> + </dia:attribute> + <dia:attribute name="font_height"> + <dia:real val="0.70555552840232849"/> + </dia:attribute> + </dia:object> + <dia:object type="ER - Attribute" version="0" id="O5"> + <dia:attribute name="obj_pos"> + <dia:point val="1.68363,17.8847"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="1.65863,17.8597;6.74613,19.6153"/> + </dia:attribute> + <dia:attribute name="elem_corner"> + <dia:point val="1.68363,17.8847"/> + </dia:attribute> + <dia:attribute name="elem_width"> + <dia:real val="5.0374999999999996"/> + </dia:attribute> + <dia:attribute name="elem_height"> + <dia:real val="1.7055555284023285"/> + </dia:attribute> + <dia:attribute name="border_width"> + <dia:real val="0.05000000074505806"/> + </dia:attribute> + <dia:attribute name="border_color"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="inner_color"> + <dia:color val="#ffffff"/> + </dia:attribute> + <dia:attribute name="name"> + <dia:string>#data_type#</dia:string> + </dia:attribute> + <dia:attribute name="key"> + <dia:boolean val="true"/> + </dia:attribute> + <dia:attribute name="weak_key"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="derived"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="multivalued"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="font"> + <dia:font family="monospace" style="0" name="Courier"/> + </dia:attribute> + <dia:attribute name="font_height"> + <dia:real val="0.70555552840232849"/> + </dia:attribute> + </dia:object> + <dia:object type="Standard - Line" version="0" id="O6"> + <dia:attribute name="obj_pos"> + <dia:point val="7.63613,9.38921"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="7.60104,9.35413;10.2503,12.7348"/> + </dia:attribute> + <dia:attribute name="conn_endpoints"> + <dia:point val="7.63613,9.38921"/> + <dia:point val="10.2152,12.6998"/> + </dia:attribute> + <dia:attribute name="numcp"> + <dia:int val="1"/> + </dia:attribute> + <dia:attribute name="line_width"> + <dia:real val="0.05000000074505806"/> + </dia:attribute> + <dia:connections> + <dia:connection handle="0" to="O1" connection="4"/> + <dia:connection handle="1" to="O0" connection="8"/> + </dia:connections> + </dia:object> + <dia:object type="Standard - Line" version="0" id="O7"> + <dia:attribute name="obj_pos"> + <dia:point val="5.4572,12.1451"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="5.42461,12.1125;9.25602,13.7136"/> + </dia:attribute> + <dia:attribute name="conn_endpoints"> + <dia:point val="5.4572,12.1451"/> + <dia:point val="9.22343,13.681"/> + </dia:attribute> + <dia:attribute name="numcp"> + <dia:int val="1"/> + </dia:attribute> + <dia:attribute name="line_width"> + <dia:real val="0.05000000074505806"/> + </dia:attribute> + <dia:connections> + <dia:connection handle="0" to="O2" connection="8"/> + <dia:connection handle="1" to="O0" connection="3"/> + </dia:connections> + </dia:object> + <dia:object type="Standard - Line" version="0" id="O8"> + <dia:attribute name="obj_pos"> + <dia:point val="6.3528,13.6099"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="6.32742,13.5845;9.20965,13.6788"/> + </dia:attribute> + <dia:attribute name="conn_endpoints"> + <dia:point val="6.3528,13.6099"/> + <dia:point val="9.18427,13.6534"/> + </dia:attribute> + <dia:attribute name="numcp"> + <dia:int val="1"/> + </dia:attribute> + <dia:attribute name="line_width"> + <dia:real val="0.05000000074505806"/> + </dia:attribute> + <dia:connections> + <dia:connection handle="0" to="O3" connection="8"/> + <dia:connection handle="1" to="O0" connection="8"/> + </dia:connections> + </dia:object> + <dia:object type="Standard - Line" version="0" id="O9"> + <dia:attribute name="obj_pos"> + <dia:point val="6.1388,15.2222"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="6.1074,14.2211;9.21598,15.2536"/> + </dia:attribute> + <dia:attribute name="conn_endpoints"> + <dia:point val="6.1388,15.2222"/> + <dia:point val="9.18458,14.2525"/> + </dia:attribute> + <dia:attribute name="numcp"> + <dia:int val="1"/> + </dia:attribute> + <dia:attribute name="line_width"> + <dia:real val="0.05000000074505806"/> + </dia:attribute> + <dia:connections> + <dia:connection handle="0" to="O4" connection="8"/> + <dia:connection handle="1" to="O0" connection="8"/> + </dia:connections> + </dia:object> + <dia:object type="Standard - Line" version="0" id="O10"> + <dia:attribute name="obj_pos"> + <dia:point val="5.26341,17.9459"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="5.22842,14.6268;9.70008,17.9809"/> + </dia:attribute> + <dia:attribute name="conn_endpoints"> + <dia:point val="5.26341,17.9459"/> + <dia:point val="9.66509,14.6618"/> + </dia:attribute> + <dia:attribute name="numcp"> + <dia:int val="1"/> + </dia:attribute> + <dia:attribute name="line_width"> + <dia:real val="0.05000000074505806"/> + </dia:attribute> + <dia:connections> + <dia:connection handle="0" to="O5" connection="8"/> + <dia:connection handle="1" to="O0" connection="8"/> + </dia:connections> + </dia:object> + <dia:object type="ER - Relationship" version="0" id="O11"> + <dia:attribute name="obj_pos"> + <dia:point val="14.3649,12.3703"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="14.0249,12.3303;19.2399,15.1313"/> + </dia:attribute> + <dia:attribute name="elem_corner"> + <dia:point val="14.3649,12.3703"/> + </dia:attribute> + <dia:attribute name="elem_width"> + <dia:real val="4.5350000000000001"/> + </dia:attribute> + <dia:attribute name="elem_height"> + <dia:real val="2.7210000000000001"/> + </dia:attribute> + <dia:attribute name="border_width"> + <dia:real val="0.079999998211860657"/> + </dia:attribute> + <dia:attribute name="border_color"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="inner_color"> + <dia:color val="#ffffff"/> + </dia:attribute> + <dia:attribute name="name"> + <dia:string>#Record#</dia:string> + </dia:attribute> + <dia:attribute name="left_card"> + <dia:string>##</dia:string> + </dia:attribute> + <dia:attribute name="right_card"> + <dia:string>##</dia:string> + </dia:attribute> + <dia:attribute name="identifying"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="rotated"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="font"> + <dia:font family="monospace" style="0" name="Courier"/> + </dia:attribute> + <dia:attribute name="font_height"> + <dia:real val="0.88194441050291061"/> + </dia:attribute> + </dia:object> + <dia:object type="Standard - Line" version="0" id="O12"> + <dia:attribute name="obj_pos"> + <dia:point val="12.7751,13.6969"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="12.7499,13.6716;14.3498,13.7357"/> + </dia:attribute> + <dia:attribute name="conn_endpoints"> + <dia:point val="12.7751,13.6969"/> + <dia:point val="14.3246,13.7105"/> + </dia:attribute> + <dia:attribute name="numcp"> + <dia:int val="1"/> + </dia:attribute> + <dia:attribute name="line_width"> + <dia:real val="0.05000000074505806"/> + </dia:attribute> + <dia:connections> + <dia:connection handle="0" to="O0" connection="8"/> + <dia:connection handle="1" to="O11" connection="8"/> + </dia:connections> + </dia:object> + <dia:object type="ER - Entity" version="0" id="O13"> + <dia:attribute name="obj_pos"> + <dia:point val="19.9528,12.677"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="19.9128,12.637;24.7728,14.5989"/> + </dia:attribute> + <dia:attribute name="elem_corner"> + <dia:point val="19.9528,12.677"/> + </dia:attribute> + <dia:attribute name="elem_width"> + <dia:real val="4.7799999999999994"/> + </dia:attribute> + <dia:attribute name="elem_height"> + <dia:real val="1.8819444105029106"/> + </dia:attribute> + <dia:attribute name="border_width"> + <dia:real val="0.079999998211860657"/> + </dia:attribute> + <dia:attribute name="border_color"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="inner_color"> + <dia:color val="#ffffff"/> + </dia:attribute> + <dia:attribute name="name"> + <dia:string>#Resource#</dia:string> + </dia:attribute> + <dia:attribute name="weak"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="associative"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="font"> + <dia:font family="monospace" style="0" name="Courier"/> + </dia:attribute> + <dia:attribute name="font_height"> + <dia:real val="0.88194441050291061"/> + </dia:attribute> + </dia:object> + <dia:object type="Standard - Line" version="0" id="O14"> + <dia:attribute name="obj_pos"> + <dia:point val="18.9401,13.6852"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="18.9146,13.6405;19.938,13.7107"/> + </dia:attribute> + <dia:attribute name="conn_endpoints"> + <dia:point val="18.9401,13.6852"/> + <dia:point val="19.9125,13.666"/> + </dia:attribute> + <dia:attribute name="numcp"> + <dia:int val="1"/> + </dia:attribute> + <dia:attribute name="line_width"> + <dia:real val="0.05000000074505806"/> + </dia:attribute> + <dia:connections> + <dia:connection handle="0" to="O11" connection="8"/> + <dia:connection handle="1" to="O13" connection="8"/> + </dia:connections> + </dia:object> + <dia:object type="ER - Attribute" version="0" id="O15"> + <dia:attribute name="obj_pos"> + <dia:point val="25.7104,12.753"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="25.6854,12.728;29.4254,14.6599"/> + </dia:attribute> + <dia:attribute name="elem_corner"> + <dia:point val="25.7104,12.753"/> + </dia:attribute> + <dia:attribute name="elem_width"> + <dia:real val="3.6899999999999999"/> + </dia:attribute> + <dia:attribute name="elem_height"> + <dia:real val="1.8819444105029106"/> + </dia:attribute> + <dia:attribute name="border_width"> + <dia:real val="0.05000000074505806"/> + </dia:attribute> + <dia:attribute name="border_color"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="inner_color"> + <dia:color val="#ffffff"/> + </dia:attribute> + <dia:attribute name="name"> + <dia:string>#name#</dia:string> + </dia:attribute> + <dia:attribute name="key"> + <dia:boolean val="true"/> + </dia:attribute> + <dia:attribute name="weak_key"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="derived"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="multivalued"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="font"> + <dia:font family="monospace" style="0" name="Courier"/> + </dia:attribute> + <dia:attribute name="font_height"> + <dia:real val="0.88194441050291061"/> + </dia:attribute> + </dia:object> + <dia:object type="Standard - Line" version="0" id="O16"> + <dia:attribute name="obj_pos"> + <dia:point val="25.6866,13.6667"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="24.7469,13.628;25.712,13.6921"/> + </dia:attribute> + <dia:attribute name="conn_endpoints"> + <dia:point val="25.6866,13.6667"/> + <dia:point val="24.7722,13.6534"/> + </dia:attribute> + <dia:attribute name="numcp"> + <dia:int val="1"/> + </dia:attribute> + <dia:attribute name="line_width"> + <dia:real val="0.05000000074505806"/> + </dia:attribute> + <dia:connections> + <dia:connection handle="0" to="O15" connection="8"/> + <dia:connection handle="1" to="O13" connection="8"/> + </dia:connections> + </dia:object> + <dia:object type="ER - Entity" version="0" id="O17"> + <dia:attribute name="obj_pos"> + <dia:point val="20.73,24.4201"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="20.69,24.3801;23.86,26.3421"/> + </dia:attribute> + <dia:attribute name="elem_corner"> + <dia:point val="20.73,24.4201"/> + </dia:attribute> + <dia:attribute name="elem_width"> + <dia:real val="3.0899999999999999"/> + </dia:attribute> + <dia:attribute name="elem_height"> + <dia:real val="1.8819444105029106"/> + </dia:attribute> + <dia:attribute name="border_width"> + <dia:real val="0.079999998211860657"/> + </dia:attribute> + <dia:attribute name="border_color"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="inner_color"> + <dia:color val="#ffffff"/> + </dia:attribute> + <dia:attribute name="name"> + <dia:string>#User#</dia:string> + </dia:attribute> + <dia:attribute name="weak"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="associative"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="font"> + <dia:font family="monospace" style="0" name="Courier"/> + </dia:attribute> + <dia:attribute name="font_height"> + <dia:real val="0.88194441050291061"/> + </dia:attribute> + </dia:object> + <dia:object type="ER - Attribute" version="0" id="O18"> + <dia:attribute name="obj_pos"> + <dia:point val="10.838,18.5049"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="10.813,18.4799;14.213,20.2355"/> + </dia:attribute> + <dia:attribute name="elem_corner"> + <dia:point val="10.838,18.5049"/> + </dia:attribute> + <dia:attribute name="elem_width"> + <dia:real val="3.3500000000000001"/> + </dia:attribute> + <dia:attribute name="elem_height"> + <dia:real val="1.7055555284023285"/> + </dia:attribute> + <dia:attribute name="border_width"> + <dia:real val="0.05000000074505806"/> + </dia:attribute> + <dia:attribute name="border_color"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="inner_color"> + <dia:color val="#ffffff"/> + </dia:attribute> + <dia:attribute name="name"> + <dia:string>#hash#</dia:string> + </dia:attribute> + <dia:attribute name="key"> + <dia:boolean val="true"/> + </dia:attribute> + <dia:attribute name="weak_key"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="derived"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="multivalued"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="font"> + <dia:font family="monospace" style="0" name="Courier"/> + </dia:attribute> + <dia:attribute name="font_height"> + <dia:real val="0.70555552840232849"/> + </dia:attribute> + </dia:object> + <dia:object type="ER - Attribute" version="0" id="O19"> + <dia:attribute name="obj_pos"> + <dia:point val="11.3709,21.5006"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="11.3459,21.4756;14.7459,23.2312"/> + </dia:attribute> + <dia:attribute name="elem_corner"> + <dia:point val="11.3709,21.5006"/> + </dia:attribute> + <dia:attribute name="elem_width"> + <dia:real val="3.3500000000000001"/> + </dia:attribute> + <dia:attribute name="elem_height"> + <dia:real val="1.7055555284023285"/> + </dia:attribute> + <dia:attribute name="border_width"> + <dia:real val="0.05000000074505806"/> + </dia:attribute> + <dia:attribute name="border_color"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="inner_color"> + <dia:color val="#ffffff"/> + </dia:attribute> + <dia:attribute name="name"> + <dia:string>#uuid#</dia:string> + </dia:attribute> + <dia:attribute name="key"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="weak_key"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="derived"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="multivalued"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="font"> + <dia:font family="monospace" style="0" name="Courier"/> + </dia:attribute> + <dia:attribute name="font_height"> + <dia:real val="0.70555552840232849"/> + </dia:attribute> + </dia:object> + <dia:object type="ER - Attribute" version="0" id="O20"> + <dia:attribute name="obj_pos"> + <dia:point val="10.3815,23.9036"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="10.3565,23.8786;15.7815,25.6342"/> + </dia:attribute> + <dia:attribute name="elem_corner"> + <dia:point val="10.3815,23.9036"/> + </dia:attribute> + <dia:attribute name="elem_width"> + <dia:real val="5.375"/> + </dia:attribute> + <dia:attribute name="elem_height"> + <dia:real val="1.7055555284023285"/> + </dia:attribute> + <dia:attribute name="border_width"> + <dia:real val="0.05000000074505806"/> + </dia:attribute> + <dia:attribute name="border_color"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="inner_color"> + <dia:color val="#ffffff"/> + </dia:attribute> + <dia:attribute name="name"> + <dia:string>#machine_sn#</dia:string> + </dia:attribute> + <dia:attribute name="key"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="weak_key"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="derived"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="multivalued"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="font"> + <dia:font family="monospace" style="0" name="Courier"/> + </dia:attribute> + <dia:attribute name="font_height"> + <dia:real val="0.70555552840232849"/> + </dia:attribute> + </dia:object> + <dia:object type="ER - Attribute" version="0" id="O21"> + <dia:attribute name="obj_pos"> + <dia:point val="11.2935,26.1286"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="11.2685,26.1036;14.586,28.0356"/> + </dia:attribute> + <dia:attribute name="elem_corner"> + <dia:point val="11.2935,26.1286"/> + </dia:attribute> + <dia:attribute name="elem_width"> + <dia:real val="3.2675000000000001"/> + </dia:attribute> + <dia:attribute name="elem_height"> + <dia:real val="1.8819444105029106"/> + </dia:attribute> + <dia:attribute name="border_width"> + <dia:real val="0.05000000074505806"/> + </dia:attribute> + <dia:attribute name="border_color"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="inner_color"> + <dia:color val="#ffffff"/> + </dia:attribute> + <dia:attribute name="name"> + <dia:string>#age#</dia:string> + </dia:attribute> + <dia:attribute name="key"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="weak_key"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="derived"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="multivalued"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="font"> + <dia:font family="monospace" style="0" name="Courier"/> + </dia:attribute> + <dia:attribute name="font_height"> + <dia:real val="0.88194441050291061"/> + </dia:attribute> + </dia:object> + <dia:object type="ER - Attribute" version="0" id="O22"> + <dia:attribute name="obj_pos"> + <dia:point val="10.9421,28.5709"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="10.9171,28.5459;14.9921,30.3015"/> + </dia:attribute> + <dia:attribute name="elem_corner"> + <dia:point val="10.9421,28.5709"/> + </dia:attribute> + <dia:attribute name="elem_width"> + <dia:real val="4.0250000000000004"/> + </dia:attribute> + <dia:attribute name="elem_height"> + <dia:real val="1.7055555284023285"/> + </dia:attribute> + <dia:attribute name="border_width"> + <dia:real val="0.05000000074505806"/> + </dia:attribute> + <dia:attribute name="border_color"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="inner_color"> + <dia:color val="#ffffff"/> + </dia:attribute> + <dia:attribute name="name"> + <dia:string>#school#</dia:string> + </dia:attribute> + <dia:attribute name="key"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="weak_key"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="derived"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="multivalued"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="font"> + <dia:font family="monospace" style="0" name="Courier"/> + </dia:attribute> + <dia:attribute name="font_height"> + <dia:real val="0.70555552840232849"/> + </dia:attribute> + </dia:object> + <dia:object type="Standard - Line" version="0" id="O23"> + <dia:attribute name="obj_pos"> + <dia:point val="13.6025,20.0277"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="13.5681,19.9933;20.7242,24.4206"/> + </dia:attribute> + <dia:attribute name="conn_endpoints"> + <dia:point val="13.6025,20.0277"/> + <dia:point val="20.6898,24.3862"/> + </dia:attribute> + <dia:attribute name="numcp"> + <dia:int val="1"/> + </dia:attribute> + <dia:attribute name="line_width"> + <dia:real val="0.05000000074505806"/> + </dia:attribute> + <dia:connections> + <dia:connection handle="0" to="O18" connection="8"/> + <dia:connection handle="1" to="O17" connection="8"/> + </dia:connections> + </dia:object> + <dia:object type="Standard - Line" version="0" id="O24"> + <dia:attribute name="obj_pos"> + <dia:point val="14.4801,22.8208"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="14.4486,22.7893;20.722,24.8762"/> + </dia:attribute> + <dia:attribute name="conn_endpoints"> + <dia:point val="14.4801,22.8208"/> + <dia:point val="20.6905,24.8447"/> + </dia:attribute> + <dia:attribute name="numcp"> + <dia:int val="1"/> + </dia:attribute> + <dia:attribute name="line_width"> + <dia:real val="0.05000000074505806"/> + </dia:attribute> + <dia:connections> + <dia:connection handle="0" to="O19" connection="8"/> + <dia:connection handle="1" to="O17" connection="8"/> + </dia:connections> + </dia:object> + <dia:object type="Standard - Line" version="0" id="O25"> + <dia:attribute name="obj_pos"> + <dia:point val="15.7259,24.9309"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="15.6993,24.9043;20.7165,25.2836"/> + </dia:attribute> + <dia:attribute name="conn_endpoints"> + <dia:point val="15.7259,24.9309"/> + <dia:point val="20.6899,25.257"/> + </dia:attribute> + <dia:attribute name="numcp"> + <dia:int val="1"/> + </dia:attribute> + <dia:attribute name="line_width"> + <dia:real val="0.05000000074505806"/> + </dia:attribute> + <dia:connections> + <dia:connection handle="0" to="O20" connection="8"/> + <dia:connection handle="1" to="O17" connection="8"/> + </dia:connections> + </dia:object> + <dia:object type="Standard - Line" version="0" id="O26"> + <dia:attribute name="obj_pos"> + <dia:point val="14.5094,26.7804"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="14.4803,25.6217;20.7189,26.8095"/> + </dia:attribute> + <dia:attribute name="conn_endpoints"> + <dia:point val="14.5094,26.7804"/> + <dia:point val="20.6898,25.6508"/> + </dia:attribute> + <dia:attribute name="numcp"> + <dia:int val="1"/> + </dia:attribute> + <dia:attribute name="line_width"> + <dia:real val="0.05000000074505806"/> + </dia:attribute> + <dia:connections> + <dia:connection handle="0" to="O21" connection="8"/> + <dia:connection handle="1" to="O17" connection="8"/> + </dia:connections> + </dia:object> + <dia:object type="Standard - Line" version="0" id="O27"> + <dia:attribute name="obj_pos"> + <dia:point val="14.3805,28.8022"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="14.3476,26.0191;20.7228,28.8351"/> + </dia:attribute> + <dia:attribute name="conn_endpoints"> + <dia:point val="14.3805,28.8022"/> + <dia:point val="20.6899,26.052"/> + </dia:attribute> + <dia:attribute name="numcp"> + <dia:int val="1"/> + </dia:attribute> + <dia:attribute name="line_width"> + <dia:real val="0.05000000074505806"/> + </dia:attribute> + <dia:connections> + <dia:connection handle="0" to="O22" connection="8"/> + <dia:connection handle="1" to="O17" connection="8"/> + </dia:connections> + </dia:object> + <dia:object type="ER - Attribute" version="0" id="O28"> + <dia:attribute name="obj_pos"> + <dia:point val="10.615,30.8866"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="10.59,30.8616;16.015,32.6172"/> + </dia:attribute> + <dia:attribute name="elem_corner"> + <dia:point val="10.615,30.8866"/> + </dia:attribute> + <dia:attribute name="elem_width"> + <dia:real val="5.375"/> + </dia:attribute> + <dia:attribute name="elem_height"> + <dia:real val="1.7055555284023285"/> + </dia:attribute> + <dia:attribute name="border_width"> + <dia:real val="0.05000000074505806"/> + </dia:attribute> + <dia:attribute name="border_color"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="inner_color"> + <dia:color val="#ffffff"/> + </dia:attribute> + <dia:attribute name="name"> + <dia:string>#sw_version#</dia:string> + </dia:attribute> + <dia:attribute name="key"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="weak_key"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="derived"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="multivalued"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="font"> + <dia:font family="monospace" style="0" name="Courier"/> + </dia:attribute> + <dia:attribute name="font_height"> + <dia:real val="0.70555552840232849"/> + </dia:attribute> + </dia:object> + <dia:object type="ER - Attribute" version="0" id="O29"> + <dia:attribute name="obj_pos"> + <dia:point val="10.0739,33.6833"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="10.0489,33.6583;16.8239,35.4139"/> + </dia:attribute> + <dia:attribute name="elem_corner"> + <dia:point val="10.0739,33.6833"/> + </dia:attribute> + <dia:attribute name="elem_width"> + <dia:real val="6.7249999999999996"/> + </dia:attribute> + <dia:attribute name="elem_height"> + <dia:real val="1.7055555284023285"/> + </dia:attribute> + <dia:attribute name="border_width"> + <dia:real val="0.05000000074505806"/> + </dia:attribute> + <dia:attribute name="border_color"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="inner_color"> + <dia:color val="#ffffff"/> + </dia:attribute> + <dia:attribute name="name"> + <dia:string>#ts (TimeStamp)#</dia:string> + </dia:attribute> + <dia:attribute name="key"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="weak_key"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="derived"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="multivalued"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="font"> + <dia:font family="monospace" style="0" name="Courier"/> + </dia:attribute> + <dia:attribute name="font_height"> + <dia:real val="0.70555552840232849"/> + </dia:attribute> + </dia:object> + <dia:object type="Standard - Line" version="0" id="O30"> + <dia:attribute name="obj_pos"> + <dia:point val="14.4181,30.9464"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="14.3832,26.3057;20.932,30.9813"/> + </dia:attribute> + <dia:attribute name="conn_endpoints"> + <dia:point val="14.4181,30.9464"/> + <dia:point val="20.8972,26.3406"/> + </dia:attribute> + <dia:attribute name="numcp"> + <dia:int val="1"/> + </dia:attribute> + <dia:attribute name="line_width"> + <dia:real val="0.05000000074505806"/> + </dia:attribute> + <dia:connections> + <dia:connection handle="0" to="O28" connection="8"/> + <dia:connection handle="1" to="O17" connection="8"/> + </dia:connections> + </dia:object> + <dia:object type="Standard - Line" version="0" id="O31"> + <dia:attribute name="obj_pos"> + <dia:point val="14.2499,33.6916"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="14.2146,26.3046;21.3674,33.727"/> + </dia:attribute> + <dia:attribute name="conn_endpoints"> + <dia:point val="14.2499,33.6916"/> + <dia:point val="21.332,26.34"/> + </dia:attribute> + <dia:attribute name="numcp"> + <dia:int val="1"/> + </dia:attribute> + <dia:attribute name="line_width"> + <dia:real val="0.05000000074505806"/> + </dia:attribute> + <dia:connections> + <dia:connection handle="0" to="O29" connection="8"/> + <dia:connection handle="1" to="O17" connection="8"/> + </dia:connections> + </dia:object> + <dia:object type="ER - Relationship" version="0" id="O32"> + <dia:attribute name="obj_pos"> + <dia:point val="19.8559,16.9477"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="19.5159,16.9077;25.1534,19.9622"/> + </dia:attribute> + <dia:attribute name="elem_corner"> + <dia:point val="19.8559,16.9477"/> + </dia:attribute> + <dia:attribute name="elem_width"> + <dia:real val="4.9574999999999996"/> + </dia:attribute> + <dia:attribute name="elem_height"> + <dia:real val="2.9744999999999995"/> + </dia:attribute> + <dia:attribute name="border_width"> + <dia:real val="0.079999998211860657"/> + </dia:attribute> + <dia:attribute name="border_color"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="inner_color"> + <dia:color val="#ffffff"/> + </dia:attribute> + <dia:attribute name="name"> + <dia:string>#execute#</dia:string> + </dia:attribute> + <dia:attribute name="left_card"> + <dia:string>##</dia:string> + </dia:attribute> + <dia:attribute name="right_card"> + <dia:string>##</dia:string> + </dia:attribute> + <dia:attribute name="identifying"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="rotated"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="font"> + <dia:font family="monospace" style="0" name="Courier"/> + </dia:attribute> + <dia:attribute name="font_height"> + <dia:real val="0.88194441050291061"/> + </dia:attribute> + </dia:object> + <dia:object type="Standard - Line" version="0" id="O33"> + <dia:attribute name="obj_pos"> + <dia:point val="22.3412,14.5991"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="22.3122,14.574;22.3662,16.9329"/> + </dia:attribute> + <dia:attribute name="conn_endpoints"> + <dia:point val="22.3412,14.5991"/> + <dia:point val="22.3373,16.9079"/> + </dia:attribute> + <dia:attribute name="numcp"> + <dia:int val="1"/> + </dia:attribute> + <dia:attribute name="line_width"> + <dia:real val="0.05000000074505806"/> + </dia:attribute> + <dia:connections> + <dia:connection handle="0" to="O13" connection="8"/> + <dia:connection handle="1" to="O32" connection="8"/> + </dia:connections> + </dia:object> + <dia:object type="Standard - Line" version="0" id="O34"> + <dia:attribute name="obj_pos"> + <dia:point val="22.3215,19.9623"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="22.2583,19.9371;22.3467,24.4051"/> + </dia:attribute> + <dia:attribute name="conn_endpoints"> + <dia:point val="22.3215,19.9623"/> + <dia:point val="22.2835,24.3799"/> + </dia:attribute> + <dia:attribute name="numcp"> + <dia:int val="1"/> + </dia:attribute> + <dia:attribute name="line_width"> + <dia:real val="0.05000000074505806"/> + </dia:attribute> + <dia:connections> + <dia:connection handle="0" to="O32" connection="8"/> + <dia:connection handle="1" to="O17" connection="8"/> + </dia:connections> + </dia:object> + <dia:object type="ER - Entity" version="0" id="O35"> + <dia:attribute name="obj_pos"> + <dia:point val="17.8849,38.8831"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="17.8449,38.8431;20.5924,40.8051"/> + </dia:attribute> + <dia:attribute name="elem_corner"> + <dia:point val="17.8849,38.8831"/> + </dia:attribute> + <dia:attribute name="elem_width"> + <dia:real val="2.6675"/> + </dia:attribute> + <dia:attribute name="elem_height"> + <dia:real val="1.8819444105029106"/> + </dia:attribute> + <dia:attribute name="border_width"> + <dia:real val="0.079999998211860657"/> + </dia:attribute> + <dia:attribute name="border_color"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="inner_color"> + <dia:color val="#ffffff"/> + </dia:attribute> + <dia:attribute name="name"> + <dia:string>#Run#</dia:string> + </dia:attribute> + <dia:attribute name="weak"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="associative"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="font"> + <dia:font family="monospace" style="0" name="Courier"/> + </dia:attribute> + <dia:attribute name="font_height"> + <dia:real val="0.88194441050291061"/> + </dia:attribute> + </dia:object> + <dia:object type="ER - Attribute" version="0" id="O36"> + <dia:attribute name="obj_pos"> + <dia:point val="9.04882,39.0691"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="9.02382,39.0441;15.7988,40.7997"/> + </dia:attribute> + <dia:attribute name="elem_corner"> + <dia:point val="9.04882,39.0691"/> + </dia:attribute> + <dia:attribute name="elem_width"> + <dia:real val="6.7249999999999996"/> + </dia:attribute> + <dia:attribute name="elem_height"> + <dia:real val="1.7055555284023285"/> + </dia:attribute> + <dia:attribute name="border_width"> + <dia:real val="0.05000000074505806"/> + </dia:attribute> + <dia:attribute name="border_color"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="inner_color"> + <dia:color val="#ffffff"/> + </dia:attribute> + <dia:attribute name="name"> + <dia:string>#ts (TimeStamp)#</dia:string> + </dia:attribute> + <dia:attribute name="key"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="weak_key"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="derived"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="multivalued"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="font"> + <dia:font family="monospace" style="0" name="Courier"/> + </dia:attribute> + <dia:attribute name="font_height"> + <dia:real val="0.70555552840232849"/> + </dia:attribute> + </dia:object> + <dia:object type="Standard - Line" version="0" id="O37"> + <dia:attribute name="obj_pos"> + <dia:point val="15.7938,39.8733"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="15.7684,39.8185;17.8704,39.8987"/> + </dia:attribute> + <dia:attribute name="conn_endpoints"> + <dia:point val="15.7938,39.8733"/> + <dia:point val="17.8451,39.8438"/> + </dia:attribute> + <dia:attribute name="numcp"> + <dia:int val="1"/> + </dia:attribute> + <dia:attribute name="line_width"> + <dia:real val="0.05000000074505806"/> + </dia:attribute> + <dia:connections> + <dia:connection handle="0" to="O36" connection="8"/> + <dia:connection handle="1" to="O35" connection="8"/> + </dia:connections> + </dia:object> + </dia:layer> +</dia:diagram> diff --git a/docs/mer.png b/docs/mer.png Binary files differnew file mode 100644 index 0000000..30cebfe --- /dev/null +++ b/docs/mer.png diff --git a/sql/proc_get_act_most_used.sql b/sql/proc_get_act_most_used.sql new file mode 100644 index 0000000..e0a4674 --- /dev/null +++ b/sql/proc_get_act_most_used.sql @@ -0,0 +1,17 @@ +DELIMITER // +DROP PROCEDURE IF EXISTS get_act_most_used// +CREATE PROCEDURE get_act_most_used() +BEGIN + DECLARE a CHAR(80); + DECLARE done INT DEFAULT FALSE; + DECLARE cur1 CURSOR FOR SELECT name FROM Resources; + + OPEN cur1; + + read_loop: LOOP + FETCH cur1 into a; + IF done THEN + LEAVE read_loop; + END IF; + END LOOP; +END; diff --git a/sugar_stats_consolidation/__init__.py b/src/__init__.py index c06c47d..c06c47d 100644 --- a/sugar_stats_consolidation/__init__.py +++ b/src/__init__.py diff --git a/sugar_stats_consolidation/build/lib.linux-x86_64-2.7/stats_consolidation/__init__.py b/src/build/lib.linux-x86_64-2.7/stats_consolidation/__init__.py index dd6e324..dd6e324 100644 --- a/sugar_stats_consolidation/build/lib.linux-x86_64-2.7/stats_consolidation/__init__.py +++ b/src/build/lib.linux-x86_64-2.7/stats_consolidation/__init__.py diff --git a/sugar_stats_consolidation/build/lib.linux-x86_64-2.7/stats_consolidation/consolidation.py b/src/build/lib.linux-x86_64-2.7/stats_consolidation/consolidation.py index 4003594..4003594 100644 --- a/sugar_stats_consolidation/build/lib.linux-x86_64-2.7/stats_consolidation/consolidation.py +++ b/src/build/lib.linux-x86_64-2.7/stats_consolidation/consolidation.py diff --git a/sugar_stats_consolidation/build/lib.linux-x86_64-2.7/stats_consolidation/db.py b/src/build/lib.linux-x86_64-2.7/stats_consolidation/db.py index a8939e5..a8939e5 100644 --- a/sugar_stats_consolidation/build/lib.linux-x86_64-2.7/stats_consolidation/db.py +++ b/src/build/lib.linux-x86_64-2.7/stats_consolidation/db.py diff --git a/sugar_stats_consolidation/build/lib.linux-x86_64-2.7/stats_consolidation/rrd_files.py b/src/build/lib.linux-x86_64-2.7/stats_consolidation/rrd_files.py index a437e0d..a437e0d 100644 --- a/sugar_stats_consolidation/build/lib.linux-x86_64-2.7/stats_consolidation/rrd_files.py +++ b/src/build/lib.linux-x86_64-2.7/stats_consolidation/rrd_files.py diff --git a/sugar_stats_consolidation/build/lib.linux-x86_64-2.7/stats_consolidation/setup.py b/src/build/lib.linux-x86_64-2.7/stats_consolidation/setup.py index 00585ee..00585ee 100644 --- a/sugar_stats_consolidation/build/lib.linux-x86_64-2.7/stats_consolidation/setup.py +++ b/src/build/lib.linux-x86_64-2.7/stats_consolidation/setup.py diff --git a/sugar_stats_consolidation/build/lib.linux-x86_64-2.7/stats_consolidation/test_cons.py b/src/build/lib.linux-x86_64-2.7/stats_consolidation/test_cons.py index 00f43b5..00f43b5 100644 --- a/sugar_stats_consolidation/build/lib.linux-x86_64-2.7/stats_consolidation/test_cons.py +++ b/src/build/lib.linux-x86_64-2.7/stats_consolidation/test_cons.py diff --git a/sugar_stats_consolidation/build/lib.linux-x86_64-2.7/stats_consolidation/test_db.py b/src/build/lib.linux-x86_64-2.7/stats_consolidation/test_db.py index 197510a..197510a 100644 --- a/sugar_stats_consolidation/build/lib.linux-x86_64-2.7/stats_consolidation/test_db.py +++ b/src/build/lib.linux-x86_64-2.7/stats_consolidation/test_db.py diff --git a/sugar_stats_consolidation/build/lib.linux-x86_64-2.7/stats_consolidation/test_rrd.py b/src/build/lib.linux-x86_64-2.7/stats_consolidation/test_rrd.py index 657ce18..657ce18 100644 --- a/sugar_stats_consolidation/build/lib.linux-x86_64-2.7/stats_consolidation/test_rrd.py +++ b/src/build/lib.linux-x86_64-2.7/stats_consolidation/test_rrd.py diff --git a/sugar_stats_consolidation/consolidation.py b/src/consolidation.py index 8c0912e..8c0912e 100644 --- a/sugar_stats_consolidation/consolidation.py +++ b/src/consolidation.py diff --git a/sugar_stats_consolidation/consolidation_run b/src/consolidation_run index 7ef1a5c..7ef1a5c 100755 --- a/sugar_stats_consolidation/consolidation_run +++ b/src/consolidation_run diff --git a/sugar_stats_consolidation/db.py b/src/db.py index 647f69c..647f69c 100644 --- a/sugar_stats_consolidation/db.py +++ b/src/db.py diff --git a/sugar_stats_consolidation/rrd_files.py b/src/rrd_files.py index 21c48df..21c48df 100644 --- a/sugar_stats_consolidation/rrd_files.py +++ b/src/rrd_files.py diff --git a/sugar_stats_consolidation/run.sh b/src/run.sh index 05bb6ca..05bb6ca 100755 --- a/sugar_stats_consolidation/run.sh +++ b/src/run.sh diff --git a/stats-consolidation.cron b/stats-consolidation.cron new file mode 100644 index 0000000..843d881 --- /dev/null +++ b/stats-consolidation.cron @@ -0,0 +1,4 @@ +PATH=/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin +BASE_PATH=/home/ceibal/ac/statistics-consolidation +0 3 * * * root $BASE_PATH/sugar_stats_consolidation/run.sh > $BASE_PATH/log/out.txt + |