britnay268 / TunaPiano-BE

0 stars 0 forks source link

Create Database #2

Closed britnay268 closed 2 months ago

britnay268 commented 2 months ago

Description

A database needs to be created to allow endpoints to interact with the data within it.

Dev Notes

[x] Create Data folder to store mock data for the data models

[x] Create a DBContext File

[ ] Artist
[ ] Song

[ ] Genre

// Added necessary packages to 
dotnet add package Npgsql.EntityFrameworkCore.PostgreSQL --version 6.0
dotnet add package Microsoft.EntityFrameworkCore.Design --version 6.0
dotnet user-secrets init
dotnet user-secrets set "ProjectNameConnectionString" "Host=localhost;Port=5432;Username=postgres;Password=<your_postgresql_password>;Database=CreekRiver"

[ ] Run code to create database

// Necessary commands for creating the database
dotnet ef migrations add InitialCreate
dotnet ef database update

Issue Type

[ ] Feature Request
[ ] Bug
[ ] Documentation
[ ] Enhancement
[X] Dev Setup

britnay268 commented 2 months ago

Completed - database PR!