func (m *SchemaDb) tableForVariables(table string) (*schema.Table, error) {
// This table doesn't belong in schema
ss := m.is.SchemaSources["schema"]
t := schema.NewTable("variables", ss)
t.AddField(schema.NewFieldBase("Variable_name", value.StringType, 64, "string"))
t.AddField(schema.NewFieldBase("Value", value.StringType, 64, "string"))
t.SetColumns(schema.ShowVariablesColumns)
return t, nil
}
func (m *CsvDataSource) Table(tableName string) (*schema.Table, error) {
if m.tblschema != nil {
return m.tblschema, nil
}
m.tblschema = schema.NewTable(tableName, nil)
for _, col := range m.Columns() {
m.tblschema.AddField(schema.NewFieldBase(col, value.StringType, 64, "string"))
}
m.tblschema.SetColumns(m.Columns())
return m.tblschema, nil
}
func (m *SchemaDb) tableForDatabases() (*schema.Table, error) {
ss := m.is.SchemaSources["schema"]
t := schema.NewTable("databases", ss)
t.AddField(schema.NewFieldBase("Database", value.StringType, 64, "string"))
t.SetColumns(schema.ShowDatabasesColumns)
rows := make([][]driver.Value, 0, len(registry.schemas))
for db, _ := range registry.schemas {
rows = append(rows, []driver.Value{db})
}
t.SetRows(rows)
ss.AddTable(t)
return t, nil
}
func (m *SchemaDb) tableForTables() (*schema.Table, error) {
// This table doesn't belong in schema
ss := m.is.SchemaSources["schema"]
//u.Debugf("schema:%p table create infoschema:%p ", m.s, m.is)
t := schema.NewTable("tables", ss)
t.AddField(schema.NewFieldBase("Table", value.StringType, 64, "string"))
t.AddField(schema.NewFieldBase("Table_type", value.StringType, 64, "string"))
cols := schema.ShowTableColumns
for _, col := range DialectWriterCols {
cols = append(cols, fmt.Sprintf("%s_create", col))
}
t.SetColumns(cols)
ss.AddTable(t)
rows := make([][]driver.Value, len(m.s.Tables()))
for i, tableName := range m.s.Tables() {
rows[i] = []driver.Value{tableName, "BASE TABLE"}
tbl, err := m.s.Table(tableName)
if tbl != nil && len(tbl.Columns()) > 0 && len(tbl.Fields) == 0 {
// I really don't like where this is, needs to be in schema somewhere
m.inspect(tbl.Name)
} else {
//u.Warnf("NOT INSPECTING")
}
for _, writer := range DialectWriters {
if err != nil {
rows[i] = append(rows[i], "error")
} else {
rows[i] = append(rows[i], writer.Table(tbl))
//u.Debugf("%s", rows[i][len(rows[i])-1])
}
}
}
//u.Debugf("set rows: %v for tables: %v", rows, m.s.Tables())
t.SetRows(rows)
return t, nil
}
func (m *SchemaDb) tableForTable(table string) (*schema.Table, error) {
ss := m.is.SchemaSources["schema"]
tbl, hasTable := m.tableMap[table]
//u.Debugf("s:%p infoschema:%p creating schema table for %q", m.s, m.is, table)
if hasTable {
//u.Infof("found existing table %q", table)
return tbl, nil
}
srcTbl, err := m.s.Table(table)
if err != nil {
u.Errorf("no table? err=%v for=%s", err, table)
}
if len(srcTbl.Columns()) > 0 && len(srcTbl.Fields) == 0 {
// I really don't like where/how this gets called
// needs to be in schema somewhere?
m.inspect(table)
} else {
//u.Warnf("NOT INSPECTING")
}
//u.Infof("found srcTable %v fields?%v", srcTbl.Columns(), len(srcTbl.Fields))
t := schema.NewTable(table, ss)
t.AddField(schema.NewFieldBase("Field", value.StringType, 64, "string"))
t.AddField(schema.NewFieldBase("Type", value.StringType, 64, "string"))
t.AddField(schema.NewFieldBase("Collation", value.StringType, 64, "string"))
t.AddField(schema.NewFieldBase("Null", value.StringType, 64, "string"))
t.AddField(schema.NewFieldBase("Key", value.StringType, 64, "string"))
t.AddField(schema.NewFieldBase("Default", value.StringType, 64, "string"))
t.AddField(schema.NewFieldBase("Extra", value.StringType, 64, "string"))
t.AddField(schema.NewFieldBase("Privileges", value.StringType, 64, "string"))
t.AddField(schema.NewFieldBase("Comment", value.StringType, 64, "string"))
t.SetColumns(schema.DescribeFullCols)
rows := srcTbl.AsRows()
//u.Debugf("found rows: %v", rows)
t.SetRows(rows)
ss.AddTable(t)
m.tableMap[table] = t
return t, nil
}
// NewMemDbForSchema creates a MemDb with given indexes, columns
func NewMemDbForSchema(name string, ss *schema.SchemaSource, cols []string) (*MemDb, error) {
if len(cols) < 1 {
return nil, fmt.Errorf("must have columns provided")
}
m := &MemDb{}
m.tbl = schema.NewTable(name, ss)
ss.AddTable(m.tbl)
if ss.Schema == nil {
m.Schema = schema.NewSchema(name)
m.Schema.AddSourceSchema(ss)
} else {
m.Schema = ss.Schema
}
m.tbl.SetColumns(cols)
err := m.buildDefaultIndexes()
if err != nil {
u.Errorf("Default indexes could not be built %v", err)
return nil, err
}
mdbSchema, err := makeMemDbSchema(m)
if err != nil {
u.Errorf("Must have valid schema %v", err)
return nil, err
}
db, err := memdb.NewMemDB(mdbSchema)
if err != nil {
u.Warnf("could not create db %v", err)
return nil, err
}
m.db = db
return m, nil
}