Uses the real submit adaptor, expression evaluator, BillingSession, task row and consume log. Set TEST_TASK_DB_DIALECT plus TEST_MYSQL_DSN or TEST_POSTGRES_DSN to exercise the same contract on an external test database. Unique table prefixes keep the fixture isolated from all existing tables. openTa
(t *testing.T, models ...any)
| 509 | // drops them on cleanup. It logs the engine version so database verification |
| 510 | // runs leave a record. |
| 511 | func openTaskDialectDatabase(t *testing.T, models ...any) (*gorm.DB, common.DatabaseType) { |
| 512 | t.Helper() |
| 513 | dialect := common.DatabaseType(os.Getenv("TEST_TASK_DB_DIALECT")) |
| 514 | var driver gorm.Dialector |
| 515 | switch dialect { |
| 516 | case "", common.DatabaseTypeSQLite: |
| 517 | dialect = common.DatabaseTypeSQLite |
| 518 | driver = sqlite.Open(":memory:") |
| 519 | case common.DatabaseTypeMySQL: |
| 520 | require.NotEmpty(t, os.Getenv("TEST_MYSQL_DSN")) |
| 521 | driver = mysql.Open(os.Getenv("TEST_MYSQL_DSN")) |
| 522 | case common.DatabaseTypePostgreSQL: |
| 523 | require.NotEmpty(t, os.Getenv("TEST_POSTGRES_DSN")) |
| 524 | driver = postgres.New(postgres.Config{DSN: os.Getenv("TEST_POSTGRES_DSN"), PreferSimpleProtocol: true}) |
| 525 | default: |
| 526 | t.Fatalf("unsupported test dialect %q", dialect) |
| 527 | } |
| 528 | db, err := gorm.Open(driver, &gorm.Config{NamingStrategy: schema.NamingStrategy{TablePrefix: fmt.Sprintf("tsubmit_%d_", time.Now().UnixNano())}}) |
| 529 | require.NoError(t, err) |
| 530 | sqlDB, err := db.DB() |
| 531 | require.NoError(t, err) |
| 532 | sqlDB.SetMaxOpenConns(1) |
| 533 | t.Cleanup(func() { _ = sqlDB.Close() }) |
| 534 | require.NoError(t, db.AutoMigrate(models...)) |
| 535 | t.Cleanup(func() { require.NoError(t, db.Migrator().DropTable(models...)) }) |
| 536 | var version string |
| 537 | if dialect == common.DatabaseTypeSQLite { |
| 538 | require.NoError(t, db.Raw("SELECT sqlite_version()").Scan(&version).Error) |
| 539 | } else { |
| 540 | require.NoError(t, db.Raw("SELECT version()").Scan(&version).Error) |
| 541 | } |
| 542 | t.Logf("database: %s %s", dialect, version) |
| 543 | return db, dialect |
| 544 | } |
| 545 | |
| 546 | func TestImmediateTaskSettlementDatabase(t *testing.T) { |
| 547 | db, dialect := openTaskDialectDatabase(t, &model.User{}, &model.Channel{}, &model.Task{}, &model.Log{}) |
no test coverage detected