Skip to content

Instantly share code, notes, and snippets.

Pierre Joubert pierrejoubert73

View GitHub Profile
@pierrejoubert73
pierrejoubert73 / markdown-details-collapsible.md
Last active Aug 5, 2020
How to add a collapsible section in markdown.
View markdown-details-collapsible.md

A collapsible section containing markdown

Click to expand!

Heading

  1. A numbered
  2. list
    • With some
    • Sub bullets
@pierrejoubert73
pierrejoubert73 / array_agg_example.sql
Last active Apr 11, 2019
An example of using the array_agg() PostgreSQL function.
View array_agg_example.sql
select
pc_games.title,
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
from
schema_A.pc_games as pc_games
inner join schema_A.avid_fans as avid_fans on (pc_games.id = avid_fans.fk_pc_game_id)
where
pc_games.release_date > '2004-12-31'
group by
@pierrejoubert73
pierrejoubert73 / psql-import-db-dump.md
Last active Oct 11, 2018
How to import a dump file in PSQL.
View psql-import-db-dump.md

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:

\l

View file-check.html
<script>
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) {
return file.name;
});
@pierrejoubert73
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;
@pierrejoubert73
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>
@pierrejoubert73
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: https://www.postgresql.org/docs/9.1/static/sql-altertype.html
@pierrejoubert73
pierrejoubert73 / arrayOfFunctions.php
Last active Oct 14, 2016
How to dynamically call functions with x amount of parameters.
View arrayOfFunctions.php
<?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"),
You can’t perform that action at this time.