py/minijack/models.py

# Copyright (c) 2013 The Chromium OS Authors. All rights reserved.
# Use of this source code is governed by a BSD-style license that can be
# found in the LICENSE file.

import minijack_common  # pylint: disable=W0611
from db import models


class Event(models.Model):
  event_id = models.TextField(primary_key=True, db_index=True)
  device_id = models.TextField(db_index=True)
  time = models.TextField()
  event = models.TextField(db_index=True)
  seq = models.IntegerField()
  log_id = models.TextField()
  prefix = models.TextField()
  boot_id = models.TextField()
  boot_sequence = models.IntegerField()
  factory_md5sum = models.TextField()
  reimage_id = models.TextField()


class Attr(models.Model):
  # No primary_key for the Attr table for speed-up. Duplication check is
  # done using the Event table.
  event_id = models.TextField(db_index=True)
  attr = models.TextField()
  value = models.TextField()
  nested_parent = Event
  nested_name = 'attrs'


class Test(models.Model):
  invocation = models.TextField(primary_key=True)
  event_id = models.TextField()
  event_seq = models.IntegerField()
  device_id = models.TextField(db_index=True)
  factory_md5sum = models.TextField()
  reimage_id = models.TextField()
  path = models.TextField(db_index=True)
  pytest_name = models.TextField()
  status = models.TextField()
  start_time = models.TextField()
  end_time = models.TextField()
  duration = models.FloatField()
  error_msg = models.TextField()


class Device(models.Model):
  device_id = models.TextField(primary_key=True, db_index=True)
  goofy_init_time = models.TextField()
  serial = models.TextField()
  mlb_serial = models.TextField()
  hwid = models.TextField()
  ips = models.TextField()
  ips_time = models.TextField()
  latest_test = models.TextField()
  latest_test_time = models.TextField()
  latest_ended_test = models.TextField()
  latest_ended_status = models.TextField()
  count_passed = models.IntegerField()
  count_failed = models.IntegerField()
  minijack_status = models.TextField()
  latest_note_level = models.TextField()
  latest_note_name = models.TextField()
  latest_note_text = models.TextField()
  latest_note_time = models.TextField()


class Component(models.Model):
  device_id = models.TextField(primary_key=True, db_index=True)
  component_class = models.TextField(primary_key=True, db_index=True)
  component_name = models.TextField()


class ComponentDetail(models.Model):
  device_id = models.TextField(primary_key=True, db_index=True)
  component_class = models.TextField(primary_key=True, db_index=True)
  field_name = models.TextField(primary_key=True, db_index=True)
  field_value = models.TextField()
  nested_parent = Component
  nested_name = 'details'