{ "_id": "6a140fc7acfb0bcc41d3b348", "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-05-25 08:58:24 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", "MD5sum": "bc2a8596654c0a1511f0caba3123463b", "_user": "tconwell", "_type": "src", "_file": "sqlHelpers_0.1.2.tar.gz", "_fileid": "dc867c55adc6e7352474c5cacf467fc68bca4bd2a457d3231970d9a1a38acba4", "_filesize": 118136, "_sha256": "dc867c55adc6e7352474c5cacf467fc68bca4bd2a457d3231970d9a1a38acba4", "_created": "2026-05-25T08:58:24.000Z", "_published": "2026-05-25T09:00:55.018Z", "_distro": "noble", "_jobs": [ { "job": 77685029746, "time": 110, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "7195081114" }, { "job": 77685029778, "time": 111, "config": "linux-release-x86_64", "r": "4.6.0", "check": "OK", "artifact": "7195081227" }, { "job": 77685029748, "time": 79, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "7195073225" }, { "job": 77685029767, "time": 66, "config": "macos-release-arm64", "r": "4.6.0", "check": "OK", "artifact": "7195069703" }, { "job": 77684722619, "time": 140, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7195051837" }, { "job": 77685029756, "time": 93, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7195076883" }, { "job": 77685029753, "time": 108, "config": "windows-devel", "r": "4.7.0", "check": "OK", "artifact": "7195080610" }, { "job": 77685029774, "time": 73, "config": "windows-oldrel", "r": "4.5.3", "check": "OK", "artifact": "7195071911" }, { "job": 77685029751, "time": 68, "config": "windows-release", "r": "4.6.0", "check": "OK", "artifact": "7195069944" } ], "_buildurl": "https://github.com/r-universe/tconwell/actions/runs/26392309730", "_status": "success", "_host": "GitHub-Actions", "_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 }, "_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" }, "_downloads": { "count": 188, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/sqlHelpers" }, "_searchresults": 5, "_rbuild": "4.6.0", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/sqlHelpers.html", "manual.pdf" ], "_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-05-25T09:00:17.000Z", "distro": "noble", "commit": "72110c508b361176b001e38a863313670f764651", "fileid": "faea12389e492e4c19138be23ba54b62b3f5c65912e06727367ac455a6a0168c", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/tconwell/actions/runs/26392309730" }, { "r": "4.6.0", "os": "linux", "version": "0.1.2", "date": "2026-05-25T09:00:18.000Z", "distro": "noble", "commit": "72110c508b361176b001e38a863313670f764651", "fileid": "229bf2bbbbb995ace68407ca05ec02985f43a0343fc8b0512fa49b26723e8256", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/tconwell/actions/runs/26392309730" }, { "r": "4.5.3", "os": "mac", "version": "0.1.2", "date": "2026-05-25T08:59:50.000Z", "commit": "72110c508b361176b001e38a863313670f764651", "fileid": "01a06eb78c6b823d8a78c8b82171276aa6cb6c439a40abf694ed11ff088a9d40", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/tconwell/actions/runs/26392309730" }, { "r": "4.6.0", "os": "mac", "version": "0.1.2", "date": "2026-05-25T08:59:38.000Z", "commit": "72110c508b361176b001e38a863313670f764651", "fileid": "b36097cc3a641c08cb7396785d515ceaab0a665228762314c8f6c03ffd6875d9", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/tconwell/actions/runs/26392309730" }, { "r": "4.6.0", "os": "wasm", "version": "0.1.2", "date": "2026-05-25T09:00:12.000Z", "commit": "72110c508b361176b001e38a863313670f764651", "fileid": "f7c8f5908ec8307461072b18880aa97435a90e78f5e8f5d1b0fe52dbc2ad3def", "status": "success", "buildurl": "https://github.com/r-universe/tconwell/actions/runs/26392309730" }, { "r": "4.7.0", "os": "win", "version": "0.1.2", "date": "2026-05-25T09:00:13.000Z", "commit": "72110c508b361176b001e38a863313670f764651", "fileid": "f0a8b5fccced4967b9be52f1e0a7c3fb6a720c266de561ebf478db6c0be0dd08", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/tconwell/actions/runs/26392309730" }, { "r": "4.5.3", "os": "win", "version": "0.1.2", "date": "2026-05-25T08:59:38.000Z", "commit": "72110c508b361176b001e38a863313670f764651", "fileid": "2f4632be0e3312b9456fc8858da1ad47b60c8cf2206e2bea6c7dec61c48ad361", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/tconwell/actions/runs/26392309730" }, { "r": "4.6.0", "os": "win", "version": "0.1.2", "date": "2026-05-25T08:59:32.000Z", "commit": "72110c508b361176b001e38a863313670f764651", "fileid": "17e5705a5d871ea85992a0db6ca959dc1d56f2f62ba32cb69560878b3a0abe05", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/tconwell/actions/runs/26392309730" } ] }