Skip to content

Instantly share code, notes, and snippets.

Pierre Joubert pierrejoubert73

Block or report user

Report or block pierrejoubert73

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
@pierrejoubert73
pierrejoubert73 / markdown-details-collapsible.md
Last active Nov 15, 2019
How to add a collapsible section in markdown.
View markdown-details-collapsible.md

A collapsible section with markdown

Click to expand!

Heading

  1. A numbered
  2. list
    • With some
    • Sub bullets
@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;
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 / 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

@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 / 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 / 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"),
@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>
You can’t perform that action at this time.