mysql

type Adapter struct {
	MySQLClient Client
}

type Client interface {
	GetPage(ctx context.Context, request *Request) (*Response, *framework.Error)
}

type Config struct {
	*config.CommonConfig

	// MySQL database to connect to.
	Database string `json:"database,omitempty"`
}

type Datasource struct {
	Client SQLClient
}

type DefaultSQLClient struct {
	DB *sql.DB
}

type MockSQLClient struct {
	DB   *sql.DB
	Mock sqlmock.Sqlmock
}

type Request struct {
	// BaseURL is the Base URL of the datasource to query.
	BaseURL string

	// Username is the user name used to authenticate with the MySQL instance.
	Username string

	// Password is the password used to authenticate with the MySQL instance.
	Password string

	// PageSize is the maximum number of objects to return from the entity.
	PageSize int64

	// EntityExternalID is the external ID of the entity.
	// The external ID should match the table name on the MySQL database.
	EntityExternalID string

	// Cursor identifies the first object of the page to return, as returned by
	// the last request for the entity.
	// nil in the request for the first page.
	Cursor *int64

	// MySQL database to connect to.
	Database string

	// UniqueAttributeExternalID is used to specify the unique ID that should be used when ordering results from
	// the specified table.
	UniqueAttributeExternalID string
}

type Response struct {
	// StatusCode is an HTTP status code.
	StatusCode int

	// RetryAfterHeader is the Retry-After response HTTP header, if set.
	RetryAfterHeader string

	// Objects is the list of objects returned from the datasource.
	// May be empty.
	Objects []map[string]any

	// NextCursor is the cursor that identifies the first object of the next page.
	// nil if this is the last page in this full sync.
	NextCursor *int64
}

type SQLClient interface {
	Connect(dataSourceName string) error
	Query(query string, args ...any) (*sql.Rows, error)
}

type SQLColumnTypes map[string]string

type SQLRow map[string]string

type SQLRows []SQLRow