package main

import (
  "context"
  "fmt"
  "strings"
  "time"

  "github.com/redis/go-redis/v9"
)

var ctx = context.Background()

var rdb *redis.Client

func main() {
  rdb = redis.NewClient(&redis.Options{
    Addr:     "localhost:6379",
    Password: "",
    DB:       0,
  })

  Listen()
}

func Listen() {
  val, err := rdb.BLPop(ctx, 0, "jobs").Result()

  if err != nil {
    panic(err)
  }

  fmt.Println(Mask(val[1]))

  Listen()
}

func Mask(str string) string {
  time.Sleep(time.Second * 5)

  return strings.Repeat("*", len(str))
}

ALTER TABLE activity_log ADD COLUMN email VARCHAR(255)
  GENERATED ALWAYS as (properties->>"$.request.email");

SELECT * FROM `users` WHERE name = 'Faye';

SELECT id, name FROM `users` WHERE name = 'Faye';

nano ~/.bashrc

alias pma='xdg-open http://127.0.0.1:8001 && php -S 127.0.0.1:8001 -t /home/dreamweaver/phpmyadmin'

-- All the rows, everybody knows that!
SELECT COUNT(*) FROM users;
-- How many developers each company has.
SELECT company_id, COUNT(*) FROM `users` GROUP BY company_id;
-- How many verified users we have. (=not null values)
SELECT COUNT(verified_at) as verified_users FROM users;
-- How many languages should we support?
SELECT COUNT(DISTINCT language) FROM users;