Skip to content

Instantly share code, notes, and snippets.

View oliviermarin's full-sized avatar
💭
I may be slow to respond.

Olivier Marin oliviermarin

💭
I may be slow to respond.
0 followers · 14 following
  • Paris Turf
  • Châtillon
View GitHub Profile
@oliviermarin
oliviermarin / install-latest-compose.sh
Created July 28, 2022 14:45 — forked from deviantony/install-latest-compose.sh
Install latest version of Docker Compose
#!/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)
@oliviermarin
oliviermarin / renommer champs table postgres
Created December 7, 2016 13:15
ALTER TABLE public.table_name RENAME COLUMN old_name TO new_name;
@oliviermarin
oliviermarin / Maven | Installation
Created October 25, 2016 13:13
https://www.mkyong.com/maven/how-to-install-maven-in-windows/
@oliviermarin
oliviermarin / gist:01a7550d0bf3b7fd233eca58c54b069f
Created October 25, 2016 13:03
PostgreSQL | Installation
http://documentation.veremes.net/public/veremap.pro/installation/postgresql-postgis/postgresql_9.1-win.html
@oliviermarin
oliviermarin / SQL | PostgreSQL | Retour d'une clé étrangère
Created June 24, 2016 09:30
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)
@oliviermarin
oliviermarin / PostgreSQL | Creation d'une table de jointure
Created June 20, 2016 15:34
CREATE TABLE t1_t2 (
t1fk_t1 integer references t1(id),
t2fk_t2 integer references t2(id) default 1
);
@oliviermarin
oliviermarin / raise-info-sql
Created June 14, 2016 09:34
SQL | PostgreSQL | Afficher information dans script SQL
RAISE INFO 'param : %', param-value;
@oliviermarin
oliviermarin / PLSQL | PostgreSQL | creation simple de script plsql
Created June 10, 2016 15:38
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;
@oliviermarin
oliviermarin / SQL | PostgreSQL | Copier des données dans une même table en modifiant certaines colonnes
Last active June 9, 2016 09:56
INSERT INTO public.personne(
id,
age,
prenom,
nom)
SELECT
id,
age,
prenom, // Donnees précédante
'Dupont' // modification valeur
@oliviermarin
oliviermarin / PRIMEFACES | OnChangeSomething | selectOneRadio
Last active June 6, 2016 11:11
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}">