react-sql-operation-function-builder

Package helps you to generate simple and complex sql friendly operations and functions. Can use multiple sql table columns. also helps to build non sql syntax

Getting Started

Make sure you have include bootstrap in your project.

You can simply generate syntax like

  POWER((Round(col-1) * 22) + ((col-2*10)/100), 2) 

npm -i react-sql-operation-function-builder

demo

Live demo

import React, { Component } from 'react'
import Operation from 'react-sql-operation-function-builder'
class App extends Component {

  constructor(props) {
      super(props);
      this.state = {
       
      };
  }

  render() {
    return (<div className='col-md-8'>
      <Operation
         type={'ALL'}
         value={this.state.value}
         attributes={[
                {name: 'col-1', source_alias: 'tab1', source_name:'tableOne'},
                {name: 'col-2', source_alias: 'tab1', source_name:'tableOne'},
                {name: 'column-1', source_alias: 'tab2', source_name:'tableTwo'}
         ]}
         onChange={(e) => {console.log('value', e); this.setState({value:e})}}/>               
    </div>)
  }
}

export default App;

props

Prop	Description	Default
value	syntax	''
onChange
type	type of functions ('STRING','NUMBER', 'DATE','ALL')	ALL
attributes	table columns, can have multiple tables and columns, source name and source alias name is mandatory	[]

Acknowledgments

*antd *viswanath lekshmanan