Skip to content

Instantly share code, notes, and snippets.

Moved over to a private GitLab

Pierre Joubert pierrejoubert73

Moved over to a private GitLab
View GitHub Profile
pierrejoubert73 /
Last active Oct 15, 2021
How to add a collapsible section in markdown.

A collapsible section containing markdown

Click to expand!


  1. A numbered
  2. list
    • With some
    • Sub bullets
pierrejoubert73 / get-file-list.js
Created Jun 29, 2017
Get the list of files uploaded.
View get-file-list.js
var fileList = $("#comment-attachment").get(0).files;
View file-check.html
var form = $('#attach-local-doc-form');
* Note that variable `data` will not show anything due to hidden properties.
* It's purpose is to be passed to the server for parsing.
var data = new FormData(form.get(0));
var fileNames = documentData.getAll("userfile").map(function (file) {
pierrejoubert73 /
Last active Sep 16, 2021
How to import a dump file in PSQL.

Open terminal.

Connect to psql:

psql -p 5433

I find it easier to delete and recreate the DB to which you want to import. So ensure the databse you want to delete is listed:


pierrejoubert73 / enums.sql
Last active Nov 21, 2016
How to view and alter enumerated types in PostgeSQL.
View enums.sql
-- To view all values in the enum:
SELECT unnest(enum_range(NULL::schema.enum_name));
-- To add a value to the enum:
ALTER TYPE schema.enum_name ADD VALUE 'new_enum_value';
-- For more operation see:
pierrejoubert73 / array_agg_example.sql
Last active Apr 11, 2019
An example of using the array_agg() PostgreSQL function.
View array_agg_example.sql
to_char(pc_games.release_date, 'YYYY-MM-DD') as release_date
array_to_string(array_agg(avid_fans.firstname || ' ' || avid_fans.surname), ', ', null) as fans
schema_A.pc_games as pc_games
inner join schema_A.avid_fans as avid_fans on ( = avid_fans.fk_pc_game_id)
pc_games.release_date > '2004-12-31'
group by
pierrejoubert73 / arrayOfFunctions.php
Last active Oct 14, 2016
How to dynamically call functions with x amount of parameters.
View arrayOfFunctions.php
$results = array();
# The "$selected_functions" array will be constructed on the client side and posted to the PHP controller function.
# Populate the "$selected_functions" array based on user interaction with the UI.
$selected_functions = array(
"function_1" => array("parameter_1_1", "parameter_1_2", "parameter_1_3"),
"function_2" => array("parameter_2_1"),
pierrejoubert73 / ng-class-multiple.js
Created Oct 12, 2016
How to add multiple classes and expressions to the ng-class attribute.
View ng-class-multiple.js
<span class="label" ng-class="{'possibleValue1' : 'class1', 'possibleValue2' : 'class2', 'possibleValue3' : 'class3'}[object.value]" ng-bind-html='object.value'></span>