{ "_id": "6a2683cf794753ddbc3f18c3", "Package": "nolock", "Type": "Package", "Title": "Append 'WITH (NOLOCK)' to 'SQL' Queries, Get Packages in Active\nScript", "Version": "1.1.0", "Authors@R": "c(person(\"Arkadiusz W.\", \"Pajda\", role = c(\"aut\", \"cre\", \"cph\"), \nemail = \"arkadiusz.pajda.97@onet.pl\"))", "Description": "Provides a suite of tools that can assist in enhancing the\nprocessing efficiency of 'SQL' and 'R' scripts. - The\n'libr_unused()' retrieves a vector of package names that are\ncalled within an 'R' script but are never actually used in the\nscript. - The 'libr_used()' retrieves a vector of package names\nactively utilized within an 'R' script; packages loaded using\n'library()' but not actually used in the script will not be\nincluded. - The 'libr_called()' retrieves a vector of all\npackage names which are called within an 'R' script. -\n'nolock()' appends 'WITH (nolock)' to all tables in 'SQL'\nqueries. This facilitates reading from databases in scenarios\nwhere non-blocking reads are preferable, such as in\nhigh-transaction environments.", "License": "GPL-3", "Encoding": "UTF-8", "RoxygenNote": "7.2.3", "NeedsCompilation": "no", "Packaged": { "Date": "2026-06-08 08:53:15 UTC", "User": "root" }, "Author": "Arkadiusz W. Pajda [aut, cre, cph]", "Maintainer": "Arkadiusz W. Pajda ", "Config/pak/sysreqs": "libicu-dev", "Repository": "https://artllex.r-universe.dev", "Date/Publication": "2023-11-17 02:39:31 UTC", "RemoteUrl": "https://github.com/cran/nolock", "RemoteRef": "HEAD", "RemoteSha": "eba7418051f43670d9d4db5c0b89afe981848f02", "MD5sum": "751377641e882e6de17cfa70a106ab12", "_user": "artllex", "_type": "src", "_file": "nolock_1.1.0.tar.gz", "_fileid": "bb1223694e0fd0efb77217b7160f0de12ccdc730836e9e36ca7dd4bfb58f82a7", "_filesize": 90830, "_sha256": "bb1223694e0fd0efb77217b7160f0de12ccdc730836e9e36ca7dd4bfb58f82a7", "_created": "2026-06-08T08:53:15.000Z", "_published": "2026-06-08T08:56:47.272Z", "_distro": "noble", "_jobs": [ { "job": 80056627000, "time": 107, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "7475580150" }, { "job": 80056626968, "time": 112, "config": "linux-release-x86_64", "r": "4.6.0", "check": "OK", "artifact": "7475581977" }, { "job": 80056626905, "time": 177, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "7475596216" }, { "job": 80056626909, "time": 131, "config": "macos-release-arm64", "r": "4.6.0", "check": "OK", "artifact": "7475579583" }, { "job": 80056160484, "time": 161, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7475540283" }, { "job": 80056626858, "time": 87, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7475572904" }, { "job": 80056626991, "time": 90, "config": "windows-devel", "r": "4.7.0", "check": "OK", "artifact": "7475574329" }, { "job": 80056626990, "time": 63, "config": "windows-oldrel", "r": "4.5.3", "check": "OK", "artifact": "7475564098" }, { "job": 80056626977, "time": 70, "config": "windows-release", "r": "4.6.0", "check": "OK", "artifact": "7475566703" } ], "_buildurl": "https://github.com/r-universe/artllex/actions/runs/27126423723", "_status": "success", "_host": "GitHub-Actions", "_upstream": "https://github.com/cran/nolock", "_commit": { "id": "eba7418051f43670d9d4db5c0b89afe981848f02", "author": "Arkadiusz W. Pajda ", "committer": "cran-robot ", "message": "version 1.1.0\n", "time": 1700188771 }, "_maintainer": { "name": "Arkadiusz W. Pajda", "email": "arkadiusz.pajda.97@onet.pl", "login": "artllex", "description": "", "uuid": 45765462 }, "_registered": true, "_dependencies": [ { "package": "R", "version": ">= 4.1.0", "role": "Depends" }, { "package": "crayon", "role": "Imports" }, { "package": "rstudioapi", "role": "Imports" }, { "package": "utils", "role": "Imports" }, { "package": "stringr", "role": "Imports" }, { "package": "NCmisc", "role": "Imports" } ], "_owner": "cran", "_selfowned": true, "_usedby": 0, "_updates": [], "_tags": [], "_stars": 0, "_contributors": [ { "user": "artllex", "count": 2, "uuid": 45765462 } ], "_userbio": { "uuid": 45765462, "type": "user", "name": "Artllex" }, "_downloads": { "count": 139, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/nolock" }, "_searchresults": 2, "_rbuild": "4.6.0", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/nolock.html", "manual.pdf" ], "_realowner": "artllex", "_cranurl": false, "_releases": [ { "version": "1.0.4", "date": "2023-09-27" }, { "version": "1.1.0", "date": "2023-11-15" } ], "_exports": [ "libr_called", "libr_unused", "libr_used", "nolock" ], "_help": [ { "page": "libr_called", "title": "'Get Packages Called in the Active 'R' Script'", "topics": [ "libr_called" ] }, { "page": "libr_unused", "title": "'Get Unused Packages in the Active 'R' Script'", "topics": [ "libr_unused" ] }, { "page": "libr_used", "title": "'Get Packages Used in the Active Script'", "topics": [ "libr_used" ] }, { "page": "nolock", "title": "'Append WITH (NOLOCK) to SQL Queries'", "topics": [ "nolock" ] } ], "_rundeps": [ "cli", "crayon", "glue", "lifecycle", "magrittr", "NCmisc", "rlang", "rstudioapi", "stringi", "stringr", "vctrs" ], "_score": 1, "_indexed": true, "_nocasepkg": "nolock", "_universes": [ "artllex" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "1.1.0", "date": "2026-06-08T08:55:05.000Z", "distro": "noble", "commit": "eba7418051f43670d9d4db5c0b89afe981848f02", "fileid": "d04b5e1d18a0d682c3077218bd2d3f4c721aba663060830ccfa5e22811f29e4e", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/artllex/actions/runs/27126423723" }, { "r": "4.6.0", "os": "linux", "version": "1.1.0", "date": "2026-06-08T08:55:08.000Z", "distro": "noble", "commit": "eba7418051f43670d9d4db5c0b89afe981848f02", "fileid": "da001709d64c61fd2e86d067092d062fa336bfb9baf9216cb8b77a5595530111", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/artllex/actions/runs/27126423723" }, { "r": "4.5.3", "os": "mac", "version": "1.1.0", "date": "2026-06-08T08:55:51.000Z", "commit": "eba7418051f43670d9d4db5c0b89afe981848f02", "fileid": "2769ea30618b002516b6383fe3842d02bb6c8e1df0eca27be92746a7c20dd365", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/artllex/actions/runs/27126423723" }, { "r": "4.6.0", "os": "mac", "version": "1.1.0", "date": "2026-06-08T08:55:05.000Z", "commit": "eba7418051f43670d9d4db5c0b89afe981848f02", "fileid": "0c3eee2c0e250190b707e2d428d73a6144ff52b5730906a506532d975eca61a4", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/artllex/actions/runs/27126423723" }, { "r": "4.6.0", "os": "wasm", "version": "1.1.0", "date": "2026-06-08T08:54:56.000Z", "commit": "eba7418051f43670d9d4db5c0b89afe981848f02", "fileid": "1e22fa0db9cb5bdcb0ce54dc047fd472bd08b58f19c3b0e58ce9231738ae74ad", "status": "success", "buildurl": "https://github.com/r-universe/artllex/actions/runs/27126423723" }, { "r": "4.7.0", "os": "win", "version": "1.1.0", "date": "2026-06-08T08:54:44.000Z", "commit": "eba7418051f43670d9d4db5c0b89afe981848f02", "fileid": "55f5880230149a25b9eb3e4916b2db04a09c743eacf3ae35bce88e2c585cc660", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/artllex/actions/runs/27126423723" }, { "r": "4.5.3", "os": "win", "version": "1.1.0", "date": "2026-06-08T08:54:17.000Z", "commit": "eba7418051f43670d9d4db5c0b89afe981848f02", "fileid": "0749c0b39a31c1b34bd8149550ae6db1c696ad6b2e6f9a40598f2ba12eab6609", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/artllex/actions/runs/27126423723" }, { "r": "4.6.0", "os": "win", "version": "1.1.0", "date": "2026-06-08T08:54:23.000Z", "commit": "eba7418051f43670d9d4db5c0b89afe981848f02", "fileid": "12a9b2ee2b0f300011c706a41674cf1247e08ba5554b54a8697c6df1cfabbf6c", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/artllex/actions/runs/27126423723" } ] }