apptypes

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

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

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
	TableSystemGTFSSourceMDB    TableSpec
	TableSystemGTFSSourceCustom 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 `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 `json:"sqlite_db,omitempty"`       // Filesystem path for the SQLite DB, if "" uses default of ~/.cache/mobsql/sqlite.db
	AllowFileURIs           bool   `json:"allow_file_uris,omitempty"` // Whether to allow loading CSV/GTFS feeds from local filepaths (file:// URIs)
	LogInfo                 bool   `json:"log_info,omitempty"`        // Whether to enable info messages
	LogWarn                 bool   `json:"log_warn,omitempty"`        // Whether to enable warning messages
	LogDebug                bool   `json:"log_debug,omitempty"`       // Whether to enable debug messages

	SchemaExtra *SchemaExtra `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 TableSpec struct {
	Table     string
	UniqueSet []string
	Columns   []LoadColumn
	Indexes   [][]string
	Optional  bool
}

type View struct {
	Name               string
	SQLCreateStatement string
	Doc                string
}