Method setDatabase

src/commands/addConnection.ts:143–232

(input: MultiStepInput, state: Partial<ConnectionState>)

  }

  async setDatabase(input: MultiStepInput, state: Partial<ConnectionState>) {
    // first need the databases
    let connection: PgClient = null;

    let databases: DatabaseQuickPickItem[] = [];
    let connectionError: any = null;
    try {
      connection = await Database.createConnection({
        label: '',
        host: state.host,
        user: state.user,
        password: state.password,
        port: state.port,
        ssl: state.secure
      }, 'postgres');
      const res = await connection.query('SELECT datname FROM pg_database WHERE datistemplate = false;');
      databases = res.rows.map<DatabaseQuickPickItem>(database => ({label: database.datname, dbname: database.datname}));
    } catch(err) {
      if (err.message === `permission denied for database "postgres"`) {
        // Heroku message anyway... probably varies
        // is there another common parameter could be checked?
      } else {
        // vscode.window.showErrorMessage(err.message);
      }
    } finally {
      if (connection) {
        await connection.end();
        connection = null;
      }
    }

    if (databases.length < 1) {
      // specify database via text input - may not have permission to list databases
      let connectionOK = false;
      do {
        state.database = await input.showInputBox({
          title: this.TITLE,
          step: input.CurrentStepNumber,
          totalSteps: this.TotalSteps,
          prompt: '[Optional] The database to connect to. Leave empty to enumerate databases on the server',
          placeholder: '',
          ignoreFocusOut: true,
          value: (typeof state.database === 'string') ? state.database : '',
          validate: async (value) => ''
        });

        try {
          let databaseToTry = state.database && state.database.trim() ? state.database : 'postgres';
          connection = await Database.createConnection({
            label: '',
            host: state.host,
            user: state.user,
            password: state.password,
            port: state.port,
            ssl: state.secure
          }, databaseToTry);
          connectionOK = true;
        } catch(err) {