Socket
Socket
Sign inDemoInstall

dbgate-plugin-csv

Package Overview
Dependencies
0
Maintainers
1
Versions
116
Alerts
File Explorer

Advanced tools

Install Socket

Detect and block malicious and high-risk dependencies

Install

    dbgate-plugin-csv

CSV import/export plugin for DbGate


Version published
Weekly downloads
40
decreased by-60.4%
Maintainers
1
Created
Weekly downloads
 

Changelog

Source

5.2.3

  • ADDED: Search entire table (multi column filter) #491
  • ADDED: OracleDB - connection to toher than default ports #496
  • CHANGED: OracleDB - status of support set to experimental
  • FIXED: OracleDB database URL - fixes: Connect to default Oracle database #489
  • ADDED: HTML, XML code highlighting for Edit cell value #485
  • FIXED: Intellisense - incorrect alias after ORDER BY clause #484
  • FIXED: Typo in SQL-Generator #481
  • ADDED: Data duplicator #480
  • FIXED: MongoDB - support for views #476
  • FIXED: "SQL:CREATE TABLE" generated SQL default value syntax errors #455
  • FIXED: Crash when right-clicking on tables #452
  • FIXED: View sort #436
  • ADDED: Arm64 version for Windows #473
  • ADDED: Sortable query results and data archive
  • CHANGED: Use transactions for saving table data
  • CHANGED: Save table structure uses transactions
  • ADDED: Table data editing - shows editing mark
  • ADDED: Editing data archive files
  • FIXED: Delete cascade options when using more than 2 tables
  • ADDED: Save to current archive commands
  • ADDED: Current archive mark is on status bar
  • FIXED: Changed package used for parsing JSONL files when browsing - fixes backend freezing
  • FIXED: SSL option for mongodb #504
  • REMOVED: Data sheet editor
  • FIXED: Creating SQLite autoincrement column
  • FIXED: Better error reporting from exports/import/dulicator
  • CHANGED: Optimalizede OracleDB analysing algorithm
  • ADDED: Mutli column filter for perspectives
  • FIXED: Fixed some scenarios using tables from different DBs
  • FIXED: Sessions with long-running queries are not killed

Readme

Source

styled with prettier NPM version

dbgate-plugin-csv

CSV import/export plugin for DbGate

Usage without DbGate

Export from fake object reader into CSV file. Fake object file can be replaced with other reader/writer factory functions, as described in dbgate-api package

const dbgateApi = require('dbgate-api');
const dbgatePluginCsv = require("dbgate-plugin-csv");

dbgateApi.registerPlugins(dbgatePluginCsv);


async function run() {
  const reader = await dbgateApi.fakeObjectReader();
  const writer = await dbgatePluginCsv.shellApi.writer({ fileName: 'myfile1.csv', separator: ';' });
  await dbgateApi.copyStream(reader, writer);
  
  console.log('Finished job script');
}
dbgateApi.runScript(run);


Factory functions

shellApi.reader

Reads CSV file

  const dbgatePluginCsv = require("dbgate-plugin-csv");
  const reader = await dbgatePluginCsv.shellApi.reader({
    fileName: 'test.csv',
    encoding: 'utf-8',
    header: true,
    delimiter: ',',
    quoted: false,
    limitRows: null
  });

shellApi.writer

Writes CSV file

  const dbgatePluginCsv = require("dbgate-plugin-csv");
  const writer = await dbgatePluginCsv.shellApi.writer({
    fileName: 'test.csv',
    encoding: 'utf-8',
    header: true,
    delimiter: ',',
    quoted: false
  });

Keywords

FAQs

Last updated on 27 Feb 2023

Did you know?

Socket for GitHub automatically highlights issues in each pull request and monitors the health of all your open source dependencies. Discover the contents of your packages and block harmful activity before you install or update your dependencies.

Install

Related posts

SocketSocket SOC 2 Logo

Product

  • Package Alerts
  • Integrations
  • Docs
  • Pricing
  • FAQ
  • Roadmap

Stay in touch

Get open source security insights delivered straight into your inbox.


  • Terms
  • Privacy
  • Security

Made with ⚡️ by Socket Inc