cimmanon

CREATE TABLE order_history (
	order_id INT NOT NULL,
	date_added TIMESTAMPTZ NOT NULL DEFAULT now(),
	status TEXT NOT NULL,

	PRIMARY KEY (order_id, date_added)
);

CREATE TABLE history_allowed_pattern (
	old TEXT NOT NULL,

cimmanon

I use PostgreSQL via the psql client. If you use a different client (eg. pgAdmin, etc.), I don't know how much will translate over.

One nice difference between psql and mysql (cli) is that if you press CTRL+C, it won't exit the client.

User administration

Login as superuser (via shell)

psql -U postgres

cimmanon

begin;

/*----------------------------------------------------------------------------------------------------*\
                                                                      | Functions for generating statistics
\*----------------------------------------------------------------------------------------------------*/

create or replace function rel_column_count(schema_name text, table_name text, column_name text, column_type text) returns table
	( not_null_count bigint
	, distinct_count bigint
	, min_length int

cimmanon

There aren't any good guides for using AttrSplices from Heist. The tutorial from the Snap website fails to show how to bind them, and the only public code I can find that uses them is Digestive Functors Heist.

How does it work?

type AttrSplice m = Text -> RuntimeSplice m [(Text, Text)]

The AttrSplice type signature says that it takes a Text and returns a Monad containing a list of tuples of Text. The first argument would only be used if you're planning on using it as a point of comparison within the template, as shown in the Attribute Splices Tutorial (n.b. the type signature listed here is slightly different, this might reflect an older version of Heist):

cimmanon

CREATE TABLE history_allowed_pattern (
	old TEXT NOT NULL,
	new TEXT NOT NULL,

	UNIQUE (old, new)
);

INSERT INTO history_allowed_pattern
	(old, new)
VALUES

cimmanon

// ----
// Sass (v3.4.21)
// Compass (v1.0.3)
// ----

.foo {
  outline: #90b2e9 solid 1px;
  outline: #90B2E9 solid 1px;
}

cimmanon

// ----
// libsass (v3.2.5)
// ----

/**
 * Little helper to create a circle
 * @group control-points
 * @access private
 * @param {Number} $size - Circle size
 * @output Dimensions, margin and border-radius

cimmanon

// ----
// Sass (v3.4.21)
// Compass (v1.0.3)
// ----

.foo {
  bar: 1.5em * 2;
}

cimmanon

// ----
// Sass (v3.4.21)
// Compass (v1.0.3)
// ----

/* test one */
.pfx {
  &__one &{
    &__two {
      color: red;

cimmanon

// ----
// Sass (v3.4.21)
// Compass (v1.0.3)
// Bourbon (v4.2.6)
// ----

@import "bourbon/bourbon";

#loader {
   @include position(absolute, 0 0 0 0);