主要是测试下typeorm与node-oracledb thin 模式的集成
环境准备
- docker-compose 文件
version: '3'
services:
db:
image: gvenzl/oracle-xe:21.3.0-slim
ports:
- "1521:1521"
environment:
- ORACLE_PASSWORD=Ccda5662E
- APP_USER=dalong
- APP_USER_PASSWORD=Ccda5662E
typeorm 集成
- entity.js
const EntitySchema = require("typeorm").EntitySchema
module.exports = new EntitySchema({
name: "sensor", // Will use table name `category` as default behaviour.
tableName: "sensor", // Optional: Provide `tableName` property to override the default behaviour for table name.
columns: {
id: {
primary: true,
type: "varchar",
},
name: {
type: "varchar",
},
address: {
type: "varchar"
}
}
})
- datasource.js
const typeorm = require("typeorm")
/**
* data store operation for sensor data
*/
const dataSource = new typeorm.DataSource({
type: "oracle",
username: "dalong",
password: "Ccda5662E",
connectString:"127.0.0.1/XEPDB1",
synchronize: true,
entities: [require("./entity")],
})
module.exports = dataSource
- index.js
const dataSource = require('./datasource')
async function run() {
const dataSourceInstance = await dataSource.initialize()
if(dataSourceInstance.isInitialized) {
const sensorRepository = dataSourceInstance.getRepository('sensor')
let body = {
id: 11,
name: 'test',
address: 'test',
status: true
}
let saveResult = await sensorRepository.save(body)
console.log(saveResult)
dataSourceInstance.destroy()
}
}
run();
说明
node-oracledb typeorm 的集成还是比较方便的，没有什么问题
参考资料
https://github.com/oracle/node-oracledb
http://typeorm.io/#/