Steps to use ln2sql

[kundanvr]

I am sorry, I am not getting how to use this tool. Can anybody tell me the uses or steps from scratch so that I can understand and use this feature.

[kalimuthu123]

Hi i am very much interested with this package and i want to implement it in my tool and what are the step sfor the implementation of the package

[lucascasserone]

after running the json file don't was been created.

[Vikashrajluhaniwal]

1. Clone the below repo to create a local copy on your computer. https://github.com/maverickjoy/ln2sql
2. Place your database dump file inside the /database folder of the repo. Here, database dump is a file containing all the DDL, DML operations i.e. all information about tables structure and data of the tables.
3. Now on the command prompt, navigate to the cloned repo and use the following command. python ln2sql.py -d database/city.sql -l lang/english.csv -j output.json -i "how many city there are in which the employee name is similar to aman ?"

Note -

• The table name, columns name, and data provided in the above command is case sensitive as per the database dump file.
• The complete repo is in Python 2.7 environment.
• If you want to use other than English language keywords then place the language configuration file inside /lang directory.

[kalimuthu123]

@Vikashrajluhaniwal is there possibility of connecting my RDBMS in the aws via sqlalchemy packages instead of placing Dump file in the folder

[isaactyj]

@Vikashrajluhaniwal Don't think it works there is a lot that does not work in this repo: https://github.com/maverickjoy/ln2sql like the formatting of it such as reload and exceptions and print statements.