{ "_id": "6ab79c8699f7aa8c6aa32ddd", "Package": "sqlHelpers", "Type": "Package", "Title": "Collection of 'SQL' Utilities for 'T-SQL' and 'Postgresql'", "Version": "0.1.2", "Authors@R": "c(person(given = \"Timothy\",\nfamily = \"Conwell\",\nrole = c(\"aut\", \"cre\"),\nemail = \"timconwell@gmail.com\"))", "Description": "Includes functions for interacting with common meta data\nfields, writing insert statements, calling functions, and more\nfor 'T-SQL' and 'Postgresql'.", "License": "GPL (>= 3)", "Encoding": "UTF-8", "RoxygenNote": "7.2.0", "NeedsCompilation": "no", "Packaged": { "Date": "2026-09-26 10:18:17 UTC", "User": "root" }, "Author": "Timothy Conwell [aut, cre]", "Maintainer": "Timothy Conwell ", "Config/pak/sysreqs": "make libicu-dev unixodbc-dev", "Repository": "https://tconwell.r-universe.dev", "Date/Publication": "2023-10-14 21:30:45 UTC", "RemoteUrl": "https://github.com/cran/sqlHelpers", "RemoteRef": "HEAD", "RemoteSha": "72110c508b361176b001e38a863313670f764651", "_user": "tconwell", "_type": "src", "_file": "sqlHelpers_0.1.2.tar.gz", "_fileid": "https://r2.ropensci.org/4d75840fc7fe17eef7fca2032c944dd80a8aa0aed6ea91cb58fbb28193f0cba2", "_filesize": 117923, "_sha256": "4d75840fc7fe17eef7fca2032c944dd80a8aa0aed6ea91cb58fbb28193f0cba2", "_expires": "2027-01-04T10:20:53.000Z", "_created": "2026-09-26T10:18:17.000Z", "_published": "2026-09-26T10:20:54.676Z", "_jobs": [ { "job": 108386127936, "time": 112, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "10903688348" }, { "job": 108386127918, "time": 118, "config": "linux-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "10903338677" }, { "job": 108386127933, "time": 96, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "10903977035" }, { "job": 108386127939, "time": 69, "config": "macos-release-arm64", "r": "4.6.1", "check": "OK", "artifact": "10903688318" }, { "job": 108385681004, "time": 191, "config": "source", "r": "4.6.1", "check": "OK", "artifact": "10903788542" }, { "job": 108386127904, "time": 106, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "10904011875" }, { "job": 108386127952, "time": 62, "config": "windows-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "10903313754" }, { "job": 108386128004, "time": 67, "config": "windows-oldrel-x86_64", "r": "4.5.3", "check": "OK", "artifact": "10903448505" }, { "job": 108386127946, "time": 60, "config": "windows-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "10904415687" } ], "_host": "GitHub-Actions", "_buildurl": "https://github.com/r-universe/tconwell/actions/runs/36235218641", "_status": "success", "_upstream": "https://github.com/cran/sqlHelpers", "_commit": { "id": "72110c508b361176b001e38a863313670f764651", "author": "Timothy Conwell ", "committer": "cran-robot ", "message": "version 0.1.2\n", "time": 1697319045 }, "_maintainer": { "name": "Timothy Conwell", "email": "timconwell@gmail.com", "login": "tconwell", "description": "", "uuid": 51293949 }, "_distro": "resolute", "_registered": true, "_dependencies": [ { "package": "data.table", "role": "Depends" }, { "package": "toolbox", "role": "Depends" }, { "package": "DBI", "role": "Imports" }, { "package": "odbc", "role": "Imports" }, { "package": "parallel", "role": "Imports" }, { "package": "stringi", "role": "Imports" } ], "_owner": "cran", "_selfowned": true, "_usedby": 0, "_updates": [], "_tags": [], "_stars": 0, "_contributors": [ { "user": "tconwell", "count": 3, "uuid": 51293949 } ], "_userbio": { "uuid": 51293949, "type": "user", "name": "Tim Conwell", "followers": 2 }, "_downloads": { "count": 234, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/sqlHelpers" }, "_searchresults": 5, "_rbuild": "4.6.1", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/manual.pdf", "extra/sqlHelpers.html" ], "_realowner": "tconwell", "_cranurl": false, "_releases": [ { "version": "0.1.0", "date": "2023-05-25" }, { "version": "0.1.1", "date": "2023-09-03" }, { "version": "0.1.2", "date": "2023-10-14" } ], "_exports": [ "call_function", "connect", "create_table_from_data_frame", "drop_table", "fetch_columns", "fetch_function_definition", "fetch_function_output_parameters", "fetch_function_parameters", "fetch_tables", "insert_batch_chunker", "insert_values", "quoteText2", "sqlizeNames", "sqlizeTypes", "t_sql_bulk_insert", "t_sql_script_create_table", "t_sql_script_proc_definition", "truncate_table", "update_values" ], "_help": [ { "page": "call_function", "title": "Call a SQL function/procedure.", "topics": [ "call_function" ] }, { "page": "connect", "title": "Connect to a database using a connection string via DBI/odbc.", "topics": [ "connect" ] }, { "page": "create_table_from_data_frame", "title": "Generate a CREATE TABLE statement based on a data.frame, optionally execute the statement if con is not NULL.", "topics": [ "create_table_from_data_frame" ] }, { "page": "drop_table", "title": "Generate a DROP TABLE statement, optionally execute the statement if con is not NULL.", "topics": [ "drop_table" ] }, { "page": "fetch_columns", "title": "Retrieve the columns/types in a table.", "topics": [ "fetch_columns" ] }, { "page": "fetch_function_definition", "title": "Retrieve the definition of a function/procedure.", "topics": [ "fetch_function_definition" ] }, { "page": "fetch_function_output_parameters", "title": "Retrieve the output parameters of a function/procedure.", "topics": [ "fetch_function_output_parameters" ] }, { "page": "fetch_function_parameters", "title": "Retrieve the input parameters of a function/procedure.", "topics": [ "fetch_function_parameters" ] }, { "page": "fetch_tables", "title": "Retrieve the tables in a schema", "topics": [ "fetch_tables" ] }, { "page": "insert_batch_chunker", "title": "Helper function for INSERT", "topics": [ "insert_batch_chunker" ] }, { "page": "insert_values", "title": "Generate a INSERT statement, optionally execute the statement if con is not NULL.", "topics": [ "insert_values" ] }, { "page": "quoteText2", "title": "Add single quotes to strings using stringi::stri_join, useful for converting R strings into SQL formatted strings.", "topics": [ "quoteText2" ] }, { "page": "sqlizeNames", "title": "Convert a column name into a SQL compatible name.", "topics": [ "sqlizeNames" ] }, { "page": "sqlizeTypes", "title": "Get the equivalent SQL data type for a given R object.", "topics": [ "sqlizeTypes" ] }, { "page": "t_sql_bulk_insert", "title": "Generate a BULK INSERT statement, optionally execute the statement if con is not NULL.", "topics": [ "t_sql_bulk_insert" ] }, { "page": "t_sql_script_create_table", "title": "Generate a CREATE TABLE statement for an existing table in Microsoft SQL Server.", "topics": [ "t_sql_script_create_table" ] }, { "page": "t_sql_script_proc_definition", "title": "Fetch the object definition of a proc in Microsoft SQL Server.", "topics": [ "t_sql_script_proc_definition" ] }, { "page": "truncate_table", "title": "Generate a TRUNCATE TABLE statement, optionally execute the statement if con is not NULL.", "topics": [ "truncate_table" ] }, { "page": "update_values", "title": "Generate a UPDATE statement, optionally execute the statement if con is not NULL.", "topics": [ "update_values" ] } ], "_rundeps": [ "bit", "bit64", "blob", "cli", "data.table", "DBI", "glue", "hms", "lifecycle", "odbc", "pkgconfig", "Rcpp", "rlang", "stringi", "toolbox", "vctrs" ], "_score": 1, "_indexed": true, "_nocasepkg": "sqlhelpers", "_universes": [ "tconwell" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.1.2", "date": "2026-09-26T10:20:17.000Z", "distro": "resolute", "commit": "72110c508b361176b001e38a863313670f764651", "fileid": "https://r2.ropensci.org/983bc87ccc7ddebcee23b3fb7e35c05576bf25ef4e5babec51635a36c36c8868", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/tconwell/actions/runs/36235218641" }, { "r": "4.6.1", "os": "linux", "version": "0.1.2", "date": "2026-09-26T10:20:21.000Z", "distro": "resolute", "commit": "72110c508b361176b001e38a863313670f764651", "fileid": "https://r2.ropensci.org/ee0508515f391b90c756c1adf27d155fbf5729aa3edf80021e97e73db31f6ff1", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/tconwell/actions/runs/36235218641" }, { "r": "4.5.3", "os": "mac", "version": "0.1.2", "date": "2026-09-26T10:20:05.000Z", "commit": "72110c508b361176b001e38a863313670f764651", "fileid": "https://r2.ropensci.org/c3637e602ff9e5de3dbd72cadfaa55d236c54d7f884652f505ec8027ef37490b", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/tconwell/actions/runs/36235218641" }, { "r": "4.6.1", "os": "mac", "version": "0.1.2", "date": "2026-09-26T10:19:39.000Z", "commit": "72110c508b361176b001e38a863313670f764651", "fileid": "https://r2.ropensci.org/017ff43305c6c36f6111b98281c7bc4f87680ff9ff99d0f9fcc643bcd530055f", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/tconwell/actions/runs/36235218641" }, { "r": "4.6.0", "os": "wasm", "version": "0.1.2", "date": "2026-09-26T10:20:19.000Z", "commit": "72110c508b361176b001e38a863313670f764651", "fileid": "https://r2.ropensci.org/aef574ca025e8d9b61d9be9298ed2ff29bf7d71b470a84d3463568e82af977e8", "status": "success", "buildurl": "https://github.com/r-universe/tconwell/actions/runs/36235218641" }, { "r": "4.7.0", "os": "win", "version": "0.1.2", "date": "2026-09-26T10:19:20.000Z", "commit": "72110c508b361176b001e38a863313670f764651", "fileid": "https://r2.ropensci.org/57a022b2d8fc1628ffc36d5cc13d408b794ae025fa434b74228c7f237c5928a5", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/tconwell/actions/runs/36235218641" }, { "r": "4.5.3", "os": "win", "version": "0.1.2", "date": "2026-09-26T10:19:19.000Z", "commit": "72110c508b361176b001e38a863313670f764651", "fileid": "https://r2.ropensci.org/5d6e307355c2505b112b25caf5c662d5e32bfccba7cb568ffb10b5f80c15599e", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/tconwell/actions/runs/36235218641" }, { "r": "4.6.1", "os": "win", "version": "0.1.2", "date": "2026-09-26T10:19:20.000Z", "commit": "72110c508b361176b001e38a863313670f764651", "fileid": "https://r2.ropensci.org/863f6cbc10cee483d031614e7f52bf00b32156e8a5ee26d4f33b1a1e417dbc29", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/tconwell/actions/runs/36235218641" } ] }