-- SELECT
--     setseed(0.5);
BEGIN;

INSERT INTO t_numeric_types(c_smallint, c_integer, c_bigint, c_decimal, c_numeric, c_real, c_double_precision)
    VALUES (1, 1, 1, 1.0::decimal, 1.0::numeric, 1.0::real, 1.0::double precision);

INSERT INTO t_numeric_types(c_decimal, c_numeric, c_real, c_double_precision)
    VALUES ('NaN'::decimal, 'NaN'::numeric, 'NaN'::real, 'NaN'::double precision);

INSERT INTO t_binary_types(bytea_col)
    VALUES ('\xDEADBEEF');

INSERT INTO t_character_types(c_char, c_varchar, c_text)
    VALUES (
    LEFT (md5(random()::text), 4), array_to_string(ARRAY (
            SELECT
                chr((65 + round(random() * 25))::integer)
    FROM generate_series(1,(random() * 10)::int)), ''),
    array_to_string(ARRAY (
            SELECT
                chr((65 + round(random() * 25))::integer)
    FROM generate_series(1,(random() * 100)::int)), ''));

INSERT INTO t_time_types(c_time, c_timetz, c_timestamp, c_timestamptz)
    VALUES ('12:34:56', '12:34:56+05:00', '2022-11-01 12:34:56', '2022-11-01 12:34:56+05:00');

INSERT INTO t_geometric_types(point_col, line_col, lseg_col, box_col, path_col1, path_col2, polygon_col, circle_col)
    VALUES ('(1,1)', '(1,1,2,2)', '(1,1,2,2)', '(1,1,2,2)', '(1,1,2,2)', '(1,1,2,2)', '((1,1),(2,2),(3,3))', '<(1,1),2>');

INSERT INTO t_network_types(cidr_col, inet_col, macaddr_col)
    VALUES ('192.168.0.0/24', '192.168.0.1', '00:11:22:33:44:55');

INSERT INTO t_bit_types
    VALUES (B'101', B'00');

INSERT INTO t_bit_types
    VALUES (B'10'::bit(3), B'101');

INSERT INTO t_json_types(json_col, jsonb_col)
    VALUES ('{"name": "John", "age": 30}', '{"name": "John", "age": 30}');

INSERT INTO t_array_types(int_array, text_array, boolean_array)
    VALUES ('{1,2,3}', '{hello,world}', '{true,false}');

INSERT INTO t_complex_types(address_col)
    VALUES (('123 Example St', 'New York', 'NY', '10001'));

INSERT INTO t_range_types(int4range_col, int8range_col, numrange_col, tsrange_col, tstzrange_col, daterange_col)
    VALUES ('[1,10]', '[1,10]', '[1,10]', '[2022-01-01, 2022-12-31]', '[2022-01-01, 2022-12-31]', '[2022-01-01, 2022-12-31]');

INSERT INTO t_domain_types(email_col, age)
    VALUES ('example@example.com', 25);

COMMIT;

