⚡ Project management that doesn't become the project. Boards, Gantt charts, and GitHub integration. Self-host it or use Kaneo Cloud.
TypeScript honoissue-managementissue-trackerjira-alternativekanbanlinear-alternativemcpproject-managementreactself-hostedtypescript
import { and, eq, type SQLWrapper, sql } from "drizzle-orm";
import { integrationTable } from "../database/schema";
import { projectInActiveWorkspace } from "../workspace/archive/active-workspace-sql";
/** True unless an administrator turned this integration provider off. */
export function integrationProviderEnabled(type: SQLWrapper) {
return sql<boolean>`not exists (
select 1 from "instance_settings" as "provider_settings"
where ${type} = any("provider_settings"."disabled_integrations")
)`;
}
/**
* An integration acts (webhooks in or out, syncs, reminders) only while it is
* enabled, its workspace is not archived, and its provider is not turned off.
* Read in SQL so every API instance sees a change at once.
*/
export function activeIntegrationCondition() {
return and(
eq(integrationTable.isActive, true),
projectInActiveWorkspace(integrationTable.projectId),
integrationProviderEnabled(integrationTable.type),
);
}