{ "_id": "6a1f1896b401979e7341ed83", "Package": "sqlstrings", "Title": "Map 'SQL' Code to R Lists", "Version": "1.0.0", "Authors@R": "person(\"Dejan\", \"Prvulovic\", , \"dejan.prv@gmail.com\", role = c(\"aut\", \"cre\"))", "Description": "Provides a helper function, to bulk read 'SQL' code from\nseparate files and load it into an 'R' list, where the list\nelements contain the individual statements and queries as\nstrings. This works by annotating the 'SQL' code with a name\ncomment, which also will be the name of the list element.", "License": "MIT + file LICENSE", "Encoding": "UTF-8", "Roxygen": "list(markdown = TRUE)", "RoxygenNote": "7.2.1", "Config/testthat/edition": "3", "Config/pak/sysreqs": "cmake make libicu-dev libuv1-dev libx11-dev", "Repository": "https://dejse.r-universe.dev", "Date/Publication": "2022-09-08 18:33:16 UTC", "RemoteUrl": "https://github.com/dejse/sqlstrings", "RemoteRef": "HEAD", "RemoteSha": "edaee0820cfe3fdae15774483b3eec72ccf66a50", "NeedsCompilation": "no", "Packaged": { "Date": "2026-05-17 05:38:34 UTC", "User": "root" }, "Author": "Dejan Prvulovic [aut, cre]", "Maintainer": "Dejan Prvulovic ", "MD5sum": "8cae7646a5a4a283991c6c6479714129", "_user": "dejse", "_type": "src", "_file": "sqlstrings_1.0.0.tar.gz", "_fileid": "f31c6afba9ee2006c8d23097647d98a6e44a9e9717911a2c77425a0c5a5a960b", "_filesize": 76662, "_sha256": "f31c6afba9ee2006c8d23097647d98a6e44a9e9717911a2c77425a0c5a5a960b", "_created": "2026-05-17T05:38:34.000Z", "_published": "2026-06-02T17:53:26.627Z", "_distro": "noble", "_jobs": [ { "job": 79136707050, "time": 113, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "7039687536" }, { "job": 79136707096, "time": 121, "config": "linux-release-x86_64", "r": "4.6.0", "check": "OK", "artifact": "7039688435" }, { "job": 79136707255, "time": 202, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "7039693022" }, { "job": 79136707178, "time": 127, "config": "macos-release-arm64", "r": "4.6.0", "check": "OK", "artifact": "7039685427" }, { "job": 79136706087, "time": 168, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7039674807" }, { "job": 79136706041, "time": 100, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7365671637" }, { "job": 79136706962, "time": 69, "config": "windows-devel", "r": "4.7.0", "check": "OK", "artifact": "7039682493" }, { "job": 79136707147, "time": 58, "config": "windows-oldrel", "r": "4.5.3", "check": "OK", "artifact": "7039681243" }, { "job": 79136707066, "time": 60, "config": "windows-release", "r": "4.6.0", "check": "OK", "artifact": "7039681502" } ], "_buildurl": "https://github.com/r-universe/dejse/actions/runs/25982520162", "_status": "success", "_host": "GitHub-Actions", "_upstream": "https://github.com/dejse/sqlstrings", "_commit": { "id": "edaee0820cfe3fdae15774483b3eec72ccf66a50", "author": "dejan ", "committer": "dejan ", "message": "remove 'this package' in DESCRIPTION\n", "time": 1662661996 }, "_maintainer": { "name": "Dejan Prvulovic", "email": "dejan.prv@gmail.com", "login": "dejse", "description": "Just some personal projects. Nothing fancy. Econ graduate learning to code :)", "uuid": 47352728 }, "_registered": true, "_dependencies": [ { "package": "fs", "role": "Imports" }, { "package": "readr", "role": "Imports" }, { "package": "stringr", "role": "Imports" }, { "package": "testthat", "version": ">= 3.0.0", "role": "Suggests" } ], "_owner": "dejse", "_selfowned": true, "_usedby": 0, "_updates": [], "_tags": [], "_topics": [ "sql" ], "_stars": 0, "_contributors": [ { "user": "dejse", "count": 29, "uuid": 47352728 } ], "_userbio": { "uuid": 47352728, "type": "user", "name": "deji", "description": "Just some personal projects. Nothing fancy. Econ graduate learning to code :)" }, "_downloads": { "count": 186, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/sqlstrings" }, "_devurl": "https://github.com/dejse/sqlstrings", "_searchresults": 2, "_rbuild": "4.6.0", "_assets": [ "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", "extra/sqlstrings.html", "manual.pdf" ], "_homeurl": "https://github.com/dejse/sqlstrings", "_realowner": "dejse", "_cranurl": true, "_releases": [ { "version": "1.0.0", "date": "2022-09-09" } ], "_exports": [ "generate_sql_strings" ], "_help": [ { "page": "generate_sql_strings", "title": "Read all files from path and return a list, where the list elements contain the individual 'SQL' statements and queries as strings", "topics": [ "generate_sql_strings" ] } ], "_readme": "https://github.com/dejse/sqlstrings/raw/HEAD/README.md", "_rundeps": [ "bit", "bit64", "cli", "clipr", "cpp11", "crayon", "fs", "glue", "hms", "lifecycle", "magrittr", "pillar", "pkgconfig", "prettyunits", "progress", "R6", "readr", "rlang", "stringi", "stringr", "tibble", "tidyselect", "tzdb", "utf8", "vctrs", "vroom", "withr" ], "_score": 2.6989700043360187, "_indexed": true, "_nocasepkg": "sqlstrings", "_universes": [ "dejse" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "1.0.0", "date": "2026-05-17T05:40:30.000Z", "distro": "noble", "commit": "edaee0820cfe3fdae15774483b3eec72ccf66a50", "fileid": "2bfd81b704a0b1cdca7febba09f63a7ca7beb356983adb8f490333fca6f3281e", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/dejse/actions/runs/25982520162" }, { "r": "4.6.0", "os": "linux", "version": "1.0.0", "date": "2026-05-17T05:40:38.000Z", "distro": "noble", "commit": "edaee0820cfe3fdae15774483b3eec72ccf66a50", "fileid": "0f86192ae30e8e85d1dd17527968d7ff35b8b218751ef368b263a4f897335a63", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/dejse/actions/runs/25982520162" }, { "r": "4.5.3", "os": "mac", "version": "1.0.0", "date": "2026-05-17T05:41:19.000Z", "commit": "edaee0820cfe3fdae15774483b3eec72ccf66a50", "fileid": "79c992c248aec2f62d9c0245bb9dee43866bd32548c680c927f61c3df1025a1b", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/dejse/actions/runs/25982520162" }, { "r": "4.6.0", "os": "mac", "version": "1.0.0", "date": "2026-05-17T05:40:15.000Z", "commit": "edaee0820cfe3fdae15774483b3eec72ccf66a50", "fileid": "ed45f5b76ff03d10087dc1c8e4820abcaeeefa934fccd00bd2bafbf51c495332", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/dejse/actions/runs/25982520162" }, { "r": "4.7.0", "os": "win", "version": "1.0.0", "date": "2026-05-17T05:39:43.000Z", "commit": "edaee0820cfe3fdae15774483b3eec72ccf66a50", "fileid": "b7838ea9c52af992a417320fc267b56686a37e6c91a52416c51c6c283c8f0fce", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/dejse/actions/runs/25982520162" }, { "r": "4.5.3", "os": "win", "version": "1.0.0", "date": "2026-05-17T05:39:32.000Z", "commit": "edaee0820cfe3fdae15774483b3eec72ccf66a50", "fileid": "41ba266a4ad769efa16cb2ab5c2eeb2d5a1173b7c44387bfc6c5394c159d3bb7", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/dejse/actions/runs/25982520162" }, { "r": "4.6.0", "os": "win", "version": "1.0.0", "date": "2026-05-17T05:39:35.000Z", "commit": "edaee0820cfe3fdae15774483b3eec72ccf66a50", "fileid": "44ce3de1504b36a68d6e0564592945ca8f7070eb7369e26fd72af7b34edbf781", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/dejse/actions/runs/25982520162" }, { "r": "4.6.0", "os": "wasm", "version": "1.0.0", "date": "2026-06-02T17:53:10.000Z", "commit": "edaee0820cfe3fdae15774483b3eec72ccf66a50", "fileid": "fd090faf86a29fc90a62a94acf86d2673ef8a1ab0eb796992eb9ed414c4b6d58", "status": "success", "buildurl": "https://github.com/r-universe/dejse/actions/runs/25982520162" } ] }