saef-api / backend /store.py
m4az19's picture
Deploy SAHAB-1 backend and pretrained AI
124816b verified
Raw History Blame Contribute Delete
1.99 kB
"""Small durable JSON document store; all paths are generated server-side."""
import json
import os
import sqlite3
import uuid
from datetime import datetime, timezone
from pathlib import Path
ROOT = Path(__file__).resolve().parents[1]
DATA = Path(os.environ.get('SATFORGE_DATA', ROOT / 'data' / 'runtime'))
DATA.mkdir(parents=True, exist_ok=True)
FILES = DATA / 'files'
FILES.mkdir(exist_ok=True)
def now():
return datetime.now(timezone.utc).isoformat()
def connection():
con = sqlite3.connect(DATA / 'mission.sqlite', timeout=30)
con.execute('CREATE TABLE IF NOT EXISTS records (kind TEXT, id TEXT, body TEXT, PRIMARY KEY(kind,id))')
return con
def put(kind, body, id=None):
id = id or uuid.uuid4().hex
body = {**body, 'id': id}
with connection() as con:
con.execute('INSERT OR REPLACE INTO records VALUES (?,?,?)', (kind, id, json.dumps(body, allow_nan=False)))
return body
def get(kind, id):
with connection() as con:
row = con.execute('SELECT body FROM records WHERE kind=? AND id=?', (kind, id)).fetchone()
if row is None:
raise KeyError(f'{kind} not found')
return json.loads(row[0])
def all_records(kind):
with connection() as con:
rows = con.execute('SELECT body FROM records WHERE kind=? ORDER BY rowid DESC', (kind,)).fetchall()
return [json.loads(row[0]) for row in rows]
def event(message, provenance='SYSTEM', **details):
return put('events', {'time': now(), 'message': message, 'provenance': provenance, **details})
def path_for(id, suffix):
if not id.isalnum() or not suffix.replace('.', '').replace('_','').isalnum():
raise ValueError('Invalid asset identifier')
return FILES / f'{id}.{suffix}'
def asset(kind, name, source, **extra):
return put('assets', {'kind':kind, 'name':name, 'source':source, 'retrieved_at':now(),
'acquisition_time':None, 'publication_time':None, 'license':'User must verify',
'processing':[], 'warnings':[], **extra})