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
Advent of Code is an Advent calendar of small programming puzzles for a variety of skill sets and skill levels that can be solved in any programming language you like.

Advent Of Code 2021 - Python English Advent of Code is an Advent calendar of small programming puzzles for a variety of skill sets and skill levels th

Coral Izquierdo Muñiz 2 Jan 09, 2022
SuperCollider library for Python

SuperCollider library for Python This project is a port of core features of SuperCollider's language to Python 3. It is intended to be the same librar

Lucas Samaruga 65 Dec 22, 2022
AutoMetamon: Simple program to play Metamon automatically

AutoMetamon: Simple program to play Metamon automatically

Ngô Văn Tuấn 2 Sep 13, 2022
Python implementation of the ASFLIP advection method

This is a python implementation of the ASFLIP advection method . We would like to hear from you if you appreciate this work.

Raymond Yun Fei 133 Nov 13, 2022
In this project, we'll be creating a virtual personal assistant for ourselves using our favorite programming language

In this project, we'll be creating a virtual personal assistant for ourselves using our favorite programming language, Python. We can perform several offline as well as online operations using the bo

Ashutosh Krishna 188 Jan 03, 2023
Install packages with pip as if you were in the past!

A PyPI time machine Do you wish you could just install packages with pip as if you were at some fixed date in the past? If so, the PyPI time machine i

Thomas Robitaille 51 Jan 09, 2023
Web service which feeds Navitia with real-time disruptions

Chaos Chaos is the web service which can feed Navitia with real-time disruptions. It can work together with Kirin which can feed Navitia with real-tim

KISIO Digital 7 Jan 07, 2022
This is the key combo trainer for League of Legends and Dota 2 players.

This is the key combo trainer for League of Legends and Dota 2 players. Place the mouse cursor on the blue point and press the key combo from the upper-left side of the screen.

Ilya Shpigor 1 Jan 31, 2022
データサイエンスチャレンジ2021 サンプル

データサイエンスチャレンジ2021 サンプル 概要 線形補間と Catmull–Rom Spline 補間のサンプル Python スクリプトです。 データサイエンスチャレンジ2021の出題意図としましては、訓練用データ(train.csv)から機械学習モデルを作成して、そのモデルに推論させてモーシ

Bandai Namco Research Inc. 5 Oct 17, 2022
Hydralit package is a wrapping and template project to combine multiple independant Streamlit applications into a multi-page application.

Hydralit The Hydralit package is a wrapping and template project to combine multiple independant (or somewhat dependant) Streamlit applications into a

Jackson Storm 108 Jan 08, 2023
E5自动续期

AutoApi v6.3 (2021-2-18) ———— E5自动续期 AutoApi系列: AutoApi(v1.0) 、 AutoApiSecret(v2.0) 、 AutoApiSR(v3.0) 、 AutoApiS(v4.0) 、 AutoApiP(v5.0) 说明 E5自动续期程序,但是

34 Feb 20, 2021
A parallel branch-and-bound engine for Python.

pybnb A parallel branch-and-bound engine for Python. This software is copyright (c) by Gabriel A. Hackebeil (gabe.hacke

Gabriel Hackebeil 52 Nov 12, 2022
A Powerful Tool For Making Combo List(All possible modes)

ComboMaker A Powerful Tool For Making Combo List Introduction Check out all possible Combo list build modes with this tool =) How to Install Open the

MasterBurnt 7 Jan 07, 2023
CarolinaCon CTF Online

CarolinaCon Online CTF CTF challenges from CarolinaCon Online April 23 through April 25, 2021. All challenges from the CTF will eventually be here. Co

49th Security Division 6 May 04, 2022
⚙️ Compile, Read and update your .conf file in python

⚙️ Compile, Read and update your .conf file in python

Reece Harris 2 Aug 15, 2022
Height 2 LDraw With python

Height2Ldraw About This project aims to be able to make a full lego 3D model using the ldraw file format (.ldr) from a height and color map, currently

1 Dec 22, 2021
Machine Learning powered app to decide whether a photo is food or not.

Food Not Food dot app ( 🍔 🚫 🍔 ) Code for building a machine Learning powered app to decide whether a photo is of food or not. See it working live a

Daniel Bourke 48 Dec 28, 2022
flake8 plugin which checks that there is no use of sleep in the code.

flake8-sleep flake8 plugin which checks for use of sleep function. installation Using Pypi: pip install flake8-sleep flake8 codes Code Description SLP

1 Nov 26, 2021
Blender-3D-SH-Dma-plugin - Import and export Sonic Heroes Delta Morph animations (.anm) into Blender 3D

io_scene_sonic_heroes_dma This plugin for Blender 3D allows you to import and ex

Psycrow 3 Mar 22, 2022
UF3: a python library for generating ultra-fast interatomic potentials

Ultra-Fast Force Fields (UF3) S. R. Xie, M. Rupp, and R. G. Hennig, "Ultra-fast interpretable machine-learning potentials", preprint arXiv:2110.00624

Ultra-Fast Force Fields 24 Nov 13, 2022