Skip to content

GitLab

  • Projects
  • Groups
  • Snippets
  • Help
    • Loading...
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
    • Contribute to GitLab
  • Sign in / Register
S
Sysma-Tickets
  • Project overview
    • Project overview
    • Details
    • Activity
    • Releases
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Contributors
    • Graph
    • Compare
  • Issues 28
    • Issues 28
    • List
    • Boards
    • Labels
    • Service Desk
    • Milestones
  • Merge Requests 0
    • Merge Requests 0
  • Operations
    • Operations
    • Incidents
  • Analytics
    • Analytics
    • Repository
    • Value Stream
  • Wiki
    • Wiki
  • Snippets
    • Snippets
  • Members
    • Members
  • Collapse sidebar
  • Activity
  • Graph
  • Create a new issue
  • Commits
  • Issue Boards
  • eptbsn
  • Sysma-Tickets
  • Issues
  • #33

Closed
Open
Opened Nov 23, 2020 by Fabien Dubois@fduboisDeveloper

fonction insertion d'un parametre pour tous les types de travaux sysma

Bonjour, je sais pas si c'est le bon endroit ici, mais si quelqu'un en avait besoin, je partage ma fonction qui ajoute le paramètre Maitre d'ouvrage (préalablement crée dans le dictionnaire) pour l'ensemble des travaux de la base Sysma. N'hésitez pas a m'indiquer si vous voyez des améliorations. Bonne journée

CREATE OR REPLACE FUNCTION a000_temp.insert_maitre_ouvrage_parametre_travaux(
	)
    RETURNS void
    LANGUAGE 'plpgsql'

    COST 100
    VOLATILE 
AS $BODY$
DECLARE
nb        	  record;
rec           record;

BEGIN

	FOR rec IN
		SELECT distinct id_type_travaux
			FROM sysma.types_travaux
			where id_type_travaux <>1
		
	
	LOOP
			FOR nb IN

					SELECT max(id_parametre)+1 as id_param
						FROM sysma.types_travaux_parametres
				
			LOOP

				
				EXECUTE
					'insert into sysma.types_travaux_parametres (id_parametre, parametre, description, type_donnee, regroupement, date_creation, date_modification, id_type_travaux, source_parametre, source_donnees, unite, obligatoire, col_sig, id_modificateur)
					SELECT '||nb.id_param||', parametre, description, type_donnee, regroupement, date_creation, date_modification, '||rec.id_type_travaux||', source_parametre, source_donnees, unite, obligatoire, col_sig, id_modificateur
					FROM sysma.types_travaux_parametres
					where id_parametre = 10800592';
	
						   
			END LOOP;
        END LOOP;

END
$BODY$;

select a000_temp.insert_maitre_ouvrage_parametre_travaux();
Edited Nov 25, 2020 by Antoine RIVIERE
To upload designs, you'll need to enable LFS and have admin enable hashed storage. More information
Assignee
Assign to
None
Milestone
None
Assign milestone
Time tracking
None
Due date
None
Reference: eptbsn/sysma-tickets#33