storage

Documentation

Index

• Constants
• Variables
• type Storage
  • func NewStorage(dbfile string) (*Storage, error)
  • func (s *Storage) Close() error
  • func (s *Storage) StorePlate(plate *alpr.ALPRGroup) error
• type TablePlateImages
• type TablePlates
• type TableProperties
• type TableVehicleImages

Constants

const (
	TABLE_PREFIX = "alpr" // alpr_plates alpr_plate_images alpr_car_images alpr_properties

	CREATE_TABLE_TEMPLATE = "CREATE TABLE %s (%s)"
	SELECT_TABLE_QUERY    = "SELECT sql FROM sqlite_master WHERE type='table' AND name=?"
)

Variables

var Tables = map[string]string{
	"plates":         "id text PRIMARY KEY, start timestamp, end timestamp, camera_id int, plate string, confidence float, direction float, is_parked integer",
	"plate_images":   "id text PRIMARY KEY, image blob",
	"vehicle_images": "id text PRIMARY KEY, image blob",
	"properties":     "id text, key text, value text, confidence float",
}

Types

type Storage

type Storage struct {
	// contains filtered or unexported fields
}

func NewStorage

func NewStorage(dbfile string) (*Storage, error)

func (*Storage) Close

func (s *Storage) Close() error

func (*Storage) StorePlate

func (s *Storage) StorePlate(plate *alpr.ALPRGroup) error

type TablePlateImages

type TablePlateImages struct {
	ID    string `db:"id"`
	Image []byte `db:"image"`
}

type TablePlates

type TablePlates struct {
	ID         string    `db:"id"`
	Start      time.Time `db:"start"`
	End        time.Time `db:"end"`
	CameraID   int       `db:"camera_id"`
	Plate      string    `db:"plate"`
	Confidence float64   `db:"confidence"`
	Direction  float64   `db:"direction"`
	IsParked   bool      `db:"is_parked"`
}

type TableProperties

type TableProperties struct {
	ID         string  `db:"id"`
	Key        string  `db:"key"`
	Value      string  `db:"value"`
	Confidence float64 `db:"confidence"`
}

type TableVehicleImages

type TableVehicleImages struct {
	ID    string `db:"id"`
	Image []byte `db:"image"`
}