{ "_id": "6acf4927d9de2f3f33fca24e", "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-10-14 08:18:45 UTC", "User": "root" }, "Author": "Dejan Prvulovic [aut, cre]", "Maintainer": "Dejan Prvulovic ", "_user": "dejse", "_type": "src", "_file": "sqlstrings_1.0.0.tar.gz", "_fileid": "https://r2.ropensci.org/22c8f66e30055bae017e51644e0b70c7d6cb2049fd7bbaa85d27a11dcbf8706c", "_filesize": 78251, "_sha256": "22c8f66e30055bae017e51644e0b70c7d6cb2049fd7bbaa85d27a11dcbf8706c", "_expires": "2027-01-22T09:19:33.000Z", "_created": "2026-10-14T08:18:45.000Z", "_published": "2026-10-14T09:19:35.482Z", "_buildurl": "https://github.com/r-universe/dejse/actions/runs/38533856622", "_status": "success", "_host": "GitHub-Actions", "_jobs": [ { "job": 115753196249, "time": 107, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "11879077193" }, { "job": 115753196308, "time": 108, "config": "linux-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "11879057285" }, { "job": 115753196292, "time": 206, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "11881624540" }, { "job": 115753196330, "time": 186, "config": "macos-release-arm64", "r": "4.6.1", "check": "OK", "artifact": "11882835423" }, { "job": 115752043096, "time": 177, "config": "source", "r": "4.6.1", "check": "OK", "artifact": "11879201604" }, { "job": 115753196307, "time": 87, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "11879242530" }, { "job": 115753196433, "time": 63, "config": "windows-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "11879497279" }, { "job": 115753196349, "time": 62, "config": "windows-oldrel-x86_64", "r": "4.5.3", "check": "OK", "artifact": "11879781800" }, { "job": 115753197709, "time": 65, "config": "windows-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "11879881266" } ], "_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 }, "_distro": "resolute", "_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", "followers": 0, "description": "Just some personal projects. Nothing fancy. Econ graduate learning to code :)" }, "_downloads": { "count": 192, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/sqlstrings" }, "_devurl": "https://github.com/dejse/sqlstrings", "_searchresults": 0, "_rbuild": "4.6.1", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/manual.pdf", "extra/NEWS.html", "extra/NEWS.txt", "extra/readme.html", "extra/readme.md", "extra/sqlstrings.html", "LICENSE" ], "_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-10-14T08:20:45.000Z", "distro": "resolute", "commit": "edaee0820cfe3fdae15774483b3eec72ccf66a50", "fileid": "https://r2.ropensci.org/aa7a569a8f57de23724497e2b292c6c936cf7cec4d93778ebb0b6019b2878358", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/dejse/actions/runs/38533856622" }, { "r": "4.6.1", "os": "linux", "version": "1.0.0", "date": "2026-10-14T08:20:45.000Z", "distro": "resolute", "commit": "edaee0820cfe3fdae15774483b3eec72ccf66a50", "fileid": "https://r2.ropensci.org/4ddf650ec58c38a649838a34b83484c50cfa9779b3bb22b5911a5b4f94cecb9e", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/dejse/actions/runs/38533856622" }, { "r": "4.5.3", "os": "mac", "version": "1.0.0", "date": "2026-10-14T09:18:27.000Z", "commit": "edaee0820cfe3fdae15774483b3eec72ccf66a50", "fileid": "https://r2.ropensci.org/c4105bc2e0f8b00832b4edc2574b5dd8dc60837348663f7c373ded20e94a33b8", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/dejse/actions/runs/38533856622" }, { "r": "4.6.1", "os": "mac", "version": "1.0.0", "date": "2026-10-14T09:14:00.000Z", "commit": "edaee0820cfe3fdae15774483b3eec72ccf66a50", "fileid": "https://r2.ropensci.org/11f67cdd81db071ed8da2f13d97561e01ae996e179b49c0d03568011813e5b4a", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/dejse/actions/runs/38533856622" }, { "r": "4.6.0", "os": "wasm", "version": "1.0.0", "date": "2026-10-14T08:20:34.000Z", "commit": "edaee0820cfe3fdae15774483b3eec72ccf66a50", "fileid": "https://r2.ropensci.org/92ae4bdae19efbaf1adc1bf2159278daa2f2724cf415538982881eae3e41502f", "status": "success", "buildurl": "https://github.com/r-universe/dejse/actions/runs/38533856622" }, { "r": "4.7.0", "os": "win", "version": "1.0.0", "date": "2026-10-14T08:19:57.000Z", "commit": "edaee0820cfe3fdae15774483b3eec72ccf66a50", "fileid": "https://r2.ropensci.org/002e085b87ecb5c34e4f5a60dde6ae7aa458bfcbf6af197d21949a379e311fa2", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/dejse/actions/runs/38533856622" }, { "r": "4.5.3", "os": "win", "version": "1.0.0", "date": "2026-10-14T08:19:58.000Z", "commit": "edaee0820cfe3fdae15774483b3eec72ccf66a50", "fileid": "https://r2.ropensci.org/d23a37dac7e78be033d943a315ac553b513e365701cc443eea8af6d29912b9d5", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/dejse/actions/runs/38533856622" }, { "r": "4.6.1", "os": "win", "version": "1.0.0", "date": "2026-10-14T08:19:59.000Z", "commit": "edaee0820cfe3fdae15774483b3eec72ccf66a50", "fileid": "https://r2.ropensci.org/d4a80883f485825b6b49c616272fe1361e0668318e4c7925800fcd43d91857ea", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/dejse/actions/runs/38533856622" } ] }