summaryrefslogtreecommitdiff
path: root/spec/services/issues/import_csv_service_spec.rb
blob: 92b88489af9d4d1208c730f4f0603964a9233df4 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
# frozen_string_literal: true

require 'spec_helper'

describe Issues::ImportCsvService do
  let(:project) { create(:project) }
  let(:user) { create(:user) }

  subject do
    uploader = FileUploader.new(project)
    uploader.store!(file)

    described_class.new(user, project, uploader).execute
  end

  describe '#execute' do
    context 'invalid file' do
      let(:file) { fixture_file_upload('spec/fixtures/banana_sample.gif') }

      it 'returns invalid file error' do
        expect(Notify).to receive_message_chain(:import_issues_csv_email, :deliver_later)

        expect(subject[:success]).to eq(0)
        expect(subject[:parse_error]).to eq(true)
      end
    end

    context 'with a file generated by Gitlab CSV export' do
      let(:file) { fixture_file_upload('spec/fixtures/csv_gitlab_export.csv') }

      it 'imports the CSV without errors' do
        expect(Notify).to receive_message_chain(:import_issues_csv_email, :deliver_later)

        expect(subject[:success]).to eq(4)
        expect(subject[:error_lines]).to eq([])
        expect(subject[:parse_error]).to eq(false)
      end

      it 'correctly sets the issue attributes' do
        expect { subject }.to change { project.issues.count }.by 4

        expect(project.issues.reload.last).to have_attributes(
          title: 'Test Title',
          description: 'Test Description'
        )
      end
    end

    context 'comma delimited file' do
      let(:file) { fixture_file_upload('spec/fixtures/csv_comma.csv') }

      it 'imports CSV without errors' do
        expect(Notify).to receive_message_chain(:import_issues_csv_email, :deliver_later)

        expect(subject[:success]).to eq(3)
        expect(subject[:error_lines]).to eq([])
        expect(subject[:parse_error]).to eq(false)
      end

      it 'correctly sets the issue attributes' do
        expect { subject }.to change { project.issues.count }.by 3

        expect(project.issues.reload.last).to have_attributes(
          title: 'Title with quote"',
          description: 'Description'
        )
      end
    end

    context 'tab delimited file with error row' do
      let(:file) { fixture_file_upload('spec/fixtures/csv_tab.csv') }

      it 'imports CSV with some error rows' do
        expect(Notify).to receive_message_chain(:import_issues_csv_email, :deliver_later)

        expect(subject[:success]).to eq(2)
        expect(subject[:error_lines]).to eq([3])
        expect(subject[:parse_error]).to eq(false)
      end

      it 'correctly sets the issue attributes' do
        expect { subject }.to change { project.issues.count }.by 2

        expect(project.issues.reload.last).to have_attributes(
          title: 'Hello',
          description: 'World'
        )
      end
    end

    context 'semicolon delimited file with CRLF' do
      let(:file) { fixture_file_upload('spec/fixtures/csv_semicolon.csv') }

      it 'imports CSV with a blank row' do
        expect(Notify).to receive_message_chain(:import_issues_csv_email, :deliver_later)

        expect(subject[:success]).to eq(3)
        expect(subject[:error_lines]).to eq([4])
        expect(subject[:parse_error]).to eq(false)
      end

      it 'correctly sets the issue attributes' do
        expect { subject }.to change { project.issues.count }.by 3

        expect(project.issues.reload.last).to have_attributes(
          title: 'Hello',
          description: 'World'
        )
      end
    end
  end
end