semvec/pypi-packages huggingface dataset:
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