397 lines
12 KiB
Go
397 lines
12 KiB
Go
// Copyright 2022 Woodpecker Authors
|
|
// Copyright 2018 Drone.IO Inc.
|
|
//
|
|
// Licensed under the Apache License, Version 2.0 (the "License");
|
|
// you may not use this file except in compliance with the License.
|
|
// You may obtain a copy of the License at
|
|
//
|
|
// http://www.apache.org/licenses/LICENSE-2.0
|
|
//
|
|
// Unless required by applicable law or agreed to in writing, software
|
|
// distributed under the License is distributed on an "AS IS" BASIS,
|
|
// WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
|
|
// See the License for the specific language governing permissions and
|
|
// limitations under the License.
|
|
|
|
package datastore
|
|
|
|
import (
|
|
"fmt"
|
|
"testing"
|
|
"time"
|
|
|
|
"github.com/franela/goblin"
|
|
"github.com/stretchr/testify/assert"
|
|
|
|
"go.woodpecker-ci.org/woodpecker/v3/server/model"
|
|
"go.woodpecker-ci.org/woodpecker/v3/server/store/types"
|
|
)
|
|
|
|
func TestPipelines(t *testing.T) {
|
|
repo := &model.Repo{
|
|
UserID: 1,
|
|
FullName: "bradrydzewski/test",
|
|
Owner: "bradrydzewski",
|
|
Name: "test",
|
|
}
|
|
|
|
store, closer := newTestStore(t, new(model.Repo), new(model.Step), new(model.Pipeline))
|
|
defer closer()
|
|
|
|
g := goblin.Goblin(t)
|
|
g.Describe("Pipelines", func() {
|
|
g.Before(func() {
|
|
_, err := store.engine.Exec("DELETE FROM repos")
|
|
g.Assert(err).IsNil()
|
|
g.Assert(store.CreateRepo(repo)).IsNil()
|
|
})
|
|
g.After(func() {
|
|
_, err := store.engine.Exec("DELETE FROM repos")
|
|
g.Assert(err).IsNil()
|
|
})
|
|
|
|
// before each test be sure to purge the package
|
|
// table data from the database.
|
|
g.BeforeEach(func() {
|
|
_, err := store.engine.Exec("DELETE FROM pipelines")
|
|
g.Assert(err).IsNil()
|
|
_, err = store.engine.Exec("DELETE FROM steps")
|
|
g.Assert(err).IsNil()
|
|
})
|
|
|
|
g.It("Should Fail early when the repo is not existing", func() {
|
|
pipeline := model.Pipeline{
|
|
RepoID: 100,
|
|
Status: model.StatusSuccess,
|
|
}
|
|
err := store.CreatePipeline(&pipeline)
|
|
g.Assert(err).IsNotNil()
|
|
|
|
count, err := store.GetPipelineCount()
|
|
g.Assert(err).IsNil()
|
|
g.Assert(count == 0).IsTrue()
|
|
fmt.Println("GOT COUNT", count)
|
|
})
|
|
|
|
g.It("Should Post a Pipeline", func() {
|
|
pipeline := model.Pipeline{
|
|
RepoID: repo.ID,
|
|
Status: model.StatusSuccess,
|
|
Commit: "85f8c029b902ed9400bc600bac301a0aadb144ac",
|
|
}
|
|
err := store.CreatePipeline(&pipeline)
|
|
g.Assert(err).IsNil()
|
|
g.Assert(pipeline.ID != 0).IsTrue()
|
|
g.Assert(pipeline.Number).Equal(int64(1))
|
|
g.Assert(pipeline.Commit).Equal("85f8c029b902ed9400bc600bac301a0aadb144ac")
|
|
|
|
count, err := store.GetPipelineCount()
|
|
g.Assert(err).IsNil()
|
|
g.Assert(count > 0).IsTrue()
|
|
fmt.Println("GOT COUNT", count)
|
|
})
|
|
|
|
g.It("Should Put a Pipeline", func() {
|
|
pipeline := model.Pipeline{
|
|
RepoID: repo.ID,
|
|
Number: 5,
|
|
Status: model.StatusSuccess,
|
|
Commit: "85f8c029b902ed9400bc600bac301a0aadb144ac",
|
|
}
|
|
err := store.CreatePipeline(&pipeline)
|
|
g.Assert(err).IsNil()
|
|
pipeline.Status = model.StatusRunning
|
|
err1 := store.UpdatePipeline(&pipeline)
|
|
GetPipeline, err2 := store.GetPipeline(pipeline.ID)
|
|
g.Assert(err1).IsNil()
|
|
g.Assert(err2).IsNil()
|
|
g.Assert(pipeline.ID).Equal(GetPipeline.ID)
|
|
g.Assert(pipeline.RepoID).Equal(GetPipeline.RepoID)
|
|
g.Assert(pipeline.Status).Equal(GetPipeline.Status)
|
|
g.Assert(pipeline.Number).Equal(GetPipeline.Number)
|
|
})
|
|
|
|
g.It("Should Get a Pipeline", func() {
|
|
pipeline := model.Pipeline{
|
|
RepoID: repo.ID,
|
|
Status: model.StatusSuccess,
|
|
}
|
|
err := store.CreatePipeline(&pipeline, []*model.Step{}...)
|
|
g.Assert(err).IsNil()
|
|
GetPipeline, err := store.GetPipeline(pipeline.ID)
|
|
g.Assert(err).IsNil()
|
|
g.Assert(pipeline.ID).Equal(GetPipeline.ID)
|
|
g.Assert(pipeline.RepoID).Equal(GetPipeline.RepoID)
|
|
g.Assert(pipeline.Status).Equal(GetPipeline.Status)
|
|
})
|
|
|
|
g.It("Should Get a Pipeline by Number", func() {
|
|
pipeline1 := &model.Pipeline{
|
|
RepoID: repo.ID,
|
|
Status: model.StatusPending,
|
|
}
|
|
pipeline2 := &model.Pipeline{
|
|
RepoID: repo.ID,
|
|
Status: model.StatusPending,
|
|
}
|
|
err1 := store.CreatePipeline(pipeline1, []*model.Step{}...)
|
|
g.Assert(err1).IsNil()
|
|
err2 := store.CreatePipeline(pipeline2, []*model.Step{}...)
|
|
g.Assert(err2).IsNil()
|
|
GetPipeline, err3 := store.GetPipelineNumber(&model.Repo{ID: 1}, pipeline2.Number)
|
|
g.Assert(err3).IsNil()
|
|
g.Assert(pipeline2.ID).Equal(GetPipeline.ID)
|
|
g.Assert(pipeline2.RepoID).Equal(GetPipeline.RepoID)
|
|
g.Assert(pipeline2.Number).Equal(GetPipeline.Number)
|
|
})
|
|
|
|
g.It("Should Get the last Pipeline", func() {
|
|
pipeline1 := &model.Pipeline{
|
|
RepoID: repo.ID,
|
|
Status: model.StatusFailure,
|
|
Branch: "main",
|
|
Commit: "85f8c029b902ed9400bc600bac301a0aadb144ac",
|
|
Event: model.EventPush,
|
|
}
|
|
pipeline2 := &model.Pipeline{
|
|
RepoID: repo.ID,
|
|
Status: model.StatusSuccess,
|
|
Branch: "main",
|
|
Commit: "85f8c029b902ed9400bc600bac301a0aadb144aa",
|
|
Event: model.EventPush,
|
|
}
|
|
err1 := store.CreatePipeline(pipeline1, []*model.Step{}...)
|
|
err2 := store.CreatePipeline(pipeline2, []*model.Step{}...)
|
|
GetPipeline, err3 := store.GetPipelineLast(&model.Repo{ID: 1}, pipeline2.Branch)
|
|
g.Assert(err1).IsNil()
|
|
g.Assert(err2).IsNil()
|
|
g.Assert(err3).IsNil()
|
|
g.Assert(pipeline2.ID).Equal(GetPipeline.ID)
|
|
g.Assert(pipeline2.RepoID).Equal(GetPipeline.RepoID)
|
|
g.Assert(pipeline2.Number).Equal(GetPipeline.Number)
|
|
g.Assert(pipeline2.Status).Equal(GetPipeline.Status)
|
|
g.Assert(pipeline2.Branch).Equal(GetPipeline.Branch)
|
|
g.Assert(pipeline2.Commit).Equal(GetPipeline.Commit)
|
|
})
|
|
|
|
g.It("Should Get the last Pipeline Before Pipeline N", func() {
|
|
pipeline1 := &model.Pipeline{
|
|
RepoID: repo.ID,
|
|
Status: model.StatusFailure,
|
|
Branch: "main",
|
|
Commit: "85f8c029b902ed9400bc600bac301a0aadb144ac",
|
|
}
|
|
pipeline2 := &model.Pipeline{
|
|
RepoID: repo.ID,
|
|
Status: model.StatusSuccess,
|
|
Branch: "main",
|
|
Commit: "85f8c029b902ed9400bc600bac301a0aadb144aa",
|
|
}
|
|
pipeline3 := &model.Pipeline{
|
|
RepoID: repo.ID,
|
|
Status: model.StatusRunning,
|
|
Branch: "main",
|
|
Commit: "85f8c029b902ed9400bc600bac301a0aadb144aa",
|
|
}
|
|
err1 := store.CreatePipeline(pipeline1, []*model.Step{}...)
|
|
g.Assert(err1).IsNil()
|
|
err2 := store.CreatePipeline(pipeline2, []*model.Step{}...)
|
|
g.Assert(err2).IsNil()
|
|
err3 := store.CreatePipeline(pipeline3, []*model.Step{}...)
|
|
g.Assert(err3).IsNil()
|
|
GetPipeline, err4 := store.GetPipelineLastBefore(&model.Repo{ID: 1}, pipeline3.Branch, pipeline3.ID)
|
|
g.Assert(err4).IsNil()
|
|
g.Assert(pipeline2.ID).Equal(GetPipeline.ID)
|
|
g.Assert(pipeline2.RepoID).Equal(GetPipeline.RepoID)
|
|
g.Assert(pipeline2.Number).Equal(GetPipeline.Number)
|
|
g.Assert(pipeline2.Status).Equal(GetPipeline.Status)
|
|
g.Assert(pipeline2.Branch).Equal(GetPipeline.Branch)
|
|
g.Assert(pipeline2.Commit).Equal(GetPipeline.Commit)
|
|
})
|
|
|
|
g.It("Should get recent pipelines", func() {
|
|
pipeline1 := &model.Pipeline{
|
|
RepoID: repo.ID,
|
|
Status: model.StatusFailure,
|
|
Event: model.EventCron,
|
|
Ref: "refs/heads/some-branch",
|
|
Branch: "some-branch",
|
|
}
|
|
pipeline2 := &model.Pipeline{
|
|
RepoID: repo.ID,
|
|
Status: model.StatusSuccess,
|
|
Event: model.EventPull,
|
|
Ref: "refs/pull/32",
|
|
Branch: "main",
|
|
}
|
|
err := store.CreatePipeline(pipeline1, []*model.Step{}...)
|
|
g.Assert(err).IsNil()
|
|
err = store.CreatePipeline(pipeline2, []*model.Step{}...)
|
|
g.Assert(err).IsNil()
|
|
pipelines, err := store.GetPipelineList(&model.Repo{ID: 1}, &model.ListOptions{Page: 1, PerPage: 50}, nil)
|
|
g.Assert(err).IsNil()
|
|
g.Assert(len(pipelines)).Equal(2)
|
|
g.Assert(pipelines[0].ID).Equal(pipeline2.ID)
|
|
g.Assert(pipelines[0].RepoID).Equal(pipeline2.RepoID)
|
|
g.Assert(pipelines[0].Status).Equal(pipeline2.Status)
|
|
|
|
pipelines, err = store.GetPipelineList(&model.Repo{ID: 1}, nil, &model.PipelineFilter{
|
|
Branch: "main",
|
|
})
|
|
g.Assert(err).IsNil()
|
|
g.Assert(len(pipelines)).Equal(1)
|
|
g.Assert(pipelines[0].ID).Equal(pipeline2.ID)
|
|
|
|
pipelines, err = store.GetPipelineList(&model.Repo{ID: 1}, nil, &model.PipelineFilter{
|
|
Events: []model.WebhookEvent{model.EventCron},
|
|
})
|
|
g.Assert(err).IsNil()
|
|
g.Assert(len(pipelines)).Equal(1)
|
|
g.Assert(pipelines[0].ID).Equal(pipeline1.ID)
|
|
|
|
pipelines, err = store.GetPipelineList(&model.Repo{ID: 1}, nil, &model.PipelineFilter{
|
|
Events: []model.WebhookEvent{model.EventCron, model.EventPull},
|
|
RefContains: "32",
|
|
})
|
|
g.Assert(err).IsNil()
|
|
g.Assert(len(pipelines)).Equal(1)
|
|
g.Assert(pipelines[0].ID).Equal(pipeline2.ID)
|
|
})
|
|
|
|
g.It("Should get filtered pipelines", func() {
|
|
pipeline1 := &model.Pipeline{
|
|
RepoID: repo.ID,
|
|
}
|
|
pipeline2 := &model.Pipeline{
|
|
RepoID: repo.ID,
|
|
}
|
|
err1 := store.CreatePipeline(pipeline1, []*model.Step{}...)
|
|
g.Assert(err1).IsNil()
|
|
time.Sleep(1 * time.Second)
|
|
before := time.Now().Unix()
|
|
err2 := store.CreatePipeline(pipeline2, []*model.Step{}...)
|
|
g.Assert(err2).IsNil()
|
|
pipelines, err3 := store.GetPipelineList(&model.Repo{ID: 1}, &model.ListOptions{Page: 1, PerPage: 50}, &model.PipelineFilter{Before: before})
|
|
g.Assert(err3).IsNil()
|
|
g.Assert(len(pipelines)).Equal(1)
|
|
g.Assert(pipelines[0].ID).Equal(pipeline1.ID)
|
|
g.Assert(pipelines[0].RepoID).Equal(pipeline1.RepoID)
|
|
})
|
|
|
|
g.It("Should get pipelines filtered by status", func() {
|
|
pipeline1 := &model.Pipeline{
|
|
RepoID: repo.ID,
|
|
Status: model.StatusSuccess,
|
|
}
|
|
pipeline2 := &model.Pipeline{
|
|
RepoID: repo.ID,
|
|
Status: model.StatusFailure,
|
|
}
|
|
pipeline3 := &model.Pipeline{
|
|
RepoID: repo.ID,
|
|
Status: model.StatusRunning,
|
|
}
|
|
err1 := store.CreatePipeline(pipeline1, []*model.Step{}...)
|
|
g.Assert(err1).IsNil()
|
|
err2 := store.CreatePipeline(pipeline2, []*model.Step{}...)
|
|
g.Assert(err2).IsNil()
|
|
err3 := store.CreatePipeline(pipeline3, []*model.Step{}...)
|
|
g.Assert(err3).IsNil()
|
|
|
|
pipelines, err := store.GetPipelineList(&model.Repo{ID: 1}, nil, &model.PipelineFilter{
|
|
Status: model.StatusSuccess,
|
|
})
|
|
g.Assert(err).IsNil()
|
|
g.Assert(len(pipelines)).Equal(1)
|
|
g.Assert(pipelines[0].ID).Equal(pipeline1.ID)
|
|
g.Assert(pipelines[0].Status).Equal(model.StatusSuccess)
|
|
})
|
|
})
|
|
}
|
|
|
|
func TestPipelineIncrement(t *testing.T) {
|
|
store, closer := newTestStore(t, new(model.Pipeline), new(model.Repo))
|
|
defer closer()
|
|
|
|
assert.NoError(t, store.CreateRepo(&model.Repo{ID: 1, Owner: "1", Name: "1", FullName: "1/1"}))
|
|
assert.NoError(t, store.CreateRepo(&model.Repo{ID: 2, Owner: "2", Name: "2", FullName: "2/2"}))
|
|
|
|
pipelineA := &model.Pipeline{RepoID: 1}
|
|
if !assert.NoError(t, store.CreatePipeline(pipelineA)) {
|
|
return
|
|
}
|
|
assert.EqualValues(t, 1, pipelineA.Number)
|
|
|
|
pipelineB := &model.Pipeline{RepoID: 1}
|
|
assert.NoError(t, store.CreatePipeline(pipelineB))
|
|
assert.EqualValues(t, 2, pipelineB.Number)
|
|
|
|
pipelineC := &model.Pipeline{RepoID: 2}
|
|
assert.NoError(t, store.CreatePipeline(pipelineC))
|
|
assert.EqualValues(t, 1, pipelineC.Number)
|
|
}
|
|
|
|
func TestDeletePipeline(t *testing.T) {
|
|
store, closer := newTestStore(t, new(model.Pipeline), new(model.Repo), new(model.Workflow),
|
|
new(model.Step), new(model.LogEntry), new(model.PipelineConfig), new(model.Config))
|
|
defer closer()
|
|
|
|
_, err := store.engine.Insert(
|
|
&model.Pipeline{
|
|
ID: 2,
|
|
Number: 2,
|
|
RepoID: 7,
|
|
},
|
|
&model.Pipeline{
|
|
ID: 5,
|
|
Number: 3,
|
|
RepoID: 7,
|
|
},
|
|
&model.Pipeline{
|
|
ID: 8,
|
|
Number: 4,
|
|
RepoID: 7,
|
|
},
|
|
&model.Config{
|
|
ID: 23,
|
|
Hash: "1234",
|
|
Name: "test",
|
|
RepoID: 7,
|
|
},
|
|
&model.Config{
|
|
ID: 25,
|
|
Hash: "6789",
|
|
Name: "test",
|
|
RepoID: 7,
|
|
},
|
|
&model.PipelineConfig{
|
|
PipelineID: 2,
|
|
ConfigID: 23,
|
|
},
|
|
&model.PipelineConfig{
|
|
PipelineID: 5,
|
|
ConfigID: 23,
|
|
},
|
|
&model.PipelineConfig{
|
|
PipelineID: 8,
|
|
ConfigID: 25,
|
|
},
|
|
)
|
|
assert.NoError(t, err)
|
|
|
|
// delete non existing pipeline
|
|
assert.ErrorIs(t, types.RecordNotExist, store.DeletePipeline(&model.Pipeline{ID: 1}))
|
|
|
|
// delete pipeline with shares config
|
|
assert.NoError(t, store.DeletePipeline(&model.Pipeline{ID: 2}))
|
|
count, err := store.engine.Count(new(model.Config))
|
|
assert.NoError(t, err)
|
|
assert.EqualValues(t, 2, count)
|
|
|
|
// delete pipeline with unique config
|
|
assert.NoError(t, store.DeletePipeline(&model.Pipeline{ID: 8}))
|
|
count, err = store.engine.Count(new(model.Config))
|
|
assert.NoError(t, err)
|
|
assert.EqualValues(t, 1, count)
|
|
}
|