geostore

type Country struct {
	orm.ShortID

	StatusField      string `db:"status"`
	Iso2CodeField    string `db:"iso2_code"`
	Iso3CodeField    string `db:"iso3_code"`
	NameField        string `db:"name"`
	ContinentField   string `db:"continent"`
	PhonePrefixField string `db:"phone_prefix"`

	CreatedAtField orm.CreatedAt
	UpdatedAtField orm.UpdatedAt
	soft_delete.SoftDeletesMaxDate
	// contains filtered or unexported fields
}

type CountryQueryOptions struct {
	ID          string
	IDIn        []string
	Status      string
	StatusIn    []string
	Iso2        string
	Iso3        string
	Offset      int
	Limit       int
	SortOrder   string
	OrderBy     string
	CountOnly   bool
	WithDeleted bool
}

type NewStoreOptions struct {
	CountryTableName   string
	StateTableName     string
	TimezoneTableName  string
	DB                 *sql.DB
	AutomigrateEnabled bool
	AutoseedEnabled    bool
}

type State struct {
	orm.ShortID

	StatusField      string `db:"status"`
	CountryCodeField string `db:"country_code"`
	StateCodeField   string `db:"state_code"`
	NameField        string `db:"name"`

	CreatedAtField orm.CreatedAt
	UpdatedAtField orm.UpdatedAt
	soft_delete.SoftDeletesMaxDate
	// contains filtered or unexported fields
}

type StateQueryOptions struct {
	ID          string
	Status      string
	StatusIn    []string
	CountryCode string
	StateCode   string
	Offset      int
	Limit       int
	SortOrder   string
	OrderBy     string
	CountOnly   bool
	WithDeleted bool
}

type StoreInterface interface {
	// GetCountryTableName returns the country table name
	GetCountryTableName() string
	// SetCountryTableName sets the country table name
	SetCountryTableName(countryTableName string)

	// GetStateTableName returns the state table name
	GetStateTableName() string
	// SetStateTableName sets the state table name
	SetStateTableName(stateTableName string)

	// GetTimezoneTableName returns the timezone table name
	GetTimezoneTableName() string
	// SetTimezoneTableName sets the timezone table name
	SetTimezoneTableName(timezoneTableName string)

	// MigrateUp creates all database tables
	MigrateUp(ctx context.Context, tx ...*sql.Tx) error

	// MigrateDown drops all database tables
	MigrateDown(ctx context.Context, tx ...*sql.Tx) error

	// Seed populates all tables with initial data
	Seed(ctx context.Context, tx ...*sql.Tx) error

	EnableDebug(debug bool)

	CountryCreate(ctx context.Context, country *Country) error
	CountryDelete(ctx context.Context, country *Country) error
	CountryDeleteByID(ctx context.Context, countryID string) error
	CountryFindByID(ctx context.Context, countryID string) (*Country, error)
	CountryFindByIso2(ctx context.Context, iso2Code string) (*Country, error)
	CountryList(ctx context.Context, options CountryQueryOptions) ([]Country, error)
	CountrySoftDelete(ctx context.Context, country *Country) error
	CountrySoftDeleteByID(ctx context.Context, countryID string) error
	CountryUpdate(ctx context.Context, country *Country) error

	StateCreate(ctx context.Context, state *State) error
	StatesCreate(ctx context.Context, states []*State) error
	StateList(ctx context.Context, options StateQueryOptions) ([]State, error)

	TimezoneCreate(ctx context.Context, timezone *Timezone) error
	TimezoneList(ctx context.Context, options TimezoneQueryOptions) ([]Timezone, error)
}

type Timezone struct {
	orm.ShortID

	StatusField      string `db:"status"`
	TimezoneField    string `db:"timezone"`
	ZoneNameField    string `db:"zone_name"`
	GlobalNameField  string `db:"global_name"`
	CountryCodeField string `db:"country_code"`
	OffsetField      string `db:"offset"`

	CreatedAtField orm.CreatedAt
	UpdatedAtField orm.UpdatedAt
	soft_delete.SoftDeletesMaxDate
	// contains filtered or unexported fields
}

type TimezoneQueryOptions struct {
	ID          string
	Status      string
	StatusIn    []string
	CountryCode string
	Timezone    string
	Offset      int
	Limit       int
	SortOrder   string
	OrderBy     string
	CountOnly   bool
	WithDeleted bool
}