/db_project

2020-1 Ajou univ. database course.

Primary LanguagePython

db_project

2020-1 Ajou univ. database course.

알레르기 유무 및 채식 유형멸 맞춤 식품 검색 서비스 development with Python, PostgreSQL

Requirements

Python 3.6, postgres

Installatoin

  1. Clone this repository
  2. Install dependencies
pip3 install -r requirements.txt

Upload Datasets

input command prompt like below

cd src
python upload_data.py --user postgres --pwd 1234 --db projectDB --host localhost --port 5432

--user: user name --pwd: sever password --db: database name --host: host address(default: localhost) --port: port number

Cuation

  • All tables in that database are dropped.

Use GUI

python main.py

User Scenario

  • initial window

스크린샷 2020-06-20 오후 4 40 12

- sign in window

스크린샷 2020-06-20 오후 4 41 15

- search & show result by personal account
  • search with text or barcode scan
    • you can close barcode windows with esc key.(not close window button.)

캡처

- alternative products in combobox

스크린샷 2020-06-20 오후 4 53 15

스크린샷 2020-06-20 오후 4 53 24

Make Datasets

input command prompt like below

cd src
python make_dataset.py

it will make AllergyRawMtrl_{%y%m%d%H%M%S}.csv, haccp_dataset_{%y%m%d%H%M%S}csv, VegRawMtrl_{%y%m%d%H%M%S}.csv

uplode_data.py will upload lastest csv file.