storage

type MysqlStorage struct {
	*sql.DB
}

type ResultIterator interface {
	Next() bool
	Get() (principal string, key ssh.PublicKey, err error)
}

type SqlResultIterator struct {
	*sql.Rows
}

type SqliteStorage struct {
	*sql.DB
}

type Storage interface {
	// Record an issuance of type (host or client) to principal with pubkey string
	// Returns an integer ID for the record (ie, database row primary key)
	RecordIssuance(certType uint32, principal string, pubkey ssh.PublicKey) (uint64, error)

	// Query all hostkeys
	QueryHostkeys() (ResultIterator, error)

	// Takes a path to DB migration locations
	Migrate(string) error

	// Record mapping of user identities to github username
	RecordGitHubMapping(mapping map[string]string) error

	// Retrieve github username given sso identity
	QueryGitHubMapping(ssoIdentity string) (string, error)

	Ping() error
	Close() error
}