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
To use as a CLI, call "sql-field-report
" within a virtual environment:
python -m venv venv
pip install sql-field-report
venv/scripts/activate
sql-field-report --help
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,
)
import uuid
from os import getenv, listdir, remove
from os.path import join
from dotenv import load_dotenv
from sql_field_report.sql_field_report import MSSQL_Database_Report
load_dotenv()
file = f"Test_Report{str(uuid.uuid4())}.xlsx"
MSSQL_Database_Report(
getenv("SERVER"),
getenv("PORT"),
getenv("USER"),
getenv("SQL_SERVER_PASSWORD"),
getenv("DATABASE"),
"dbo",
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
sql_field_report-1.2.7.tar.gz
(11.6 kB
view hashes)
Built Distribution
Close
Hashes for sql_field_report-1.2.7-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | a71f8d7a6e9f69b5a91831477941bdf78bbf554256a7cf394870070bf0e09f87 |
|
MD5 | 2ddced67452995f5ad369fc2f44ee655 |
|
BLAKE2b-256 | 0a022b62f9df1aef9c041533701a2e435a9a5be5018a9ba126630d6c4d0062dc |