Database diagrams editor that allows you to visualize and design your DB with a single query.
TypeScript databasedbdb-migrationeditorerdmariadbmssqlmysqlpostgresqlreactreact-flowschema-migrationssqlsqlitetypescriptvisualizationxyflow
import { z } from 'zod';
import type { CheckConstraintDiff } from './check-constraint-diff';
import { createCheckConstraintDiffSchema } from './check-constraint-diff';
import type { FieldDiff } from './field-diff';
import { createFieldDiffSchema } from './field-diff';
import type { IndexDiff } from './index-diff';
import { createIndexDiffSchema } from './index-diff';
import type { RelationshipDiff } from './relationship-diff';
import { createRelationshipDiffSchema } from './relationship-diff';
import type { TableDiff } from './table-diff';
import { createTableDiffSchema } from './table-diff';
import type { AreaDiff } from './area-diff';
import { createAreaDiffSchema } from './area-diff';
import type { NoteDiff } from './note-diff';
import { createNoteDiffSchema } from './note-diff';
import type {
DBCheckConstraint,
DBField,
DBIndex,
DBRelationship,
DBTable,
Area,
Note,
} from '..';
export type ChartDBDiff<
TTable = DBTable,
TField = DBField,
TIndex = DBIndex,
TCheckConstraint = DBCheckConstraint,
TRelationship = DBRelationship,
TArea = Area,
TNote = Note,
> =
| TableDiff<TTable>
| FieldDiff<TField>
| IndexDiff<TIndex>
| CheckConstraintDiff<TCheckConstraint>
| RelationshipDiff<TRelationship>
| AreaDiff<TArea>
| NoteDiff<TNote>;
export const createChartDBDiffSchema = <
TTable = DBTable,
TField = DBField,
TIndex = DBIndex,
TCheckConstraint = DBCheckConstraint,
TRelationship = DBRelationship,
TArea = Area,
TNote = Note,
>(
tableSchema: z.ZodType<TTable>,
fieldSchema: z.ZodType<TField>,
indexSchema: z.ZodType<TIndex>,
checkConstraintSchema: z.ZodType<TCheckConstraint>,
relationshipSchema: z.ZodType<TRelationship>,
areaSchema: z.ZodType<TArea>,
noteSchema: z.ZodType<TNote>
): z.ZodType<
ChartDBDiff<
TTable,
TField,
TIndex,
TCheckConstraint,
TRelationship,
TArea,
TNote
>
> => {
return z.union([
createTableDiffSchema(tableSchema),
createFieldDiffSchema(fieldSchema),
createIndexDiffSchema(indexSchema),
createCheckConstraintDiffSchema(checkConstraintSchema),
createRelationshipDiffSchema(relationshipSchema),
createAreaDiffSchema(areaSchema),
createNoteDiffSchema(noteSchema),
]) as z.ZodType<
ChartDBDiff<
TTable,
TField,
TIndex,
TCheckConstraint,
TRelationship,
TArea,
TNote
>
>;
};
export type DiffMap<
TTable = DBTable,
TField = DBField,
TIndex = DBIndex,
TCheckConstraint = DBCheckConstraint,
TRelationship = DBRelationship,
TArea = Area,
TNote = Note,
> = Map<
string,
ChartDBDiff<
TTable,
TField,
TIndex,
TCheckConstraint,
TRelationship,
TArea,
TNote
>
>;
export type DiffObject<
TTable = DBTable,
TField = DBField,
TIndex = DBIndex,
TCheckConstraint = DBCheckConstraint,
TRelationship = DBRelationship,
TArea = Area,
TNote = Note,
> =
| TableDiff<TTable>['object']
| FieldDiff<TField>['object']
| IndexDiff<TIndex>['object']
| CheckConstraintDiff<TCheckConstraint>['object']
| RelationshipDiff<TRelationship>['object']
| AreaDiff<TArea>['object']
| NoteDiff<TNote>['object'];
type ExtractDiffKind<T> = T extends { object: infer O; type: infer Type }
? T extends { attribute: infer A }
? { object: O; type: Type; attribute: A }
: { object: O; type: Type }
: never;
export type DiffKind<
TTable = DBTable,
TField = DBField,
TIndex = DBIndex,
TCheckConstraint = DBCheckConstraint,
TRelationship = DBRelationship,
TArea = Area,
TNote = Note,
> = ExtractDiffKind<
ChartDBDiff<
TTable,
TField,
TIndex,
TCheckConstraint,
TRelationship,
TArea,
TNote
>
>;
export const isDiffOfKind = <
TTable = DBTable,
TField = DBField,
TIndex = DBIndex,
TCheckConstraint = DBCheckConstraint,
TRelationship = DBRelationship,
TArea = Area,
TNote = Note,
>(
diff: ChartDBDiff<
TTable,
TField,
TIndex,
TCheckConstraint,
TRelationship,
TArea,
TNote
>,
kind: DiffKind<
TTable,
TField,
TIndex,
TCheckConstraint,
TRelationship,
TArea,
TNote
>
): boolean => {
if ('attribute' in kind) {
return (
diff.object === kind.object &&
diff.type === kind.type &&
diff.attribute === kind.attribute
);
}
if ('attribute' in diff) {
return false;
}
return diff.object === kind.object && diff.type === kind.type;
};