mysql-qbuilder
Advanced tools
Comparing version
18
index.js
const mysql = require('mysql') | ||
const queryBuilder = require('./lib/QueryBuilder') | ||
// const dbBuilder = require('./lib/DatabaseBuilder') | ||
const queryModel = require('./lib/QueryModel') | ||
@@ -44,10 +43,2 @@ const parameters = require('./lib/Parameters') | ||
// /** | ||
// * [Start to change the Database strcture] | ||
// * @return {DatabaseBuilder} [Database Builder Creator for modify the structure of Table on database] | ||
// */ | ||
// exports.setDatabaseStructure = () => { | ||
// return dbBuilder | ||
// } | ||
/** | ||
@@ -125,3 +116,2 @@ * [Make table scheme and use some common methods] | ||
parameters.prepare() | ||
return this | ||
@@ -136,7 +126,7 @@ } | ||
connection.query(parameters.command, parameters.params, (err, result) => { | ||
if (err) console.log(err) | ||
if (err) throw new Error(err) | ||
}) | ||
} else { | ||
connection.query(parameters.command, (err, result) => { | ||
if (err) console.log(err) | ||
if (err) throw new Error(err) | ||
}) | ||
@@ -153,3 +143,3 @@ } | ||
connection.query(parameters.command, parameters.params, (err, rows, fields) => { | ||
if (err) callback(err, null) | ||
if (err) return callback(err, null) | ||
callback(null, JSON.parse(JSON.stringify(rows))) | ||
@@ -159,3 +149,3 @@ }) | ||
connection.query(parameters.command, (err, rows, fields) => { | ||
if (err) callback(err, null) | ||
if (err) return callback(err, null) | ||
callback(null, JSON.parse(JSON.stringify(rows))) | ||
@@ -162,0 +152,0 @@ }) |
{ | ||
"name": "mysql-qbuilder", | ||
"version": "1.3.2", | ||
"version": "1.3.3", | ||
"description": "Query Builder for MySQL", | ||
@@ -5,0 +5,0 @@ "main": "index.js", |
# mysql-qbuilder | ||
[]() | ||
[]() | ||
[](https://semaphoreapp.com/boennemann/badges) | ||
[]() | ||
[](https://github.com/feross/standard) | ||
[]() | ||
[]() | ||
[]() | ||
[]() | ||
[](https://semaphoreapp.com/boennemann/badges) | ||
[]() | ||
[](https://github.com/feross/standard) | ||
[]() | ||
[]() | ||
## Table of Contents | ||
@@ -17,22 +17,22 @@ | ||
- [Clauses](#clauses) | ||
- [SELECT](#select) | ||
- [INSERT](#insert) | ||
- [FROM Table](#from-table) | ||
- [DELETE](#delete) | ||
- [UPDATE](#update) | ||
- [JOIN](#join) | ||
- [ORDER BY](#order-by) | ||
- [GROUP BY](#group-by) | ||
- [LIMIT](#limit) | ||
- [OFFSET](#offset) | ||
- [WHERE](#where) | ||
- - [SELECT](#select) | ||
- - [INSERT](#insert) | ||
- - [FROM Table](#from-table) | ||
- - [DELETE](#delete) | ||
- - [UPDATE](#update) | ||
- - [JOIN](#join) | ||
- - [ORDER BY](#order-by) | ||
- - [GROUP BY](#group-by) | ||
- - [LIMIT](#limit) | ||
- - [OFFSET](#offset) | ||
- - [WHERE](#where) | ||
- [All Query Builder Functions](#query-builder) | ||
- [How to Execute](#how-to-execute) | ||
- [Query Model](#query-model) | ||
- [Add](#add) | ||
- [Get First](#get-first) | ||
- [Get Last](#get-last) | ||
- [Get All](#get-all) | ||
- [Find by Id](#find-by-id) | ||
- [Find by Fields](#find-by-fields) | ||
- - [Add](#add) | ||
- - [Get First](#get-first) | ||
- - [Get Last](#get-last) | ||
- - [Get All](#get-all) | ||
- - [Find by Id](#find-by-id) | ||
- - [Find by Fields](#find-by-fields) | ||
- [How to write Your own Query](#how-to-write-own-query) | ||
@@ -79,3 +79,3 @@ - [Get Mysql Module](#get-mysql-module) | ||
### Then connecto to database | ||
### Then connect to the database | ||
```JavaScript | ||
@@ -82,0 +82,0 @@ qBuilder.connectToDatabase() |
62621
-0.37%983
-0.81%