Export assigned issues in iCalendar feed (!5846) · Merge requests · GitLab.org / GitLab

The source project of this merge request has been removed.

Imre Farkas requested to merge (removed):ee-44184-issues_ical_feed into master May 25, 2018

Add a description of your merge request here. Merge requests without an adequate description will not be reviewed until one is added.

Database Checklist

When adding migrations:

Updated db/schema.rb
Added a down method so the migration can be reverted
Added the output of the migration(s) to the MR body

Migration Output

== 20180330113252 RenameUsersRssTokenToFeedToken: migrating ===================
-- transaction_open?()
   -> 0.0000s
-- columns(:users)
   -> 0.0025s
-- add_column(:users, :feed_token, :string, {:limit=>nil, :precision=>nil, :scale=>nil})
   -> 0.1296s
-- quote_table_name(:users)
   -> 0.0001s
-- quote_column_name(:rss_token)
   -> 0.0000s
-- quote_column_name(:feed_token)
   -> 0.0000s
-- execute("CREATE OR REPLACE FUNCTION trigger_7dc952250ffd()\nRETURNS trigger AS\n$BODY$\nBEGIN\n  NEW.\"feed_token\" := NEW.\"rss_token\";\n  RETURN NEW;\nEND;\n$BODY$\nLANGUAGE 'plpgsql'\nVOLATILE\n")
   -> 0.1078s
-- execute("CREATE TRIGGER trigger_7dc952250ffd\nBEFORE INSERT OR UPDATE\nON \"users\"\nFOR EACH ROW\nEXECUTE PROCEDURE trigger_7dc952250ffd()\n")
   -> 0.0499s
-- transaction_open?()
   -> 0.0000s
-- exec_query("SELECT COUNT(*) AS count FROM \"users\"")
   -> 0.0634s
-- exec_query("SELECT  \"users\".\"id\" FROM \"users\"  ORDER BY \"users\".\"id\" ASC LIMIT 1")
   -> 0.0011s
-- exec_query("SELECT  \"users\".\"id\" FROM \"users\" WHERE \"users\".\"id\" >= 1  ORDER BY \"users\".\"id\" ASC LIMIT 1 OFFSET 3")
   -> 0.0011s
-- execute("UPDATE \"users\" SET \"feed_token\" = \"users\".\"rss_token\" WHERE \"users\".\"id\" >= 1 AND \"users\".\"id\" < 4")
   -> 0.0307s
-- exec_query("SELECT  \"users\".\"id\" FROM \"users\" WHERE \"users\".\"id\" >= 4  ORDER BY \"users\".\"id\" ASC LIMIT 1 OFFSET 3")
   -> 0.0012s
-- execute("UPDATE \"users\" SET \"feed_token\" = \"users\".\"rss_token\" WHERE \"users\".\"id\" >= 4 AND \"users\".\"id\" < 7")
   -> 0.0058s
-- exec_query("SELECT  \"users\".\"id\" FROM \"users\" WHERE \"users\".\"id\" >= 7  ORDER BY \"users\".\"id\" ASC LIMIT 1 OFFSET 3")
   -> 0.0008s
-- execute("UPDATE \"users\" SET \"feed_token\" = \"users\".\"rss_token\" WHERE \"users\".\"id\" >= 7 AND \"users\".\"id\" < 10")
   -> 0.0066s
-- exec_query("SELECT  \"users\".\"id\" FROM \"users\" WHERE \"users\".\"id\" >= 10  ORDER BY \"users\".\"id\" ASC LIMIT 1 OFFSET 3")
   -> 0.0008s
-- execute("UPDATE \"users\" SET \"feed_token\" = \"users\".\"rss_token\" WHERE \"users\".\"id\" >= 10 AND \"users\".\"id\" < 13")
   -> 0.0067s
-- exec_query("SELECT  \"users\".\"id\" FROM \"users\" WHERE \"users\".\"id\" >= 13  ORDER BY \"users\".\"id\" ASC LIMIT 1 OFFSET 3")
   -> 0.0010s
-- execute("UPDATE \"users\" SET \"feed_token\" = \"users\".\"rss_token\" WHERE \"users\".\"id\" >= 13 AND \"users\".\"id\" < 16")
   -> 0.0061s
-- exec_query("SELECT  \"users\".\"id\" FROM \"users\" WHERE \"users\".\"id\" >= 16  ORDER BY \"users\".\"id\" ASC LIMIT 1 OFFSET 3")
   -> 0.0010s
-- execute("UPDATE \"users\" SET \"feed_token\" = \"users\".\"rss_token\" WHERE \"users\".\"id\" >= 16 AND \"users\".\"id\" < 19")
   -> 0.0066s
-- exec_query("SELECT  \"users\".\"id\" FROM \"users\" WHERE \"users\".\"id\" >= 19  ORDER BY \"users\".\"id\" ASC LIMIT 1 OFFSET 3")
   -> 0.0010s
-- execute("UPDATE \"users\" SET \"feed_token\" = \"users\".\"rss_token\" WHERE \"users\".\"id\" >= 19 AND \"users\".\"id\" < 22")
   -> 0.0068s
-- exec_query("SELECT  \"users\".\"id\" FROM \"users\" WHERE \"users\".\"id\" >= 22  ORDER BY \"users\".\"id\" ASC LIMIT 1 OFFSET 3")
   -> 0.0010s
-- execute("UPDATE \"users\" SET \"feed_token\" = \"users\".\"rss_token\" WHERE \"users\".\"id\" >= 22 AND \"users\".\"id\" < 25")
   -> 0.0063s
