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
The RAP community of practice includes all analysts and data scientists who are interested in adopting the working practices included in reproducible analytical pipelines (RAP) at NHS Digital.

The RAP community of practice includes all analysts and data scientists who are interested in adopting the working practices included in reproducible analytical pipelines (RAP) at NHS Digital.

NHS Digital 50 Dec 22, 2022
Controller state monitor plugin for EVA ICS

eva-plugin-cmon Controller status monitor plugin for EVA ICS Monitors connected controllers status in SFA and pushes measurements into an external Inf

Altertech 1 Nov 06, 2021
Reactjs web app written entirely in python, using transcrypt compiler.

Reactjs web app written entirely in python, using transcrypt compiler.

Dan Shai 22 Nov 27, 2022
A python mathematics module

A python mathematics module

Fayas Noushad 4 Nov 28, 2021
A set of scripts for a two-step procedure to measure the value of access to destinations across several modes of travel within a geographic area.

A set of scripts for a two-step procedure to measure the value of access to destinations across several modes of travel within a geographic area.

Institute for Transportation and Development Policy 2 Oct 16, 2022
A small scale relica of bank management system using the MySQL queries in the python language.

Bank_Management_system This is a Bank Management System Database Project. Abstract: The main aim of the Bank Management Mini project is to keep record

Arun Singh Babal 1 Jan 27, 2022
Show Public IP Information In Linux Taskbar

IP Information In Linux Taskbar 📍 How Use IP Script? 🤔 Download ip.py script and save somewhere in your system. Add command applet in your taskbar a

HOP 2 Jan 25, 2022
A python script that will automate the boring task of login to the captive portal again and again

A python script that will automate the boring task of login to the captive portal again and again

Rakib Hasan 2 Feb 09, 2022
EloGGs 🎮 is a 1v1.LOL Trophy Boosting Program (PATCHED)

EloGGs 🎮 is an old patched 1v1.LOL boosting program I developed months ago, My team made around $1000 total off of this, but now it's been patched by the developers.

doop 1 Jul 22, 2022
People tracker on the Internet: OSINT analysis and research tool by Jose Pino

trape (stable) v2.0 People tracker on the Internet: Learn to track the world, to avoid being traced. Trape is an OSINT analysis and research tool, whi

Jose Pino 7.3k Dec 30, 2022
京东自动入会获取京豆

京东入会领京豆 要求 有一定的电脑知识 or 有耐心爱折腾 需要Chrome(推荐)、Edge(Chromium)、Firefox 操作系统需是Mac(本人没在m1上测试)、Linux(在deepin上测试过)、Windows 安装方法 脚本采用Selenium遍历京东入会有礼界面,由于遍历了200

Vanke Anton 500 Dec 22, 2022
Demo content - Automate your automation!

Automate-AAP2 Demo Content - Automate your automation! A fully automated Ansible Automation Platform. Context Installing and configuring Ansible Autom

0 Oct 27, 2022
Compiler Final Project - Lisp Interpreter

Compiler Final Project - Lisp Interpreter

2 Jan 23, 2022
Discovering local read-level DNA methylation patterns and DNA methylation heterogeneity in intermediately methylated regions

Discovering local read-level DNA methylation patterns and DNA methylation heterogeneity in intermediately methylated regions

1 Jan 11, 2022
Defichain maxi - Scripts to optimize performance on defichain rewards

defichain_maxi This script is made to optimize your defichain vault rewards by m

kuegi 75 Dec 31, 2022
Python wrapper around Apple App Store Api

App Store Connect Api This is a Python wrapper around the Apple App Store Api : https://developer.apple.com/documentation/appstoreconnectapi So far, i

123 Jan 06, 2023
Utility functions for working with data from Nix in Python

Pynixutil - Utility functions for working with data from Nix in Python Examples Base32 encoding/decoding import pynixutil input = "v5sv61sszx301i0x6x

Tweag 11 Dec 16, 2022
Material de apoio da oficina de SAST apresentada pelo CAIS no Webinar de 28/05/21.

CAIS-CAIS Conjunto de Aplicações Intencionamente Sem-Vergonha do CAIS Material didático do Webinar "EP1. Oficina - Práticas de análise estática de cód

Fausto Filho 14 Jul 25, 2022
An app to automatically take attendance by scanning students' bar coded ID card as they enter the classroom.

Auto Classroom Attendance This application may be run on a PC to automatically scan students' ID card using a generic bar code scanner and output the

1 Nov 10, 2021
An app to help people apply for admissions on schools/hostels

Admission-helper About An app to help people apply for admissions on schools/hostels This app is a rewrite of Admission-helper-beta-v5.8.9 and I impor

Advik 3 Apr 24, 2022