Function TestWebserverPostgresDBClient

pkg/ddevapp/ddevapp_test.go:2289–2388

TestWebserverPostgresDBClient tests functionality of Postgres database clients in the ddev-webserver

(t *testing.T)

// TestWebserverPostgresDBClient tests functionality of Postgres
// database clients in the ddev-webserver
func TestWebserverPostgresDBClient(t *testing.T) {
	assert := asrt.New(t)

	serverVersions := []string{"postgres:18", "postgres:17", "postgres:16"}

	app := &ddevapp.DdevApp{}
	origDir, _ := os.Getwd()

	site := TestSites[0]
	runTime := util.TimeTrackC(fmt.Sprintf("%s %s", site.Name, t.Name()))

	testcommon.ClearDockerEnv()
	err := app.Init(site.Dir)
	assert.NoError(err)

	err = app.Stop(true, false)
	require.NoError(t, err)

	// Existing DB type in volume should be empty
	dbType, err := app.GetExistingDBType()
	assert.NoError(err)
	assert.Equal("", strings.Trim(dbType, " \n\r\t"))

	// Make sure there isn't an old database volume laying around
	_ = dockerutil.RemoveVolume(app.Name + "-postgres")
	t.Cleanup(func() {
		err = app.Stop(true, false)
		assert.NoError(err)
		err = os.RemoveAll(app.GetConfigPath("db_snapshots"))
		assert.NoError(err)
		_ = os.RemoveAll(filepath.Join(app.AppRoot, "users.sql"))
		_ = os.RemoveAll(filepath.Join(app.AppRoot, "dbdump.sql"))
		// Make sure we leave the config.yaml in expected state
		app.Database.Type = nodeps.MariaDB
		app.Database.Version = nodeps.MariaDBDefaultVersion
		err = app.WriteConfig()
		assert.NoError(err)
		err = os.Chdir(origDir)
		assert.NoError(err)
	})

	for _, dbTypeVersion := range serverVersions {
		t.Logf("Testing postgres client functionality of %s", dbTypeVersion)
		parts := strings.Split(dbTypeVersion, ":")
		dbType := parts[0]
		dbVersion := parts[1]
		require.Len(t, parts, 2)

		err = app.Stop(true, false)
		require.NoError(t, err)
		app.Database.Type = dbType
		app.Database.Version = dbVersion
		err = app.WriteConfig()
		require.NoError(t, err)

		startErr := app.Start()
		require.NoError(t, startErr)