
Security News
Vite Releases Technical Preview of Rolldown-Vite, a Rust-Based Bundler
Vite releases Rolldown-Vite, a Rust-based bundler preview offering faster builds and lower memory usage as a drop-in replacement for Vite.
@bpframework/middleware-db
Advanced tools
https://github.com/bpcloud/middleware
import { Application } from 'bpframework';
import * as middleware_db from '@bpframework/middleware-db';
Application.use(middleware_db.middleware)
Application.runKoa(...);
spring.db:
# db type: mysql, mssql
type: mysql
# (optional) timeout of connect to database.
connectTimeout: 5000
# (optional) timeout of query.
queryTimeout: 5000
# (optional) timeout of acquire connection from pool.
acquireTimeout: 5000
# (optional) max queue length of wait for acquire connection.
queueLimit: 200
# (optional) max count of connection in pool.
connectionLimit: 10
# (optional) idle timeout to recreate connect
idleTimeoutMillis: 600000
# database host.
host: 127.0.0.1
# (optional) databse port.
port: 3306
# database name.
database: dbname
# user name of databse.
user: username
# the password of user.
password: password
# (optional) table prefix name.
table_prefix: prefix_
/**
* table model
*/
@Table('tablename')
class Table1Model {
@Column({ type: dataType.Char(32), primaryKey: true })
id: string;
@Column({ type: dataType.VarChar(64) })
col1: string;
@Column({ type: dataType.Bit() })
col2: boolean;
}
/**
* table mapper
*/
class Table1Mapper extends BaseMapper<Table1Model> implements IBaseMapper {
/** Must have this static member */
static Model = Table1Model;
}
@Service()
class DBConfigure {
@Bean()
dbTemplate(): DBTemplate {
return new DBTemplate();
}
}
@Service()
class DBService {
@Autowired("dbTemplate")
dbTemplate: DBTemplate;
async foo(): Promise<void> {
// get mapper.
let mapper: Table1Mapper = this.dbTemplate.getMapper(Table1Mapper);
// query.
let count = await mapper.count('1=1');
console.log(`count: ${count}`);
let exist = await mapper.exist('617a46bf66555e3ea251000001a5da4f');
console.log(`exist: ${exist}`);
let select = await mapper.select(
mapper.condition.equal('id', '617a46bf66555e3ea251000001a5da4f')
);
console.log(`select: ${JSON.stringify(select[0])}`);
let selectById = await mapper.selectById(
'617a46bf66555e3ea251000001a5da4f'
);
console.log(`selectById: ${JSON.stringify(selectById)}`);
// exec.
await this.dbTemplate.exec('select * from tablename');
}
}
FAQs
db middleware of bpframework
The npm package @bpframework/middleware-db receives a total of 16 weekly downloads. As such, @bpframework/middleware-db popularity was classified as not popular.
We found that @bpframework/middleware-db demonstrated a healthy version release cadence and project activity because the last version was released less than 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
Vite releases Rolldown-Vite, a Rust-based bundler preview offering faster builds and lower memory usage as a drop-in replacement for Vite.
Research
Security News
A malicious npm typosquat uses remote commands to silently delete entire project directories after a single mistyped install.
Research
Security News
Malicious PyPI package semantic-types steals Solana private keys via transitive dependency installs using monkey patching and blockchain exfiltration.