@vorlefan/prisma-backup

Export all the databse models into json files and use them as backup

Usage no npm install needed!

<script type="module">
  import vorlefanPrismaBackup from 'https://cdn.skypack.dev/@vorlefan/prisma-backup';
</script>

README

Prisma Backup

Use this module to create a backup measure for your project that uses Prisma. You can either backup the information, or use them to migrate to another database, or just to reset the database. Example: Let's say that you need to change a unique key (email) to another like (code). You can backup first, then change the schema.prisma, and use this module to inject the old information.

In truth, this work with any database, ORM and etc, the only thing you need is that the models returns a Object (that has as value a array of objects).

https://badgen.net/bundlephobia/minzip/@vorlefan/prisma-backup]

With npm do:

npm install @vorlefan/prisma-backup

With yarn do:

yarn add  @vorlefan/prisma-backup

Documentation

A better documentation will be made at the near future.

import { runBackup, getBackup } from '@vorlefan/prisma-backup';

// The 'backup' function is async and has these properties

export type BackupProps = {
    encrypt?: boolean; // true to encrypt data
    password?: string; // if encrypt is true, then is required
    folder?: string; // folder that will be saved the data generated
    models:  Record<string, Array<Record<any, any>>>; // models from prisma
    onRoute?: (route: PathRoute) => any; // define the route save
    backupFolderName?: string; // backup folder name that will be generated, by default is 'Date.now()'
};

await runBackup(props: BackupProps)

// To get the bakcup

export type GetBackupProps = {
    password?: string; // if is encrypted, then is required
    folder?: string; // the general folder, by default is '.db'
    backupFolderName?: string; // instend of getting the most recent folder of backup, you can define to get from one
    onRoute?: (route: PathRoute) => any; // define the route
    onCurrentModel: GetBackupOnCurrentModelProps; // async function to handle each model
};

await getBackup(props: GetBackupProps)

Highlight

  • Create json backup of your database in fragments
  • Easy to setup and choose what models to backup
  • You can encrypt your backup with a password
  • Method to handle the importing of backup data

Example

Please, take a look at the 'example/backup_test/.db' folder of this repository

import { PrismaClient } from '@prisma/client';
import { runBackup } from '@vorlefan/prisma-backup';

const prisma = new PrismaClient();

void (async function () {
    const [user] = await prisma.$transaction([prisma.user.findMany({})]);

    // w/out encrypt

    await runBackup({
        models: {
            user,
        },
    });

    // w/ encrypt

    await runBackup({
        models: {
            user,
        },
        encrypt: true,
        password: 'pwd123',
    });
})();

Splitting models

import { PrismaClient } from '@prisma/client';
import { runBackup } from '@vorlefan/prisma-backup';
import { BackupModels } from '@vorlefan/prisma-backup/dist/types/backup';

const prisma = new PrismaClient();

function chunk(array: Array<any>, size = 2) {
    return Array.from(
        {
            length: Math.ceil(array.length / size),
        },
        (v, i) => array.slice(i * size, i * size + size)
    );
}

void (async function () {
    const user = await prisma.user.findMany();

    const models: BackupModels = {};

    const users = chunk(user, 2);

    users.map((model, i) => {
        const key = `user_${i}`;
        models[key] = model;
    });

    await runBackup({
        models,
        backupFolderName: 'user',
    });
})();

Get the backup data, example

import { getBackup } from '@vorlefan/prisma-backup';

await getBackup({
    onCurrentModel: async function ({ instance, currentModel, currentFile }) {
        if (currentFile.name === 'user') {
            const data = currentModel;
            await instance.route.json().store({
                routeName: '@',
                filename: `${Date.now().toString(16)}.json`, /// `${data.name}.json`,
                data,
            });
        }
    },
    folder: '.db',
    onRoute: function (route) {
        route.remove('root');
        route.set('root', route.resolve(__dirname, '..'));
    },
    password: 'pwd123',
    backupFolderName: 'encrypted',
});