use crate::postgres_source::models::PgType;
pub const COPY_SIGNATURE: &[u8] = b"PGCOPY\n\xff\r\n\0";
pub const HEADER_FIXED_LENGTH: usize = 19;
pub const HEADER_EXTENSION_OFFSET: usize = 15;
pub const COPY_TRAILER: i16 = -1;
pub const NULL_FIELD_LENGTH: i32 = -1;
pub const POSTGRES_EPOCH_DAYS: i32 = 10_957;
pub const POSTGRES_EPOCH_MICROS: i64 = 946_684_800_000_000;
pub const DEFAULT_BATCH_ROWS: usize = 65_536;
pub const DEFAULT_BATCH_BYTES: usize = 64 * 1024 * 1024;
pub const NUMERIC_DIGIT_WIDTH: i32 = 4;
pub const NUMERIC_POSITIVE: u16 = 0x0000;
pub const NUMERIC_NEGATIVE: u16 = 0x4000;
pub const CATALOG_COLUMNS_SQL: &str = "
SELECT n.nspname, c.relname, a.attname, format_type(a.atttypid, a.atttypmod), t.typname,
information_schema._pg_numeric_precision(a.atttypid, a.atttypmod),
information_schema._pg_numeric_scale(a.atttypid, a.atttypmod),
information_schema._pg_char_max_length(a.atttypid, a.atttypmod),
t.typcategory::text, NOT a.attnotnull,
c.reltuples::bigint, pg_total_relation_size(c.oid), obj_description(c.oid, 'pg_class')
FROM pg_catalog.pg_attribute a
JOIN pg_catalog.pg_class c ON c.oid = a.attrelid
JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
JOIN pg_catalog.pg_type t ON t.oid = a.atttypid
WHERE c.relkind IN ('r', 'p', 'v', 'm') AND a.attnum > 0 AND NOT a.attisdropped
AND n.nspname NOT IN ('pg_catalog', 'information_schema', 'pg_toast')
AND n.nspname NOT LIKE 'pg\\_temp\\_%' AND n.nspname NOT LIKE 'pg\\_toast\\_temp\\_%'
AND NOT c.relispartition
ORDER BY n.nspname, c.relname, a.attnum";
pub const CATALOG_PRIMARY_KEYS_SQL: &str = "
SELECT n.nspname, c.relname, a.attname
FROM pg_catalog.pg_constraint k
JOIN pg_catalog.pg_class c ON c.oid = k.conrelid
JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
CROSS JOIN LATERAL unnest(k.conkey) WITH ORDINALITY AS key(attnum, position)
JOIN pg_catalog.pg_attribute a ON a.attrelid = c.oid AND a.attnum = key.attnum
WHERE k.contype = 'p'
ORDER BY n.nspname, c.relname, key.position";
pub const CATALOG_INDEXED_COLUMNS_SQL: &str = "
SELECT DISTINCT n.nspname, c.relname, a.attname
FROM pg_catalog.pg_index i
JOIN pg_catalog.pg_class c ON c.oid = i.indrelid
JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
JOIN pg_catalog.pg_class ic ON ic.oid = i.indexrelid
JOIN pg_catalog.pg_am am ON am.oid = ic.relam
JOIN pg_catalog.pg_attribute a ON a.attrelid = c.oid AND a.attnum = i.indkey[0]
WHERE am.amname = 'btree' AND i.indisvalid AND i.indpred IS NULL
ORDER BY 1, 2, 3";
pub const ARRAY_CATEGORY: &str = "A";
pub const NATIVE_TYPE_NAMES: &[(&str, PgType)] = &[
("bool", PgType::Bool),
("int2", PgType::Int2),
("int4", PgType::Int4),
("int8", PgType::Int8),
("oid", PgType::Oid),
("float4", PgType::Float4),
("float8", PgType::Float8),
("numeric", PgType::Numeric),
("text", PgType::Text),
("varchar", PgType::Varchar),
("date", PgType::Date),
("time", PgType::Time),
("timestamp", PgType::Timestamp),
("timestamptz", PgType::TimestampTz),
("json", PgType::Json),
("jsonb", PgType::Json),
("uuid", PgType::Uuid),
("bytea", PgType::Bytea),
];
pub const SESSION_OPTIONS: &str = "-c TimeZone=UTC -c standard_conforming_strings=on";
pub const COPY_QUEUE_BATCHES: usize = 2;
pub const COPY_READ_AHEAD_BYTES: usize = 1024 * 1024;
pub const COPY_READ_AHEAD_GROUPS: usize = 8;
pub const SPLIT_BEGIN: &str = "BEGIN ISOLATION LEVEL REPEATABLE READ READ ONLY";
pub const SPLIT_PAGES_SQL: &str = "
SELECT current_setting('server_version_num')::int >= 140000 AND c.relkind = 'r',
pg_relation_size(c.oid) / current_setting('block_size')::bigint
FROM pg_catalog.pg_class c
JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
WHERE n.nspname = $1 AND c.relname = $2";
pub const SPLIT_READ_MIN_PAGES: i64 = 16_384;