(t *testing.T, db database.DB)
| 314 | } |
| 315 | |
| 316 | func testProjectsWithPagination(t *testing.T, db database.DB) { |
| 317 | ctx := context.Background() |
| 318 | |
| 319 | // add org |
| 320 | org, err := db.InsertOrganization(ctx, &database.InsertOrganizationOptions{Name: "test"}) |
| 321 | require.NoError(t, err) |
| 322 | require.Equal(t, "test", org.Name) |
| 323 | |
| 324 | // add another org |
| 325 | org2, err := db.InsertOrganization(ctx, &database.InsertOrganizationOptions{Name: "test2"}) |
| 326 | require.NoError(t, err) |
| 327 | require.Equal(t, "test2", org2.Name) |
| 328 | |
| 329 | // add projects |
| 330 | proj, err := db.InsertProject(ctx, &database.InsertProjectOptions{OrganizationID: org.ID, Name: "alpha"}) |
| 331 | require.NoError(t, err) |
| 332 | require.Equal(t, "alpha", proj.Name) |
| 333 | |
| 334 | proj1, err := db.InsertProject(ctx, &database.InsertProjectOptions{OrganizationID: org.ID, Name: "beta"}) |
| 335 | require.NoError(t, err) |
| 336 | require.Equal(t, "beta", proj1.Name) |
| 337 | |
| 338 | proj2, err := db.InsertProject(ctx, &database.InsertProjectOptions{OrganizationID: org.ID, Name: "gamma"}) |
| 339 | require.NoError(t, err) |
| 340 | require.Equal(t, "gamma", proj2.Name) |
| 341 | |
| 342 | proj3, err := db.InsertProject(ctx, &database.InsertProjectOptions{OrganizationID: org2.ID, Name: "other"}) |
| 343 | require.NoError(t, err) |
| 344 | require.Equal(t, "other", proj3.Name) |
| 345 | |
| 346 | // fetch project name without name filter |
| 347 | projs, err := db.FindProjectsForOrganization(ctx, org.ID, "", 2) |
| 348 | require.NoError(t, err) |
| 349 | require.Equal(t, len(projs), 2) |
| 350 | require.Equal(t, "alpha", projs[0].Name) |
| 351 | require.Equal(t, "beta", projs[1].Name) |
| 352 | |
| 353 | // fetch project with name filter |
| 354 | projs, err = db.FindProjectsForOrganization(ctx, org.ID, projs[1].Name, 2) |
| 355 | require.NoError(t, err) |
| 356 | require.Equal(t, len(projs), 1) |
| 357 | require.Equal(t, "gamma", projs[0].Name) |
| 358 | |
| 359 | //cleanup |
| 360 | require.NoError(t, db.DeleteProject(ctx, proj.ID)) |
| 361 | require.NoError(t, db.DeleteProject(ctx, proj1.ID)) |
| 362 | require.NoError(t, db.DeleteProject(ctx, proj2.ID)) |
| 363 | require.NoError(t, db.DeleteProject(ctx, proj3.ID)) |
| 364 | require.NoError(t, db.DeleteOrganization(ctx, "test")) |
| 365 | require.NoError(t, db.DeleteOrganization(ctx, "test2")) |
| 366 | } |
| 367 | |
| 368 | func testProjectsForUserWithPagination(t *testing.T, db database.DB) { |
| 369 | ctx := context.Background() |
no test coverage detected