/
Alex_Ural
/
opencode
Обзор
Документация
Войти
/
Alex_Ural
/
opencode
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
Аналитика
Безопасность
dev
packages/console/core/script/black-select-workspaces.ts
41 строка
1 KB
Kit Langton
fix: resolve oxlint warnings — suppress false positives, remove unused imports (#22687)
16 апр 2026, 04:33
Не верифицирован
16 апр 2026, 04:33
f7d4665
Код
Авторство
О чём код?
import { Database, eq, and, sql, inArray, isNull } from "../src/drizzle/index.js" import { BillingTable, BlackPlans } from "../src/schema/billing.sql.js" import { UserTable } from "../src/schema/user.sql.js" import { AuthTable } from "../src/schema/auth.sql.js" const plan = process.argv[2] as (typeof BlackPlans)[number] if (!BlackPlans.includes(plan)) { console.error("Usage: bun foo.ts <count>") process.exit(1) } const workspaces = await Database.use((tx) => tx .select({ workspaceID: BillingTable.workspaceID }) .from(BillingTable) .where(and(eq(BillingTable.subscriptionPlan, plan), isNull(BillingTable.timeSubscriptionSelected))) .orderBy(sql`RAND()`) .limit(100), ) console.log(`Found ${workspaces.length} workspaces on Black ${plan} waitlist`) console.log("== Workspace IDs ==") const ids = workspaces.map((w) => w.workspaceID) for (const id of ids) { console.log(id) } console.log("\n== User Emails ==") const emails = await Database.use((tx) => tx .select({ email: AuthTable.subject }) .from(UserTable) .innerJoin(AuthTable, and(eq(UserTable.accountID, AuthTable.accountID), eq(AuthTable.provider, "email"))) .where(inArray(UserTable.workspaceID, ids)), ) const unique = new Set(emails.map((row) => row.email)) for (const email of unique) { console.log(email) }