persistence.go 1.8 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667
  1. package auth
  2. import (
  3. "context"
  4. "strings"
  5. "github.com/owncast/owncast/core/data"
  6. "github.com/owncast/owncast/core/user"
  7. "github.com/owncast/owncast/db"
  8. )
  9. var _datastore *data.Datastore
  10. // Setup will initialize auth persistence.
  11. func Setup(db *data.Datastore) {
  12. _datastore = db
  13. createTableSQL := `CREATE TABLE IF NOT EXISTS auth (
  14. "id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
  15. "user_id" TEXT NOT NULL,
  16. "token" TEXT NOT NULL,
  17. "type" TEXT NOT NULL,
  18. "timestamp" DATE DEFAULT CURRENT_TIMESTAMP NOT NULL,
  19. FOREIGN KEY(user_id) REFERENCES users(id)
  20. );`
  21. _datastore.MustExec(createTableSQL)
  22. _datastore.MustExec(`CREATE INDEX IF NOT EXISTS idx_auth_token ON auth (token);`)
  23. }
  24. // AddAuth will add an external authentication token and type for a user.
  25. func AddAuth(userID, authToken string, authType Type) error {
  26. return _datastore.GetQueries().AddAuthForUser(context.Background(), db.AddAuthForUserParams{
  27. UserID: userID,
  28. Token: authToken,
  29. Type: string(authType),
  30. })
  31. }
  32. // GetUserByAuth will return an existing user given auth details if a user
  33. // has previously authenticated with that method.
  34. func GetUserByAuth(authToken string, authType Type) *user.User {
  35. u, err := _datastore.GetQueries().GetUserByAuth(context.Background(), db.GetUserByAuthParams{
  36. Token: authToken,
  37. Type: string(authType),
  38. })
  39. if err != nil {
  40. return nil
  41. }
  42. var scopes []string
  43. if u.Scopes.Valid {
  44. scopes = strings.Split(u.Scopes.String, ",")
  45. }
  46. return &user.User{
  47. ID: u.ID,
  48. DisplayName: u.DisplayName,
  49. DisplayColor: int(u.DisplayColor),
  50. CreatedAt: u.CreatedAt.Time,
  51. DisabledAt: &u.DisabledAt.Time,
  52. PreviousNames: strings.Split(u.PreviousNames.String, ","),
  53. NameChangedAt: &u.NamechangedAt.Time,
  54. AuthenticatedAt: &u.AuthenticatedAt.Time,
  55. Scopes: scopes,
  56. }
  57. }