[Toaster] question on spec for "Package included in ..."

[Lerner, Dave]

Hi Belen, Alex



I have a question about the intent of the specification on page 5 of 10 of spec design-1.5.1-package-details.pdf listing the images that a package is included in.



Packages included in target image

If the package is installed in a build target image, the '1.5.1

Package details' left content column shows only a list of

the target images that include the package.

Each target image is a link to the corresponding '1.1.1

Included package details' page.

If there is more than one target image in the build, they

are separated by commas, and listed in ascending

alphabetical order.





[cid:image002.jpg at 01CF0FA4.EFC45B70]



The list that should appear is clearly for the package name-version-revision, but should it be a list restricted (as implied by the breadcrumbs) to a single machine/bsp, for example atom-pc vs qemuarm?

Do I understand the view spec correctly?



For that case, the current form of the database requires a complicated query. I think the logic would have to be (for a passed in build-id-arg, package-id-arg)

*         Get the machine, buildMachine, for this build-id-arg

*         Get a list of package.id's for this list of build.id's with this buildMachine

*         Get a list of target-installed-package.target_ids's that are in the include the package.id's above

*         Return a list of distinct target.target using the target-insalled-package.target_ids list above and also have target.is_image true (1)



or using $var embedded sql syntax (for C), after buildMachine, packageName, packageVersion, packageRevision are retrieved...



select distinct(orm_target.target) from orm_target, orm_target_installed_package

where

orm_target.is_image = 1

and orm_target.id = orm_target_installed_package.target_id

and orm_target_installed_package.package_id in

(select orm_package.id from orm_build, orm_package

where

orm_build.machine = $buildMachine

and orm_package.name = $packageName

and orm_package.version = $packageVersion

and orm_package.revision = $packageRevision

and orm_build.id = orm_package.build_id);



Thanks,

Dave Lerner


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.yoctoproject.org/pipermail/toaster/attachments/20140112/cfa83a2b/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.jpg
Type: image/jpeg
Size: 10356 bytes
Desc: image002.jpg
URL: <http://lists.yoctoproject.org/pipermail/toaster/attachments/20140112/cfa83a2b/attachment-0001.jpg>