Child table of UpdateSpecTable.
Child table of UpdateSpecTable. For each row in that table there's one or more rows in this table.
Each row corresponds to an UpdateSpec instance except that dependencies
are kept in RequiredPackageTable
Abort a pending update specified by uuid and vin.
Abort a pending update specified by uuid and vin. Updates with statuses other than 'Pending' will not be aborted
Delete all the required packages that are needed for a VIN.
Delete all the required packages that are needed for a VIN. This is part of the process for deleting a VIN from the system
The vehicle to get the VIN to delete from
Delete all the updates for a specific VIN This is part of the process for deleting a VIN from the system
Delete all the updates for a specific VIN This is part of the process for deleting a VIN from the system
The vehicle to get the VIN to delete from
Lookup by PK in UpdateSpecTable table.
Lookup by PK in UpdateSpecTable table.
Note: A tuple is returned instead of an UpdateSpec instance because
the later would require joining RequiredPackageTable to populate the dependencies
of that instance.
Return a list of all the VINs that a specific version of a package will be installed on.
Return a list of all the VINs that a specific version of a package will be installed on. Note that VINs where the package has started installation, or has either been installed or where the install failed are not included.
The package name to search for
The version of the package to search for
A list of VINs that the package will be installed on
The UpdateSpec-s (excluding dependencies but including status) for the given UpdateRequest.
The UpdateSpec-s (excluding dependencies but including status) for the given UpdateRequest. Each element in the result corresponds to a different VIN.
Install a list of specific packages on a VIN
Install a list of specific packages on a VIN
The VIN to install on
Update Id of the update to install
Add an update for a specific VIN.
Add an update for a specific VIN. This update will consist of one-or-more packages that need to be installed on a single VIN
The list of packages that should be installed
Set status of a given update to 'In-Flight'
Set status of a given update to 'In-Flight'
the vin associated with the desired update
the uuid of the update whose status should be changed
Rewrite in the DB the status of an UpdateSpec, ie for a (campaign, VIN) combination.
Rewrite in the DB the status of an UpdateSpec, ie for a (campaign, VIN) combination.
The combination of VIN and update request to record the status of
The latest status of the installation. One of Pending InFlight, Canceled, Failed or Finished.
Database mapping definitions for the UpdateSpecs and RequiredPackages tables.