DriveShare

Setup and Run Locally

1. Clone the Repository

   git clone https://github.com/leahmirch/DriveShare-Platform.git
   cd DriveShare-Platform

2. Create a Virtual Environment

   python -m venv venv
   source venv/bin/activate  # On Mac/Linux
   venv\Scripts\activate     # On Windows

3. Install Dependencies

   pip install -r requirements.txt

4. Run the Application in a Terminal

   python app.py

5. Access the Site Locally

   • Open http://127.0.0.1:5000/ in a web browser.

Database

• This project uses SQLite for simplicity.
• If needed, delete database.db to reset the database.

Accessing the Database

1. Using SQLite CLI:

   • Open a terminal or command prompt and navigate to the project directory:

     cd path/to/DriveShare-Platform

   • Start SQLite with the database file:

     sqlite3 database.db

   • List all tables:

     .tables

   • View table schema:

     .schema users
     .schema cars

   • Run a basic query:

     SELECT * FROM users;

2. (Optional) Use DB Browser for SQLite (GUI Tool):

   • Download and install DB Browser for SQLite.
   • Open database.db in the application.
   • Browse tables, execute queries, and inspect data visually.

Running Custom Queries

• Insert Data:

  INSERT INTO users (email, password, security_q1, security_q2, security_q3) 
  VALUES ('test@example.com', 'securepass', 'Answer1', 'Answer2', 'Answer3');

• Update Data:

  UPDATE users SET password='newpass' WHERE email='test@example.com';

• Delete Data:

  DELETE FROM users WHERE email='test@example.com';

Notes