sqlitedb

type DBTX interface {
	ExecContext(context.Context, string, ...interface{}) (sql.Result, error)
	PrepareContext(context.Context, string) (*sql.Stmt, error)
	QueryContext(context.Context, string, ...interface{}) (*sql.Rows, error)
	QueryRowContext(context.Context, string, ...interface{}) *sql.Row
}

type DeleteDeviceParams struct {
	UserID    string
	PushToken string
}

type DeleteHostByUserParams struct {
	UserID   string
	Provider string
}

type Device struct {
	UserID     string
	PushToken  string
	Platform   string
	CreatedAt  time.Time
	LastSeenAt time.Time
}

type GetHostByUserParams struct {
	UserID   string
	Provider string
}

type Host struct {
	ID            string
	UserID        string
	Provider      string
	ExternalID    string
	Hostname      string
	Status        string
	LastUrl       string
	LastToken     string
	AuthToken     string
	NotifierToken string
	AutoWake      int64
	ProviderMeta  string
	CreatedAt     time.Time
	UpdatedAt     time.Time
}

type InsertHostIfAbsentParams struct {
	ID            string
	UserID        string
	Provider      string
	ExternalID    string
	Hostname      string
	Status        string
	LastUrl       string
	LastToken     string
	AuthToken     string
	NotifierToken string
	AutoWake      int64
	CreatedAt     time.Time
	UpdatedAt     time.Time
}

type Querier interface {
	DeleteDevice(ctx context.Context, arg DeleteDeviceParams) error
	// Used by the dispatcher when Expo returns DeviceNotRegistered for a
	// token; the user_id is irrelevant, the token itself is dead.
	DeleteDeviceByPushToken(ctx context.Context, pushToken string) error
	DeleteHostByID(ctx context.Context, id string) error
	DeleteHostByUser(ctx context.Context, arg DeleteHostByUserParams) error
	GetHostByID(ctx context.Context, id string) (Host, error)
	GetHostByNotifierToken(ctx context.Context, notifierToken string) (Host, error)
	GetHostByUser(ctx context.Context, arg GetHostByUserParams) (Host, error)
	// The cross-instance claim: exactly one concurrent caller inserts;
	// everyone else reads the winner's row back. provider_meta is left to
	// its default (CASProviderMeta is its only writer). ASCII only here:
	// sqlc slices query text by byte offset but counts chars, so a
	// multi-byte character in a comment corrupts every later query.
	InsertHostIfAbsent(ctx context.Context, arg InsertHostIfAbsentParams) (int64, error)
	ListDevicesByUser(ctx context.Context, userID string) ([]Device, error)
	UpsertDevice(ctx context.Context, arg UpsertDeviceParams) error
	UpsertHost(ctx context.Context, arg UpsertHostParams) error
}

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

type UpsertDeviceParams struct {
	UserID     string
	PushToken  string
	Platform   string
	CreatedAt  time.Time
	LastSeenAt time.Time
}

type UpsertHostParams struct {
	ID            string
	UserID        string
	Provider      string
	ExternalID    string
	Hostname      string
	Status        string
	LastUrl       string
	LastToken     string
	AuthToken     string
	NotifierToken string
	AutoWake      int64
	CreatedAt     time.Time
	UpdatedAt     time.Time
}