Transform column and table name to desired one
Project description
SQL Refactor
This library contains a class, Refactor
, for refactoring a SQL with a given knowledge of tables and column names mapping.
Structur of the knowledge
The knowledge is a dictionary containing the mapping of old_table
-new_table
and corresponding old_column
-new_column
.
The structure of the knowledge:
{
"old_table_name":
{
"new_table": "new_table_name",
"column_knowledge":
{
"column_1" : "new_column_1",
"column_2" : "new_column_2",
}
"preserved" : boolean
},
.
.
.
}
How to use
Code sample:
from sql_refactor import Refactor
# refer to Structure of Knowledge
knowledge = KNOWLEDGE
refactor = Refactor(knowledge)
refactor.refactor('''SELECT column_1, column_2 FROM old_table_name''')
new_query = refactor.result()
Result:
SELECT
new_column_1 AS column_1,
new_column_2 AS column_2
FROM
`new_table_name`
Project details
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
sql-refactor-0.0.2.tar.gz
(40.3 kB
view hashes)
Built Distribution
Close
Hashes for sql_refactor-0.0.2-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 6cfc976860ea227fec99079f1d0dc8cd9e52031ead46d50811804e56141a7e4b |
|
MD5 | 5df60e18f4928e5f67490bead0944ed8 |
|
BLAKE2b-256 | f9ef27dd9f755f1a94253bf5d421ed9c656cae9886100b233cc705d768206213 |