No project description provided
Project description
SQL Field Report
Author: Will James
About
SQL Field Report is a polars poward data analysis tool, which summarises the schema of a given dataset. This can be a series of flat files (excel/csv) or tables in a database. It returns a table of analysis with the following columns:
Column | Description |
---|---|
Table/File | The table or file of the analysed field |
Field | The analysed column/field |
Count | The number of records in the table/file |
Populated | For the column/field, how many rows are populated |
Unique | For the column/field, how many unique values are present |
Datatype | Estimated CRM datatype for the column/field |
Installation
To install use pip:
pip install sql-field-report
Usage
SQL Field Report is a Typer CLI tool to see the available functions run:
sql-field-report --help
Usage: sql-field-report [OPTIONS] COMMAND [ARGS]...
Commands
mssql-database-report MSSQL Database Report
mysql-database-report MySQL Database Report
MSSQL Database Report
Generate an excel report summarising the data in an MSSQL Database
Args:
│ * server TEXT [default: None] [required] │
│ * port INTEGER [default: None] [required] │
│ * user TEXT [default: None] [required] │
│ * password TEXT [default: None] [required] │
│ * database_name TEXT [default: None] [required] │
│ * schema TEXT [default: None] [required] │
│ * output_file_name TEXT [default: None] [required]
SQL Field Report can also be used as an importable package in python code:
from sql_field_report import build_dataframe_field_report, read_file
analysis_files = ['file1.xlsx', 'file2.xlsx']
build_dataframe_field_report(
"Field_Report.xlsx,
analysis_files,
read_file,
)
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Close
Hashes for sql_field_report-1.0.15-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 20393937eba8a8488eadc0ae6c591a0a2003a209787812fbbec4557d0fedd357 |
|
MD5 | 512b8d7b1518cb1b80aa8f5046e5fba0 |
|
BLAKE2b-256 | b59ce7a168da52720511f0642e3d2814d9626277acb75c247f46bbc6ae8f1775 |