Jsonjsdb_editor

Jsonjsdb_editor is a tool to transform relationnal tables into a jsonjs database (see https://github.com/bassim-matar/jsonjsdb).

For now it works only with xlsx files as a source, where each file contains one table.

basic examples

simple update

First argument is the path to the source db folder containing the xlsx files. Second argument is the path to the jsonjsdb folder.

import Jsonjsdb_editor from "../../../dist/jsonjsdb_editor.js"

const editor = new Jsonjsdb_editor()
await editor.set_output_db("app_db")
await editor.update_db("db")

inside a vite config file

The Jsonjsdb_watcher is used to watch and update the jsonjsdb. Any time a source db file is updated, the jsonjsdb will be updated and the vite app will reload.

The jsonjsdb_add_config will add the jsonjsdb_config file to the index.html at serve and build time.

import { defineConfig } from "vite"
import FullReload from "vite-plugin-full-reload"
import { Jsonjsdb_watcher, jsonjsdb_add_config } from "jsonjsdb_editor"

await Jsonjsdb_watcher.set_db("app_db")
await Jsonjsdb_watcher.watch("db")
await Jsonjsdb_watcher.update_preview("preview", "data")

export default defineConfig({
  plugins: [
    jsonjsdb_add_config("data/jsonjsdb_config.html"),
    process.env.NODE_ENV &&
      FullReload(Jsonjsdb_watcher.get_db_meta_file_path()),
  ],
})