Web-based CRUD database.

2Fast4U Computers assembles and sells $2 million in PCs annually (on average 1,500 PCs assembled per year). The Computer Inventory and Manufacturing (CIM) web app will help manage the inventory, assembly, and quality control (QC) process for 2Fast4U. The state of the art database (DB) behind the CIM webapp will be used by 2Fast4U Employees at different production Sites. Employees are assigned Work Orders, which list Products to assemble using Regular Components (which are available in large quantities like MotherBoard, RAM, etc.) and Special Components (CPUs, which must be tracked using unique serial numbers). Regular Components and Special Components are stored in Locations at any particular Site until they are used to assemble Products. Once each Product has been assembled and QC’d, the Work Order can be closed.

This class project was built for Oregon State's CS340 Databases class in Winter 2021.

• Flask: a backend framework for Python used to develop web applications.
• Bootstrap: a Python framework for responsive web styling.
• MySQL: a relational database management system.

To get a local copy up and running follow these simple steps.

In order to make local changes to the CIMDB, you must first have Python and pip installed on your system. If you need assistance installing these prerequisites, see the folowing steps:

• Python is a programming language. Almost all of this project's code base (particularly the backend) is written in Python. Download the latest version of Python and install onto your local machine.

• Pip is the package installer for Python. Once Python is installed, open your local machine's command line and use the following command to utilize Python to install Pip:

python get-pip.py -g

Git is a version control system. In this project, Git is used to clone (copy) the most up-to-date project files from GitHub to your local machine. Download the latest version of git and install on your local machine.

1. Open the command line on your local machine.

2. Enter the following command to use Git to clone this repository to your local machine.

git clone https://https://github.com/team-cs-cats.git

3. Create a virtual environment called env within your local cloned repository.

virtualenv env

4. Activate the env virtual environment.

env\Scripts\activate.bat

5. Enter the following command to use Pip to install this repository's dependencies.

pip install -r requirements.txt

6. To run a local copy of the website on your local execute the run.py file.

python run.py

7. On your browser, navigate to http://localhost:5147/. This will update to saved changes in your local directory upon refresh.
8. Occasionally, some of the built-in resources (particularly the javascript scripts) of this project do not update when reloading changes made to files. To bypass these errors, reload the web page and bypass the cache. This can be done using the Shift + left click Reload button on Firefox or by entering developer mode on Google Chrome and selecting the Empty Cache and Hard Reload option.

See the open issues for a list of proposed features (and known issues).

Contributions are what make the open source community such an amazing place to be learn, inspire, and create. Any contributions you make are greatly appreciated.

1. Fork the Project
2. Create your Feature Branch (git checkout -b feature/AmazingFeature)
3. Commit your Changes (git commit -m 'Add some AmazingFeature')
4. Push to the Branch (git push origin feature/AmazingFeature)
5. Open a Pull Request

Distributed under the MIT License. See LICENSE for more information.

Ali Jalilian - [email protected] Asa LeHolland - [email protected]

Project Link: https://github.com/team-cs-cats/cimdb

• othneildrew for creating the template README file that was used as the starting point for the README for this project.