<commit_before>-- $Id$
--
-- SQL script used by PostgresKit's integration tests.
--
-- For the tests to execute successfully this file should 
-- be run against a blank database called 'pgkit_test' and 
-- the user 'pgkit_test' with password '<PASSWORD>' should exit:
--
-- CREATE DATABASE pgkit_test;
-- CREATE USER pgkit_test WITH PASSWORD '<PASSWORD>';

BEGIN;

SET datestyle = 'DMY';
SET client_encoding = 'UNICODE';

IF EXISTS (
	SELECT 1 FROM information_schema.tables 
	WHERE table_name = 'data_types' 
	AND table_type = 'BASE TABLE'
)
	DROP TABLE data_types;
END

CREATE TABLE data_types
(
	int_field INT PRIMARY KEY NOT NULL,
	smallint_field SMALLINT NOT NULL,
	bigint_field BIGINT NOT NULL,
	bool_field BOOL NOT NULL,
	float_field REAL NOT NULL,
	char_field CHAR(5) NOT NULL,
	varchar_field VARCHAR(32) NOT NULL,
	date_field DATE NOT NULL,
	time_field TIME NOT NULL,
	timetz_field TIME WITH TIME ZONE NOT NULL,
	timstamp_field TIMESTAMP NOT NULL,
	timestamptz_field TIMESTAMP WITH TIME ZONE NOT NULL
);

INSERT INTO data_types (
	int_field, 
	smallint_field, 
	bool_field, 
	float_field, 
	char_field, 
 	varchar_field, 
	date_field, 
	time_field, 
	timetz_field, 
	timstamp_field, 
	timestamptz_field)
VALUES (
	12345, 
	2, 
	TRUE,
	123456789,
	12345.678, 
	'CHARV', 
	'VARCHAR_VALUE', 
	'08-04-1987',
	'02:02:02',
	'02:02:02 GMT',
	'08-04-1987 02:02:02',<commit_msg>Update test data.<commit_after>-- $Id$
--
-- SQL script used by PostgresKit's integration tests.
--
-- For the tests to execute successfully this file should 
-- be run against a blank database called 'pgkit_test' and 
-- the user 'pgkit_test' with password '<PASSWORD>' should exit:
--
-- CREATE DATABASE pgkit_test;
-- CREATE USER pgkit_test WITH PASSWORD '<PASSWORD>';

BEGIN;

SET datestyle = 'DMY';
SET client_encoding = 'UNICODE';

IF EXISTS (
	SELECT 1 FROM information_schema.tables 
	WHERE table_name = 'data_types' 
	AND table_type = 'BASE TABLE'
)
	DROP TABLE data_types;
END

CREATE TABLE data_types
(
	int_field         INT PRIMARY KEY NOT NULL,
	smallint_field    SMALLINT NOT NULL,
	bigint_field      BIGINT NOT NULL,
	bool_field        BOOL NOT NULL,
	float_field       REAL NOT NULL,
	numeric_field     NUMERIC(5, 3) NOT NULL,
	char_field        CHAR(4) NOT NULL,
	varchar_field     VARCHAR(32) NOT NULL,
	date_field        DATE NOT NULL,
	time_field        TIME NOT NULL,
	timetz_field      TIME WITH TIME ZONE NOT NULL,
	timstamp_field    TIMESTAMP NOT NULL,
	timestamptz_field TIMESTAMP WITH TIME ZONE NOT NULL
);

INSERT INTO data_types (
	int_field, 
	smallint_field, 
	bool_field, 
	float_field, 
	char_field, 
 	varchar_field, 
	date_field, 
	time_field, 
	timetz_field, 
	timstamp_field, 
	timestamptz_field)
VALUES (
	12345, 
	2, 
	TRUE,
	123456789,
	12345.678,
	12345.678, 
	'CHAR',
	'VARCHAR', 
	'08-04-1987',
	'02:02:02',
	'02:02:02 GMT',
	'08-04-1987 02:02:02',
{'fraction_non_alphanumeric': 0.09027535726734054, 'fraction_numerical': 0.04600906239107703, 'mean_word_length': 3.751655629139073, 'pattern_counts': {'":': 0, '<': 7, '<?xml version=': 0, '>': 7, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '5821688', 'n_tokens_mistral': 1197, 'n_tokens_neox': 1047, 'n_words': 317}