mysql

Documentation

Index

• Variables

Variables

var (
	// NewReader for MySQL databases
	NewReader = infos.New(
		infos.WithPlaceholder(func(int) string { return "?" }),
		infos.WithSequences(false),
		infos.WithCheckConstraints(false),
		infos.WithCustomClauses(map[infos.ClauseName]string{
			infos.ColumnsDataType:                 "column_type",
			infos.ColumnsNumericPrecRadix:         "10",
			infos.FunctionColumnsNumericPrecRadix: "10",
			infos.ConstraintIsDeferrable:          "''",
			infos.ConstraintInitiallyDeferred:     "''",
			infos.PrivilegesGrantor:               "''",
			infos.ConstraintJoinCond:              "AND r.referenced_table_name = f.table_name",
		}),
		infos.WithSystemSchemas([]string{"mysql", "information_schema", "performance_schema", "sys"}),
		infos.WithCurrentSchema("COALESCE(DATABASE(), '%')"),
		infos.WithUsagePrivileges(false),
	)
	// NewCompleter for MySQL databases
	NewCompleter = func(db drivers.DB, opts ...completer.Option) readline.AutoCompleter {
		readerOpts := []metadata.ReaderOption{

			metadata.WithTimeout(3 * time.Second),
			metadata.WithLimit(1000),
		}
		reader := NewReader(db, readerOpts...)
		opts = append([]completer.Option{
			completer.WithReader(reader),
			completer.WithDB(db),
			completer.WithSQLStartCommands(append(completer.CommonSqlStartCommands, "USE")),
			completer.WithBeforeComplete(complete(reader)),
		}, opts...)
		return completer.NewDefaultCompleter(opts...)
	}
)