Olivier Marin oliviermarin

## install-latest-compose.sh
#!/bin/bash


## THIS THE THE OLD WAY
## Nowadays, simply follow the Compose installation instructions in the official documentation: https://docs.docker.com/compose/install/


# get latest docker compose released tag
COMPOSE_VERSION=$(curl -s https://api.github.com/repos/docker/compose/releases/latest | grep 'tag_name' | cut -d\" -f4)

## renommer champs table postgres
ALTER TABLE public.table_name RENAME COLUMN old_name TO new_name;

## Maven | Installation
https://www.mkyong.com/maven/how-to-install-maven-in-windows/

## gist:01a7550d0bf3b7fd233eca58c54b069f
http://documentation.veremes.net/public/veremap.pro/installation/postgresql-postgis/postgresql_9.1-win.html

## SQL | PostgreSQL | Retour d'une clé étrangère
DECLARE
region_id integer;
BEGIN

-- Insertion de la région de la réunion
INSERT INTO t1(t1_f1, t1_f2, t1_f3, t1_f4)
VALUES ('Réunion', '04', TRUE, 1) RETURNING id INTO t1_id;

-- Insertion du département région
INSERT INTO t2(t2_f1, t2_f2, t2_f3, t1fk_t1)

## PostgreSQL | Creation d'une table de jointure
CREATE TABLE t1_t2 (
	t1fk_t1 integer references t1(id),
	t2fk_t2 integer references t2(id) default 1
);

## raise-info-sql
RAISE INFO 'param : %', param-value;

## PLSQL | PostgreSQL | creation simple de script plsql
DO $$
DECLARE
  counter integer := 0;
BEGIN
 FOR i IN 1..10
 LOOP
      counter := couter + i;
 END LOOP;
END;
$$ LANGUAGE plpgsql;

## SQL | PostgreSQL | Copier des données dans une même table en modifiant certaines colonnes
INSERT INTO public.personne(
	id,
	age,
	prenom,
	nom)
SELECT
	id,
	age,
	prenom, // Donnees précédante
	'Dupont' // modification valeur

## PRIMEFACES | OnChangeSomething | selectOneRadio
xhtml | Face :

<p:row>
	<p:column>
		<p:outputLabel  for="zone-geographique"
									  value="#{messages['operationimmobiliere.zone.geographique']} : " />
	</p:column>
	<p:column>
		<p:selectOneRadio	  id="zone-geographique"
    										value="#{operationImmobiliereFace.codeZoneGeographique}">
	#!/bin/bash


	## THIS THE THE OLD WAY
	## Nowadays, simply follow the Compose installation instructions in the official documentation: https://docs.docker.com/compose/install/


	# get latest docker compose released tag
	COMPOSE_VERSION=$(curl -s https://api.github.com/repos/docker/compose/releases/latest \| grep 'tag_name' \| cut -d\" -f4)
	DECLARE
	region_id integer;
	BEGIN

	-- Insertion de la région de la réunion
	INSERT INTO t1(t1_f1, t1_f2, t1_f3, t1_f4)
	VALUES ('Réunion', '04', TRUE, 1) RETURNING id INTO t1_id;

	-- Insertion du département région
	INSERT INTO t2(t2_f1, t2_f2, t2_f3, t1fk_t1)
	CREATE TABLE t1_t2 (
	t1fk_t1 integer references t1(id),
	t2fk_t2 integer references t2(id) default 1
	);
	DO $$
	DECLARE
	counter integer := 0;
	BEGIN
	FOR i IN 1..10
	LOOP
	counter := couter + i;
	END LOOP;
	END;
	$$ LANGUAGE plpgsql;
	INSERT INTO public.personne(
	id,
	age,
	prenom,
	nom)
	SELECT
	id,
	age,
	prenom, // Donnees précédante
	'Dupont' // modification valeur
	xhtml \| Face :

	<p:row>
	<p:column>
	<p:outputLabel for="zone-geographique"
	value="#{messages['operationimmobiliere.zone.geographique']} : " />
	</p:column>
	<p:column>
	<p:selectOneRadio id="zone-geographique"
	value="#{operationImmobiliereFace.codeZoneGeographique}">