Skip to content

Rapid SQL query generator extension for node. It provides an abstraction over SQL database to migrate JSON Schemas into DB. and provide methods to query the database.

Notifications You must be signed in to change notification settings

DeveshPankaj/untitled-model

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

1 Commit
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Untitled-model Documentation

Rapid sql query generator extention for node.

NPM Version NPM Downloads

Installation

This is a Node.js module available through the npm registry.

Before installing, download and install Node.js. Node.js 0.10 or higher is required.

Installation is done using the npm install command:

$ npm install untitled-model
test installation
$ node
> var model = require('untitled-model')
>

Follow our installing guide for more information.

Features

  • Mysql database support
  • Fetching data from database from sql
  • Fetching data from relational database [foreign key]
  • row SQL query [ all / filter / values / update / delete ]
Security Issues

If you discover a security vulnerability in untitled-model, please see Security Policies and Procedures.

Quick Start

Start new project

$ mkdir myWeb && cd myWeb
$ node init
$ node i untitled-model

Create model:

# make sure your current dir should be ~/myWeb/
$ mkdir models
$ touch ./models/user.json
User model :

Copy and past this inside ~/models/user.json

{
  "id" : {"dtype":"int","primary":true,"unique":true,"size":8,"auto-inc":true},
  "name" : {"dtype":"string","size":100},
  "address" : {"dtype":"text"},
  "password" : {"dtype":"string","size":100,"secure":true}
}

Migrating models

/myWeb/test.js

var model = require('untitled-model');
model.connection(
    {   
        host: "localhost",
        user: "root",
        password: "",
        database:"test"
    }
);
model.migrate('user.json');

Philosophy

The untitled-model philosophy is to provide a tool for programmers to send and receive data to and from sql database. Migrate function is use to generate tables inside database. It supports relational database foreign key concept.

foreign key

department.json

{
    "id" : {"dtype":"int","primary":true,"auto-inc":true},
    "name" : {"dtype":"string","size":100}
}

user.json

{
    "id" : {"dtype":"int","primary":true,"unique":true,"size":8,"auto-inc":true},
    "name" : {"dtype":"string","size":100},
    "address" : {"dtype":"text"},
    "password" : {"dtype":"string","size":100,"secure":true},
    "department":{"dtype":"foreign", "model":"department"}
 }

Functions

  • User = model.get('user')

         User = { 
          model: 'user',
          all: [Function],
          filter: [Function],
          values: [Function],
          update: [Function],
          insert: [Function],
          delete: [Function] ,
          
          m: { 
                model: 'user',
                select: [],
                FILTER: [],
                join: '',
                buffer: [],
                show: [Function],
                value: [Function],
                filter_: [Function],
                values: [Function],
                filters: [Function],
                rename: [Function] 
            },
         }
  • User.all(callback) requires sql connection
       // It returns data to callback unction
       all(callback){
         let table = this.model;
         let project = this.m.select;
         . . .
         . . .
         query = "select " +select+" from " + table ;
         . . . 
         callback(error, data);
       }
    
    Example:
    
      User.all(function(err,data){
       if(e) throw e;
       console.log(data);
      });
  • User.filter({},callback) requires sql connection
        // It returns data to callback unction
        filter({id:5},callback){
          let table = this.model;
          let project = this.m.select;
          . . .
          . . .
          query = "select " +select+" from " + table + " WHERE " + filters;
          . . . 
          callback(error, data);
        } 
     
     Example:
       User.filter({'id': 2},callback);
       User.filter({'id > ': 2},callback);
       User.filter({'id': 2,'name':'someone'},callback);
       
       User.filter({'id': 2},function(err,data){
           if(err) throw err;
           console.log(data);
       });
  • User.values(['attr']) sql projection
    • use __ for foreign table
          // It returns data to callback unction
          function(select=[]){
            . . .
            _set_select_vlaues_
            . . . 
            return this.m;
          }
          
          Example:
                User = User.values(['name','department__name'])
                User.all((error, data)=>{
                    if(error) throw error;
                    console.log(data);
                });
                 
                         // or
                  
                User = User.values(['name','department__name'])
                User.filter({id:5},(error, data)=>{
                    if(error) throw error;
                    console.log(data);
                })
  • update({}) returns model
        User.update({name:'pankaj'}).filter({name:'pankajdevesh'},(e, data)=>{
            if(e) throw  e;
            console.log(data);
        });
  • insert({}, callback) insert into database
          User.insert({name:'javascript'},(error, data)=>{
            if(error) throw error;
            console.log(data);
          });
  • delete().filter({},callback) delete from database
          User.delete().filter({id:5},(error, data)=>{
            if(error) throw error;
            console.log(data);
          });

License

MIT

About

Rapid SQL query generator extension for node. It provides an abstraction over SQL database to migrate JSON Schemas into DB. and provide methods to query the database.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published