Skip to content

A PyMySQL Project for maintaining a database for an Online Pharmacy System

Notifications You must be signed in to change notification settings

harshita130602/MyMedicine-Pharmacy-management-system

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

10 Commits
 
 
 
 
 
 

Repository files navigation

MyMedicine - Pharmacy management system

This repository is an attempt to create a mini world of “MyMedicine - An Online Pharmacy Management System”. It is a system that stores data and enables functionality that allows users to buy medicines via an online network. To be precise, pharmacy management system is an internet-based vendor that sells medicines and allowsusers an option to buy from their mobile, laptop etc.

The CLI version for the same can be run by cloning this repo.

Requirements

  • Python3
$ sudo apt-get update
$ sudo apt-get install python3.6
  • MySQL
  • PyMySQL
$ sudo apt-get install python3-pip
$ pip3 install pymysql

Installation

You will need to replicate the MyMedicine Databse on your local machine, for which the dump.sql file is provided herewith.

Open your MySQL server and create the following database:

$ mysql> CREATE DATABASE MYMEDICINE;

Run the following command to import the database:

$ mysql -u username -p MYMEDICINE < dump.sql

You might need to enter your password in the next step.

To run the CLI, change your directory to the cloned folder and run the following command:

$ python3 MyMedicine.py
- Please Note: If you are using Docker to run MySQL, you might need to first change your port to 5005 (or the port you use) by replacing the following lines for connecting the database in the MyMedicine.py file: 
con = pymysql.connect(host='localhost',
                              user=username,
                              password=password,
                              db='MYMEDICINE',
                              port='5005',
                              cursorclass=pymysql.cursors.DictCursor)

near lines 1086-1090.

Steps to Run

You will be first prompted to enter your MySQL Username and Password as follows:

Enter username and password to access the database.
Username: 
Password:

You will now be redirected to the Login/Signup Page.

The following are some sample credentials for you to login (although you can create yours too from the CLI):

  • Admin
Email-Id: [email protected] 
Password: 1234
  • Customer
Email-Id: [email protected] 
Password: 1234
  • Manager
Email-Id: [email protected] 
Password: 1234
Email-Id: [email protected] 
Password: 1234
Email-Id: [email protected] 
Password: 1234

Happy Shopping! ❤️

About

A PyMySQL Project for maintaining a database for an Online Pharmacy System

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages