Using the sqlserver driver and adapter with Azure AD / Azure CLI authentication

[marhaasa]

First off I must say that I am incredibly impressed by this plugin! Keep up the great work.

Now over to my issue.

I need to alter, or implement my own custom adapter for that matter, the original sqlserver adapter to use "github.com/microsoft/go-mssqldb/azuread" to be able to pass fedath=ActiveDirectoryAzCli in the connection string to use nvim-dbee with my sql server in Azure, and for the life of me I cannot get this to work correctly by altering the sqlserver adapter and/or driver directly. After many tries it always ends up with giving me this error message even though I have tried hardcoding the connection strings in both the adapter and driver:

E5108: Error executing lua: function DbeeConnectionGetStructure[1]..remote#define#request, line 2: Vim(let):Error invoking '0:function:DbeeConnectionGetStructure' on channel 3:
c.GetStructure: c.db.Conn: mssql: login error: Login failed for user ''.
stack traceback:
        [C]: in function 'DbeeConnectionGetStructure'
        ...ocal/share/nvim/lazy/nvim-dbee/lua/dbee/handler/init.lua:223: in function 'connection_get_structure'
        ...share/nvim/lazy/nvim-dbee/lua/dbee/ui/drawer/convert.lua:92: in function 'lazy_children'
        ...al/share/nvim/lazy/nvim-dbee/lua/dbee/ui/drawer/init.lua:208: in function 'expand_node'
        ...al/share/nvim/lazy/nvim-dbee/lua/dbee/ui/drawer/init.lua:293: in function <...al/share/nvim/lazy/nvim-dbee/lua/dbee/ui/drawer/init.lua:285>

I have written my first(!) GO program which actually works after running az login in my terminal session, but I am struggling to implement this into nvim-dbee. Could someone help me figure out this problem?

package main

import (
    "database/sql"
    "fmt"
    "log"

    // Import the Azure AD driver module (also imports the regular driver package)
    "github.com/microsoft/go-mssqldb/azuread"
)

func main() {
    connString := "sqlserver://mydatabase.database.windows.net?database=mydatabase&fedauth=ActiveDirectoryAzCli"

    db, err := sql.Open(azuread.DriverName, connString)
    if err != nil {
        log.Fatalf("Error opening database: %v", err)
    }
    defer db.Close()

    fmt.Println("Database connection established")

    rows, err := db.Query("SELECT TOP 10 * FROM mytable")
    if err != nil {
        log.Fatalf("Error executing query: %v", err)
    }
    defer rows.Close()

    fmt.Println("Query executed successfully")

    columns, err := rows.Columns()
    if err != nil {
        log.Fatalf("Error getting columns: %v", err)
    }

    fmt.Println("Columns retrieved:", columns)

    rowCount := 0
    for rows.Next() {
        rowCount++
        values := make([]interface{}, len(columns))
        valuePtrs := make([]interface{}, len(columns))
        for i := range values {
            valuePtrs[i] = &values[i]
        }

        if err := rows.Scan(valuePtrs...); err != nil {
            log.Fatalf("Error scanning row: %v", err)
        }

        for i, col := range columns {
            fmt.Printf("%s: %v\n", col, values[i])
        }
        fmt.Println("---------------------")
    }

    if err := rows.Err(); err != nil {
        log.Fatalf("Error with rows: %v", err)
    }

    if rowCount == 0 {
        fmt.Println("No rows returned by the query")
    } else {
        fmt.Printf("Rows processed successfully: %d\n", rowCount)
    }
}

[marhaasa]

Due to my lack of knowledge with lua and GO this was probably no issue to begin with. Rewriting relevant code, running new build with go-mssqldb/azuread and replacing the binary solved everything.