sqls

Documentation

Overview

Package sqls implements SQL schema definitions.

Index

• Constants

Constants

const BasePragma = `
pragma encoding = "UTF-8";
pragma foreign_keys = ON;
`

BasePragma is the baseline required database pragma.

const BaseSchema = `` /* 239-byte string literal not displayed */

BaseSchema is the baseline required database schema.

const ProdSchema = BaseSchema + `
insert into Keys (name) values ("readme");
insert into Vals (key, body) values ("readme", "Welcome to Soske!");
`

ProdSchema is the default schema for production applications.

const TestSchema = BaseSchema + `
insert into Keys (name, init) values ("alpha", 100);
insert into Keys (name, init) values ("bravo", 200);
insert into Keys (name, init) values ("charlie", 300);
insert into Vals (key, body, init) values ("alpha", "Alpha one.", 400);
insert into Vals (key, body, init) values ("alpha", "Alpha two.", 500);
insert into Vals (key, body, init) values ("bravo", "Bravo one.", 600);
`

TestSchema is the default schema for testing applications.