tableschema-sql-js

KO | EN

gitlite — search

#javascript #python #hacktoberfest #react #ai #typescript #llm #go #golang #android #machine-learning #rust #deep-learning #linux

tableschema-sql-js

★ 8 Open GitHub ↗

Library for converting JSON Table Schema to an SQL table, for Node and the browser.

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

# jts-sql-js
Library for converting JSON Table Schema to an SQL table, for Node and the browser.

## Usage

Here's an example of using ``jts-sql-js``:

```
var Sequelize = require('sequelize');
var SchemaTable = require('jts-sql-js').SchemaTable;
var streamify = require('stream-array'); // only needed to turn array -> stream

// your rows of data - maybe you loaded these from a CSV :-)
var data = [
  {'foo': 3, 'bar': 'YES'},
  {'foo': 5, 'bar': 'NO'}
];

// this is your JSON Table Schema - http://dataprotocols.org/json-table-schema/
var schema = {
  'fields': [
    {
      'name': 'foo',
      'type': 'integer'
    },
    {
      'name': 'bar',
      'type': 'string',
      'constraints': {
          'required': true,
          'enum': ['YES', 'NO']
      }
    }
  ]
};

var engine = new Sequelize('datastore', 'datastore', '', {
  dialect: 'sqlite',
  storage: './example.db'
});

var table = SchemaTable(engine, 'foo_table', schema);
table.create().then(function () {
  table.load_iter(streamify(data));
});

```

## Tests

`npm test`

tableschema-sql-js

Explore Similar Repositories

Was this content helpful?

Recent Feedback

Download README