open-index/open-npm huggingface dataset:
npm package: @redsuperadmin/postgres-query-builder
Description: A PostgreSQL query builder for NodeJS
Author: Karan Singh Gill
Latest version: 1.0.8

# PostgreSQL query builder for Node

A PostgreSQL query builder for NodeJS. 

## Installation

```javascript
npm install @redsuperadmin/postgres-query-builder
```

## Usage guide
It implements async/await.
### Simple select

```javascript
const {select} = require('@redsuperadmin/postgres-query-builder')

const products = await select("*")
.from("product")
.where("product_id", ">", 1)
.execute(pool);
```
### More complex where
```javascript
const {select} = require('@redsuperadmin/postgres-query-builder')

const products = await select("*")
.from("product")
.where("product_id", ">", 1)
.and("sku", "LIKE", "sku")
.execute(pool);
```
### Event more complex where
```javascript
const {select} = require('@redsuperadmin/postgres-query-builder')

const query = select("*").from("product");
query.where("product_id", ">", 1).and("sku", "LIKE", "sku");
query.orWhere("price", ">", 100);

const products = await query.execute(pool);
```

### Join table
```javascript
const {select} = require('@redsuperadmin/postgres-query-builder')

const query = select("*").from("product");
query.leftJoin('price').on('product.`product_id`', '=', 'price.`product_id`');
query.where("product_id", ">", 1).and("sku", "LIKE", "sku");
query.andWhere("price", ">", 100);

const products = await query.execute(pool);
```

### Insert&update
<table>
<tr>
<th> user_id </th>
<th> name </th>
<th> email </th>
<th> phone </th>
<th> status </th>
</tr>
<tr>
<td>
  1
</td>
<td>
  David
</td>
<td>
  emai@email.com
</td>
<td>
  123456
</td>
<td>
  1
</td>
</tr>
</table>

```javascript
```javascript
const {insert} = require('@redsuperadmin/postgres-query-builder')

const query = insert("user")
.given({name: "David", email: "email@email.com", "phone": "123456", status: 1, notExistedColumn: "This will not be a part of the query"});
await query.execute(pool);
```
```javascript
const {update} = require('@redsuperadmin/postgres-query-builder')

const query = update("user")
.given({name: "David", email: "email@email.com", "phone": "123456", status: 1, notExistedColumn: "This will not be a part of query"})
.where("user_id", "=", 1);
await query.execute(pool);
```
### Working with transaction

```javascript
const { Pool } = require('pg');
const {insert, getConnection, startTransaction, commit, rollback} = require('@redsuperadmin/postgres-query-builder');

const pool = new Pool(connectionSetting);

// Create a connection from the pool
const connection = await getConnection(pool);

// Start a transaction
await startTransaction(connection);
try {
  await insert("user")
        .given({name: "David", email: "email@email.com", "phone": "123456", status: 1, notExistedColumn: "This will not be a part of the query"})
        .execute(connection);
  await commit(connection);
} catch(e) {
  await rollback(connection);
}
```
## Security

All user provided data will be escaped.
npm package: @redswap/eslint-config-redswap
Description: Eslint config for RedSwap
Author: RabbitDoge
Latest version: 0.0.1

# eslint-config-librax

LibraX Eslint config with:

- Airbnb config
- Typescript
- Prettier

## Usage

```
npx install-peerdeps --dev @librax/eslint-config-librax
```

Add `"extends": "@librax/eslint-config-librax"` to your eslint config file.
npm package: @redswap/token-lists
Description: This repo contains main LibraX token list and tools to validate it.
Latest version: 0.0.1

# LibraX Token Lists

This repo contains main LibraX token list and tools to validate it.

## How to add external lists

URLs to external lists are stored in `token-lists.json`, if you want your list to be available on upcoming list UI page - submit a PR modifying `token-lists.json`.

## How to add new lists within this repository

- Add an array of tokens under `src/tokens`
- Add `checksum:newlistname`, `generate:newlistname`, `makelist:newlistname` command to `package.json` analogous to LibraX default and extended list scripts.
- Modify `checksum.ts`, `buildList.ts`, `ci-check.ts`, and `default.test.ts` to handle new list

## How to add new tokens to LibraX (extended) token list

Note - this is not something we expect pull requests for.  
Unless you've been specifically asked by someone from PCS team please do no submit PRs to be listed on default PCS list. You can still trade your tokens on PCS exchange by pasting your address into the token field.

- Add new tokens to `src/tokens/librax-extended.json` file
- Run `yarn makelist:pcs-extended`
  - By default new list will have patch version number bumped by 1 (e.g. `2.0.1` -> `2.0.2`).
  - If you want to bump minor version add `minor` after makelist command `yarn makelist:pcs-extended minor`
  - If you want to bump major version add `major` after makelist command `yarn makelist:pcs-extended major`
- If tests pass - new token list will be created under `lists` directory

For list to be considered valid it need to satisfy the following criteria:

- It passes [token list schema](https://github.com/Uniswap/token-lists/blob/master/src/tokenlist.schema.json) validation (schema is [slightly modified](src/schema.ts))
- There are no duplicate addresses, symbols or token names in the list
- All addresses are valid and checksummed (`yarn checksum:pcs` automatically converts addresses to checksummed versions, it is also part of `yarn makelist:pcs`)

## How to update Top100 Token list

Note - this is not something we expect pull requests for.

```shell script
# Fetch the Top100 Tokens on LibraX v2, and update list.
$ yarn fetch:pcs-top-100

# Build token list (pancakeswap-top-100.json)
$ yarn makelist:pcs-top-100
```

## Deploying

Token lists will be auto-deployed via netlify when PR is merged to master. Be sure to build the list with `yarn makelist:list-name` before submitting/merging the PR since it doesn't make much sense building lists within Netlify (because most errors are related to wrong token information and should be fixed prior to landing into master)

Netlify simply takes the json files under `lists` directory and hosts them on `tokens.pancakeswap.finance/list-name.json`
npm package: @redswap/uikit
Description: Set of UI components for RedSwap projects
Latest version: 0.0.2

# 🌟 LibraX UIkit

[![Version](https://img.shields.io/npm/v/@librax/uikit)](https://www.npmjs.com/package/@librax/uikit) [![Size](https://img.shields.io/bundlephobia/min/@librax/uikit)](https://www.npmjs.com/package/@librax/uikit)

LibraX UIkit is a set of React components and hooks used to build pages on LibraX's apps. It also contains a theme file for dark and light mode.

## Install

`yarn add @librax/uikit`


## Setup

### Theme

Before using LibraX UIkit, you need to provide the theme file to styled-component.

```
import { ThemeProvider } from 'styled-components'
import { light, dark } from '@librax/uikit'
...
<ThemeProvider theme={isDark}>...</ThemeProvider>
```

### Reset

A reset CSS is available as a global styled component.

```
import { ResetCSS } from '@librax/uikit'
...
<ResetCSS />
```

### Types

This project is built with Typescript and export all the relevant types.