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.

Owner
Yash Wadhvani
Yash Wadhvani
Organize seu linux - organize your linux

OrganizeLinux Organize seu linux - organize your linux Organize seu linux Uma forma rápida de separar arquivos dispersos em pastas. formatos a serem c

Marcus Vinícius Ribeiro Andrade 1 Nov 30, 2021
Sailwind Mod Manager

Sailwind Mod Manager The Sailwind Mod Manager is an open source mod manager for the Sailwind community. It currently allows you to browse and download

Max 3 Jul 15, 2022
Hspice-Wave-Generator is a tool used to quickly generate stimuli souces of hspice format

Hspice-Wave-Generator is a tool used to quickly generate stimuli souces of hspice format. All the stimuli sources are based on `pwl` function of HSPICE and the specific complex operations of writing

3 Aug 02, 2022
Structured, dependable legos for Starknet development.

cairomate • Structured, dependable legos for starknet development. Directory Structure contracts ├─ defi │ ├─ ChainlinkPriceOracle — "Simple price or

andreas 127 Nov 23, 2022
Sync SiYuanNote & Yuque.

SiyuanYuque Sync SiYuanNote & Yuque. Install Use pip to install. pip install SiyuanYuque Execute like this: python -m SiyuanYuque Remember to create a

Clouder 23 Nov 25, 2022
Script that creates graphical representations of Julia an Mandelbrot sets.

Julia and Mandelbrot Picture Maker This simple functions create simple plots of the Julia and Mandelbrot sets. The Julia set require the important par

Juan Riera Gomez 1 Jan 10, 2022
Blender-miHoYo-Shaders - Shaders for Blender attempting to replicate the shading of games developed by miHoYo

Blender-miHoYo-Shaders - Shaders for Blender attempting to replicate the shading of games developed by miHoYo

Matsuri 449 Jan 07, 2023
Identifies the faulty wafer before it can be used for the fabrication of integrated circuits and, in photovoltaics, to manufacture solar cells.

Identifies the faulty wafer before it can be used for the fabrication of integrated circuits and, in photovoltaics, to manufacture solar cells. The project retrains itself after every prediction, mak

Arun Singh Babal 2 Jul 01, 2022
Source for the Fedora Silverblue and Kinoite variants.

Source for the Fedora Silverblue and Kinoite variants.

Fedora Kinoite 7 Aug 20, 2022
HashDB Binary Ninja Plugin

HashDB Plugin (v0.1) Author: Vector 35 Inc Plugin for interacting with the OALABS HashDB service. Description: Plugin that can be used to lookup hashe

Jordan 3 Jul 30, 2022
Un Assistente Vocale scritto in Python e altamente personalizzabile

Un Assistente Vocale scritto in Python e altamente personalizzabile

Marco 2 May 06, 2022
「📖」Tool created to extract metadata from a domain

Metafind is an OSINT tool created with the aim of automating the search for metadata of a particular domain from the search engine known as Google.

9 Dec 28, 2022
This repo contains scripts that add functionality to xbar.

xbar-custom-plugins This repo contains scripts that add functionality to xbar. Usage You have to add scripts to xbar plugin folder. If you don't find

osman uygar 1 Jan 10, 2022
Enjoyable scripting experience with Python

Enjoyable scripting experience with Python

8 Jun 08, 2022
Displays Christmas-themed ASCII art

Christmas Color Scripts Displays Christmas-themed ASCII art. This was mainly inspired by DistroTube's Shell Color Scripts Screenshots ASCII Shadow Tex

1 Aug 09, 2022
Spyware baseado em Python para Windows que registra como atividades da janela em primeiro plano, entradas do teclado.

Spyware baseado em Python para Windows que registra como atividades da janela em primeiro plano, entradas do teclado. Além disso, é capaz de fazer capturas de tela e executar comandos do shell em seg

Tavares 1 Oct 29, 2021
A streamlit app for exploring image search results from HuggingPics

title emoji colorFrom colorTo sdk app_file pinned huggingpics-explorer 🤗 blue red streamlit app.py false huggingpics-explorer A streamlit app for exp

Nathan Raw 4 Sep 10, 2022
OTP-Bomber - An otp from MPL ID app, which can be spammed

OTP-Bomber An otp from MPL ID app, which can be spammed Note: Only available on

5 Oct 29, 2022
Kellogg bad | Union good | Support strike funds

KelloggBot Credit to SeanDaBlack for the basis of the script. req.py is selenium python bot. sc.js is a the base of the ios shortcut [COMING SOON] Set

407 Nov 17, 2022
Generates images with semantic content from distribution A in the style of distribution B

A2B Generates images with semantic content from distribution A in the style of d

Richard Herbert 2 Dec 27, 2021