Function handleSQLMode

viewer/lineedit.go:232–296

(m *TuiModel, input string)

}

func handleSQLMode(m *TuiModel, input string) {
	if m.QueryResult != nil {
		m.QueryResult = nil
	}
	m.QueryResult = &TableState{ // perform query
		Database: m.Table().Database,
		Data:     make(map[string]interface{}),
	}
	m.QueryData = &UIData{}

	firstword := strings.ToLower(strings.Split(input, " ")[0])
	if exec := firstword == "update" ||
		firstword == "delete" ||
		firstword == "insert"; exec {
		m.QueryData = nil
		m.QueryResult = nil
		populateUndo(m)
		_, err := m.DefaultTable.Database.GetDatabaseReference().Exec(input)
		if err != nil {
			ExitToDefaultView(m)
			m.DisplayMessage(fmt.Sprintf("%v", err))
			return
		}
		var c *sql.Rows
		defer func() {
			if c != nil {
				c.Close()
			}
		}()
		err = m.SetModel(c, m.DefaultTable.Database.GetDatabaseReference())
		if err != nil {
			m.DisplayMessage(fmt.Sprintf("%v", err))
		} else {
			ExitToDefaultView(m)
		}
	} else { // query
		c, err := m.QueryResult.Database.GetDatabaseReference().Query(input)
		defer func() {
			if c != nil {
				c.Close()
			}
		}()
		if err != nil {
			m.QueryResult = nil
			m.QueryData = nil
			ExitToDefaultView(m)
			m.DisplayMessage(fmt.Sprintf("%v", err))
			return
		}

		i := 0

		m.QueryData.TableHeaders = make(map[string][]string)
		m.QueryData.TableIndexMap = make(map[int]string)
		m.QueryData.TableSlices = make(map[string][]interface{})
		m.QueryData.TableHeadersSlice = []string{}

		m.PopulateDataForResult(c, &i, QueryResultsTableName)