TULIP

Trusted Unified Legal Intake Portal

TULIP (Trusted Unified Legal Intake Portal) is a web application created in partnership between OSS and the SLU School of Law Clinic Program. It is a digital intake portal for all clinics within the program to replace the current paper-based intake system. Case-assignment workflows are standardized through this tool for more efficient document management.

Installation

1. Install node.js

2. Install Postgres (or have access to a connection string) and start local server

3. Clone the repository

git clone https://github.com/oss-slu/tulip.git

4. Set up environment variables

DATABASE_URL="postgresql://USER:PASSWORD@localhost:5432/YOUR_DATABASE_NAME" (start a local postgres server and put that here)

5. Install dependencies

cd tulip
npm install

cd app
npm install

cd api
npm install

6. Start the development server

cd api
npm run dev

7. Start the react app

cd app
npm run dev

8. Open your browser to http://localhost:5173 to view the app

9. Migrate prisma database with local postgres server.

Change directory

cd api

Install Prisma Client

npm install prisma --save-dev
npm install @prisma/client @prisma/adapter-pg pg

Generate Prisma Client

npx prisma generate

Apply migrations

npx prisma migrate dev

Run seed file

npm run db:seed

10. If you need to access the database (not necessary for initial setup), open Prisma Studio

Run the following in your terminal (Command Prompt for Windows) to open the database

npx prisma studio