| 373 | } |
| 374 | |
| 375 | func showDatabases(c *sql.DB) ([]string, error) { |
| 376 | rows, err := c.Query("show databases") |
| 377 | if err != nil { |
| 378 | return []string{}, err |
| 379 | } |
| 380 | |
| 381 | defer rows.Close() |
| 382 | |
| 383 | databases := make([]string, 0) |
| 384 | for rows.Next() { |
| 385 | var database string |
| 386 | err = rows.Scan(&database) |
| 387 | if err != nil { |
| 388 | return databases, err |
| 389 | } |
| 390 | |
| 391 | if _, ignored := ignoredDatabases[database]; ignored { |
| 392 | continue |
| 393 | } |
| 394 | |
| 395 | databases = append(databases, database) |
| 396 | } |
| 397 | |
| 398 | return databases, nil |
| 399 | } |
| 400 | |
| 401 | func showTablesFrom(c *sql.DB, dbname string) ([]string, error) { |
| 402 | rows, err := c.Query(fmt.Sprintf("show tables from %s", QuoteField(dbname))) |