Method run

src/commands/selectDatabase.ts:10–29

()

export class selectDatabaseCommand extends BaseCommand {
  async run() {
    // vscode.window.showInformationMessage('Select Database!');
    let connectionDetails: IConnection = EditorState.connection;
    if (!connectionDetails) return;
    
    const connection = await Database.createConnection(connectionDetails, 'postgres');

    let databases: string[] = [];
    try {
      const res = await connection.query('SELECT datname FROM pg_database WHERE datistemplate = false;');
      databases = res.rows.map<string>(database => database.datname);
    } finally {
      await connection.end();
    }

    //vscode.window.showInputBox
    const db = await vscode.window.showQuickPick(databases, {placeHolder: 'Select a database'});
    if (!db) return;
    EditorState.connection = Database.getConnectionWithDB(connectionDetails, db);
  }
}