MySQL Connectivity based project. Contains various functions of a Store-Management-System

Overview

store-management-system

An Intermediate Level Python - MySQL Connectivity based project. Contains various functions of a Store-Management-System.

Help on module Main:

NAME Main

FUNCTIONS CustomerMenu() Function that shows the options for customers to select from.

Menu()
    Function that show options to Log In as a Customer or an Owner or to Exit the program.

OwnerMenu()
    Function that shows a Menu to select options from for the Owner of the Store.

Help on module Database_Connect:

NAME Database_Connect

FUNCTIONS create_tables() Function that creates the required tables in MySQL Database if not created already.

database_connector()
    Function that Returns an Connection Object that connects Python to MySQL.

Help on module Owner:

NAME Owner

CLASSES builtins.object Owner

class Owner(builtins.object)
 |  Owner(name)
 |
 |  Class for Object of type 'Owner'. Contains all the functions accessible by an Owner.
 |
 |  Methods defined here:
 |
 |  P_Invoice(self)
 |      Function to make Purchase for New Stock.
 |
 |  Show_Customers(self)
 |      Function that prints Customers table from Database.
 |
 |  Show_Owners(self)
 |      Function that prints Owners Table from Database.
 |
 |  __init__(self, name)
 |      Function to initiate an Owner and add it to the Owners table if it doesn't exist.
 |
 |  account(self)
 |      Function that prints the Amount in selected Owners Account.
 |
 |  addCustomer(self, name)
 |      Function to add a New Customer to Customers Table.
 |
 |  delete_item(self)
 |      Function to Delete Items from the Stock Table.
 |
 |  ----------------------------------------------------------------------
 |  Static methods defined here:
 |
 |  ItemIsThere(sr='', name='')
 |      Static Function to search for an Item using it's Sr. No. or Name. Return True/False.
 |
 |  Stock_Report()
 |      Static Funtion to print the Stock Report.

Help on module Customer:

NAME Customer

CLASSES builtins.object Customer

class Customer(builtins.object)
 |  Customer(name)
 |
 |  Class for an Object of type 'Customer'. Contains all the functions accessible by a Customer.
 |
 |  Methods defined here:
 |
 |  S_Invoice(self)
 |      Function to generate a Sales Invoice for a Customer. Asks for items to be purchased from Customer and Prints Invoice.        
 |
 |  __init__(self, name)
 |      Function to initiate a Customer and add it to Customers Table if it doesn't exist.
 |
 |  payBill(self)
 |      Function to settle accounts by paying the outstanding bill.
 |
 |  printInvoice(self)
 |      Function to print the Sales Ivoice.
 |
 |  ----------------------------------------------------------------------
 |  Static methods defined here:
 |
 |  search_item(name)
 |      Static Function to search if a given item is there in stock or not.

This project can be used for Class 12th Computer Science Project as it serves the purpose correctly.

You might also like...
A self contained invitation management system for gatekeeping.

Invitease Description A self contained invitation management system for gatekeeping. Purpose Serves as a focal point for inviting guests to a venue pr

A student information management system in Python
A student information management system in Python

Student-information-management-system 本项目是一个学生信息管理系统,这个项目是用Python语言实现的,也实现了图形化界面的显示,同时也实现了管理员端,学生端两个登陆入口,同时底层使用的是Redis做的数据持久化。 This project is a stude

Open Source Management System for Botanic Garden Collections.

BotGard 3.0 Open Source Management System for Botanic Garden Collections built and maintained by netzkolchose.de in cooperation with the Botanical Gar

A Company Management System For Python

campany-management Getting started To make it easy for you to get started with GitLab, here's a list of recommended next steps. Already a pro? Just ed

User management system (UMS), has the primary purpose of connecting to an Active Directory (AD)
User management system (UMS), has the primary purpose of connecting to an Active Directory (AD)

💿 Sistema de Gerenciamento de Usuário (SGU) 📚 Sobre o projeto Sistema de gerenciamento de usuários (SGU), tem o objetivo primário de se conectar a u

An example using debezium and mysql with docker-compose

debezium-mysql An example using debezium and mysql with docker-compose The docker compose starts the Zookeeper, Kafka, Mysql and Debezium Connect. Aft

An example of Connecting a MySQL Database with Python Code
An example of Connecting a MySQL Database with Python Code

An example of Connecting a MySQL Database with Python Code And How to install Table of contents General info Technologies Setup General info In this p

An example of Connecting a MySQL Database with Python Code
An example of Connecting a MySQL Database with Python Code

An example of Connecting And Query Data a MySQL Database with Python Code And How to install Table of contents General info Technologies Setup General

Бэкапалка таблиц mysql 8 через брокер сообщений nats

nats-mysql-tables-backup Бэкап таблиц mysql 8 через брокер сообщений nats (проверено и работает в ubuntu 20.04, при наличии python 3.8) ПРИМЕРЫ: Ниже

Owner
Yash Wadhvani
Yash Wadhvani
Library management using python & MySQL

Library management using python & MySQL Dev/Editor: Pavan Ananth Sharma & MK Akash Introduction: This is an intermediate project which is a user-frie

Pavan Ananth Sharma 2 Jul 5, 2022
Student Result Management System Project in tkinter created based on python, tkinter, and SQLITE3 Database

Student-Result-Management-System This Student Result Management System Project in tkinter created based on python, tkinter, and SQLITE3 Database. The

Ravi Chauhan 2 Aug 3, 2022
A basic DIY-project made using Python and MySQL

Banking-Using-Python-MySQL This is a basic DIY-project made using Python and MySQL. Pre-Requisite needed:-->> MySQL command Line:- creating a database

ABHISHEK 0 Jul 3, 2022
Possible solutions to Wordscapes, a mobile game for the android operating system, downloadable from the play store

Possible solutions to Wordscapes, a mobile game for the android operating system, downloadable from the play store

Clifford Onyonka 2 Feb 23, 2022
This repository contains various tools useful for offensive operations (reversing, etc) regarding the PE (Portable Executable) format

PE-Tools This repository contains various tools useful for offensive operations (reversing, etc) regarding the PE (Portable Executable) format Install

stark0de 4 Oct 13, 2022
CaskDB is a disk-based, embedded, persistent, key-value store based on the Riak's bitcask paper, written in Python.

CaskDB - Disk based Log Structured Hash Table Store CaskDB is a disk-based, embedded, persistent, key-value store based on the Riak's bitcask paper, w

null 886 Dec 27, 2022
This is a simple bank management system based on Python.

Python Bank Management This is a simple bank management system based on Python. It's able to do basic operations of simple bank management. Outcome: W

Md. Rakibul Islam 3 Jan 6, 2022
Student Management System Built With Python

Student-Management-System Group Members 19BCE183 - Patel Sarthak 19BCE195 - Patel Jinil 19BCE220 - Rana Yash Project Description In our project Studen

Sarthak Patel 6 Oct 20, 2022
Allow you to create you own custom decentralize job management system.

ants Allow you to create you own custom decentralize job management system. Install $> git clone https://github.com/hvuhsg/ants.git Run monitor exampl

null 1 Feb 15, 2022
Public Management System for ACP's 24H TT Fronteira 2021

CROWD MANAGEMENT SYSTEM 24H TT Vila de Froteira 2021 This python script creates a dashboard with realtime updates regarding the capacity of spectactor

VOST Portugal 1 Nov 24, 2021