Socket
Book a DemoInstallSign in
Socket

@jasperalani/mysql-query-builder

Package Overview
Dependencies
Maintainers
1
Versions
1
Alerts
File Explorer

Advanced tools

Socket logo

Install Socket

Detect and block malicious and high-risk dependencies

Install

@jasperalani/mysql-query-builder

MySQL Query Builder

latest
Source
npmnpm
Version
1.0.0
Version published
Maintainers
1
Created
Source

MySQL Query Builder

Functions that values and return SQL ready to be queried.

Languages

  • Javascript
  • Typescript
  • Go

In the future:

  • PHP

Functions

select insert update delete

Todo

  • Create test files
  • Improve typescript syntax

Usage

Javascript:

queryBuilder.select(['id', 'name'], 'my_table', 'id = 6');

queryBuilder.insert(['name', 'deleted'], ['Jasper', false], 'my_table');

queryBuilder.update(['name', 'deleted'], ['Yasper', true], 'id = 6', 'my_table');

queryBuilder.delete('id = 6', 'my_table');

Typescript:

const columns: Columns = {
    columns: [
        {value: 'id'},
        {value: 'name'},
        {value: 'deleted'}
    ]
}

const values: Values = {
    values: [
        {value: 6},
        {value: 'value'},
        {value: false}
    ]
}

queryBuilder.insert(columns, values, 'my_table');

queryBuilder.select(columns, 'my_table', 'id = 6');

queryBuilder.update(columns, values, 'id = 6', 'my_table');

queryBuilder.delete('id = 6', 'my_table');

Keywords

MySQL

FAQs

Package last updated on 01 Oct 2020

Did you know?

Socket

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