No project description provided
Project description
SQL Field Report
Author: Will James
About
SQL Field Report is a polars powered 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.17-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 16259d4cc6b4edd3287e91a0c7967039f34ca71b0dcbb6b8dcf8284b828e6478 |
|
MD5 | ef7078bb4aded0039580bc55bf873615 |
|
BLAKE2b-256 | 19136bbc84cb9026ecf6a2b55eb5a5f1b8b682091040bc14496d700e9cda0cc0 |