Skip to content

Saves the CSV data to DB and provides CRUD operation for data manipulation.

License

Notifications You must be signed in to change notification settings

Saatwik-Mehta/csv_to_db_pkg

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

14 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

CSV_TO_DB_CONVERTER

It takes a CSV file as input, converts and save the data into a default set Database (fileupload). The table name will consist of the name of the file user is uploading. After a successful upload user can perform CRUD operations on the file data using a localhost server.

Installation

pip install csv-to-db-converter-saatwikmehta

STEPS TO INSTALL & MODIFY THE PROJECT

  • Activate your python venv

  • Install the requirements given:

    pip install -r requirements.txt
  • Mysql is the main component for storing data

    • Set env variables
      $env:HOST= your hostname for mysql
      $env:USER= your username
      $env:PASSWORD= your password
  • Run server inside directory file upload_file.py

python upload_file.py

License

© 2022 Saatwik Mehta

This repository is licensed under the MIT license. See LICENSE for details.

About

Saves the CSV data to DB and provides CRUD operation for data manipulation.

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published