AOSSIE-Org / AOSSIE-Org/NeuroTrack

BUG: SQL Syntax Error

Aperta
#144 1 commento 0 reazioni 0 assegnatari Vedi su GitHub
Lingua principale
Dart
Stelle
29
Fork
50
Metriche di merge delle PR
Nessuna PR unita negli ultimi 30g

Descrizione

### Is there an existing issue for this?

- [x] I have searched the existing issues

### What happened?

## 📌 Issue Overview
SQL schema has syntax errors preventing database setup

## 🔍 Steps to Reproduce
1. Go to Supabase Dashboard
2. Navigate to SQL Editor
3. Copy `supabase/schemas/schema.sql` file contents
4. Paste into Supabase SQL Editor
5. Click "Run"
6. See SQL syntax error

## 🎯 Expected Behavior
- All database tables should be created successfully
- No SQL errors should appear
- All 14 tables should be visible in Table Editor

## 🚨 Actual Behavior
- SQL syntax error appears
- Database tables are not created
- Error message: "syntax error at or near ')'"

## 📋 Error Details
The schema file contains 4 syntax errors (missing/extra commas):

1. **therapist table** (line ~23): Extra trailing comma before closing bracket
2. **daily_activity_logs table** (line ~142): Missing comma between `activity_items` and `patient_id` columns
3. **observation_master table** (line ~112): Extra trailing comma before closing bracket
4. **activity_master table** (line ~127): Extra trailing comma before closing bracket

## 📷 Error Message
Error: Failed to run sql query: ERROR: 42601: syntax error at or near ")" LINE 37: ); ^
## 📷 Screenshot

Image

## 💡 Suggested Improvements

## 💡 Suggested Fix
Fix comma placement in the following tables:

**therapist table:**
- Remove comma after `license_number TEXT,` → `license_number TEXT`

**daily_activity_logs table:**
- Add comma after `activity_items JSONB NOT NULL,` (currently missing)

**observation_master table:**
- Remove comma after `applicable_therapies UUID[] NOT NULL,` → `applicable_therapies UUID[] NOT NULL`

**activity_master table:**
- Remove comma after `applicable_therapies UUID[] NOT NULL,` → `applicable_therapies UUID[] NOT NULL`

### Record

- [x] I agree to follow this project's Code of Conduct
- [x] I want to work on this issue

Guida per i contributori

Nessuna guida per i contributori indicizzata per questo repository

Valutazione

Questa issue non è ancora stata valutata.

Ricevi le nuove issue nella tua casella

Un breve riepilogo di issue GitHub adatte ai principianti.