apptypes

type ComputedTable struct {
	Name          string
	Doc           string
	View          string
	SourcePair    bool
	CacheOnTables []string
	TableSpec     TableSpec
}

type LoadColumn struct {
	Column     string
	DType      uint
	Required   bool
	Check      string
	Enum       []int
	Conversion func(s string) (any, error)
}

type LoadSchema struct {
	TablesGTFS          []LoadTable
	TableSystemTracking TableSpec
	TableSystemMDB      TableSpec
	ViewsSystem         []View
}

type LoadTable struct {
	File      string
	Doc       string
	TableSpec TableSpec
}

type MobsqlRuntime struct {
	DB          *sqlx.DB
	Schema      LoadSchema
	SchemaExtra *SchemaExtra // Extra SQL schema configuration (views & computed tables config)
}

type RuntimeConfig struct {
	MobilityDBCatalogCSVURI string `yaml:"mdb_csv,omitempty" json:"mdb_csv,omitempty"`                 // URI (file:// or http://) of Mobility Database Catalog CSV URI (use load custom GTFS), default Mobility DB bit.ly
	SQLiteDBPath            string `yaml:"sqlite_db,omitempty" json:"sqlite_db,omitempty"`             // Filesystem path for the SQLite DB, if "" uses default of ~/.cache/mobsql/sqlite.db
	AllowFileURIs           bool   `yaml:"allow_file_uris,omitempty" json:"allow_file_uris,omitempty"` // Whether to allow loading CSV/GTFS sources from local filepaths (file:// URIs)
	LogInfo                 bool   `yaml:"log_info,omitempty" json:"log_info,omitempty"`               // Whether to enable info messages
	LogWarn                 bool   `yaml:"log_warn,omitempty" json:"log_warn,omitempty"`               // Whether to enable warning messages
	LogDebug                bool   `yaml:"log_debug,omitempty" json:"log_debug,omitempty"`             // Whether to enable debug messages

	SchemaExtra *SchemaExtra `yaml:"-" json:"-"` // Extra SQL schema configuration (views & computed tables config)
}

type SchemaExtra struct {
	InitExec       string          // Arbitrary SQL to execute at initialization (can be used for pragmas etc.)
	TablesComputed []ComputedTable // Computed table specifications to create
	Views          []View          // SQL views to create
}

type SourcesetOpResult struct {
	Operation string `json:"operation"` // Name of operation (compute/purge/load)
	Success   bool   `json:"success"`   // Whether the operation was successful
	Mdbids    []int  `json:"mdbids"`    // Array of mdbids matched / performed against
}

type TableSpec struct {
	Table     string
	UniqueSet []string
	Columns   []LoadColumn
	Indexes   [][]string
	Optional  bool
}

type View struct {
	Name               string
	SQLCreateStatement string
	Doc                string
}