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-10-19Add GroupLabel modelDouglas Barbosa Alexandre
2016-10-18Merge remote-tracking branch 'origin/master' into 22191-delete-dynamic-envs-mrKamil Trzcinski
2016-10-17Add visibility level to project repositoryFelipe Artur
2016-10-17Add on_stop column [ci skip]Kamil Trzcinski
2016-10-17Update `db/schema.rb`Kamil Trzcinski
2016-10-17Refactor code to use available and stopped statuses and refactor views to ↵Kamil Trzcinski
use separate renders
2016-10-17Merge remote-tracking branch 'origin/master' into 22191-delete-dynamic-envs-mrKamil Trzcinski
2016-10-12Use activerecord_sane_schema_dumperRémy Coutable
Signed-off-by: Rémy Coutable <remy@rymai.me>
2016-10-10Precalculate trending projectsYorick Peterse
This commit introduces a Sidekiq worker that precalculates the list of trending projects on a daily basis. The resulting set is stored in a database table that is then queried by Project.trending. This setup means that Unicorn workers no longer _may_ have to calculate the list of trending projects. Furthermore it supports filtering without any complex caching mechanisms. The data in the "trending_projects" table is inserted in the same order as the project ranking. This means that getting the projects in the correct order is simply a matter of: SELECT projects.* FROM projects INNER JOIN trending_projects ON trending_projects.project_id = projects.id ORDER BY trending_projects.id ASC; Such a query will only take a few milliseconds at most (as measured on GitLab.com), opposed to a few seconds for the query used for calculating the project ranks. The migration in this commit does not require downtime and takes care of populating an initial list of trending projects.
2016-10-07Add markdown cache columns to the database, but don't use them yetNick Thomas
This commit adds a number of _html columns and, with the exception of Note, starts updating them whenever the content of their partner fields changes. Note has a collision with the note_html attr_accessor; that will be fixed later A background worker for clearing these cache columns is also introduced - use `rake cache:clear` to set it off. You can clear the database or Redis caches separately by running `rake cache:clear:db` or `rake cache:clear:redis`, respectively.
2016-10-06Allow to close environmentsKamil Trzcinski
2016-10-06Make environments to be close ableKamil Trzcinski
2016-10-06Initial support for closing environmentsKamil Trzcinski
2016-10-04Fix pipeline fixtures and calls to removed methodGrzegorz Bizon
2016-09-28Allow Member.add_user to handle access requestersRémy Coutable
Changes include: - Ensure Member.add_user is not called directly when not necessary - New GroupMember.add_users_to_group to have the same abstraction level as for Project - Refactor Member.add_user to take a source instead of an array of members - Fix Rubocop offenses - Always use Project#add_user instead of project.team.add_user - Factorize users addition as members in Member.add_users_to_source - Make access_level a keyword argument in GroupMember.add_users_to_group and ProjectMember.add_users_to_projects - Destroy any requester before adding them as a member - Improve the way we handle access requesters in Member.add_user Instead of removing the requester and creating a new member, we now simply accepts their access request. This way, they will receive a "access request granted" email. - Fix error that was previously silently ignored - Stop raising when access level is invalid in Member, let Rails validation do their work Signed-off-by: Rémy Coutable <remy@rymai.me>
2016-09-27Improvements to user organization field feature after code reviewDmitriy Zaporozhets
* Add newline to user organization spec according to test guide * Remove unnecessary comments from user organization database migration Signed-off-by: Dmitriy Zaporozhets <dmitriy.zaporozhets@gmail.com>
2016-09-27Add organization field to user profileDmitriy Zaporozhets
Signed-off-by: Dmitriy Zaporozhets <dmitriy.zaporozhets@gmail.com>
2016-09-23Merge branch 'fix/database-seeds' into 'master' Rémy Coutable
Fix database seeds for development environment ## What does this MR do? This MR fixes database seeds for development environment and adds CI test for it. ## Why was this MR needed? Database seeds for development environment are often broken, and we are not able to catch that when someone modified `db/fixtures` and forgets to reseed database. Closes #22422 See merge request !6475
2016-09-23Add index on labels titleAhmad Sherif
2016-09-23Limit test environment size to one project in CIGrzegorz Bizon
2016-09-21Update db/schema.rb per most recent migrationsYorick Peterse
It seems this wasn't updated properly when migrations were added in a previous commit.
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.