Zahar
77d5be8fd1
- Backend:
- Add address column to tickets and migration script
- Create guest users when user_id is missing; accept user_name and address
- Normalize stored image paths and expose absolute image_url
- Introduce utils for path normalization and ticket serialization
- Add CORS configuration for dashboard/emulator origins
- Tickets API:
- Serialize via ticket_to_dict with consistent schema
- Change status update to PATCH /api/tickets/{id}/status with JSON body
- Add DELETE /api/tickets/{id} with safe file removal
- Dashboard:
- Fetch tickets from backend, show thumbnails, absolute image URLs
- Status select + PATCH updates, toasts for feedback
- Add i18n key btn.viewDetails
- Mobile app:
- Persist device user_id via SharedPreferences
- Fetch and merge API tickets; prefer network imageUrl
- Submit user_name and address; delete via API when available
- Make location acquisition robust with fallbacks and non-blocking UX
- Android/deps:
- Disable Geolocator NMEA listener to prevent crashes
- Downgrade geolocator to ^11.0.0 for stability
BREAKING CHANGE:
- Status endpoint changed from PATCH /api/tickets/{id}?new_status=... to
PATCH /api/tickets/{id}/status with JSON body: {"status":"in_progress"}.
- /api/tickets and /api/tickets/{id} responses now use "id" (replacing
"ticket_id"), include "image_url", and normalize fields for clients. Update
consumers to use the new schema.
33 lines
958 B
Python
33 lines
958 B
Python
import sqlite3
|
|
import os
|
|
import sys
|
|
|
|
def main():
|
|
script_dir = os.path.dirname(os.path.abspath(__file__))
|
|
db_path = os.path.normpath(os.path.join(script_dir, '..', 'app', 'db', 'fixmate.db'))
|
|
print(f"Using database: {db_path}")
|
|
if not os.path.exists(db_path):
|
|
print(f"DB not found: {db_path}")
|
|
return 2
|
|
|
|
conn = sqlite3.connect(db_path)
|
|
try:
|
|
cur = conn.cursor()
|
|
cur.execute("PRAGMA table_info(tickets);")
|
|
cols = [row[1] for row in cur.fetchall()]
|
|
if 'address' in cols:
|
|
print("Column 'address' already exists")
|
|
return 0
|
|
|
|
cur.execute("ALTER TABLE tickets ADD COLUMN address TEXT;")
|
|
conn.commit()
|
|
print("Added 'address' column to 'tickets' table")
|
|
return 0
|
|
except Exception as e:
|
|
print("Failed to add 'address' column:", e)
|
|
return 1
|
|
finally:
|
|
conn.close()
|
|
|
|
if __name__ == '__main__':
|
|
sys.exit(main()) |