types

type Column struct {
	Name         string         `json:"name"`          // Name is the name of the column.
	Type         string         `json:"type"`          // Type is the data type of the column.
	IsNullable   string         `json:"is_nullable"`   // IsNullable indicates whether the column can have null values.
	Key          string         `json:"key"`           // Key is the key type of the column.
	DefaultValue sql.NullString `json:"default_value"` // DefaultValue is the default value of the column.
	Extra        string         `json:"extra"`         // Extra contains additional information about the column.
	Description  string         `json:"description"`   // Description is a description of the column.
	Metatags     []string       `json:"metatags"`      // Metatags contains the column name.
	Visibility   bool           `json:"visibility"`    // Visibility indicates whether the column is visible.
	IsIndex      bool           `json:"is_index"`      // IsIndex indicates whether the column is an index.
	IsPrimary    bool           `json:"is_primary"`    // IsPrimary indicates whether the column is a primary key.
}

type DbType int

type ISQL interface {
	Schema(string) (Table, error)
	Execute(string) ([]byte, error)
	Tables(string) ([]string, error)
}

type QueryResult struct {
	Columns []string        `json:"columns"` // Columns are the names of the columns in the result.
	Rows    [][]interface{} `json:"rows"`    // Rows are the rows in the result.
	Time    int64           `json:"time"`    // Time is the time it took to execute the query.
	Error   string          `json:"error"`   // Error is any error that occurred while executing the query.
}

type Table struct {
	Name        string   `json:"name"`         // Name is the name of the table.
	Columns     []Column `json:"columns"`      // Columns are the columns in the table.
	ColumnCount int64    `json:"column_count"` // ColumnCount is the number of columns in the table.
	Description string   `json:"description"`  // Description is a description of the table.
	Metatags    []string `json:"metatags"`     // Metatags contains all column names.
}