mirror of
https://github.com/idanoo/go-mastodon-stats
synced 2025-07-01 05:42:19 +00:00
89 lines
2.7 KiB
Go
89 lines
2.7 KiB
Go
package gomastodonstats
|
|
|
|
// Host information
|
|
var (
|
|
POSTGRESQL_HOST string
|
|
POSTGRESQL_USER string
|
|
POSTGRESQL_PASS string
|
|
POSTGRESQL_STATS_DB string
|
|
POSTGRESQL_STATS_TABLE = "statsdb"
|
|
|
|
MYSQL_HOST string
|
|
MYSQL_USER string
|
|
MYSQL_PASS string
|
|
|
|
TIMEZONE string
|
|
|
|
MATRIX_WEBHOOK_URL string
|
|
MATRIX_WEBHOOK_API_KEY string
|
|
MATRIX_WEBHOOK_CHANNEL string
|
|
|
|
MASTODON_CLIENT_NAME = "go-mastodon-stats"
|
|
MASTODON_INSTANCE_URL string
|
|
MASTODON_CLIENT_ID string
|
|
MASTODON_CLIENT_SECRET string
|
|
MASTODON_CLIENT_USERNAME string
|
|
MASTODON_CLIENT_PASSWORD string
|
|
|
|
// UserCount metric name
|
|
METRICNAME_USERCOUNT = "userCount"
|
|
METRICNAME_1W_USERCOUNT = "userCount1W"
|
|
|
|
// This is hardcoded because.. well configs are annoying
|
|
SERVICE_LINKS = map[string]string{
|
|
PIXELFED_IDENTIFIER: "https://pixelfed.nz",
|
|
MATRIX_IDENTIFIDER: "https://mtrx.nz",
|
|
MASTODON_IDENTIFIER: "https://mastodon.nz",
|
|
TINKERNZ_IDENTIFIER: "https://tinker.nz",
|
|
MOBILIZON_IDENTIFIER: "https://openevents.nz",
|
|
PEERTUBE_IDENTIFIER: "https://peertube.nz",
|
|
BOOKWYRM_IDENTIFIER: "https://bookworm.nz",
|
|
CALCKEY_IDENTIFIER: "https://firefish.nz",
|
|
WRITEAS_IDENTIFIER: "https://write.nz",
|
|
}
|
|
|
|
// Pixelfed
|
|
PIXELFED_DB_SCHEMA string
|
|
PIXELFED_USER_QUERY = "SELECT count(*) FROM users WHERE status IS NULL;"
|
|
PIXELFED_IDENTIFIER = "pixelfed"
|
|
|
|
// Matrix
|
|
MATRIX_DB_SCHEMA string
|
|
MATRIX_USER_QUERY = "SELECT count(*) FROM users WHERE deactivated = 0;"
|
|
MATRIX_IDENTIFIDER = "matrix"
|
|
|
|
// Mastodon
|
|
MASTODON_DB_SCHEMA string
|
|
MASTODON_USER_QUERY = "SELECT count(*) FROM users WHERE disabled = False AND confirmed_at IS NOT NULL AND approved = True;"
|
|
MASTODON_1W_ACTIVE_USER_QUERY = "SELECT count(*) FROM users WHERE disabled = False AND confirmed_at IS NOT NULL AND approved = True AND current_sign_in_at >= now() - interval '1 week';"
|
|
MASTODON_IDENTIFIER = "mastodon"
|
|
|
|
// Mastodon 2
|
|
TINKERNZ_DB_SCHEMA string
|
|
TINKERNZ_IDENTIFIER = "tinkernz"
|
|
|
|
// Mobilizon
|
|
MOBILIZON_DB_SCHEMA string
|
|
MOBILIZON_USER_QUERY = "SELECT count(*) FROM users WHERE disabled = False;"
|
|
MOBILIZON_IDENTIFIER = "mobilizon"
|
|
|
|
// Peertube
|
|
PEERTUBE_DB_SCHEMA string
|
|
PEERTUBE_USER_QUERY = "SELECT count(*) FROM \"user\" WHERE blocked = False;"
|
|
PEERTUBE_IDENTIFIER = "peertube"
|
|
|
|
// BookWyrm
|
|
BOOKWYRM_DB_SCHEMA string
|
|
BOOKWYRM_USER_QUERY = "SELECT count(*) FROM bookwyrm_user WHERE local = True AND is_active = True;"
|
|
BOOKWYRM_IDENTIFIER = "bookwyrm"
|
|
|
|
// Calckey
|
|
CALCKEY_DB_SCHEMA string
|
|
CALCKEY_USER_QUERY = `SELECT count(*) FROM "user" WHERE "isDeleted" = False and "host" IS NULL;`
|
|
CALCKEY_IDENTIFIER = "calckey"
|
|
|
|
// Write.as
|
|
WRITEAS_DB_SCHEMA string
|
|
WRITEAS_USER_QUERY = `SELECT count(*) FROM users WHERE status = 0`
|
|
WRITEAS_IDENTIFIER = "writeas"
|
|
)
|