metastore

type Meta struct {
	ID         string     `db:"id"`
	ObjectType string     `db:"object_type"`
	ObjectID   string     `db:"object_id"`
	Key        string     `db:"meta_key"`
	Value      string     `db:"meta_value"`
	CreatedAt  time.Time  `db:"created_at"`
	UpdatedAt  time.Time  `db:"updated_at"`
	DeletedAt  *time.Time `db:"deleted_at"`
}

type NewStoreOptions struct {
	MetaTableName      string
	DB                 *sql.DB
	AutomigrateEnabled bool
	DebugEnabled       bool
}

type Store struct {
	// contains filtered or unexported fields
}

type StoreInterface interface {
	// MigrateDown drops the meta table
	MigrateDown(ctx context.Context, tx ...*sql.Tx) error

	// MigrateUp creates the meta table
	MigrateUp(ctx context.Context, tx ...*sql.Tx) error

	// EnableDebug enables or disables debug logging
	EnableDebug(debug bool)

	// FindByKey finds a meta entry by object type, object ID, and key
	FindByKey(objectType string, objectID string, key string) (*Meta, error)

	// Get retrieves a value by object type, object ID, and key
	Get(objectType string, objectID string, key string, valueDefault string) (string, error)

	// GetJSON retrieves and unmarshals a JSON value by object type, object ID, and key
	GetJSON(objectType string, objectID string, key string, valueDefault interface{}) (interface{}, error)

	// Remove deletes a meta entry by object type, object ID, and key
	Remove(objectType string, objectID string, key string) error

	// Set stores a string value for a given object type, object ID, and key
	Set(objectType string, objectID string, key string, value string) error

	// SetJSON marshals and stores a JSON value for a given object type, object ID, and key
	SetJSON(objectType string, objectID string, key string, value interface{}) error

	// GetMetaTableName returns the meta table name
	GetMetaTableName() string

	// GetDB returns the database connection
	GetDB() *sql.DB

	// IsAutomigrateEnabled returns whether automigrate is enabled
	IsAutomigrateEnabled() bool
}