{ "_id": "6a0f6b75acfb0bcc41c5e62d", "Package": "acdcquery", "Title": "Query the Attentional Control Data Collection or the Truth\nEffect Database", "Version": "1.2.3", "Authors@R": "c(\nperson(given = \"Sven\", family = \"Lesche\", email = \"sven.lesche@psychologie.uni-heidelberg.de\", role = c(\"aut\", \"cre\", \"cph\")),\nperson(given = \"Julia M.\", family = \"Haaf\", email = \"j.m.haaf@uva.nl\", role = c(\"ctb\", \"ths\")),\nperson(given = \"Madlen\", family = \"Hoffstadt\", email = \"madlenfeehoffstadt@gmail.com\", role = c(\"ctb\"))\n)", "Description": "Interact with the Attentional Control Data Collection\n(ACDC) or the Truth Effect Database (TED). Download the\ndatabases using download_acdc() or download_ted(), connect to\nthe database via connect_to_db(), set filter arguments via\nadd_argument() and query the database via query_db().", "License": "GPL (>= 3)", "Encoding": "UTF-8", "Roxygen": "list(markdown = TRUE)", "RoxygenNote": "7.3.2", "URL": "https://github.com/SLesche/acdc-query", "BugReports": "https://github.com/SLesche/acdc-query/issues", "Config/pak/sysreqs": "libssl-dev", "Repository": "https://slesche.r-universe.dev", "Date/Publication": "2026-02-19 16:11:00 UTC", "RemoteUrl": "https://github.com/slesche/acdc-query", "RemoteRef": "HEAD", "RemoteSha": "4f118031115f0cbcaf8e72295ed557f9f94bde27", "NeedsCompilation": "no", "Packaged": { "Date": "2026-05-21 08:32:11 UTC", "User": "root" }, "Author": "Sven Lesche [aut, cre, cph],\nJulia M. Haaf [ctb, ths],\nMadlen Hoffstadt [ctb]", "Maintainer": "Sven Lesche ", "MD5sum": "c4a35aca9ebeda1d3ba2f727032356d0", "_user": "slesche", "_type": "src", "_file": "acdcquery_1.2.3.tar.gz", "_fileid": "8a29b094c24da74f77993c459aee575e15206e5b15318a2a72a9562aa7a359a8", "_filesize": 144306, "_sha256": "8a29b094c24da74f77993c459aee575e15206e5b15318a2a72a9562aa7a359a8", "_created": "2026-05-21T08:32:11.000Z", "_published": "2026-05-21T20:30:45.834Z", "_distro": "noble", "_jobs": [ { "job": 77262686959, "time": 127, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "7130999170" }, { "job": 77262686965, "time": 122, "config": "linux-release-x86_64", "r": "4.6.0", "check": "OK", "artifact": "7130996868" }, { "job": 77262687325, "time": 156, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "7130997261" }, { "job": 77262687271, "time": 134, "config": "macos-release-arm64", "r": "4.6.0", "check": "OK", "artifact": "7130989717" }, { "job": 77262686499, "time": 172, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7130952670" }, { "job": 77262686496, "time": 101, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7146486216" }, { "job": 77262687056, "time": 76, "config": "windows-devel", "r": "4.7.0", "check": "OK", "artifact": "7130980623" }, { "job": 77262687091, "time": 64, "config": "windows-oldrel", "r": "4.5.3", "check": "OK", "artifact": "7130976338" }, { "job": 77262687255, "time": 68, "config": "windows-release", "r": "4.6.0", "check": "OK", "artifact": "7130976971" } ], "_buildurl": "https://github.com/r-universe/slesche/actions/runs/26214748665", "_status": "success", "_host": "GitHub-Actions", "_upstream": "https://github.com/slesche/acdc-query", "_commit": { "id": "4f118031115f0cbcaf8e72295ed557f9f94bde27", "author": "Sven Lesche <113923517+SLesche@users.noreply.github.com>", "committer": "Sven Lesche <113923517+SLesche@users.noreply.github.com>", "message": "update readme\n", "time": 1771517460 }, "_maintainer": { "name": "Sven Lesche", "email": "sven.lesche@psychologie.uni-heidelberg.de" }, "_registered": true, "_dependencies": [ { "package": "DBI", "role": "Imports" }, { "package": "RSQLite", "role": "Imports" }, { "package": "httr", "role": "Imports" }, { "package": "jsonlite", "role": "Imports" }, { "package": "digest", "role": "Imports" } ], "_owner": "slesche", "_selfowned": true, "_usedby": 0, "_updates": [ { "week": "2025-26", "n": 1 }, { "week": "2025-31", "n": 5 }, { "week": "2025-48", "n": 2 }, { "week": "2025-49", "n": 1 }, { "week": "2026-08", "n": 18 } ], "_tags": [ { "name": "v1.1.1", "date": "2025-11-28" } ], "_stars": 0, "_contributors": [ { "user": "slesche", "count": 135, "uuid": 113923517 } ], "_userbio": { "uuid": 113923517, "type": "user", "name": "Sven Lesche", "description": "PhD Candidate | Psychology | Heidelberg University" }, "_downloads": { "count": 280, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/acdcquery" }, "_devurl": "https://github.com/slesche/acdc-query", "_searchresults": 22, "_rbuild": "4.6.0", "_assets": [ "extra/acdcquery.html", "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/NEWS.html", "extra/NEWS.txt", "extra/readme.html", "extra/readme.md", "manual.pdf" ], "_homeurl": "https://github.com/slesche/acdc-query", "_realowner": "slesche", "_cranurl": true, "_releases": [ { "version": "1.0.1", "date": "2023-10-20" }, { "version": "1.1.0", "date": "2025-08-01" }, { "version": "1.1.1", "date": "2025-11-30" }, { "version": "1.2.1", "date": "2026-02-18" }, { "version": "1.2.2", "date": "2026-02-18" }, { "version": "1.2.3", "date": "2026-02-19" } ], "_exports": [ "add_argument", "check_acdc", "check_ted", "connect_to_db", "download_acdc", "download_ted", "query_db", "update_acdc", "update_ted" ], "_help": [ { "page": "add_argument", "title": "Add a filter argument to a list", "topics": [ "add_argument" ] }, { "page": "add_join_paths_to_query", "title": "Add Join Paths to Query", "topics": [ "add_join_paths_to_query" ] }, { "page": "check_acdc", "title": "Check local ACDC database against GitHub release", "topics": [ "check_acdc" ] }, { "page": "check_operator", "title": "Check validity of operator and values", "topics": [ "check_operator" ] }, { "page": "check_ted", "title": "Check local TED database against GitHub release", "topics": [ "check_ted" ] }, { "page": "compare_sqlite_to_release", "title": "Compare local SQLite database to GitHub release hash", "topics": [ "compare_sqlite_to_release" ] }, { "page": "connect_to_db", "title": "Connect to an SQLite database", "topics": [ "connect_to_db" ] }, { "page": "create_sqlite_hash_file", "title": "Create SHA256 hash file for a SQLite database", "topics": [ "create_sqlite_hash_file" ] }, { "page": "discover_id_introduction_steps", "title": "Discover ID Introduction Steps", "topics": [ "discover_id_introduction_steps" ] }, { "page": "download_acdc", "title": "Download ACDC database from GitHub release", "topics": [ "download_acdc" ] }, { "page": "download_sqlite_release", "title": "Download SQLite file from GitHub release", "topics": [ "download_sqlite_release" ] }, { "page": "download_ted", "title": "Download TED database from GitHub release", "topics": [ "download_ted" ] }, { "page": "find_relevant_tables", "title": "Find relevant tables based on column name", "topics": [ "find_relevant_tables" ] }, { "page": "get_argument_sequence", "title": "Get argument sequence based on argument relation", "topics": [ "get_argument_sequence" ] }, { "page": "get_column_names", "title": "Get column names from database tables", "topics": [ "get_column_names" ] }, { "page": "get_filter_statement", "title": "Get Filter Statement", "topics": [ "get_filter_statement" ] }, { "page": "make_valid_sql", "title": "Create a valid SQL statement based on variable, operator, and values", "topics": [ "make_valid_sql" ] }, { "page": "precompute_table_join_paths", "title": "Precompute Table Join Paths", "topics": [ "precompute_table_join_paths" ] }, { "page": "query_db", "title": "Query Database", "topics": [ "query_db" ] }, { "page": "return_id_name_from_table", "title": "Return ID column name from table name", "topics": [ "return_id_name_from_table" ] }, { "page": "return_table_name_from_id", "title": "Return table name from ID column name", "topics": [ "return_table_name_from_id" ] }, { "page": "update_acdc", "title": "Update local ACDC database from GitHub release", "topics": [ "update_acdc" ] }, { "page": "update_database", "title": "Update a local SQLite database from a GitHub release", "topics": [ "update_database" ] }, { "page": "update_ted", "title": "Update local TED database from GitHub release", "topics": [ "update_ted" ] } ], "_readme": "https://github.com/slesche/acdc-query/raw/HEAD/README.md", "_rundeps": [ "askpass", "bit", "bit64", "blob", "cachem", "cli", "cpp11", "curl", "DBI", "digest", "fastmap", "glue", "httr", "jsonlite", "lifecycle", "memoise", "mime", "openssl", "pkgconfig", "R6", "rlang", "RSQLite", "sys", "vctrs" ], "_score": 3.7403626894942437, "_indexed": true, "_nocasepkg": "acdcquery", "_universes": [ "slesche" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "1.2.3", "date": "2026-05-21T08:34:20.000Z", "distro": "noble", "commit": "4f118031115f0cbcaf8e72295ed557f9f94bde27", "fileid": "61e65bc464f241f3130b12a32d083b7dc39f6cb8138c60bb01b313fcd40eff74", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/slesche/actions/runs/26214748665" }, { "r": "4.6.0", "os": "linux", "version": "1.2.3", "date": "2026-05-21T08:34:15.000Z", "distro": "noble", "commit": "4f118031115f0cbcaf8e72295ed557f9f94bde27", "fileid": "366800362f25a2eb8a90c63000deb7f6f7bd3c8f89340131daae8e47ae4634e8", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/slesche/actions/runs/26214748665" }, { "r": "4.5.3", "os": "mac", "version": "1.2.3", "date": "2026-05-21T08:34:22.000Z", "commit": "4f118031115f0cbcaf8e72295ed557f9f94bde27", "fileid": "4a519caf3831ddc335f9c39b3dac6b84d7d1aeeb876c83e67d20637b7b25450e", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/slesche/actions/runs/26214748665" }, { "r": "4.6.0", "os": "mac", "version": "1.2.3", "date": "2026-05-21T08:34:01.000Z", "commit": "4f118031115f0cbcaf8e72295ed557f9f94bde27", "fileid": "c5b8a662496f5ecf8987d6916a3e329124945845a7cf56168dd2b84d11537aa4", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/slesche/actions/runs/26214748665" }, { "r": "4.6.0", "os": "wasm", "version": "1.2.3", "date": "2026-05-21T20:30:25.000Z", "commit": "4f118031115f0cbcaf8e72295ed557f9f94bde27", "fileid": "7abc79cf5775f3600e2ada34f4ed2292d7d7c95654620ada77c8bc726e0c92a5", "status": "success", "buildurl": "https://github.com/r-universe/slesche/actions/runs/26214748665" }, { "r": "4.7.0", "os": "win", "version": "1.2.3", "date": "2026-05-21T08:33:26.000Z", "commit": "4f118031115f0cbcaf8e72295ed557f9f94bde27", "fileid": "d972a3b58ee5dcaed9e7b77a3f29d18563d6f632b34d1240b10b7985bcb38fb8", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/slesche/actions/runs/26214748665" }, { "r": "4.5.3", "os": "win", "version": "1.2.3", "date": "2026-05-21T08:33:16.000Z", "commit": "4f118031115f0cbcaf8e72295ed557f9f94bde27", "fileid": "5fd18d9991391ae12f18974f6f68bcb40d15cbb1f78cc1eab7a0deeb798341cb", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/slesche/actions/runs/26214748665" }, { "r": "4.6.0", "os": "win", "version": "1.2.3", "date": "2026-05-21T08:33:17.000Z", "commit": "4f118031115f0cbcaf8e72295ed557f9f94bde27", "fileid": "f9c43979224115f3623775082b850b6710a5385b40c699fdf026a2968c44c9d0", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/slesche/actions/runs/26214748665" } ] }