crud-generator 1.0.2

This will generate a crud operations (crud.py) for your Database tables.

crud_generator

This will generate a crud operations (crud.py) for your Database tables.

How to Use:

Step 1:

• from crud_generator import generate_crud
• generate_crud(tablename, attributes) is the function which will create crud_tablename.py file
• Table name and attributes/column name are the only two parameters to be passed.
• Eg: generate_crud("Employee","Name,Age,Employee_code,Salary")
• then this will automatically create py file.

Step 2:

• functions created by the functions are

  #First:

• def create_conn():

• this function is an empty function where you can create your connections. You can choose any DB, import library accordingly.

• Following is the code which you will get.

• def create_conn():

• pass

• #Enter your connection code

• #Example: for postgresql

• #conn = psycopg2.connect(database = "testdb", user = "postgres", password = "pass123", host = "127.0.0.1", port = "5432")

• #then return conn

  #Second:

• def create_tablename(values):

• this function will perform insert operation in table.

• Here, you just need to pass values of the attributes

• Eg: create_Employee("""'Alex',26,'EMP_2760',29000""") #Name,Age,Employee_code,Salary

• You can see the sql query in CLI

• Ensure to pass values as raw input.

  #Third:

• def read_Employee(condition="1=1"):

• this function will perform read operation in table.

• Here, if you don't pass any parameters it will return all records or you can pass any condition.

• Eg: read_Employee("Salary=2900 and Employee_code='EMP_2760'") # condition similary to that in where clause can be passed here.

• You can see the sql query in CLI

  #Fourth:

• def update_Employee(values,condition="1=1"):

• this function will perform update operation in table.

• Here, if you don't pass any condition it will perform update on all records or you can pass any condition.

• Here, you can pass values like "salary=30000", just like you pass in sql.

• Eg: update_Employee("Salary=30000","Name='Alex'") # condition similary to that in where clause can be passed here and values like that in update statement.

• You can see the sql query in CLI

  #Fifth:

• def delete_Employee(condition="1=1"):

• this function will perform delete operation in table.

• Here, if you don't pass any parameters it will delete all records or you can pass any condition.

• Eg: delete_Employee("Salary=2900 and Employee_code='EMP_2760'") # condition similary to that in where clause can be passed here.

• You can see the sql query in CLI