Skip to content

Database project of level 2 term 2. A website built with django (python) and oracle database.

Notifications You must be signed in to change notification settings

fardinanam/RentaStay

Repository files navigation


RentaStay

Table of Contents
  1. About The Project
  2. Getting Started
  3. Contributors

About The Project

RentaStay is an oracle powered bootstrapped Django website inspired by Airbnb. Here a user can rent rooms that are available in the location they are going. At the same time, they can upload the information of their own house so that others can rent that. Based on this key idea many other features are added to ease access of the site for the users. We tried our best to add as many features as we could in this brief time.

Watch the video describing detailed features of the website here.

The goal of the project was to learn database from the core. So, we were not allowed to use Django's built-in models features. Instead, we had to use raw sql. Other than that, we had the privilege to use all the other features of Django that made the website easier to build. This was quite a challenging journey but a fun way to learn new things about website development.

Built With

Database

Oracle

Backend

Python Django

Fronend

HTML5

CSS3 Bootstrap

JavaScript jQuery

back to top

Getting Started

Follow the step by step installation procedure to install and run this on your machine

Prerequisites

Make sure you have python and oracle installed in your device.

Python: Install Python from here.

Oracle: Install Oracle from here and register for an account of your own.

Installation

Getting the repository

  1. Clone the repo:

    git clone https://github.com/fardinanam/RentaStay.git
  2. If you don't have git installed in your device then download zip

Setting up Python

  1. Go to the repository base folder and open terminal.

  2. Install python packages

    pip install -r requirements.txt

    This will install all the required packages for this project

Setting up Oracle

  1. The oracle TNSListener and Services are supposed to run by default but on windows sometimes these are required to start manually. In that case, in Windows->Services find OracleOraDB19Home2TNSListener (or just find the one that starts with oracle and ends with Listener) and OracleServiceORCL. Start these sequencially.

  2. Open SQL Plus

  3. Enter credentials

    username: sys as sysdba
    password: password
  4. Create a new user sa

    create user sa identified by sa;
    grant all privileges to sa;

Setting up the Database

  1. Connect to oracle as sa in SQL Plus

  2. Copy and paste the codes from sql/schemas.sql and run.

  3. Copy and paste the codes from sql/PLSQL.sql and run it.

    Almost there...

  4. copy and paste all the codes from sql/insert_locations.sql and run. (Only the cities of Bangladesh are added here. You can add more if you want.)

  5. If no errors are shown we are good to go!

One last step

  1. Now that everything is set, open terminal in the base directory of the repo.

  2. Run the code

    python manage.py makemigrations
    python manage.py migrate

You are all set. Wohoo!

  • Run the server

    python manage.py runserver

back to top

Contributors

Supervisor

  • Dr. Rifat Shahriyar

    Professor

    Department of Computer Science and Engineering Bangladesh University of Engineering and Technology Dhaka-1000, Bangladesh

    Homepage:

    http://rifatshahriyar.github.io/

back to top