-- exec_query("SELECT  \"users\".\"id\" FROM \"users\" WHERE \"users\".\"id\" >= 25  ORDER BY \"users\".\"id\" ASC LIMIT 1 OFFSET 3")
   -> 0.0009s
-- execute("UPDATE \"users\" SET \"feed_token\" = \"users\".\"rss_token\" WHERE \"users\".\"id\" >= 25 AND \"users\".\"id\" < 28")
   -> 0.0066s
-- exec_query("SELECT  \"users\".\"id\" FROM \"users\" WHERE \"users\".\"id\" >= 28  ORDER BY \"users\".\"id\" ASC LIMIT 1 OFFSET 3")
   -> 0.0012s
-- execute("UPDATE \"users\" SET \"feed_token\" = \"users\".\"rss_token\" WHERE \"users\".\"id\" >= 28 AND \"users\".\"id\" < 31")
   -> 0.0061s
-- exec_query("SELECT  \"users\".\"id\" FROM \"users\" WHERE \"users\".\"id\" >= 31  ORDER BY \"users\".\"id\" ASC LIMIT 1 OFFSET 3")
   -> 0.0008s
-- execute("UPDATE \"users\" SET \"feed_token\" = \"users\".\"rss_token\" WHERE \"users\".\"id\" >= 31 AND \"users\".\"id\" < 34")
   -> 0.0067s
-- exec_query("SELECT  \"users\".\"id\" FROM \"users\" WHERE \"users\".\"id\" >= 34  ORDER BY \"users\".\"id\" ASC LIMIT 1 OFFSET 3")
   -> 0.0008s
-- execute("UPDATE \"users\" SET \"feed_token\" = \"users\".\"rss_token\" WHERE \"users\".\"id\" >= 34 AND \"users\".\"id\" < 37")
   -> 0.0066s
-- exec_query("SELECT  \"users\".\"id\" FROM \"users\" WHERE \"users\".\"id\" >= 37  ORDER BY \"users\".\"id\" ASC LIMIT 1 OFFSET 3")
   -> 0.0008s
-- execute("UPDATE \"users\" SET \"feed_token\" = \"users\".\"rss_token\" WHERE \"users\".\"id\" >= 37 AND \"users\".\"id\" < 40")
   -> 0.0068s
-- exec_query("SELECT  \"users\".\"id\" FROM \"users\" WHERE \"users\".\"id\" >= 40  ORDER BY \"users\".\"id\" ASC LIMIT 1 OFFSET 3")
   -> 0.0010s
-- execute("UPDATE \"users\" SET \"feed_token\" = \"users\".\"rss_token\" WHERE \"users\".\"id\" >= 40 AND \"users\".\"id\" < 43")
   -> 0.0062s
-- exec_query("SELECT  \"users\".\"id\" FROM \"users\" WHERE \"users\".\"id\" >= 43  ORDER BY \"users\".\"id\" ASC LIMIT 1 OFFSET 3")
   -> 0.0009s
-- execute("UPDATE \"users\" SET \"feed_token\" = \"users\".\"rss_token\" WHERE \"users\".\"id\" >= 43 AND \"users\".\"id\" < 46")
   -> 0.0067s
-- exec_query("SELECT  \"users\".\"id\" FROM \"users\" WHERE \"users\".\"id\" >= 46  ORDER BY \"users\".\"id\" ASC LIMIT 1 OFFSET 3")
   -> 0.0009s
-- execute("UPDATE \"users\" SET \"feed_token\" = \"users\".\"rss_token\" WHERE \"users\".\"id\" >= 46 AND \"users\".\"id\" < 49")
   -> 0.0065s
-- exec_query("SELECT  \"users\".\"id\" FROM \"users\" WHERE \"users\".\"id\" >= 49  ORDER BY \"users\".\"id\" ASC LIMIT 1 OFFSET 3")
   -> 0.0008s
-- execute("UPDATE \"users\" SET \"feed_token\" = \"users\".\"rss_token\" WHERE \"users\".\"id\" >= 49")
   -> 0.0068s
-- indexes(:users)
   -> 0.0101s
-- transaction_open?()
   -> 0.0000s
-- execute("SET statement_timeout TO 0")
   -> 0.0004s
-- index_exists?(:users, ["feed_token"], {:unique=>false, :name=>"index_users_on_feed_token", :length=>[], :order=>{}, :using=>:btree, :algorithm=>:concurrently})
   -> 0.0094s
-- add_index(:users, ["feed_token"], {:unique=>false, :name=>"index_users_on_feed_token", :length=>[], :order=>{}, :using=>:btree, :algorithm=>:concurrently})
   -> 0.0471s
-- foreign_keys(:users)
   -> 0.0046s
== 20180330113252 RenameUsersRssTokenToFeedToken: migrated (0.6023s) ==========

== 20180408143355 CleanupUsersRssTokenRename: migrating =======================
-- execute("DROP TRIGGER IF EXISTS trigger_7dc952250ffd ON users")
   -> 0.0234s
-- execute("DROP FUNCTION IF EXISTS trigger_7dc952250ffd()")
   -> 0.0082s
-- remove_column(:users, :rss_token)
   -> 0.0088s
== 20180408143355 CleanupUsersRssTokenRename: migrated (0.0417s) ==============

General Checklist

Changelog entry added, if necessary
Documentation created/updated
Tests added for this feature/bug
Review
- Has been reviewed by Backend
- Has been reviewed by Database
Conform by the merge request performance guides
Conform by the style guides
Squashed related commits together

Closes https://gitlab.com/gitlab-org/gitlab-ce/issues/44184

Edited May 19, 2022 by Coung Ngo

Admin message

Export assigned issues in iCalendar feed

Database Checklist

Migration Output

General Checklist

Merge request reports