mysql

package

v0.1.6 Latest Latest Go to latest Published: May 25, 2026 License: MIT Imports: 3 Imported by: 0

Details

Package mysql provides database schema introspection for MySQL and MariaDB databases.

This section is empty.

This section is empty.

This section is empty.

type Inspector struct {
	DB *sql.DB
}

Inspector implements schema introspection for MySQL / MariaDB.

func New(db *sql.DB) *Inspector

New returns a new MySQL Inspector.

func (i *Inspector) Columns(ctx context.Context, tableName string) ([]string, error)

Columns returns column descriptors for tableName in "name|type|pk" format, where pk is "1" for primary-key columns, "0" otherwise.

func (i *Inspector) Relations(ctx context.Context, tableName string) ([]string, error)

Relations returns foreign-key descriptors for tableName in "fromCol -> targetTable.targetCol" format.

func (i *Inspector) Tables(ctx context.Context) ([]string, error)

Tables returns all user-defined table names in the current database.