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

In personalscience/taster: Personal Science CGM Analysis Web App

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, 4451L, 4532L, 4533L, 4534L, 4535L, 4536L, 
2249L, 2287L, 2275L, 2276L, 2277L, 2278L, 2279L, 3838L, 2280L, 
2281L, 2283L, 2776L, 3500L, 3115L, 325L, 3310L, 269L, 3831L, 
5077L, 5078L, 5079L, 5080L, 4537L, 4538L, 4600L, 4601L, 1000L, 
1001L, 1002L, 1003L, 1016L, 1005L, 1006L, 1007L, 1008L, 1009L, 
1028L, 1010L, 1011L, 1012L, 1013L, 210L, 270L, 272L, 273L, 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, 6150L, 6151L, 
6152L, 6153L, 6155L, 6157L, 1263L, 12001L, 12000L, 12003L, 12002L, 
12005L, 12004L, 12007L, 12006L, 12009L, 12008L, 12011L, 12010L, 
12013L, 12012L, 12015L, 12014L, 12017L, 12016L, 12019L, 12018L, 
12021L, 12020L, 12023L, 12022L, 12025L, 12024L, 12027L, 12026L, 
12029L, 12028L, 12031L, 12030L, 12033L, 12032L, 12035L, 12034L, 
12037L, 12036L, 12039L, 12038L, 12041L, 12040L, 12043L, 12042L, 
12045L, 12044L, 12047L, 12046L, 12049L, 12048L, 12051L, 12050L, 
1248L, 12052L, 12054L, 12053L, 12056L, 12055L, 2842L, 12057L, 
2843L, 12058L, 12060L, 12059L, 12062L, 12061L, 12064L, 12063L, 
12066L, 12065L, 12068L, 12067L, 12070L, 12069L, 12072L, 12071L, 
12074L, 12073L, 12076L, 12075L, 12078L, 12077L, 12080L, 12079L, 
12082L, 12081L, 12084L, 12083L, 12086L, 12085L, 12088L, 12087L, 
12090L, 12089L, 12092L, 12091L, 4066L, 12093L, 12095L, 12094L, 
12097L, 12096L, 12099L, 12098L, 12101L, 12100L, 12103L, 12102L, 
12105L, 12104L, 12107L, 12106L, 6101L, 12108L, 12110L, 12109L, 
12219L, 12218L, 12224L, 12223L, 12229L, 12228L, 12233L, 12232L, 
12237L, 12236L, 12242L, 12241L, 12247L, 12246L, 12252L, 12251L, 
12257L, 12256L, 12262L, 12261L, 12267L, 12266L, 12272L, 12271L, 
12277L, 12276L, 12282L, 12281L, 12287L, 12286L, 12292L, 12291L, 
12296L, 12295L, 12300L, 12299L, 12304L, 12303L, 12309L, 12308L, 
12314L, 12313L, 12318L, 12317L, 12323L, 12322L, 12329L, 12328L, 
12333L, 12332L, 12337L, 12336L, 12341L, 12340L, 12345L, 12344L, 
12349L, 12348L, 12353L, 12352L, 12357L, 12356L, 12362L, 12361L, 
12367L, 12366L, 12372L, 12371L, 12376L, 12375L, 12381L, 12380L, 
12385L, 12384L, 12390L, 12389L, 12394L, 12393L, 12398L, 12397L, 
12403L, 12402L, 12407L, 12406L, 12411L, 12410L, 12416L, 12415L, 
12420L, 12419L, 12424L, 12423L, 12429L, 12428L, 12433L, 12432L, 
12437L, 12436L, 12442L, 12441L, 12447L, 12446L, 12451L, 12450L, 
12455L, 12454L, 12460L, 12459L, 12464L, 12463L, 12468L, 12467L, 
12473L, 12472L, 12477L, 12476L, 12482L, 12481L, 12486L, 12485L, 
12491L, 12490L, 12496L, 12495L, 12500L, 12499L, 12504L, 12503L, 
12508L, 12507L, 12513L, 12512L, 12518L, 12517L, 12523L, 12522L, 
12528L, 12527L, 12533L, 12532L, 12538L, 12537L, 12543L, 12542L, 
13669L, 13668L, 13672L, 13671L, 13674L, 13673L, 13677L, 13676L, 
13680L, 13679L, 13682L, 13681L, 13686L, 13685L, 13691L, 13690L, 
13695L, 13694L, 13700L, 13699L, 13705L, 13704L, 13710L, 13709L, 
13715L, 13714L, 13720L, 13719L, 13725L, 13724L, 13730L, 13729L, 
13735L, 13734L, 13740L, 13739L, 13745L, 13744L, 13750L, 13749L, 
13755L, 13754L, 13760L, 13759L, 13765L, 13764L, 13770L, 13769L, 
13775L, 13774L, 13779L, 13778L, 13784L, 13783L, 13789L, 13788L, 
13794L, 13793L, 13798L, 13797L, 13803L, 13802L, 13808L, 13807L, 
13812L, 13811L, 13817L, 13816L, 13822L, 13821L, 13827L, 13826L, 
13832L, 13831L, 13836L, 13835L, 13841L, 13840L, 13846L, 13845L, 
13851L, 13850L, 13856L, 13855L, 13861L, 13860L, 13866L, 13865L, 
13871L, 13870L, 13875L, 13874L, 13880L, 13879L, 13885L, 13884L, 
13890L, 13889L, 13895L, 13894L, 13900L, 13899L, 13904L, 13903L, 
13909L, 13908L, 13913L, 13912L, 13918L, 13917L, 13923L, 13922L, 
13928L, 13927L, 13933L, 13932L, 13938L, 13937L, 13943L, 13942L, 
13948L, 13947L, 13953L, 13952L, 13957L, 13956L, 13961L, 13960L, 
13965L, 13964L, 13969L, 13968L, 13974L, 13973L, 13978L, 13977L, 
13982L, 13981L, 13987L, 13986L, 13991L, 13990L, 13995L, 13994L, 
14000L, 13999L, 14005L, 14004L, 16587L, 16586L, 16592L, 16591L, 
16599L, 16598L, 16604L, 16603L, 16610L, 16609L, 16616L, 16615L, 
16622L, 16621L, 16637L, 16636L), 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", 
"int4multirange", "nummultirange", "tsmultirange", "tstzmultirange", 
"datemultirange", "int8multirange", "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", "anymultirange", "anycompatiblemultirange", 
"pg_brin_bloom_summary", "pg_brin_minmax_multi_summary", "_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", "_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", 
"_int4multirange", "_nummultirange", "_tsmultirange", "_tstzmultirange", 
"_datemultirange", "_int8multirange", "_cstring", "pg_attrdef", 
"_pg_attrdef", "pg_constraint", "_pg_constraint", "pg_inherits", 
"_pg_inherits", "pg_index", "_pg_index", "pg_operator", "_pg_operator", 
"pg_opfamily", "_pg_opfamily", "pg_opclass", "_pg_opclass", "pg_am", 
"_pg_am", "pg_amop", "_pg_amop", "pg_amproc", "_pg_amproc", "pg_language", 
"_pg_language", "pg_largeobject_metadata", "_pg_largeobject_metadata", 
"pg_largeobject", "_pg_largeobject", "pg_aggregate", "_pg_aggregate", 
"pg_statistic", "_pg_statistic", "pg_statistic_ext", "_pg_statistic_ext", 
"pg_statistic_ext_data", "_pg_statistic_ext_data", "pg_rewrite", 
"_pg_rewrite", "pg_trigger", "_pg_trigger", "pg_event_trigger", 
"_pg_event_trigger", "pg_description", "_pg_description", "pg_cast", 
"_pg_cast", "pg_enum", "_pg_enum", "pg_namespace", "_pg_namespace", 
"pg_conversion", "_pg_conversion", "pg_depend", "_pg_depend", 
"pg_database", "_pg_database", "pg_db_role_setting", "_pg_db_role_setting", 
"pg_tablespace", "_pg_tablespace", "pg_authid", "_pg_authid", 
"pg_auth_members", "_pg_auth_members", "pg_shdepend", "_pg_shdepend", 
"pg_shdescription", "_pg_shdescription", "pg_ts_config", "_pg_ts_config", 
"pg_ts_config_map", "_pg_ts_config_map", "pg_ts_dict", "_pg_ts_dict", 
"pg_ts_parser", "_pg_ts_parser", "pg_ts_template", "_pg_ts_template", 
"pg_extension", "_pg_extension", "pg_foreign_data_wrapper", "_pg_foreign_data_wrapper", 
"pg_foreign_server", "_pg_foreign_server", "pg_user_mapping", 
"_pg_user_mapping", "pg_foreign_table", "_pg_foreign_table", 
"pg_policy", "_pg_policy", "pg_replication_origin", "_pg_replication_origin", 
"pg_default_acl", "_pg_default_acl", "pg_init_privs", "_pg_init_privs", 
"pg_seclabel", "_pg_seclabel", "pg_shseclabel", "_pg_shseclabel", 
"pg_collation", "_pg_collation", "pg_partitioned_table", "_pg_partitioned_table", 
"pg_range", "_pg_range", "pg_transform", "_pg_transform", "pg_sequence", 
"_pg_sequence", "pg_publication", "_pg_publication", "pg_publication_rel", 
"_pg_publication_rel", "pg_subscription", "_pg_subscription", 
"pg_subscription_rel", "_pg_subscription_rel", "pg_roles", "_pg_roles", 
"pg_shadow", "_pg_shadow", "pg_group", "_pg_group", "pg_user", 
"_pg_user", "pg_policies", "_pg_policies", "pg_rules", "_pg_rules", 
"pg_views", "_pg_views", "pg_tables", "_pg_tables", "pg_matviews", 
"_pg_matviews", "pg_indexes", "_pg_indexes", "pg_sequences", 
"_pg_sequences", "pg_stats", "_pg_stats", "pg_stats_ext", "_pg_stats_ext", 
"pg_stats_ext_exprs", "_pg_stats_ext_exprs", "pg_publication_tables", 
"_pg_publication_tables", "pg_locks", "_pg_locks", "pg_cursors", 
"_pg_cursors", "pg_available_extensions", "_pg_available_extensions", 
"pg_available_extension_versions", "_pg_available_extension_versions", 
"pg_prepared_xacts", "_pg_prepared_xacts", "pg_prepared_statements", 
"_pg_prepared_statements", "pg_seclabels", "_pg_seclabels", "pg_settings", 
"_pg_settings", "pg_file_settings", "_pg_file_settings", "pg_hba_file_rules", 
"_pg_hba_file_rules", "pg_timezone_abbrevs", "_pg_timezone_abbrevs", 
"pg_timezone_names", "_pg_timezone_names", "pg_config", "_pg_config", 
"pg_shmem_allocations", "_pg_shmem_allocations", "pg_backend_memory_contexts", 
"_pg_backend_memory_contexts", "pg_stat_all_tables", "_pg_stat_all_tables", 
"pg_stat_xact_all_tables", "_pg_stat_xact_all_tables", "pg_stat_sys_tables", 
"_pg_stat_sys_tables", "pg_stat_xact_sys_tables", "_pg_stat_xact_sys_tables", 
"pg_stat_user_tables", "_pg_stat_user_tables", "pg_stat_xact_user_tables", 
"_pg_stat_xact_user_tables", "pg_statio_all_tables", "_pg_statio_all_tables", 
"pg_statio_sys_tables", "_pg_statio_sys_tables", "pg_statio_user_tables", 
"_pg_statio_user_tables", "pg_stat_all_indexes", "_pg_stat_all_indexes", 
"pg_stat_sys_indexes", "_pg_stat_sys_indexes", "pg_stat_user_indexes", 
"_pg_stat_user_indexes", "pg_statio_all_indexes", "_pg_statio_all_indexes", 
"pg_statio_sys_indexes", "_pg_statio_sys_indexes", "pg_statio_user_indexes", 
"_pg_statio_user_indexes", "pg_statio_all_sequences", "_pg_statio_all_sequences", 
"pg_statio_sys_sequences", "_pg_statio_sys_sequences", "pg_statio_user_sequences", 
"_pg_statio_user_sequences", "pg_stat_activity", "_pg_stat_activity", 
"pg_stat_replication", "_pg_stat_replication", "pg_stat_slru", 
"_pg_stat_slru", "pg_stat_wal_receiver", "_pg_stat_wal_receiver", 
"pg_stat_subscription", "_pg_stat_subscription", "pg_stat_ssl", 
"_pg_stat_ssl", "pg_stat_gssapi", "_pg_stat_gssapi", "pg_replication_slots", 
"_pg_replication_slots", "pg_stat_replication_slots", "_pg_stat_replication_slots", 
"pg_stat_database", "_pg_stat_database", "pg_stat_database_conflicts", 
"_pg_stat_database_conflicts", "pg_stat_user_functions", "_pg_stat_user_functions", 
"pg_stat_xact_user_functions", "_pg_stat_xact_user_functions", 
"pg_stat_archiver", "_pg_stat_archiver", "pg_stat_bgwriter", 
"_pg_stat_bgwriter", "pg_stat_wal", "_pg_stat_wal", "pg_stat_progress_analyze", 
"_pg_stat_progress_analyze", "pg_stat_progress_vacuum", "_pg_stat_progress_vacuum", 
"pg_stat_progress_cluster", "_pg_stat_progress_cluster", "pg_stat_progress_create_index", 
"_pg_stat_progress_create_index", "pg_stat_progress_basebackup", 
"_pg_stat_progress_basebackup", "pg_stat_progress_copy", "_pg_stat_progress_copy", 
"pg_user_mappings", "_pg_user_mappings", "pg_replication_origin_status", 
"_pg_replication_origin_status", "cardinal_number", "_cardinal_number", 
"character_data", "_character_data", "sql_identifier", "_sql_identifier", 
"information_schema_catalog_name", "_information_schema_catalog_name", 
"time_stamp", "_time_stamp", "yes_or_no", "_yes_or_no", "applicable_roles", 
"_applicable_roles", "administrable_role_authorizations", "_administrable_role_authorizations", 
"attributes", "_attributes", "character_sets", "_character_sets", 
"check_constraint_routine_usage", "_check_constraint_routine_usage", 
"check_constraints", "_check_constraints", "collations", "_collations", 
"collation_character_set_applicability", "_collation_character_set_applicability", 
"column_column_usage", "_column_column_usage", "column_domain_usage", 
"_column_domain_usage", "column_privileges", "_column_privileges", 
"column_udt_usage", "_column_udt_usage", "columns", "_columns", 
"constraint_column_usage", "_constraint_column_usage", "constraint_table_usage", 
"_constraint_table_usage", "domain_constraints", "_domain_constraints", 
"domain_udt_usage", "_domain_udt_usage", "domains", "_domains", 
"enabled_roles", "_enabled_roles", "key_column_usage", "_key_column_usage", 
"parameters", "_parameters", "referential_constraints", "_referential_constraints", 
"role_column_grants", "_role_column_grants", "routine_column_usage", 
"_routine_column_usage", "routine_privileges", "_routine_privileges", 
"role_routine_grants", "_role_routine_grants", "routine_routine_usage", 
"_routine_routine_usage", "routine_sequence_usage", "_routine_sequence_usage", 
"routine_table_usage", "_routine_table_usage", "routines", "_routines", 
"schemata", "_schemata", "sequences", "_sequences", "sql_features", 
"_sql_features", "sql_implementation_info", "_sql_implementation_info", 
"sql_parts", "_sql_parts", "sql_sizing", "_sql_sizing", "table_constraints", 
"_table_constraints", "table_privileges", "_table_privileges", 
"role_table_grants", "_role_table_grants", "tables", "_tables", 
"transforms", "_transforms", "triggered_update_columns", "_triggered_update_columns", 
"triggers", "_triggers", "udt_privileges", "_udt_privileges", 
"role_udt_grants", "_role_udt_grants", "usage_privileges", "_usage_privileges", 
"role_usage_grants", "_role_usage_grants", "user_defined_types", 
"_user_defined_types", "view_column_usage", "_view_column_usage", 
"view_routine_usage", "_view_routine_usage", "view_table_usage", 
"_view_table_usage", "views", "_views", "data_type_privileges", 
"_data_type_privileges", "element_types", "_element_types", "_pg_foreign_table_columns", 
"__pg_foreign_table_columns", "column_options", "_column_options", 
"_pg_foreign_data_wrappers", "__pg_foreign_data_wrappers", "foreign_data_wrapper_options", 
"_foreign_data_wrapper_options", "foreign_data_wrappers", "_foreign_data_wrappers", 
"_pg_foreign_servers", "__pg_foreign_servers", "foreign_server_options", 
"_foreign_server_options", "foreign_servers", "_foreign_servers", 
"_pg_foreign_tables", "__pg_foreign_tables", "foreign_table_options", 
"_foreign_table_options", "foreign_tables", "_foreign_tables", 
"_pg_user_mappings", "__pg_user_mappings", "user_mapping_options", 
"_user_mapping_options", "user_mappings", "_user_mappings", "user_list", 
"_user_list", "glucose_records", "_glucose_records", "notes_records", 
"_notes_records", "accounts_user", "_accounts_user", "accounts_firebase", 
"_accounts_firebase", "accounts_user_demographics", "_accounts_user_demographics", 
"experiments", "_experiments", "raw_glucose", "_raw_glucose")), class = "data.frame", row.names = c(NA, 
-617L))