SQL Connection in Html Architect

jsusen · November 3, 2025, 9:26am

It would be nice to have some kind of UI for creating and testing connection strings in the new HTML Architect.
Something like Jetbrains have.

tvavrda · November 6, 2025, 3:19pm

In the old project wizard we use the connection string builder class.

github.com/origam/origam

backend/Origam.ProjectAutomation/Builders/DataDatabaseBuilder.cs

5c9463748


      
              CreateSchema(project);
              DataService(_databaseType).ConnectionString = BuildConnectionStringCreateDatabase(
                  project,
                  ""
              );
          }
          
          public string BuildConnectionStringCreateDatabase(Project project, string creatingDatabase)
          {
              return DataService(_databaseType)
                  .BuildConnectionString(
                      project.DatabaseServerName,
                      project.DatabasePort,
                      creatingDatabase,
                      project.DatabaseUserName,
                      project.DatabasePassword,
                      project.DatabaseIntegratedAuthentication,
                      false
                  );
          }

Where would this UI be located? Today it’s either

New Project Wizard
Settings Editor

jsusen · November 6, 2025, 4:42pm

The new project wizard (Composer) is a console application. So it would have to be in the settings editor only.

tvavrda · November 6, 2025, 5:06pm

But will the setting editor configure the connection string? Won’t the connection string be set by environment variables to the Architect’s and server’s docker containers? Maybe this option would only make sense if the Composer has a GUI in the future?