aboutsummaryrefslogtreecommitdiff
path: root/guix-data-service/model
Commit message (Collapse)AuthorAge
* Get the translated package synopsis and descriptions into the databaseDanjela Lura2020-06-19
| | | | Signed-off-by: Christopher Baines <mail@cbaines.net>
* Guard against some changes in how guile-json represents null valuesChristopher Baines2020-06-19
|
* Fix lint checker testsDanjela Lura2020-06-07
| | | | Signed-off-by: Christopher Baines <mail@cbaines.net>
* Fall back to en_US.utf8 in the package pageDanjela Lura2020-06-07
| | | | Signed-off-by: Christopher Baines <mail@cbaines.net>
* Fall back to en_US.utf8 for the lint warnings page for a revisionDanjela Lura2020-06-07
| | | | Signed-off-by: Christopher Baines <mail@cbaines.net>
* Make the query that provides locale options look nicerDanjela Lura2020-06-07
| | | | Signed-off-by: Christopher Baines <mail@cbaines.net>
* Use lint checker related translations on some pagesDanjela Lura2020-06-07
| | | | Signed-off-by: Christopher Baines <mail@cbaines.net>
* Add checks to guard against null dataDanjela Lura2020-06-07
| | | | Signed-off-by: Christopher Baines <mail@cbaines.net>
* Get the translated lint checker descriptions into the databaseDanjela Lura2020-06-07
| | | | Signed-off-by: Christopher Baines <mail@cbaines.net>
* Fix select-build-servers with respect to the lookup-builds fieldChristopher Baines2020-06-06
|
* Make nar_urls file sizes optionalChristopher Baines2020-06-03
|
* Add a lookup_builds field to the build_servers tableChristopher Baines2020-05-24
| | | | | This is to allow for build servers where only the substitutes should be queried, and it shouldn't be assumed that they're running Cuirass.
* Tweak select-output-consistency-for-revisionChristopher Baines2020-05-03
| | | | | I don't think this actually changes the result, but I think the query is a bit better formed.
* Add a new package substitute availability pageChristopher Baines2020-05-03
|
* Add a couple of options to select-derivation-outputs-in-revisionChristopher Baines2020-05-03
| | | | To filter outputs by whether particular substitute servers have a substitute.
* Fix a window clause in package-outputs-for-branchChristopher Baines2020-05-03
| | | | This was leading to the first and last revision datetimes to be wrong.
* Support controlling the fields returned for package derivationsChristopher Baines2020-04-24
| | | | | Mostly so that the builds can be avoided when querying for all the derivations, as that's slow.
* Make it clearer that some things relate to package derivationsChristopher Baines2020-04-24
| | | | Rather than derivations in general.
* Add i586-gnu as a valid systemChristopher Baines2020-04-20
| | | | | This is present currently on core-updates. Ideally the valid-systems would adapt to the revision, but for the moment just add it everywhere.
* Handle when there's no system-test-data to insertChristopher Baines2020-04-20
| | | | Previously it would error in one of the INSERT queries.
* Add option to change language of lint messages for the revision pageDanjela lura2020-04-04
| | | | Signed-off-by: Christopher Baines <mail@cbaines.net>
* Fix the new package-versions-for-branch queryChristopher Baines2020-03-31
| | | | | | | This recent change simply didn't work, the ordering was bad and the window function wasn't properly defined. It now should hopefully work, although there's an interesting case where different versions are available for different systems/targets, which isn't handled particularly well.
* Improve the insert-guix-revision-package-derivation-entries queryChristopher Baines2020-03-31
| | | | | Somewhat untested improvements, but these make the query a bit more rigorous in the case of multiple branches and git repositories.
* Handle NULL better insert-missing-data-and-return-all-ids queriesChristopher Baines2020-03-29
| | | | | | | | Actually check if fields can be NULL, and if they can be then include some extra conditions for the comparison. This will at least make the queries smaller, I'm not sure if it will have an effect on performance.
* Add a function to fetch information about a tableChristopher Baines2020-03-29
| | | | Mostly so whether a field can contain NULL values can be determined.
* Remove redundant DISTINCT from the derivation range INSERT queryChristopher Baines2020-03-24
| | | | This was redundant and slow, so don't do it.
* Implement version history using the derivations tableChristopher Baines2020-03-24
| | | | | | | | | Rather than having two big tables looking at the history, just use the derivations table as it has all the information. This will allow deleting the package_versions_by_guix_revision_range table which should help save time when importing revisions, and reduce the size of the database.
* Fix the date ordering on the package output history pageChristopher Baines2020-03-24
|
* Sort the lint-warning-message-ids when queryingChristopher Baines2020-03-23
| | | | | This might solve errors where the Guix Data Service is trying to insert a lint_warning_message_set that already exists.
* Change the sort order for derivations on the package version pageChristopher Baines2020-03-21
| | | | Put the non-cross built derivations first.
* Add a new function to get the outputs for a package on a branchChristopher Baines2020-03-21
| | | | | Similar to the one above for derivations, this just looks at outputs. This filters out equivalent derivations, which can be useful.
* Generate and store system test derivations for all supported systemsChristopher Baines2020-03-20
| | | | | | | Rather than just the native system. I'm not quite sure of the value here, as I guess system tests should behave the same regardless of the way the software is compiled, but this seems like it could be useful, and being explicit about the system the derivation is for is good.
* Increase the batch size for fetching builds/narinfo filesChristopher Baines2020-03-14
| | | | | To increase the likelyhood that all the builds and narinfo files for the latest revisions are fetched.
* Set an order for select-outputs-without-known-nar-entriesChristopher Baines2020-03-14
| | | | Pulling out the recent entries first.
* Order build statuses by id, not timestampChristopher Baines2020-03-01
| | | | | Some builds from Cuirass change status at the same timestamp, so use the id for ordering instead.
* Clean up some time logging codeChristopher Baines2020-02-24
|
* Adapt some license related code to work without mock in the testsChristopher Baines2020-02-24
| | | | | With Guile 3, there's a potential for mock to work in even fewer circumstances. So, adapt the code to enable writing the tests without mock.
* Enhance ensure-build-existsChristopher Baines2020-02-15
| | | | | Support calling it with derivation-output-details-set-id, which can be used when querying for builds.
* Properly sort the derivation outputsChristopher Baines2020-02-15
|
* Avoid an error when there are no references to insertChristopher Baines2020-02-15
|
* Improve system and target query parameter handlingChristopher Baines2020-02-13
|
* Add a function to select channel instances for a revisionChristopher Baines2020-02-12
|
* Remove the restriction on cross build derivation queryingChristopher Baines2020-02-11
| | | | As some build servers do build cross derivations.
* Update the cross build filter for the package reproducibility pageChristopher Baines2020-02-11
|
* Start storing channel instance derivationsChristopher Baines2020-02-11
| | | | These are the ones that relate to Guix pull.
* Support excluding and including branches from a repositoryChristopher Baines2020-02-08
| | | | | So that you can have the Guix Data Service only pay attention to some of the branches.
* Tweak the sort order for derivation countsChristopher Baines2020-02-08
| | | | So that the non-cross derivations appear first.
* Rework cross derivations supportChristopher Baines2020-02-08
| | | | | | | | | | | | | | Stop using the system values as targets, and remove package derivation entries where this is the case. Switch the non-cross derivation case to have a target of "", rather than matching the system, as this makes more sense, and is more consistent now that the target values no longer match the system values. Hardcode some more correct target values, and use these instead. Hopefully this can be better integrated with Guix in the future. This commit also includes a migration attempting to shrink some indexes.
* Use a temporary table when inserting package metadata entriesChristopher Baines2020-02-04
| | | | To speed up this step, as there is a lot of data.
* Support using a temp table in insert-missing-data-and-return-all-idsChristopher Baines2020-02-04
| | | | This is more performant when there is a lot of data.