tests/testthat/ddvtest/SELECT-526b8c.R

In majazaloznik/ddvR: Parsing Weekly DDV (VAT) Data from FURS

structure(list(oid = c(16L, 17L, 18L, 19L, 20L, 21L, 22L, 23L, 
24L, 25L, 26L, 27L, 28L, 29L, 30L, 71L, 75L, 81L, 83L, 114L, 
142L, 194L, 3361L, 3402L, 5017L, 32L, 5069L, 600L, 601L, 602L, 
603L, 604L, 628L, 700L, 701L, 705L, 718L, 790L, 829L, 869L, 650L, 
774L, 1033L, 1042L, 1043L, 1082L, 1083L, 1114L, 1184L, 1186L, 
1266L, 1560L, 1562L, 1700L, 1790L, 2202L, 2203L, 2204L, 2205L, 
4191L, 2206L, 4096L, 4089L, 2950L, 3220L, 3614L, 3642L, 3615L, 
3734L, 3769L, 3802L, 4072L, 2970L, 5038L, 3904L, 3906L, 3908L, 
3910L, 3912L, 3926L, 2249L, 2287L, 2275L, 2276L, 2277L, 2278L, 
2279L, 3838L, 2280L, 2281L, 2283L, 2776L, 3500L, 3115L, 325L, 
3310L, 269L, 3831L, 5077L, 5078L, 5079L, 5080L, 1000L, 1001L, 
1002L, 1003L, 1016L, 1005L, 1006L, 1007L, 1008L, 1009L, 1028L, 
1010L, 1011L, 1012L, 1013L, 199L, 143L, 271L, 1017L, 1018L, 1019L, 
1020L, 1027L, 629L, 1021L, 1022L, 719L, 791L, 1040L, 1041L, 651L, 
775L, 1034L, 1014L, 1015L, 1182L, 1183L, 1115L, 1185L, 1187L, 
1270L, 1561L, 1563L, 1231L, 2201L, 2207L, 2208L, 2209L, 2210L, 
4192L, 2211L, 4097L, 4090L, 2951L, 3221L, 3643L, 3644L, 3645L, 
3735L, 3770L, 3807L, 4073L, 2949L, 5039L, 3905L, 3907L, 3909L, 
3911L, 3913L, 3927L, 1263L, 12000L, 12001L, 12002L, 12003L, 12004L, 
12005L, 12006L, 12007L, 12008L, 12009L, 12010L, 12011L, 12012L, 
12013L, 12014L, 12015L, 12016L, 12017L, 12018L, 12019L, 12020L, 
12021L, 12022L, 12023L, 12024L, 12025L, 1248L, 12026L, 12027L, 
2842L, 2843L, 12028L, 12029L, 12030L, 12031L, 12032L, 12033L, 
12034L, 12035L, 12036L, 12037L, 12038L, 12039L, 12040L, 12041L, 
12042L, 12043L, 12044L, 4066L, 12045L, 12046L, 12047L, 12048L, 
12049L, 12050L, 12051L, 6101L, 12052L, 12053L, 12054L, 12055L, 
12056L, 12057L, 12058L, 12059L, 12060L, 12061L, 12062L, 12063L, 
12064L, 12065L, 12066L, 12067L, 12068L, 12069L, 12070L, 12071L, 
12072L, 12073L, 12074L, 12075L, 12076L, 12077L, 12078L, 12079L, 
12080L, 12081L, 12082L, 12083L, 12084L, 12085L, 12086L, 12088L, 
12092L, 12096L, 12099L, 12102L, 12106L, 12110L, 12114L, 12118L, 
12122L, 12126L, 12130L, 12134L, 12138L, 12142L, 12145L, 12148L, 
12151L, 12155L, 12159L, 12162L, 12166L, 12171L, 12174L, 12177L, 
12180L, 12183L, 12186L, 12189L, 12193L, 12197L, 12201L, 12204L, 
12208L, 12211L, 12215L, 12218L, 12221L, 12225L, 12228L, 12231L, 
12235L, 12238L, 12241L, 12245L, 12248L, 12251L, 12255L, 12259L, 
12262L, 12265L, 12268L, 12271L, 12274L, 12278L, 12282L, 12285L, 
12289L, 12293L, 12296L, 12299L, 12303L, 12307L, 12311L, 12315L, 
12319L, 12323L, 13171L, 13170L, 13174L, 13173L, 13176L, 13175L, 
13178L, 13181L, 13180L, 13183L, 13182L, 13186L, 13190L, 13193L, 
13197L, 13201L, 13205L, 13209L, 13213L, 13217L, 13221L, 13225L, 
13229L, 13233L, 13237L, 13241L, 13245L, 13249L, 13253L, 13257L, 
13260L, 13264L, 13268L, 13272L, 13275L, 13279L, 13282L, 13286L, 
13289L, 13293L, 13295L, 13298L, 13300L, 13303L, 13305L, 13308L, 
13310L, 13313L, 13317L, 13321L, 13324L, 13328L, 13332L, 13336L, 
13340L, 13344L, 13347L, 13351L, 13354L, 13358L, 13362L, 13366L, 
13370L, 13374L, 13378L, 13382L, 13386L, 13389L, 13392L, 13395L, 
13398L, 13402L, 13405L, 13408L, 13412L, 13415L, 13418L, 13422L, 
13426L, 25923L, 25928L, 26007L, 26010L, 27546L, 27545L, 27548L, 
27557L, 27556L, 27559L, 27563L, 27562L, 27565L, 27569L, 27568L, 
27571L, 27576L, 27575L, 27578L, 27582L, 27581L, 27584L), typname = c("bool", 
"bytea", "char", "name", "int8", "int2", "int2vector", "int4", 
"regproc", "text", "oid", "tid", "xid", "cid", "oidvector", "pg_type", 
"pg_attribute", "pg_proc", "pg_class", "json", "xml", "pg_node_tree", 
"pg_ndistinct", "pg_dependencies", "pg_mcv_list", "pg_ddl_command", 
"xid8", "point", "lseg", "path", "box", "polygon", "line", "float4", 
"float8", "unknown", "circle", "money", "macaddr", "inet", "cidr", 
"macaddr8", "aclitem", "bpchar", "varchar", "date", "time", "timestamp", 
"timestamptz", "interval", "timetz", "bit", "varbit", "numeric", 
"refcursor", "regprocedure", "regoper", "regoperator", "regclass", 
"regcollation", "regtype", "regrole", "regnamespace", "uuid", 
"pg_lsn", "tsvector", "gtsvector", "tsquery", "regconfig", "regdictionary", 
"jsonb", "jsonpath", "txid_snapshot", "pg_snapshot", "int4range", 
"numrange", "tsrange", "tstzrange", "daterange", "int8range", 
"record", "_record", "cstring", "any", "anyarray", "void", "trigger", 
"event_trigger", "language_handler", "internal", "anyelement", 
"anynonarray", "anyenum", "fdw_handler", "index_am_handler", 
"tsm_handler", "table_am_handler", "anyrange", "anycompatible", 
"anycompatiblearray", "anycompatiblenonarray", "anycompatiblerange", 
"_bool", "_bytea", "_char", "_name", "_int8", "_int2", "_int2vector", 
"_int4", "_regproc", "_text", "_oid", "_tid", "_xid", "_cid", 
"_oidvector", "_json", "_xml", "_xid8", "_point", "_lseg", "_path", 
"_box", "_polygon", "_line", "_float4", "_float8", "_circle", 
"_money", "_macaddr", "_inet", "_cidr", "_macaddr8", "_aclitem", 
"_bpchar", "_varchar", "_date", "_time", "_timestamp", "_timestamptz", 
"_interval", "_timetz", "_bit", "_varbit", "_numeric", "_refcursor", 
"_regprocedure", "_regoper", "_regoperator", "_regclass", "_regcollation", 
"_regtype", "_regrole", "_regnamespace", "_uuid", "_pg_lsn", 
"_tsvector", "_gtsvector", "_tsquery", "_regconfig", "_regdictionary", 
"_jsonb", "_jsonpath", "_txid_snapshot", "_pg_snapshot", "_int4range", 
"_numrange", "_tsrange", "_tstzrange", "_daterange", "_int8range", 
"_cstring", "pg_attrdef", "pg_constraint", "pg_inherits", "pg_index", 
"pg_operator", "pg_opfamily", "pg_opclass", "pg_am", "pg_amop", 
"pg_amproc", "pg_language", "pg_largeobject_metadata", "pg_largeobject", 
"pg_aggregate", "pg_statistic_ext", "pg_statistic_ext_data", 
"pg_statistic", "pg_rewrite", "pg_trigger", "pg_event_trigger", 
"pg_description", "pg_cast", "pg_enum", "pg_namespace", "pg_conversion", 
"pg_depend", "pg_database", "pg_db_role_setting", "pg_tablespace", 
"pg_authid", "pg_auth_members", "pg_shdepend", "pg_shdescription", 
"pg_ts_config", "pg_ts_config_map", "pg_ts_dict", "pg_ts_parser", 
"pg_ts_template", "pg_extension", "pg_foreign_data_wrapper", 
"pg_foreign_server", "pg_user_mapping", "pg_foreign_table", "pg_policy", 
"pg_replication_origin", "pg_default_acl", "pg_init_privs", "pg_seclabel", 
"pg_shseclabel", "pg_collation", "pg_partitioned_table", "pg_range", 
"pg_transform", "pg_sequence", "pg_publication", "pg_publication_rel", 
"pg_subscription", "pg_subscription_rel", "pg_toast_2600", "pg_toast_2604", 
"pg_toast_3456", "pg_toast_2606", "pg_toast_826", "pg_toast_2609", 
"pg_toast_3466", "pg_toast_3079", "pg_toast_2328", "pg_toast_1417", 
"pg_toast_3118", "pg_toast_3394", "pg_toast_2612", "pg_toast_2615", 
"pg_toast_3350", "pg_toast_3256", "pg_toast_1255", "pg_toast_2618", 
"pg_toast_3596", "pg_toast_2619", "pg_toast_3381", "pg_toast_3429", 
"pg_toast_2620", "pg_toast_3600", "pg_toast_1247", "pg_toast_1418", 
"pg_toast_1260", "pg_toast_1262", "pg_toast_2964", "pg_toast_6000", 
"pg_toast_2396", "pg_toast_3592", "pg_toast_6100", "pg_toast_1213", 
"pg_roles", "pg_shadow", "pg_group", "pg_user", "pg_policies", 
"pg_rules", "pg_views", "pg_tables", "pg_matviews", "pg_indexes", 
"pg_sequences", "pg_stats", "pg_stats_ext", "pg_publication_tables", 
"pg_locks", "pg_cursors", "pg_available_extensions", "pg_available_extension_versions", 
"pg_prepared_xacts", "pg_prepared_statements", "pg_seclabels", 
"pg_settings", "pg_file_settings", "pg_hba_file_rules", "pg_timezone_abbrevs", 
"pg_timezone_names", "pg_config", "pg_shmem_allocations", "pg_stat_all_tables", 
"pg_stat_xact_all_tables", "pg_stat_sys_tables", "pg_stat_xact_sys_tables", 
"pg_stat_user_tables", "pg_stat_xact_user_tables", "pg_statio_all_tables", 
"pg_statio_sys_tables", "pg_statio_user_tables", "pg_stat_all_indexes", 
"pg_stat_sys_indexes", "pg_stat_user_indexes", "pg_statio_all_indexes", 
"pg_statio_sys_indexes", "pg_statio_user_indexes", "pg_statio_all_sequences", 
"pg_statio_sys_sequences", "pg_statio_user_sequences", "pg_stat_activity", 
"pg_stat_replication", "pg_stat_slru", "pg_stat_wal_receiver", 
"pg_stat_subscription", "pg_stat_ssl", "pg_stat_gssapi", "pg_replication_slots", 
"pg_stat_database", "pg_stat_database_conflicts", "pg_stat_user_functions", 
"pg_stat_xact_user_functions", "pg_stat_archiver", "pg_stat_bgwriter", 
"pg_stat_progress_analyze", "pg_stat_progress_vacuum", "pg_stat_progress_cluster", 
"pg_stat_progress_create_index", "pg_stat_progress_basebackup", 
"pg_user_mappings", "pg_replication_origin_status", "cardinal_number", 
"_cardinal_number", "character_data", "_character_data", "sql_identifier", 
"_sql_identifier", "information_schema_catalog_name", "time_stamp", 
"_time_stamp", "yes_or_no", "_yes_or_no", "applicable_roles", 
"administrable_role_authorizations", "attributes", "character_sets", 
"check_constraint_routine_usage", "check_constraints", "collations", 
"collation_character_set_applicability", "column_column_usage", 
"column_domain_usage", "column_privileges", "column_udt_usage", 
"columns", "constraint_column_usage", "constraint_table_usage", 
"domain_constraints", "domain_udt_usage", "domains", "enabled_roles", 
"key_column_usage", "parameters", "referential_constraints", 
"role_column_grants", "routine_privileges", "role_routine_grants", 
"routines", "schemata", "sequences", "sql_features", "pg_toast_13292", 
"sql_implementation_info", "pg_toast_13297", "sql_parts", "pg_toast_13302", 
"sql_sizing", "pg_toast_13307", "table_constraints", "table_privileges", 
"role_table_grants", "tables", "transforms", "triggered_update_columns", 
"triggers", "udt_privileges", "role_udt_grants", "usage_privileges", 
"role_usage_grants", "user_defined_types", "view_column_usage", 
"view_routine_usage", "view_table_usage", "views", "data_type_privileges", 
"element_types", "_pg_foreign_table_columns", "column_options", 
"_pg_foreign_data_wrappers", "foreign_data_wrapper_options", 
"foreign_data_wrappers", "_pg_foreign_servers", "foreign_server_options", 
"foreign_servers", "_pg_foreign_tables", "foreign_table_options", 
"foreign_tables", "_pg_user_mappings", "user_mapping_options", 
"user_mappings", "hstore", "_hstore", "ghstore", "_ghstore", 
"davcni_racuni", "_davcni_racuni", "pg_toast_27544", "airlines", 
"_airlines", "pg_toast_27555", "airports", "_airports", "pg_toast_27561", 
"flights", "_flights", "pg_toast_27567", "planes", "_planes", 
"pg_toast_27574", "weather", "_weather", "pg_toast_27580")), class = "data.frame", row.names = c(NA, 
-433L))