Security News
Research
Data Theft Repackaged: A Case Study in Malicious Wrapper Packages on npm
The Socket Research Team breaks down a malicious wrapper package that uses obfuscation to harvest credentials and exfiltrate sensitive data.
A SQL query builder based on Knex with powerful TypeScript type support.
npm install kmore kmore-cli
# Then add one of the following:
npm install pg
npm install mssql
npm install oracle
npm install sqlite3
Edit the package.json
{
"script": {
"build": "tsc -b && npm run db:gen",
"db:gen": "kmore gen --path src/ test/",
"db:gen-cjs": "kmore gen --path src/ test/ --format cjs"
},
}
import { KnexConfig, kmoreFactory, genDbDict } from 'kmore'
// connection config
export const config: KnexConfig = {
client: 'pg',
connection: {
host: 'localhost',
user: 'postgres',
password: 'foo',
database: 'db_ci_test',
},
}
// Define database model
export interface Db {
tb_user: UserDo
tb_user_ext: UserExtDo
}
export interface UserDo {
uid: number
name: string
ctime: Date
}
export interface UserExtDo {
uid: number
age: number
address: string
}
const dict = genDbDict<Db>()
export const km = kmoreFactory({ config, dict })
await km.dbh.schema
.createTable('tb_user', (tb) => {
tb.increments('uid')
tb.string('name', 30)
tb.timestamp('ctime', { useTz: false })
})
.createTable('tb_user_ext', (tb) => {
tb.integer('uid')
tb.foreign('uid')
.references('tb_user.uid')
.onDelete('CASCADE')
.onUpdate('CASCADE')
tb.integer('age')
tb.string('address', 255)
})
.catch((err: Error) => {
assert(false, err.message)
})
// auto generated accessort tb_user() and tb_user_detail()
const { ref_tb_user, ref_tb_user_detail } = km.refTables
await ref_tb_user()
.insert([
{ user_name: 'user1', ctime: new Date() }, // ms
{ user_name: 'user2', ctime: 'now()' }, // μs
])
.then()
const affectedRows = await ref_tb_user_detail()
.insert([
{ uid: 1, age: 10, user_address: 'address1' },
{ uid: 2, age: 10, user_address: 'address1' },
])
.returning('*')
.then()
import { RecordCamelKeys } from '@waiting/shared-types'
// auto generated accessort tb_user() and tb_user_detail()
const { ref_tb_user, ref_tb_user_detail } = km.camelTables
interface UserDO {
user_name: string
ctime: date | string
}
type UserDTO = RecordCamelKeys<UserDO>
const users: UserDTO[] = await ref_tb_user()
.insert([
{ userName: 'user1', ctime: new Date() }, // ms
{ userName: 'user2', ctime: 'now()' }, // μs
])
.returning('*')
.then()
const { refTables } = km
const { tables, scoped } = km.dict
const ret = await refTables.ref_tb_user()
.innerJoin<UserExtDo>(
tables.tb_user_ext,
scoped.tb_user.uid,
scoped.tb_user_ext.uid,
)
.select('*')
.where(scoped.tb_user.uid, 1)
const cols = [
alias.tb_user.uid, // { tbUser: 'tb_user.uid' }
alias.tb_user_ext.uid, // { tbUserExt: 'tb_user_ext.uid' }
]
// --------------
type CT = DbDictType<Db>
type CT_USER = CT['tb_user']
type CT_USER_EXT = CT['tb_user_ext']
const ret = await camelTables.ref_tb_user()
.innerJoin<CT_USER & CT_USER_EXT>(
tables.tb_user_ext,
scoped.tb_user.uid,
scoped.tb_user_ext.uid,
)
.columns(cols)
.then(rows => rows[0])
const cols = {
uid: scoped.tb_user.uid,
foo: scoped.tb_user_ext.uid,
}
const ret = await camelTables.ref_tb_user()
.innerJoin<CT_USER & CT_USER_EXT>(
tables.tb_user_ext,
scoped.tb_user.uid,
scoped.tb_user_ext.uid,
)
.columns(cols)
.then(rows => rows[0])
More examples of join see joint-table
// drop table
await km.dbh.raw(`DROP TABLE IF EXISTS "${tb}" CASCADE;`).then()
// disconnect
await km.dbh.destroy()
@Provide()
export class UserRepo {
@Inject() dbManager: DbManager<'master' | 'slave', Db>
async getUser(uid: number): Promise<UserDTO[]> {
const db = this.dbManager.getDataSource('master')
assert(db)
const { ref_tb_user } = db.camelTables
const user = await ref_tb_user()
.select('*')
.where({ uid })
return user
}
}
kmore is comprised of many specialized packages. This repository contains all these packages. Below you will find a summary of each package.
Package | Version |
---|---|
kmore | |
kmore-types | |
kmore-cli | |
midway-component-kmore |
FAQs
A SQL query builder based on knex with powerful TypeScript type support
The npm package kmore receives a total of 77 weekly downloads. As such, kmore popularity was classified as not popular.
We found that kmore demonstrated a healthy version release cadence and project activity because the last version was released less than a year ago. It has 0 open source maintainers 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
Research
The Socket Research Team breaks down a malicious wrapper package that uses obfuscation to harvest credentials and exfiltrate sensitive data.
Research
Security News
Attackers used a malicious npm package typosquatting a popular ESLint plugin to steal sensitive data, execute commands, and exploit developer systems.
Security News
The Ultralytics' PyPI Package was compromised four times in one weekend through GitHub Actions cache poisoning and failure to rotate previously compromised API tokens.