pierrejoubert73

How to

<details>
  <summary>Click me</summary>
  
  ### Heading
  1. Foo
  2. Bar
     * Baz
 * Qux

pierrejoubert73

var fileList = $("#comment-attachment").get(0).files;

pierrejoubert73

<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

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

-- 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

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

<?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

<span class="label" ng-class="{'possibleValue1' : 'class1', 'possibleValue2' : 'class2', 'possibleValue3' : 'class3'}[object.value]" ng-bind-html='object.value'></span>