a

Documentation

Index

• Constants
• func Demo(testName string, testDescription string, testDatabaseDsn string, testType int) (err error)

Constants

const (
	TypeCreateTable      = 1
	TypeFillTable        = 2
	TypeSelectAll        = 4
	TypeCreateFunction   = 8
	TypeSelectDumbNormal = 16
	TypeSelectDumbTest   = 32
	TypeCreateCreator    = 64
	TypeFinalization     = 128
)

const ErrfTypeUnrecognized = "Type is unrecognized: %v."

const QueryCreateCreator = `` /* 476-byte string literal not displayed */

const QueryCreateFunction = `CREATE FUNCTION add_name_clear(name text)
RETURNS integer
LANGUAGE sql
AS $$
	----------------------------------------------------------------------------
	--|	This is a demonstrative Function which inserts a Name into the Table |-- 
	--| which is cleared before the Insertion.                               |--
	----------------------------------------------------------------------------
    DELETE FROM ` + TableNameFull + ` WHERE TRUE;
    INSERT INTO ` + TableNameFull + ` ("Name")
    VALUES (name)
    RETURNING "Id";
$$;
`

const QueryCreateTable = `CREATE TABLE ` + TableNameFull + `
(
    "Id"   serial NOT NULL PRIMARY KEY,
    "Name" text   NOT NULL
);`

const QueryFillTable = `INSERT INTO ` + TableNameFull + ` ("Id", "Name")
VALUES 
	(1, 'Aaa'),
	(2, 'Bbb'),
	(3, 'Ccc'),
	(4, 'John'),
	(5, 'Jack'),
	(6, 'Gojoko'),
	(7, 'Fojo'),
	(8, 'Koho');
`

const QueryFinalization = `DROP TABLE ` + TableNameFull + `;
DROP FUNCTION create_object(text);
DROP FUNCTION add_name_clear(text);`

const QueryFormatDumb = `SELECT "Id", "Name"
FROM ` + TableNameFull + `
WHERE
	("Name" ILIKE '%%%s%%');`

const QuerySelectAll = `SELECT * 
FROM ` + TableNameFull + `;`

const TableNameFull = `public."TestA"`

Functions

func Demo

func Demo(
	testName string,
	testDescription string,
	testDatabaseDsn string,
	testType int,
) (err error)