import { Injectable, Logger } from '@nestjs/common';
import { DataSource, Repository } from 'typeorm';
import { DynamicEntity } from '../../entity/dynamic.entity'; // 引入占位实体
import { DataGlobalService } from './dataGlobal.service';
@Injectable()
export class DataSourceService {
private readonly logger = new Logger(DataSourceService.name);
constructor(private dataGlobalService: DataGlobalService) {}
public async connect(
uuid: string,
config: {
type: 'my
sql' | 'ms
sql' | 'postgres' | '
sqlite';
host: string;
port:
number;
username: string;
password: string;
database: string;
},
): Promise<DataSource> {
const existing = this.dataGlobalService.dataSources.find((o) => o.uuid === uuid);
if (existing) {
return existing.dataSource;
}
const typeormConfig = {
type: config.type,
host: config.host,
port: config.port,
username: config.username,
password: config.password,
database: config.database,
entities: [DynamicEntity],
synchronize: false,
logging: false,
...this.getDatabaseSpecificConfig(config.type),
};
try {
const dataSource = new DataSource(typeormConfig);
await dataSource.initialize();
this.logger.log(`Connected to database ${config.type}://${config.database} with UUID=${uuid}`);
this.dataGlobalService.dataSources.push({ uuid, dataSource });
return dataSource;
} catch (error) {
this.logger.error(`Failed to initialize DataSource for ${uuid}:`, error.stack);
throw new Error(`Connection failed: ${error.message}`);
}
}
private getDatabaseSpecificConfig(dbType: string): Record<string, any> {
switch (dbType) {
case 'my
sql':
return {
extra: {
charset: 'utf8mb4',
collate: 'utf8mb4_unicode_ci',
},
};
case 'ms
sql':
return {
options: {
encrypt: true,
trustServerCertificate: true,
},
};
case 'postgres':
return {
ssl: false,
};
default:
return {};
}
}
public getRepository(uuid: string): Repository<any> {
const entry = this.dataGlobalService.dataSources.find((o) => o.uuid === uuid);
if (!entry) throw new Error('DataSource未连接');
return entry.dataSource.getRepository(DynamicEntity); // 返回 repository（可用于
queryRunner 等）
}
}
import { Injectable } from '@nestjs/common';
import { DataSourceService } from './dataSource.service';
@Injectable()
export class Date
SqlService {
constructor(
private readonly dataSource: DataSourceService
) {}
public async queryTable(uuid:string,
tableName: string,
selectColumns: string[] = ['*'],
whereConditions: Record<string, any> = {},
orderBy: Record<string, 'ASC' | 'DESC'> = {}): Promise<any[]> {
// 1. 连接数据库
//await this.dataSource.connect(uuid,dbConfig);
// 2. 构建查询
const queryBuilder = this.dataSource.getRepository(uuid)
.createQueryBuilder()
.select(selectColumns.join(', '))
.from(tableName, 't');
// 3. 添加条件
if (Object.keys(whereConditions).length > 0) {
Object.keys(whereConditions).forEach(key => {
queryBuilder.andWhere(`t.${key} = :${key}`).setParameter(`:${key}` as any, whereConditions[key]);
});
}
// 4. 添加排序
if (Object.keys(orderBy).length > 0) {
Object.keys(orderBy).forEach(key => {
queryBuilder.addOrderBy(`t.${key}`, orderBy[key]);
});
}
// 5. 执行查询
return await queryBuilder.getRawMany();
}
}
现在my
sql 数据库ocr已经连接上，进行准备请求user表时
报错[Nest] 37232 - 11/11/2025, 12:46:58 PM ERROR [ExceptionsHandler] QueryFailedError: Table 'ocr.dynamic_entity' doesn't exist
at Query.onResult (C:\cat\2_customers\CXL\2_Fuction\DigitalTwin\digital-twin.connector.service\node_modules\typeorm\driver\src\driver\my
sql\My
sqlQueryRunner.ts:248:33)
at Query.execute (C:\cat\2_customers\CXL\2_Fuction\DigitalTwin\digital-twin.connector.service\node_modules\my
sql2\lib\commands\command.js:36:14)
at PoolConnection.handlePacket (C:\cat\2_customers\CXL\2_Fuction\DigitalTwin\digital-twin.connector.service\node_modules\my
sql2\lib\base\connection.js:477:34)
at PacketParser.onPacket (C:\cat\2_customers\CXL\2_Fuction\DigitalTwin\digital-twin.connector.service\node_modules\my
sql2\lib\base\connection.js:93:12)
at PacketParser.executeStart (C:\cat\2_customers\CXL\2_Fuction\DigitalTwin\digital-twin.connector.service\node_modules\my
sql2\lib\packet_parser.js:75:16)
at Socket.<anonymous> (C:\cat\2_customers\CXL\2_Fuction\DigitalTwin\digital-twin.connector.service\node_modules\my
sql2\lib\base\connection.js:100:25)
at Socket.emit (node:events:518:28)
at addChunk (node:internal/streams/readable:561:12)
at readableAddChunkPushByteMode (node:internal/streams/readable:512:3)
at Readable.push (node:internal/streams/readable:392:5) {
query: 'SELECT * FROM `dynamic_entity` `DynamicEntity`, `user` `t`',
parameters: [],
driverError: Error: Table 'ocr.dynamic_entity' doesn't exist
at Packet.asError (C:\cat\2_customers\CXL\2_Fuction\DigitalTwin\digital-twin.connector.service\node_modules\my
sql2\lib\packets\packet.js:740:17)
at Query.execute (C:\cat\2_customers\CXL\2_Fuction\DigitalTwin\digital-twin.connector.service\node_modules\my
sql2\lib\commands\command.js:29:26)
at PoolConnection.handlePacket (C:\cat\2_customers\CXL\2_Fuction\DigitalTwin\digital-twin.connector.service\node_modules\my
sql2\lib\base\connection.js:477:34)
at PacketParser.onPacket (C:\cat\2_customers\CXL\2_Fuction\DigitalTwin\digital-twin.connector.service\node_modules\my
sql2\lib\base\connection.js:93:12)
at PacketParser.executeStart (C:\cat\2_customers\CXL\2_Fuction\DigitalTwin\digital-twin.connector.service\node_modules\my
sql2\lib\packet_parser.js:75:16)
at Socket.<anonymous> (C:\cat\2_customers\CXL\2_Fuction\DigitalTwin\digital-twin.connector.service\node_modules\my
sql2\lib\base\connection.js:100:25)
at Socket.emit (node:events:518:28)
at addChunk (node:internal/streams/readable:561:12)
at readableAddChunkPushByteMode (node:internal/streams/readable:512:3)
at Readable.push (node:internal/streams/readable:392:5) {
code: 'ER_NO_SUCH_TABLE',
errno: 1146,
sqlState: '42S02',
sqlMessage: "Table 'ocr.dynamic_entity' doesn't exist",
sql: 'SELECT * FROM `dynamic_entity` `DynamicEntity`, `user` `t`'
},
code: 'ER_NO_SUCH_TABLE',
errno: 1146,
sqlState: '42S02',
sqlMessage: "Table 'ocr.dynamic_entity' doesn't exist",
sql: 'SELECT * FROM `dynamic_entity` `DynamicEntity`, `user` `t`'
} 该怎么修改
本文探讨使用Apache Commons DBUtils库进行模糊查询时遇到的问题及解决方案。详细解释了因转义字符引起的SQL语法错误，并提供了正确的字符串拼接方法，确保查询语句正确执行。
扫一扫
8645
到【灌水乐园】发言
