258 lines · 5.8 KB · TypeScript
RawDownload
import { relations } from "drizzle-orm";import {	type AnyPgColumn,	boolean,	integer,	jsonb,	pgEnum,	pgTable,	text,} from "drizzle-orm/pg-core";import { createInsertSchema } from "drizzle-zod";import { nanoid } from "nanoid";import { z } from "zod";import { generateAppName } from ".";import { compose } from "./compose";import { deployments } from "./deployment";import { destinations } from "./destination";import { libsql } from "./libsql";import { mariadb } from "./mariadb";import { mongo } from "./mongo";import { mysql } from "./mysql";import { postgres } from "./postgres";import { user } from "./user";export const databaseType = pgEnum("databaseType", [	"postgres",	"mariadb",	"mysql",	"mongo",	"web-server",	"libsql",]); export const backupType = pgEnum("backupType", ["database", "compose"]); export const backups = pgTable("backup", {	backupId: text("backupId")		.notNull()		.primaryKey()		.$defaultFn(() => nanoid()),	appName: text("appName")		.notNull()		.$defaultFn(() => generateAppName("backup"))		.unique(),	schedule: text("schedule").notNull(),	enabled: boolean("enabled"),	database: text("database").notNull(),	prefix: text("prefix").notNull(),	serviceName: text("serviceName"),	destinationId: text("destinationId")		.notNull()		.references(() => destinations.destinationId, { onDelete: "cascade" }),	keepLatestCount: integer("keepLatestCount"),	includeEncryptionKey: boolean("includeEncryptionKey").notNull().default(true),	backupType: backupType("backupType").notNull().default("database"),	databaseType: databaseType("databaseType").notNull(),	composeId: text("composeId").references(		(): AnyPgColumn => compose.composeId,		{			onDelete: "cascade",		},	),	postgresId: text("postgresId").references(		(): AnyPgColumn => postgres.postgresId,		{			onDelete: "cascade",		},	),	mariadbId: text("mariadbId").references(		(): AnyPgColumn => mariadb.mariadbId,		{			onDelete: "cascade",		},	),	mysqlId: text("mysqlId").references((): AnyPgColumn => mysql.mysqlId, {		onDelete: "cascade",	}),	mongoId: text("mongoId").references((): AnyPgColumn => mongo.mongoId, {		onDelete: "cascade",	}),	libsqlId: text("libsqlId").references((): AnyPgColumn => libsql.libsqlId, {		onDelete: "cascade",	}),	userId: text("userId").references(() => user.id),	// Only for compose backups	metadata: jsonb("metadata").$type<		| {				postgres?: {					databaseUser: string;				};				mariadb?: {					databaseUser: string;					databasePassword: string;				};				mongo?: {					databaseUser: string;					databasePassword: string;				};				mysql?: {					databaseRootPassword: string;				};		  }		| undefined	>(),}); export const backupsRelations = relations(backups, ({ one, many }) => ({	destination: one(destinations, {		fields: [backups.destinationId],		references: [destinations.destinationId],	}),	postgres: one(postgres, {		fields: [backups.postgresId],		references: [postgres.postgresId],	}),	mariadb: one(mariadb, {		fields: [backups.mariadbId],		references: [mariadb.mariadbId],	}),	mysql: one(mysql, {		fields: [backups.mysqlId],		references: [mysql.mysqlId],	}),	mongo: one(mongo, {		fields: [backups.mongoId],		references: [mongo.mongoId],	}),	libsql: one(libsql, {		fields: [backups.libsqlId],		references: [libsql.libsqlId],	}),	user: one(user, {		fields: [backups.userId],		references: [user.id],	}),	compose: one(compose, {		fields: [backups.composeId],		references: [compose.composeId],	}),	deployments: many(deployments),})); const createSchema = createInsertSchema(backups, {	backupId: z.string(),	destinationId: z.string(),	enabled: z.boolean().optional(),	prefix: z.string().min(1),	database: z.string().min(1),	schedule: z.string(),	keepLatestCount: z.number().optional(),	databaseType: z.enum([		"postgres",		"mariadb",		"mysql",		"mongo",		"web-server",		"libsql",	]),	postgresId: z.string().optional(),	mariadbId: z.string().optional(),	mysqlId: z.string().optional(),	mongoId: z.string().optional(),	libsqlId: z.string().optional(),	userId: z.string().optional(),	includeEncryptionKey: z.boolean().optional(),	metadata: z.any().optional(),}); export const apiCreateBackup = createSchema.pick({	schedule: true,	enabled: true,	prefix: true,	destinationId: true,	keepLatestCount: true,	database: true,	mariadbId: true,	mysqlId: true,	postgresId: true,	mongoId: true,	libsqlId: true,	databaseType: true,	userId: true,	backupType: true,	composeId: true,	serviceName: true,	includeEncryptionKey: true,	metadata: true,}); export const apiFindOneBackup = z.object({	backupId: z.string().min(1),}); export const apiRemoveBackup = createSchema	.pick({		backupId: true,	})	.required(); export const apiUpdateBackup = createSchema	.pick({		schedule: true,		enabled: true,		prefix: true,		backupId: true,		destinationId: true,		database: true,		keepLatestCount: true,		serviceName: true,		metadata: true,		databaseType: true,	})	.required()	.extend({		includeEncryptionKey: z.boolean().optional(),	}); export const apiRestoreBackup = z.object({	databaseId: z.string(),	databaseType: z.enum([		"postgres",		"mysql",		"mariadb",		"mongo",		"web-server",		"libsql",	]),	backupType: z.enum(["database", "compose"]),	databaseName: z.string().min(1),	backupFile: z.string().min(1),	destinationId: z.string().min(1),	metadata: z		.object({			serviceName: z.string().optional(),			postgres: z				.object({					databaseUser: z.string(),				})				.optional(),			mariadb: z				.object({					databaseUser: z.string(),					databasePassword: z.string(),				})				.optional(),			mongo: z				.object({					databaseUser: z.string(),					databasePassword: z.string(),				})				.optional(),			mysql: z				.object({					databaseRootPassword: z.string(),				})				.optional(),		})		.optional(),});

Keyboard shortcuts

General

Show keyboard shortcuts
?
Focus the current search
/

Issues and pull requests

Open filters
f

Issues, pull requests and Inbox

Select next item
j↓
Select previous item
k↑
Open selected item
Enter
Dismiss filters or clear selection
Esc

Repository code

Go to file
t