func execQuery(g *gocui.Gui, v *gocui.View) error {
dbc := db.Use("test")
query := strings.TrimSpace(v.Buffer())
v.Reset()
fmt.Fprint(v, query)
widtgh, height := v.Size()
if height > v.LinesCount() {
v.SetSize(widtgh, v.LinesCount())
_, maxY := g.Size()
splitY = maxY - v.LinesCount() - 3
}
v.SetCursor(0, 0)
if len(query) == 0 {
return nil
}
log, _ := g.View("log")
rows, err := dbc.Queryx(query)
if err != nil {
fmt.Fprintln(log, err)
return nil
}
fmt.Fprintln(log, "\n", query)
logWidth, _ := log.Size()
log.Write(bytes.Repeat([]byte("─"), logWidth))
for rows.Next() {
log.Write([]byte("\n"))
cols, err := rows.SliceScan()
if err != nil {
fmt.Fprintln(log, err)
err = nil
break
}
for _, col := range cols {
if col != nil {
log.Write(col.([]byte))
log.Write([]byte("\t"))
}
}
}
log.Write([]byte("\n"))
log.Write(bytes.Repeat([]byte("─"), logWidth))
return err
}
// sql panel is for exploring queries and log output
func baseLayout(g *gocui.Gui) error {
maxX, maxY := g.Size()
// Panels of sql explorer
if splitY == 0 {
splitY = maxY - 4
}
l, err := g.SetView("log", 0, 0, maxX-1, splitY)
if err != nil {
if err != gocui.ErrUnknownView {
return err
}
l.Frame = false
l.Autoscroll = true
l.BgColor = gocui.ColorBlack
l.FgColor = gocui.ColorWhite
fmt.Fprintf(l, strings.Repeat("\n", splitY))
}
s, err := g.SetView("sql", 0, splitY, maxX-1, maxY-2)
if err != nil {
if err != gocui.ErrUnknownView {
return err
}
s.Editable = true
s.Wrap = true
s.Frame = false
s.BgColor = gocui.ColorBlack
s.FgColor = gocui.ColorWhite
fmt.Fprint(s, "")
}
// Two panels over sql explorer
lp, err := g.SetView("lpanel", 0, 0, maxX/2-1, maxY-2)
if err != nil {
if err != gocui.ErrUnknownView {
return err
}
// lp.Autoscroll = true
lp.Highlight = true
lp.BgColor = gocui.ColorBlue
lp.SelBgColor = gocui.ColorYellow
lp.SelFgColor = gocui.ColorBlack
for i := 1; i < 255; i++ {
fmt.Fprintf(lp, " menu item %3d │ \n", i)
}
}
rp, err := g.SetView("rpanel", maxX/2, 0, maxX-1, maxY-2)
if err != nil {
if err != gocui.ErrUnknownView {
return err
}
// rp.Autoscroll = true
rp.Highlight = true
rp.BgColor = gocui.ColorBlue
lp.SelBgColor = gocui.ColorYellow
lp.SelFgColor = gocui.ColorBlack
}
mp, err := g.SetView("menu", 0, maxY-2, maxX-1, maxY)
if err != nil {
if err != gocui.ErrUnknownView {
return err
}
mp.Frame = false
mp.BgColor = gocui.ColorBlack
mp.FgColor = gocui.ColorYellow | gocui.AttrBold
fmt.Fprint(mp, "F1 new F2 edit F5 copy F8 delete F10 exit")
}
as, _ := g.SetView("addSource", maxX/2-10, maxY/2-2, maxX/2+10, maxY/2+2)
as.Hide()
if twoPanelsVisible {
g.SetCurrentView("lpanel")
} else {
g.SetCurrentView("sql")
}
return nil
}