/SQL-Music-Tour-API

Primary LanguageJavaScriptMIT LicenseMIT

Music Tour Management API

Description

This project is a RESTful API for managing a music tour. It includes functionality for handling bands, stages, and events, providing a comprehensive back-end solution for tour organization and scheduling.

Features

  • CRUD operations for bands, stages, and events
  • Filtering bands by name
  • Ordering events by date
  • Robust error handling and validation

Technologies Used

  • Node.js
  • Express.js
  • Sequelize ORM
  • PostgreSQL

Getting Started

Prerequisites

  • Node.js
  • npm (Node Package Manager)
  • PostgreSQL

Installation

  1. Clone the repository: https://github.com/djmotor90/SQL-Music-Tour-API.git
  2. Navigate to the project directory: cd SQL-Music-Tour-API
  3. Install the dependencies: npm install

Setting Up the Database

  1. Create a new PostgreSQL database for the project.
  2. Configure your database settings in a .env file or directly in the Sequelize configuration file.

Running the Application

  1. Start the server:
npm start
  1. The server will start running on http://localhost:8080/ (or a different port if configured).