@pinelab/vendure-scripts
v1.6.0
Published
Scripts that can be used with Vendure projects
Downloads
248
Readme
Vendure Scripts
Official documentation here
This 'plugin' contains generic scripts that can be used with Vendure
projects. The following scripts are available:
assignAllProductsToChannel
: assigns allProducts
,ProductVariants
,Facets
andFacetValues
from the source channel to the target channel.assignProductsToChannel
: assigns specifiedProducts
with their relatedProductVariants
,Facets
andFacetValues
from the source channel to the target channel.assignCustomersToChannel
: assigns allCustomers
from the source channel to the target channel.assignOrdersToChannel
: assigns allOrders
from the source channel to the target channel.exportDbToFile
andinsertIntoDb
to copy databases from production to test
Assign products to a new channel
This script assigns all products from the source channel to the target channel
import { ModuleRef } from '@nestjs/core';
import { assignAllProductsToChannel } from '@pinelab/vendure-scripts';
import { ChannelService, Injector, bootstrap } from '@vendure/core';
import { getSuperadminContext } from '@vendure/testing/lib/utils/get-superadmin-context';
require('dotenv').config({ path: process.env.ENV_FILE }); // Load env before config
import('../src/vendure-config').then(async ({ config }) => {
const app = await bootstrap(config);
const sourceChannel = await app.get(ChannelService).getDefaultChannel();
const targetChannel = await app
.get(ChannelService)
.getChannelFromToken('colourgraphics');
const injector = new Injector(app.get(ModuleRef));
const ctx = await getSuperadminContext(app);
console.log(
`Assigning all products from ${sourceChannel.code} to ${targetChannel.code}`
);
await assignAllProductsToChannel(
sourceChannel.id,
targetChannel.id,
injector,
ctx
);
await new Promise((resolve) => setTimeout(resolve, 10000)); // Wait for any background tasks or jobs
process.exit(0);
});
Copying a production database to a test database
These scripts allow you to copy all data from a source database to a target database.
- Run the script below
- Optional: Copy over the Vendure assets to your test environment. For Google Cloud we use a transfer job to copy assets to the test bucket.
- Don't forget to disable any syncs to external platforms in your test env. For example, disable sending placed orders to Shipmate to prevent test orders ending up in production third party platforms.
Both exportDbToFile
and insertIntoDb
will prompt you to proceed first, before actually doing anything.
import {
exportDbToFile,
DBConfig,
insertIntoDb,
} from '@pinelab/vendure-scripts';
import fs from 'fs/promises';
import path from 'path';
/**
* @example
*
* yarn ts-node scripts/copy-prod-to-test
*/
(async () => {
// Get Prod env variables
const prodEnv = require('dotenv').parse(
await fs.readFile(path.join(__dirname, '../.env'))
);
const prodConfig: DBConfig = {
databaseName: prodEnv.DB_NAME,
host: prodEnv.DB_HOST,
password: prodEnv.DB_PASSWORD,
username: prodEnv.DB_USER,
};
// Export prod DB to file
const prodSqlFile = await exportDbToFile(prodConfig, '/tmp/prod_db.sql');
// Get Test env variables
const testEnv = require('dotenv').parse(
await fs.readFile(path.join(__dirname, '../.env.test'))
);
const testConfig: DBConfig = {
databaseName: testEnv.DB_NAME,
host: testEnv.DB_HOST,
password: testEnv.DB_PASSWORD,
username: testEnv.DB_USER,
};
// Insert prod DB into test DB
await insertIntoDb(testConfig, prodSqlFile);
console.log(`Copied prod DB to test DB"`);
})();