Create and drop databases
create_db()
Create a New Database
drop_db()
Drop a Database
get_conn_db()
Get Connection Database
ls_db()
List Databases
rename_db()
Rename a Database
render_create_db()
Render SQL to Create Database
render_rename_db()
Render SQL to Rename a Table
Create and drop schemas
create_schema()
Create a Schema
drop_schema()
Drop a Postgres schema
grant_all_in_schema()
Grant All Privileges on all Tables
ls_schema()
List Schemas
rename_schema()
Rename a Schema
render_create_schema()
Render SQL to Create a Schema
render_drop_schema()
Render SQL to Drop a Schema
render_grant_schema()
Render GRANT ALL PRIVILEGES
render_ls_schema()
Render SQL to List All Schema
summarize_schema()
Summarize all Fields in a Schema
drop_cascade()
Read, write, append, and drop tables
write_table()
Write a Table
read_table()
Read an Entire Table
drop_table()
Drop a Table
append_table()
Append a Table
search_table()
Search a Table for a Value
drop_all_staging_tables()
Drop V Tables
write_staging_table()
Write a Staging Table.
Build queries of predetermined styles
build_join_query()
Build a Query for a Join
build_query()
Build a Simple SQL Query
build_query_like()
Build a Like Query
build_query_regex()
Build a Regex Query
build_query_string()
Build a Query the Loops Over String
Set defaults for all or some of the arguments of a selection of functions
brake_ff()
Create a Brake Function
connect_ff()
Connection Function Factory
execute_creds_ff()
Query Function Factory
execute_fun_ff()
Execute Function Factory using Connection Expression
flag_ff()
Create a Flag Function
log_error_ff()
Log an Error Function Factory
log_start_ff()
Log a Start Function Factory
log_stop_ff()
Log a Stop Function Factory
q_creds_ff()
q_fun_ff()
Query Function Factory using Connection Expression
send_ff()
Send Function Factor
Create a logging system of functions for a project.
Logical questions on connection or database attributes
db_exists()
Does a database exist?
drop_if_exists()
field_exists()
Does a field exist?
schema_exists()
Does a schema exist?
table_exists()
Does a table exist?
is_closed()
Is the Connection Closed?
is_conn_open()
Is the Connection Open?
is_reserved()
Is a string a reserve word?
Summarize counts and valuesets at the field level across a subset of fields, an entire table or an entire schema
summarize_fields()
Summarize 1 or more Fields
summarize_table()
Summarize all Fields in a Table