getViewColumns gets the create statement of a table.
(db *sql.DB, dbName, tblName string)
| 462 | |
| 463 | // getViewColumns gets the create statement of a table. |
| 464 | func getViewColumns(db *sql.DB, dbName, tblName string) ([]string, error) { |
| 465 | query := fmt.Sprintf("SHOW COLUMNS FROM `%s`.`%s`;", dbName, tblName) |
| 466 | // https://dev.mysql.com/doc/refman/8.0/en/show-columns.html |
| 467 | // Field, Type, Null, Key, Default, Extra. |
| 468 | rows, err := db.Query(query) |
| 469 | if err != nil { |
| 470 | return nil, err |
| 471 | } |
| 472 | defer rows.Close() |
| 473 | |
| 474 | var fields []string |
| 475 | for rows.Next() { |
| 476 | var field string |
| 477 | var unused sql.NullString |
| 478 | if err := rows.Scan(&field, &unused, &unused, &unused, &unused, &unused); err != nil { |
| 479 | return nil, err |
| 480 | } |
| 481 | fields = append(fields, field) |
| 482 | } |
| 483 | if err := rows.Err(); err != nil { |
| 484 | return nil, err |
| 485 | } |
| 486 | return fields, nil |
| 487 | } |
| 488 | |
| 489 | // getRoutines gets all routines of a database. |
| 490 | func getRoutines(db *sql.DB, dbName string) ([]*routineSchema, error) { |