From fad4ec50ee9040f96cd242abec55016e7f8f55cf Mon Sep 17 00:00:00 2001 From: Gustavo Duarte Date: Mon, 01 Apr 2013 14:58:22 +0000 Subject: + Ordering files tasks + Add stats-consolidation.cron as sample file for cron configuration. --- diff --git a/docs/mer.dia b/docs/mer.dia new file mode 100644 index 0000000..f6f4ea0 --- /dev/null +++ b/docs/mer.dia Binary files differ 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 @@ + + + + + + + + + + + + + #A4# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #Usage# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #ts (TimeStamp)# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #user_hash # + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #start_date# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #resource_name# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #data_type# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #Record# + + + ## + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #Resource# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #name# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #User# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #hash# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #uuid# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #machine_sn# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #age# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #school# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #sw_version# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #ts (TimeStamp)# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #execute# + + + ## + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #Run# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #ts (TimeStamp)# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + diff --git a/docs/mer.png b/docs/mer.png new file mode 100644 index 0000000..30cebfe --- /dev/null +++ b/docs/mer.png Binary files differ 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 + -- cgit v0.9.1