API Reference
The set-up functions
Save encoded database engine url to keyring or config. |
|
The |
|
Alias for |
|
Make database connection engine. |
|
Make or remake a test table on database. |
Database operator object
The base database operator class. |
Database operator object - operation methods
Make and run an add primary key statement. |
|
Make and run a create table statment. |
|
Make and run a create schema statement. |
|
Create table and insert based on dataframe. |
|
WIP |
|
Drop table if exist. |
|
Check if table exist. |
|
Create the iris test table on the database. |
|
Create the mtcars test table on the database. |
|
Make a |
|
Run sql statement. |
|
WIP |
|
Make and run a insert many statement. |
|
Insert without creating duplicates. |
Database operator object - metadata methods
List all constraints. |
|
List all tables on database or specified schema. |
|
Show information of specified table's columns. |
|
List sizes of all tables in current schema. |
Query object
The query class. |
Query object - clause methods
Add a case when clause to the select clause. |
|
Add the from clause to query. |
|
Add the group by clause to query. |
|
Add the having clause to query. |
|
Add a join clause to query. |
|
Add the order by clause to query. |
|
Print the built query. |
|
Run the built query. |
|
Add the select clause to query. |
|
Replace the underlying query by specified sql. |
|
Return the built query as str. |
|
Add the where clause to query. |
Query object - summary methods
WIP |
|
Fetch column names of the sub query table. |
|
Count number of distinct occurances of data. |
|
WIP |
|
Calculate a simple oracle hash for table. |
|
Fetch top 5 rows of the sub query table. |
|
Length of the sub query table. |
|
Fetch maximum and minimum values of a column. |
|
WIP |
|
WIP |
|
Fetch top row of the sub query table. |
|
Value count of a column or combination of columns. |