[Noalyss-commit] [noalyss] 12/16: force login user to lower case for ACTION_GESTION

[Dany De Bontridder]

sparkyx pushed a commit to branch master
in repository noalyss.

commit bf2f4fa0891836c04dd18733209ce3720a860003
Author: Dany De Bontridder <address@hidden>
Date:   Tue Oct 20 11:46:57 2015 +0200

    force login user to lower case for ACTION_GESTION
---
 sql/upgrade.sql |   14 +++++++++++++-
 1 files changed, 13 insertions(+), 1 deletions(-)

diff --git a/sql/upgrade.sql b/sql/upgrade.sql
index 9fcce26..870dac2 100644
--- a/sql/upgrade.sql
+++ b/sql/upgrade.sql
@@ -165,4 +165,16 @@ CREATE TRIGGER todo_list_shared_ins_upd
   ON todo_list_shared
   FOR EACH ROW
   EXECUTE PROCEDURE comptaproc.trg_todo_list_shared_ins_upd();
-COMMENT ON TRIGGER todo_list_shared_ins_upd ON todo_list_shared IS 'Force the 
column ua_login to lowercase';
\ No newline at end of file
+COMMENT ON TRIGGER todo_list_shared_ins_upd ON todo_list_shared IS 'Force the 
column ua_login to lowercase';
+
+CREATE OR REPLACE FUNCTION comptaproc.action_gestion_ins_upd()
+  RETURNS trigger AS
+$BODY$
+begin
+NEW.ag_title := substr(trim(NEW.ag_title),1,70);
+NEW.ag_hour := substr(trim(NEW.ag_hour),1,5);
+NEW.ag_owner := lower(NEW.ag_owner);
+return NEW;
+end;
+$BODY$
+LANGUAGE plpgsql;