Welcome to mirror list, hosted at ThFree Co, Russian Federation.

gitlab.com/gitlab-org/gitlab-foss.git - Unnamed repository; edit this file 'description' to name the repository.
summaryrefslogtreecommitdiff
path: root/db
AgeCommit message (Collapse)Author
2016-09-20Implement a second round of review comments from @DouweM.Timothy Andrew
- Don't use `TableReferences` - using `.arel_table` is shorter! - Move some database-related code to `Gitlab::Database` - Remove the `MergeRequest#issues_closed` and `Issue#closed_by_merge_requests` associations. They were either shadowing or were too similar to existing methods. They are not being used anywhere, so it's better to remove them to reduce confusion. - Use Rails 3-style validations - Index for `MergeRequest::Metrics#first_deployed_to_production_at` - Only include `CycleAnalyticsHelpers::TestGeneration` for specs that need it. - Other minor refactorings.
2016-09-20Update schema.rbTimothy Andrew
2016-09-20Fix `ON DELETE CASCADE` migrations.Timothy Andrew
Incorrect syntax.
2016-09-20Implement review comments from @yorickpeterseTimothy Andrew
1. Change multiple updates to a single `update_all` 2. Use cascading deletes 3. Extract an average function for the database median. 4. Move database median to `lib/gitlab/database` 5. Use `delete_all` instead of `destroy_all` 6. Minor refactoring
2016-09-20Merge remote-tracking branch 'origin/master' into 21170-cycle-analyticsTimothy Andrew
2016-09-20Miscellaneous cycle-analytics-related changes.Timothy Andrew
1. Add indexes to `CreateMergeRequestsClosingIssues` columns. 2. Remove an extraneous `check_if_open` check that is redundant now. It would've been better to rebase this in, but that's not possible because more people are working on this branch.
2016-09-19Merge branch 'master' into per-build-tokenKamil Trzcinski
2016-09-19Cleanup changesKamil Trzcinski
2016-09-19Added missing db/schema changesKamil Trzcinski
2016-09-19Add support for dynamic environmentsKamil Trzcinski
Environments that can have a URL with predefined CI variables.
2016-09-19Remove unused merge request metrics.Timothy Andrew
- These are not being used anymore. - Consolidate all issue metrics into a single migration. - Consolidate all merge request metrics into a single migration.
2016-09-17Add a "populate metrics directly" option to the cycle analytics seed.Timothy Andrew
- The normal seed creates all the data for cycle analytics the "right" way. It creates issues, merge requests, commits, branches, deployments, etc. This is good, but too slow for perf testing. Generating a 1000 sets of records this way takes more than an hour. - When the `CYCLE_ANALYTICS_POPULATE_METRICS_DIRECTLY` environment variable is passed in, the seed only creates issues and merge requests. It then adds the `metrics` for each issue and merge request directly, to save time. - The seed now takes about 4 minutes to run for 1000 sets of records.
2016-09-16Merge branch 'increase_artifact_size_column' into 'master' Yorick Peterse
Increase ci_builds artifacts_size column to 8-byte integer to allow larger files See merge request !6333
2016-09-16Merge branch 'group-specific-lfs-settings' into 'master' Rémy Coutable
Added group-specific setting for LFS. Groups can enable/disable LFS, but this setting can be overridden at the project level. **Admin only** Closes #18092 See merge request !6164
2016-09-16Increase ci_builds artifacts_size column to 8-byte integer to allow larger filesDrew Blessing
2016-09-16Fix undefined method when reverting migration RemoveProjectsPushesSinceGcDouglas Barbosa Alexandre
2016-09-15Merge remote-tracking branch 'origin/lfs-support-for-ssh' into per-build-tokenKamil Trzcinski
# Conflicts: # app/controllers/projects/git_http_client_controller.rb # app/helpers/lfs_helper.rb # lib/gitlab/auth.rb # spec/requests/lfs_http_spec.rb
2016-09-15Improved helper methods, better flow for `project.lfs_enabled?`, and UI fixes.Patricio Cano
2016-09-15Added group-specific setting for LFS.Patricio Cano
Groups can enable/disable LFS, but this setting can be overridden at the project level. Admin only
2016-09-15Refactor LFS token logic to use a Redis key instead of a DB field, making it ↵Patricio Cano
a 1 use only token.
2016-09-15Added LFS support to SSHPatricio Cano
- Required on the GitLab Rails side is mostly authentication and API related.
2016-09-15Merge branch 'fix-old-migration-repos-path-key' into 'master' Robert Speicher
Update references to deprecated `repos_path` configuration key to avoid ## What does this MR do? Update references to deprecated `repos_path` configuration key to avoid errors when updating GitLab from older versions ## Why was this MR needed? Users were reporting errors when upgrading from GitLab 6.7 ## What are the relevant issue numbers? https://gitlab.com/gitlab-org/omnibus-gitlab/issues/1464 See merge request !6350
2016-09-15Merge branch 'group-similar' into 'master' Rémy Coutable
Group similar builds We group builds by removing from the builds name two numbers which are delimited by whitespace or colon: * `name 0 1` => `name` * `name 0:1` => `name` * `name 0/1` => `name` * `name 0:1 ruby` => `name ruby` * `name 0/1 ruby` => `name ruby` * `0 1 name ruby` => `name ruby` * `0:1 name ruby` => `name ruby` * `0/1 name ruby` => `name ruby` See merge request !6242
2016-09-15Merge remote-tracking branch 'origin/master' into per-build-tokenKamil Trzcinski
# Conflicts: # db/schema.rb
2016-09-15Improve performance of the cycle analytics page.Timothy Andrew
1. These changes bring down page load time for 100 issues from more than a minute to about 1.5 seconds. 2. This entire commit is composed of these types of performance enhancements: - Cache relevant data in `IssueMetrics` wherever possible. - Cache relevant data in `MergeRequestMetrics` wherever possible. - Preload metrics 3. Given these improvements, we now only need to make 4 SQL calls: - Load all issues - Load all merge requests - Load all metrics for the issues - Load all metrics for the merge requests 4. A list of all the data points that are now being pre-calculated: a. The first time an issue is mentioned in a commit - In `GitPushService`, find all issues mentioned by the given commit using `ReferenceExtractor`. Set the `first_mentioned_in_commit_at` flag for each of them. - There seems to be a (pre-existing) bug here - files (and therefore commits) created using the Web CI don't have cross-references created, and issues are not closed even when the commit title is "Fixes #xx". b. The first time a merge request is deployed to production When a `Deployment` is created, find all merge requests that were merged in before the deployment, and set the `first_deployed_to_production_at` flag for each of them. c. The start / end time for a merge request pipeline Hook into the `Pipeline` state machine. When the `status` moves to `running`, find the merge requests whose tip commit matches the pipeline, and record the `latest_build_started_at` time for each of them. When the `status` moves to `success`, record the `latest_build_finished_at` time. d. The merge requests that close an issue - This was a big cause of the performance problems we were having with Cycle Analytics. We need to use `ReferenceExtractor` to make this calculation, which is slow when we have to run it on a large number of merge requests. - When a merge request is created, updated, or refreshed, find the issues it closes, and create an instance of `MergeRequestsClosingIssues`, which acts as a join model between merge requests and issues. - If a `MergeRequestsClosingIssues` instance links a merge request and an issue, that issue closes that merge request. 5. The `Queries` module was changed into a class, so we can cache the results of `issues` and `merge_requests_closing_issues` across various cycle analytics stages. 6. The code added in this commit is untested. Tests will be added in the next commit.
2016-09-15Update references to deprecated `repos_path` configuration key to avoidAlejandro Rodríguez
errors on updates from older versions
2016-09-14Fix migration for removing MR diff indexesYorick Peterse
For whatever reason on some PostgreSQL installations there would be a separate UNIQUE constraint on the merge_request_id column. Rails' index_exists?() returns false for this constraint (even when using the full name), yet the indexes() method returns it. This commit changes the migration so that the constraint is dropped as well. MySQL installations don't appear to be affected. Fixes gitlab-org/gitlab-ce#22136
2016-09-14wip: perfTimothy Andrew
2016-09-14Add a `seed_fu` fixture to generate data for cycle analytics.Timothy Andrew
- The fixture generates data for every stage in the cycle analytics dashboard. Once this fixture has run, you shouldn't be seeing any "<not enough data>" messages for cycle analytics. - This is probably not necessary for every fixture run, so it might be moved behind an env var in the future.
2016-09-13Move pushes_since_gc to RedisYorick Peterse
This moves tracking of the pushes since the last Git GC from PostgreSQL to Redis. This reduces the number of writes on the "projects" table. This in turn reduces the vacuuming overhead. The lease used for incrementing the counter has been removed. This lease was mostly put in place to prevent high database load but this isn't needed anymore due to the counter now being stored in Redis. Fixes gitlab-org/gitlab-ce#22125
2016-09-13Update db/schema.rbKamil Trzcinski
2016-09-13Use a permissions of user to access all dependent projects from CI jobs ↵Kamil Trzcinski
(this also includes a container images, and in future LFS files)
2016-09-08Fix DB schema to match latest migrationStan Hu
2016-09-07Group similar buildsKamil Trzcinski
2016-09-07Merge remote-tracking branch 'origin/master' into 21170-cycle-analyticsTimothy Andrew
2016-09-06Support empty PG database tooZ.J. van de Weg
First check if there is a result on the migration, else there is nothing to do
2016-09-05Don't fail on an empty databaseZ.J. van de Weg
2016-09-05Support MySQL too, when removing gitorious from import_sourcesZ.J. van de Weg
2016-09-05Remove gitorious from import_sources on ApplicationSetting modelZ.J. van de Weg
2016-09-05Merge branch 'master' of https://dev.gitlab.org/gitlab/gitlabhqRémy Coutable
Signed-off-by: Rémy Coutable <remy@rymai.me>
2016-09-01Project tools visibility levelFelipe Artur
2016-09-01Add migration to set confidential issues events on web hooksDouglas Barbosa Alexandre
2016-09-01Add option to confidential issues events to trigger servicesDouglas Barbosa Alexandre
2016-09-01Add option to confidential issues events to trigger WebhooksDouglas Barbosa Alexandre
2016-08-31Remove not-null constraint on lock_version column if it existsStan Hu
Closes #21678
2016-08-31Merge branch 'project-specific-lfs' into 'master' Robert Speicher
Added project specific enable/disable setting for LFS ## What does this MR do? Adds project specific enable/disable setting for LFS ## What are the relevant issue numbers? Needed for #18092 See merge request !5997
2016-08-31Renamed `enable_lfs` to `lfs_enabled` for the Project field, and related fixes.Patricio Cano
2016-08-31Added project specific enable/disable setting for LFSPatricio Cano
2016-08-30Remove default value for lock_versionValery Sizov
2016-08-26Drop unused CI tables and filesZ.J. van de Weg
These tables, web hooks and services, are unused but where not dropped with the commits d5c91bb9a601a1a344d94763654f0b0996857497 and 2988e1fbf50b3c9e803a9358933e3e969e64dcc3. The file was left too, but never called.