Security News
ESLint is Now Language-Agnostic: Linting JSON, Markdown, and Beyond
ESLint has added JSON and Markdown linting support with new officially-supported plugins, expanding its versatility beyond JavaScript.
clickhouse-ts
Advanced tools
import { ClickhouseQueryBuilder } from 'clickhouse-sql-client'
const dialect = new ClickhouseQueryBuilder()
const myRawQuery = dialect
.select(b => b.raw('count(article)'))
.from((b) => b.table.name('article_stats'))
.preWhere(b => b
.raw('sold = 0')
.and('date', '=', "toDateTime('1970-02-30')")
).sql()
comeClickhouseClient.query(myRawQuery).toPromise().then(r => process(r))
// SELECT count(article) FROM article_stats PREWHERE sold = 0 AND date = toDateTime('2021-01-01')
dialect.
.select(builder => builder
.raw('name as userName')
.raw('count(id) as rowsCount')
)
// query
dialect.from(b => b.table.name('table_name'))
// subquery
dialect.from(b => b.query
.from(subq => subq.table.name('table_name'))
.select(subq => subq.raw('user_id'))
.preWhere(subq => smth)
.where(subq => smth)
.sql()
)
dialect.where(b => b
.and('user', '=', 'me') // AND user = me
.in('user', ['me', 'you', 'others']) // user IN ('me', 'you', 'others')
.andIn('user', ['me', 'you', 'others']) // AND user IN ('me', 'you', 'others')
.orIn('user', ['me', 'you', 'others']) // OR user IN ('me', 'you', 'others')
.or('value', '<=', 5) // OR value = '5'
.raw('for difficult conditions')
)
dialect.preWhere() // same as where
dialect
.groupBy('raw')
.orderBy('raw')
.limit(5)
.limit('1,2 BY id')
.offset('raw')
.offset(100000)
FAQs
Light stable Clickhouse client
The npm package clickhouse-ts receives a total of 164 weekly downloads. As such, clickhouse-ts popularity was classified as not popular.
We found that clickhouse-ts demonstrated a not healthy version release cadence and project activity because the last version was released a year ago. It has 1 open source maintainer collaborating on the project.
Did you know?
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.
Security News
ESLint has added JSON and Markdown linting support with new officially-supported plugins, expanding its versatility beyond JavaScript.
Security News
Members Hub is conducting large-scale campaigns to artificially boost Discord server metrics, undermining community trust and platform integrity.
Security News
NIST has failed to meet its self-imposed deadline of clearing the NVD's backlog by the end of the fiscal year. Meanwhile, CVE's awaiting analysis have increased by 33% since June.