{ "_id": "6ad0afc2f55ded6d77dfa3f5", "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-10-15 10:45:05 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", "_user": "artllex", "_type": "src", "_file": "nolock_1.1.0.tar.gz", "_fileid": "https://r2.ropensci.org/7d19a95aec58a46642a6dae08cbc43dd9ec91906311ce2f39f9711e2b024024e", "_filesize": 91796, "_sha256": "7d19a95aec58a46642a6dae08cbc43dd9ec91906311ce2f39f9711e2b024024e", "_expires": "2027-01-23T10:49:36.000Z", "_created": "2026-10-15T10:45:05.000Z", "_published": "2026-10-15T10:49:38.252Z", "_buildurl": "https://github.com/r-universe/artllex/actions/runs/38722191947", "_status": "success", "_host": "GitHub-Actions", "_jobs": [ { "job": 116380246821, "time": 126, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "11966592342" }, { "job": 116380246762, "time": 101, "config": "linux-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "11966782020" }, { "job": 116380246727, "time": 222, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "11967137167" }, { "job": 116380246833, "time": 168, "config": "macos-release-arm64", "r": "4.6.1", "check": "OK", "artifact": "11966752151" }, { "job": 116379351357, "time": 134, "config": "source", "r": "4.6.1", "check": "OK", "artifact": "11966706758" }, { "job": 116380246902, "time": 85, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "11966901842" }, { "job": 116380247015, "time": 58, "config": "windows-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "11966871880" }, { "job": 116380246776, "time": 102, "config": "windows-oldrel-x86_64", "r": "4.5.3", "check": "OK", "artifact": "11966792073" }, { "job": 116380246802, "time": 63, "config": "windows-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "11966941877" } ], "_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 }, "_distro": "resolute", "_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", "followers": 0 }, "_downloads": { "count": 263, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/nolock" }, "_searchresults": 1, "_rbuild": "4.6.1", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/manual.pdf", "extra/nolock.html" ], "_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-10-15T10:47:16.000Z", "distro": "resolute", "commit": "eba7418051f43670d9d4db5c0b89afe981848f02", "fileid": "https://r2.ropensci.org/a3994b50447a418123f0159520f4f593212a8e783176ab9a86d843ae8947f76c", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/artllex/actions/runs/38722191947" }, { "r": "4.6.1", "os": "linux", "version": "1.1.0", "date": "2026-10-15T10:46:49.000Z", "distro": "resolute", "commit": "eba7418051f43670d9d4db5c0b89afe981848f02", "fileid": "https://r2.ropensci.org/f9a0a8fe0812a8803dcfde46f0d1a97c5efe8504ae1f11f7999e98008c7e02e6", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/artllex/actions/runs/38722191947" }, { "r": "4.5.3", "os": "mac", "version": "1.1.0", "date": "2026-10-15T10:48:10.000Z", "commit": "eba7418051f43670d9d4db5c0b89afe981848f02", "fileid": "https://r2.ropensci.org/97dff0b1135ca76e9521bb3a55f987f2edc58a311323fa122f73adb3cf427b63", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/artllex/actions/runs/38722191947" }, { "r": "4.6.1", "os": "mac", "version": "1.1.0", "date": "2026-10-15T10:47:17.000Z", "commit": "eba7418051f43670d9d4db5c0b89afe981848f02", "fileid": "https://r2.ropensci.org/3542236cc3a311020c5897202f8ebede9cb384653438d4f88ffc77af57a8209b", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/artllex/actions/runs/38722191947" }, { "r": "4.6.0", "os": "wasm", "version": "1.1.0", "date": "2026-10-15T10:46:43.000Z", "commit": "eba7418051f43670d9d4db5c0b89afe981848f02", "fileid": "https://r2.ropensci.org/c0655994246a546931a94924de3adf97ae6e12dc0713213e162eaab172cac03d", "status": "success", "buildurl": "https://github.com/r-universe/artllex/actions/runs/38722191947" }, { "r": "4.7.0", "os": "win", "version": "1.1.0", "date": "2026-10-15T10:46:01.000Z", "commit": "eba7418051f43670d9d4db5c0b89afe981848f02", "fileid": "https://r2.ropensci.org/a9356cc04b5353219c2719cf35c9d669eb5899304993697ffaca74efd1a36ea6", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/artllex/actions/runs/38722191947" }, { "r": "4.5.3", "os": "win", "version": "1.1.0", "date": "2026-10-15T10:46:42.000Z", "commit": "eba7418051f43670d9d4db5c0b89afe981848f02", "fileid": "https://r2.ropensci.org/1292dc31a7bb4eedfe14a42cc21865219811472e44afeb03db9727168c8a0464", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/artllex/actions/runs/38722191947" }, { "r": "4.6.1", "os": "win", "version": "1.1.0", "date": "2026-10-15T10:46:04.000Z", "commit": "eba7418051f43670d9d4db5c0b89afe981848f02", "fileid": "https://r2.ropensci.org/284faab88756c92ee9cd1912cbc0fc1a1155b2e9ed04c1e018a306c74763d64c", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/artllex/actions/runs/38722191947" } ] }