•  
      Internship #163919 Incorporating python and mysql and adding crud operations through flask and using restful APIs
    #163919
    Aryan Jain (aryan30056)
    2024-06-07 10:37
    2024-06-07 10:37
    Details
    Incorporating python and mysql and adding crud operations through flask and using restful APIs
    1. Environment Setup: Installed Python and PyCharm on my system. Set up a MySQL database server. Used pip to install Flask and other necessary libraries. Project Initialization:

    2. Created a new project in PyCharm. Set up a virtual environment to manage dependencies. Database Configuration:

    3. Created a MySQL database and a table with attributes including creation and updation timestamps. Configured the connection to the MySQL database using SQLAlchemy in Flask. Flask Application Setup:

    4. Initialized a Flask application. Configured Flask with the MySQL database using SQLAlchemy.

    5. CRUD Operations Implementation: Create (POST): Implemented API endpoints to add new records to the database, capturing the creation timestamp. Read (GET): Implemented API endpoints to fetch records from the database. Update (PUT/PATCH): Implemented API endpoints to update existing records, capturing the updation timestamp. Delete (DELETE): Implemented API endpoints to delete records from the database.

    6. RESTful API Design: Designed RESTful API endpoints following best practices for naming and structuring. Ensured proper HTTP methods (GET, POST, PUT, DELETE) were used for respective operations.

    Empty
    Empty
    State of Progress
    2024-06-04
    Empty
    2024-06-07
    srishti srivastava (srishti), Arvind Rai (arvind_rai), Aryan Jain (aryan30056)
    Indresh Singh Bhadoria (indresh)
    2024-06-07
    Open
    Attachments
    Empty
    References
    References list is empty