jsonverse - npm Package Compare versions

Comparing version 1.3.1 to 1.3.2

index.js

@@ -16,2 +16,4 @@ /*!
 const colors = require("./lib/colors");
+const ExcelJS = require("exceljs");
+const json2xls = require("json2xls");
 
@@ -117,4 +119,2 @@ function formatDateTime(date) {
 
-
-
   // Encrypt sensitive data
@@ -341,2 +341,6 @@ encrypt(data, secretKey) {
       this.logSuccess(`Data exported to CSV: ${filePath}`);
+    } else if (format === "xlsx") {
+      // Export as XLSX using exceljs
+      const filePath = this.getFilePath(dataName + ".xlsx");
+      await this.writeDataToXLSX(filePath, data);
     }
@@ -358,2 +362,10 @@ }
       this.logSuccess(`Data imported from CSV: ${filePath}`);
+    } else if (format === "xlsx") {
+      // Import XLSX data using exceljs
+      const xlsxData = await this.readXLSX(filePath);
+      await this.writeDataByFileName(dataName, xlsxData);
+      this.logSuccess(`Data imported from XLSX: ${filePath}`);
+    } else {
+      // Handle unsupported file format
+      this.logError(`Unsupported file format: ${format}`);
     }
@@ -389,2 +401,76 @@ }
 
+  // Function to read data from an XLSX file using exceljs
+  async readXLSX(filePath) {
+    try {
+      const workbook = new ExcelJS.Workbook();
+      await workbook.xlsx.readFile(filePath);
+      const worksheet = workbook.getWorksheet(1); // Assuming there's only one sheet
+
+      const data = [];
+      worksheet.eachRow((row, rowNumber) => {
+        if (rowNumber !== 1) {
+          const rowData = row.values.map((cell) => cell);
+          data.push(rowData);
+        }
+      });
+
+      return data;
+    } catch (error) {
+      this.logError(`Reading XLSX file: ${error}`);
+      return null;
+    }
+  }
+
+  // Helper method to write data to an XLSX file using exceljs
+  async writeDataToXLSX(filePath, data) {
+    const workbook = new ExcelJS.Workbook();
+    const worksheet = workbook.addWorksheet("Sheet1");
+
+    // Add headers to the worksheet
+    if (data.length > 0) {
+      const headers = Object.keys(data[0]);
+      worksheet.addRow(headers);
+    }
+
+    // Add data rows to the worksheet
+    data.forEach((row) => {
+      worksheet.addRow(Object.values(row));
+    });
+
+    await workbook.xlsx.writeFile(filePath);
+    this.logSuccess(`Data exported to XLSX: ${filePath}`);
+  }
+
+  // Export Data to XLSX
+  async exportDataToXLSX(dataName) {
+    const data = await this.readData(dataName);
+
+    // Check if the data is empty
+    if (data.length === 0) {
+      this.logError(`No data to export in ${dataName}.`);
+      return;
+    }
+
+    // Create an XLSX object from the JSON data
+    const xls = json2xls(data);
+
+    // Specify the file path where the XLSX file will be saved
+    const filePath = this.getFilePath(dataName + ".xlsx");
+
+    try {
+      // Save the XLSX data to the file
+      fs.writeFileSync(filePath, xls, "binary");
+      this.logSuccess(`Data exported to XLSX: ${filePath}`);
+    } catch (error) {
+      this.logError(`Failed to export data to XLSX: ${error}`);
+    }
+  }
+
+  // Function to convert XLS data to JSON
+  async xlsToJSON(xlsData) {
+    const wb = XLSX.read(xlsData, { type: "buffer" });
+    const ws = wb.Sheets[wb.SheetNames[0]]; // Assuming there's only one sheet
+    return XLSX.utils.sheet_to_json(ws);
+  }
+
   isCacheExpired(dataName) {
@@ -391,0 +477,0 @@ const CACHE_EXPIRATION_TIME = 10 * 60 * 1000; // 10 minutes in milliseconds

package.json

 {
   "name": "jsonverse",
-  "version": "1.3.1",
+  "version": "1.3.2",
   "description": "jsonVerse is a lightweight JSON-based database package for Node.js. It provides a simple interface to store, retrieve, and manage data using JSON files.",
@@ -25,3 +25,3 @@ "main": "index.js",
   ],
-  "homepage": "https://github.com/Marco5dev/jsonverse#readme",
+  "homepage": "https://jsonversedb.web.app",
   "keywords": [
@@ -70,4 +70,6 @@ "JSON",
     "dateformat": "^5.0.3",
+    "exceljs": "^4.3.0",
     "fuse.js": "^6.6.2",
-    "json2csv": "^6.0.0-alpha.2"
+    "json2csv": "^6.0.0-alpha.2",
+    "json2xls": "^0.1.2"
   },
@@ -74,0 +76,0 @@ "devDependencies": {

README.md

@@ -5,3 +5,9 @@ # jsonVerse
 
-[![Node.js Package NPM](https://github.com/Marco5dev/jsonverse/actions/workflows/npm-publish.yml/badge.svg)](https://github.com/Marco5dev/jsonverse/actions/workflows/npm-publish.yml)
+[![Build](https://github.com/Marco5dev/jsonverse/actions/workflows/npm-publish.yml/badge.svg)](https://github.com/Marco5dev/jsonverse/actions/workflows/npm-publish.yml)
+[![NPM Version](https://img.shields.io/npm/v/jsonverse.svg)](https://www.npmjs.com/package/jsonverse)
+[![NPM Downloads](https://img.shields.io/npm/dt/jsonverse.svg)](https://www.npmjs.com/package/jsonverse)
+[![Github Repo Size](https://img.shields.io/github/repo-size/Marco5dev/jsonverse.svg)](https://github.com/Marco5dev/jsonverse)
+[![LICENSE](https://img.shields.io/npm/l/jsonverse.svg)](https://github.com/Marco5dev/jsonverse/blob/master/LICENSE)
+[![Contributors](https://img.shields.io/github/contributors/Marco5dev/jsonverse.svg)](https://github.com/Marco5dev/jsonverse/graphs/contributors)
+[![Commit](https://img.shields.io/github/last-commit/Marco5dev/jsonverse.svg)](https://github.com/Marco5dev/jsonverse/commits/master)
 
@@ -8,0 +14,0 @@ ## Introduction

No alert changes

Improved metrics

Total package byte prevSize

32391

11.63%

Lines of code

650

13.04%

Number of lines in readme file

235

2.62%

Worsened metrics

Dependency count

7

40%

Dependency changes

• + Added

  exceljs@^4.3.0

• + Added

  json2xls@^0.1.2

• + Added

  @fast-csv/format@4.3.5
  (transitive)

• + Added

  @fast-csv/parse@4.3.6
  (transitive)

• + Added

  @types/node@14.18.63
  (transitive)

• + Added

  archiver@5.3.2
  (transitive)

• + Added

  archiver-utils@2.1.03.0.4
  (transitive)

• + Added

  async@3.2.6
  (transitive)

• + Added

  balanced-match@1.0.2
  (transitive)

• + Added

  base64-js@1.5.1
  (transitive)

• + Added

  big-integer@1.6.52
  (transitive)

• + Added

  binary@0.3.0
  (transitive)

• + Added

  bl@4.1.0
  (transitive)

• + Added

  bluebird@3.4.7
  (transitive)

• + Added

  brace-expansion@1.1.122.0.2
  (transitive)

• + Added

  buffer@5.7.1
  (transitive)

• + Added

  buffer-crc32@0.2.13
  (transitive)

• + Added

  buffer-indexof-polyfill@1.0.2
  (transitive)

• + Added

  buffers@0.1.1
  (transitive)

• + Added

  chainsaw@0.1.0
  (transitive)

• + Added

  compress-commons@4.1.2
  (transitive)

• + Added

  concat-map@0.0.1
  (transitive)

• + Added

  core-util-is@1.0.3
  (transitive)

• + Added

  crc-32@1.2.2
  (transitive)

• + Added

  crc32-stream@4.0.3
  (transitive)

• + Added

  dayjs@1.11.13
  (transitive)

• + Added

  duplexer2@0.1.4
  (transitive)

• + Added

  end-of-stream@1.4.5
  (transitive)

• + Added

  excel-export@0.3.11
  (transitive)

• + Added

  exceljs@4.4.0
  (transitive)

• + Added

  fast-csv@4.3.6
  (transitive)

• + Added

  fs-constants@1.0.0
  (transitive)

• + Added

  fs.realpath@1.0.0
  (transitive)

• + Added

  fstream@1.0.12
  (transitive)

• + Added

  glob@7.2.3
  (transitive)

• + Added

  graceful-fs@4.2.11
  (transitive)

• + Added

  ieee754@1.2.1
  (transitive)

• + Added

  immediate@3.0.6
  (transitive)

• + Added

  inflight@1.0.6
  (transitive)

• + Added

  inherits@2.0.4
  (transitive)

• + Added

  isarray@1.0.0
  (transitive)

• + Added

  json2xls@0.1.2
  (transitive)

• + Added

  jszip@2.5.03.10.1
  (transitive)

• + Added

  lazystream@1.0.1
  (transitive)

• + Added

  lie@3.3.0
  (transitive)

• + Added

  listenercount@1.0.1
  (transitive)

• + Added

  lodash.defaults@4.2.0
  (transitive)

• + Added

  lodash.difference@4.5.0
  (transitive)

• + Added

  lodash.escaperegexp@4.1.2
  (transitive)

• + Added

  lodash.flatten@4.4.0
  (transitive)

• + Added

  lodash.groupby@4.6.0
  (transitive)

• + Added

  lodash.isboolean@3.0.3
  (transitive)

• + Added

  lodash.isequal@4.5.0
  (transitive)

• + Added

  lodash.isfunction@3.0.9
  (transitive)

• + Added

  lodash.isnil@4.0.0
  (transitive)

• + Added

  lodash.isplainobject@4.0.6
  (transitive)

• + Added

  lodash.isundefined@3.0.1
  (transitive)

• + Added

  lodash.union@4.6.0
  (transitive)

• + Added

  lodash.uniq@4.5.0
  (transitive)

• + Added

  minimatch@3.1.25.1.6
  (transitive)

• + Added

  minimist@1.2.8
  (transitive)

• + Added

  mkdirp@0.5.6
  (transitive)

• + Added

  node-zip@1.1.1
  (transitive)

• + Added

  normalize-path@3.0.0
  (transitive)

• + Added

  once@1.4.0
  (transitive)

• + Added

  pako@0.2.91.0.11
  (transitive)

• + Added

  path-is-absolute@1.0.1
  (transitive)

• + Added

  process-nextick-args@2.0.1
  (transitive)

• + Added

  readable-stream@2.3.83.6.2
  (transitive)

• + Added

  readdir-glob@1.1.3
  (transitive)

• + Added

  rimraf@2.7.1
  (transitive)

• + Added

  safe-buffer@5.1.2
  (transitive)

• + Added

  saxes@5.0.1
  (transitive)

• + Added

  setimmediate@1.0.5
  (transitive)

• + Added

  string_decoder@1.1.1
  (transitive)

• + Added

  tar-stream@2.2.0
  (transitive)

• + Added

  tmp@0.2.3
  (transitive)

• + Added

  traverse@0.3.9
  (transitive)

• + Added

  unzipper@0.10.14
  (transitive)

• + Added

  util-deprecate@1.0.2
  (transitive)

• + Added

  uuid@8.3.2
  (transitive)

• + Added

  wrappy@1.0.2
  (transitive)

• + Added

  xmlchars@2.2.0
  (transitive)

• + Added

  zip-stream@4.1.1
  (transitive)