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
Built Distribution
Close
Hashes for sql_field_report-1.0.18-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 6ebc24b8519df3416ea0273827a874d7c82e6c7be666aa67c4f3bdf5da558932 |
|
MD5 | 407b75a5f4a3a97bc3dab91c3d9c83af |
|
BLAKE2b-256 | 50a22370283730d208d7b2ff43250f69dba327544421ecd33818ab408f730b3a |