import { column, Table } from '@/remote/database/schema';

export const foodLogsTable = new Table(
  {
    profile_id: column.text,
    day_id: column.text,
    food_item_name: column.text,
    ingredients: column.text,
    processed_food_nova_class: column.integer,
    nutrition: column.text,
    photo_path: column.text,
    bounding_box: column.text,
    eaten_time: column.text,
    creation_time: column.text,
    last_edit_time: column.text,
    processing_status: column.text,
    deleted_at: column.text,
  },
  {
    indexes: {
      day_id: ['day_id'],
      eaten_time: ['eaten_time'],
    },
  }
);

export const foodLogPhotosTable = new Table(
  {
    photo_uri: column.text,
    pending_upload: column.integer,
  },
  { localOnly: true }
);

export const foodLogPredsTable = new Table(
  {
    food_log_id: column.text,
    profile_id: column.text,
    ai_model: column.text,
    food_item_name: column.text,
    ingredients: column.text,
    processed_food_nova_class: column.integer,
    nutrition: column.text,
    creation_time: column.text,
    last_edit_time: column.text,
    deleted_at: column.text,
  },
  { indexes: { food_log_id: ['food_log_id'], profile_id: ['profile_id'] } }
);

export const daysTable = new Table(
  {
    profile_id: column.text,
    date: column.text,
    nutrition_target: column.text,
    nutrition_consumed: column.text,
    nutrition_score: column.real,
    recommended_ingredients: column.text,
    recommended_foods: column.text,
    creation_time: column.text,
    last_edit_time: column.text,
    deleted_at: column.text,
  },
  { indexes: { date: ['date'], profile_id: ['profile_id'] } }
);

export const memoLogsTable = new Table(
  {
    profile_id: column.text,
    day_id: column.text,
    logger_id: column.text,
    title: column.text,
    type: column.text,
    value: column.text,
    value_unit: column.text,
    icon: column.text,
    logged_time: column.text,
    creation_time: column.text,
    last_edit_time: column.text,
    deleted_at: column.text,
  },
  {
    indexes: {
      profile_id: ['profile_id'],
      day_id: ['day_id'],
      logger_id: ['logger_id'],
      logged_time: ['logged_time'],
    },
  }
);

export const memoLoggersTable = new Table(
  {
    profile_id: column.text,
    name: column.text,
    icon: column.text,
    color: column.text,
    type: column.text,
    unit: column.text,
    options: column.text,
    sort_order: column.integer,
    creation_time: column.text,
    last_edit_time: column.text,
    deleted_at: column.text,
  },
  { indexes: { profile_id: ['profile_id'], sort_order: ['sort_order'] } }
);