I'm new to golang and i'm trying to impliment MySQL lookup for multiple connections, however I keep getting an error using the below code.
cannot use irc.IRC("goTest", "goTee") (type *irc.Connection) as type string in assignment
result[0] is the network name
If i changeresult[0] = irc.IRC("goTest", "goTee")
toconn := irc.IRC("goTest", "goTee")
it works fine.
Any help is greatly appreciated.
package main
import (
"database/sql"
"fmt"
_ "github.com/go-sql-driver/mysql"
"github.com/thoj/go-ircevent"
)
func main() {
db, err := sql.Open("mysql", sqllogin()+":"+sqlpasswd()+"@("+sqlip()+":"+sqlport()+")/"+sqlgodb())
rows, err := db.Query("SELECT * FROM `network` ")
cols, err := rows.Columns()
rawResult := make([][]byte, len(cols))
result := make([]string, len(cols))
fmt.Println(rawResult)
dest := make([]interface{}, len(cols))
for i, _ := range rawResult {
dest[i] = &rawResult[i]
}
for rows.Next() {
err = rows.Scan(dest...)
if err != nil {
fmt.Println("Failed to scan row", err)
return
}
for i, raw := range rawResult {
if raw == nil {
result[i] = ""
} else {
result[i] = string(raw)
}
}
result[0] = irc.IRC("goTest", "goTee")
result[0].Connect("ip:port")
}
result[0].Loop()
}