This is a wrapper around ln2sql by Jeremy Ferrero for convenient use
Project description
ln2sqlmodule
This is an adoption of the awesome ln2sql by Jérémy Ferrero as a python module so that people can easily use it to create some awesome things !
Things added in ln2sqlmodule :
- API for getting WHERE queries with LIKE and '%'
- INNER JOIN working correctly with FOREIGN KEY
- PRIMARY KEY and FOREIGN KEY detection from ALTER STATEMENT
- Value extraction from natural language
INSTALLATION
pip install ln2sqlmodule
import ln2sqlmodule
USAGE
getSql(query, sqlDump[, outputFile])
- ln2sqlmodule.getSql(query, sqlDump[, outputFile])
returns SQL query from natural language query
Parameters :
query : query in natural language
sqlDump : path to sql dump file
[outputFile] : path to file to output SQL query in json
returns :
SQL query string
Example:
ln2sqlmodule.getSql("get name of all emp","./emp.sql")
-> SELECT name FROM emp
getSql_like(query, sqlDump[, outputFile])**
returns SQL query from natural language with LIKE with % in WHERE clause
Parameters :
query : query in natural language
sqlDump : path to sql dump file
[outputFile] : path to file to output SQL query in json
returns :
SQL query string with LIKE
Example:
ln2sqlmodule.getSql("all data for emp where name is rupinder","./emp.sql")
-> SELECT * FROM emp WHERE name LIKE '%rupinder%'
ln2sqlmodule.getSql("all data for emp where name is 'abc xyz'","./emp.sql")
-> SELECT * FROM emp WHERE name LIKE '%abc%xyz'
outputFile Schema
{
"select": {
"column": "",
"type": ""
},
"from": {
"table": ""
},
"join": {
},
"where": {
},
"group_by": {
},
"order_by": {
}
}
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
ln2sqlmodule-1.0.1.tar.gz
(15.6 kB
view hashes)
Built Distribution
Close
Hashes for ln2sqlmodule-1.0.1-py2-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | f5c79af581f76e09c1dcb48cacb6d762e55e6bdcee4a7ec0ea8badbc0f4cd468 |
|
MD5 | 51f7714bd0aab66a2b05e1b26f016190 |
|
BLAKE2b-256 | 3ad79053f7ffb2baa3206442453ab8009a45ed6fe069466f3223531e3d210c73 |