jl-

CREATE OR REPLACE FUNCTION public.json_append(data json, insert_data json)
RETURNS json
IMMUTABLE
LANGUAGE sql
AS $$
    SELECT ('{'||string_agg(to_json(key)||':'||value, ',')||'}')::json
    FROM (
        SELECT * FROM json_each(data)
        UNION ALL
        SELECT * FROM json_each(insert_data)

jl-

--
-- PostgreSQL database dump
--

SET statement_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SET check_function_bodies = false;
SET client_min_messages = warning;

jl-

CREATE TABLE IF NOT EXISTS sample_table (
    id serial,
    field1 text,
    field2 int,
    field3 date
);

INSERT INTO sample_table (field1, field2, field3)
SELECT
    md5(random()::text),

jl-

-- Demo of PostgreSQL 9.5 features for Wellington PostgreSQL User's Group
-- The following is not necessarily in the right order or exactly how I ran it,
-- I mixed it up a bit when presenting!

DROP TABLE IF EXISTS country CASCADE;

DROP TABLE IF EXISTS sales_per_person CASCADE;

DROP TABLE IF EXISTS film CASCADE;

jl-

WITH in_radius AS (
        SELECT id 
        FROM table
        WHERE earth_box( ll_to_earth( 51.534901, -0.204573), 5000.00) @> ll_to_earth(table.lat, table.lng)
    ), results AS (
			SELECT *
			FROM spaces
			WHERE id IN (SELECT id FROM in_radius)
	)
SELECT *,

jl-

import React from 'react';

export default function flattenReactChildrenToArray(nodeChildren, accumulated = []) {
  React.Children.forEach(nodeChildren, (childNode) => {
    accumulated.push(childNode);
    if (childNode && childNode.props && childNode.props.children) {
      flattenReactChildrenToArray(childNode.props.children, accumulated);
    }
  });
  return accumulated;

jl-

create table departments
(
  dept_id integer primary key,
  dept_name varchar(255)
);

create table employees
(
  emp_id integer primary key,
  emp_name varchar(255),

jl-

# Dockerfile for Flarum, based on Flarum's Vagrantfile
# (https://github.com/flarum/flarum/blob/master/Vagrantfile)
# which uses scripts from Vaprobash
# (https://github.com/fideloper/Vaprobash)

# Run with:
# docker-compose up flarum
# docker-compose run --service-ports flarum <custom command, e.g. /bin/bash>

FROM phusion/baseimage

jl-

/* begin table creation */

create table department
 (department_id serial primary key,
  name varchar(20) not null
 );

create table branch
 (branch_id serial primary key,
  name varchar(20) not null,

jl-

delimiter $$

CREATE TABLE `accounts` (
  `account_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Account ID',
  `account_username` char(32) NOT NULL DEFAULT '' COMMENT 'Account username',
  `account_password` char(64) NOT NULL COMMENT 'Account password',
  `account_station_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'Account STATION_ID',
  `account_level` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Account - CSR Flag',
  `account_banned` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Account - Banned Status',
  `account_email` char(64) NOT NULL DEFAULT '' COMMENT 'Account - User email',