Art Bindu's questions

我有两个具有相同键但不同键值的 ENUM，如下所示：

enum STUDENT_INFO {
    NAME("Student Name"),
    AGE("Age"),
    DOB("Date of Birth"),
    SEX("Sex"),
    LOCATION1("Hostel Info"),
    LOCATION2("Permanent Address"),
    ID("Institution ID"),
    INSTITUTE("Institution Name");

    private final String enumKey;
    STUDENT_INFO(String enumKey) {
        this.enumKey = enumKey;
    }
    public String getEnumKey() {
        return enumKey;
    }
}

enum PERSON_INFO {
    NAME("Person Name"),
    AGE("Age"),
    DOB("Date of Birth"),
    SEX("Sex"),
    LOCATION1("Present Address"),
    LOCATION2("Permanent Address"),
    ID("Person ID"),
    INSTITUTE("Job Name");

    private final String enumKey;
    PERSON_INFO(String enumKey) {
        this.enumKey = enumKey;
    }
    public String getEnumKey() {
        return enumKey;
    }
}

我想创建一个通用函数（printGenericEnumInfo）来打印其中任何一个 ENUM 键。

class JavaTest {
    public static void printStudentEnumInfo() {
        System.out.println(STUDENT_INFO.NAME.getEnumKey());
        System.out.println(STUDENT_INFO.LOCATION1.getEnumKey());
        System.out.println(STUDENT_INFO.LOCATION2.getEnumKey());
    }

    // Generic Method to Print Enum Keys
    public static void printGenericEnumInfo(Enum<T> enumName) {
        System.out.println(enumName.NAME.getEnumKey());
        System.out.println(enumName.LOCATION1.getEnumKey());
        System.out.println(enumName.LOCATION2.getEnumKey());
    }
}

public class Main {
    public static void main(String[] args) {
        // Working perfectly
        JavaTest.printStudentEnumInfo();

        // How to implement this
        JavaTest.printGenericEnumInfo(STUDENT_INFO);
        JavaTest.printGenericEnumInfo(PERSON_INFO);
    }
}

你能帮我怎么做吗？

演示代码：tutorialspoint_JavaCompiler

我有两张桌子，TableA&TableB

所有表格数据均可在此处获取：db<>fiddle

TableA如下：

TableB包含以下通过/失败的场景：

我想要用特定tableA的数据更新。tableBA_id

我期望tableA输出如下：

因此，我编写了更新的查询A_id=2如下：

UPDATE  TableA
SET     
    total_count = (SELECT COUNT(A_id) AS total_count 
                FROM TableB WHERE A_id = 2),
    pass_count = (SELECT COUNT(CASE WHEN(isPassed = 'Y') THEN 1 END) as pass_count 
                FROM TableB WHERE A_id = 2),
    fail_count = (SELECT COUNT(CASE WHEN(isPassed = 'N') THEN 1 END) as fail_count 
                FROM TableB WHERE A_id = 2)
WHERE   A_id = 2;

并检查TableA其更新数据是否正确。

但是，上述查询对于每个列更新都有 3 个不同的子查询。
因此，我想编写更新后的查询，如下所示：

WITH T0 AS (
    SELECT A_id,
        COUNT(A_id) AS TOTAL_SCENARIOS_COUNT,
        COUNT(CASE WHEN(isPassed = 'Y') THEN 1 END) as PASS_SCENARIOS_COUNT,
        COUNT(CASE WHEN(isPassed = 'N') THEN 1 END) as FAIL_SCENARIOS_COUNT
    from RT_TEST_RUN_SCENARIO
    GROUP BY A_id    
    HAVING A_id = 4779
)
UPDATE  tableA
SET     
    tableA.total_count = t0.total_count,
    tableA.pass_count = t0.pass_count,
    tableA.fail_count = t0.fail_count
FROM tableA INNER JOIN T0
ON tableA.A_id = T0.A_id

但是，它不起作用。你能帮我怎么做吗？
错误显示如下：

还有其他方法可以更新吗TableA？

注意：所有表格数据/查询都可以在这里找到：db<>fiddle

我正在使用node.js。oracledb我
已经创建了连接池来连接数据库。

当我从数据库获取任何数据时，它都运行正常。但当我尝试更新表列时，它却没有更新oracle sql server table。

我有一张EmpInfo包含列empno (primary key)和的表格notes (varchar(200))。我正尝试更新notes相对于的列empno。

这是我的示例代码如下：

oracleSqlDb.ts

import * as oracledb from 'oracledb';

const oracleDB_connectionConfig = {
    connectString   : "host:port/schema",
    user            : "username",
    password        : "********",
    poolIncrement   : 0,
    poolMax         : 10,
    poolMin         : 10,
    poolTimeout     : 60,
    poolAlias       : 'default'
};

export default class OracleSQL {
    private static isConnected: boolean = false;
    private static poolConn: any;

    static async connect() {
        return await oracledb.createPool(
            oracleDB_connectionConfig, 
            (err, pool) => {
                if (err) {
                    console.error('Connectivity Error: ', {code : err.errorNum, msg: err.message});
                    this.close();
                }
                console.info('Connection Pool Established ...');
                this.isConnected = true;
            });
    }

    static async query(queryStr: string) {
        if (!this.isConnected) {
            console.info('Reconnecting ....');
            await this.connect();
        }
        console.debug(`Query: ${queryStr}`);
        try {
            this.poolConn = await oracledb.getConnection('default');
            const result = await this.poolConn.execute(queryStr);
            if (result) {
                await this.poolConn.close();
                console.debug('Query result: ', result);
                return result;
            }
        } catch(err) {
            console.error('Query execution error: ', {code : err.errorNum, msg: err.message});
            this.close();
            return null;
        }
    }

    static async close() {
        console.debug("Disconnecting Connection Oracle SQL DB .... ");
        if (this.isConnected && this.poolConn && this.poolConn.isHealthy()) {
            await this.poolConn.close().then(() => {
                this.poolConn = null;
                console.info("DB disconnected ...");
            });
        }
        await oracledb.getPool().close(0);
        this.poolConn = null;
        this.isConnected = false;
    }
}

Model.ts

export interface UpdateQueryModel {
    empno : number
    notes : string | ''
};
export interface UpdateDataResponseModel {
    updateRecordId      : number | string,
    updateRecordType    : string,
    updateRecordCount   : number
};

AppRepository.ts

import { UpdateQueryModel, UpdateDataResponseModel } from "./models";
import { OracleSQL } from "./oracleSqlDb";

export class AppRepository {
    public async updateTableColumn(query: UpdateQueryModel): Promise<any> {
        console.debug(`QueryModel: ${JSON.stringify(query)}`);

        const resModel: UpdateDataResponseModel = {
            updateRecordId: query.empno,
            updateRecordType: 'Failure Message',
            updateRecordCount: 0
        };
        try {
            const dbQuery: string = `UPDATE  empinfo
                        SET     notes     =   '${query.notes}'
                        WHERE   empno     =   ${Number(query.empno)}`;

            const result = await OracleSQL.query(dbQuery);
            if (result && result.rowsAffected) {
                return {
                    ...resModel, 
                    updateRecordCount: dbData.rowsAffected,
                    updateRecordType : 'Update Record succesfully'
                };
            } else return resModel;
        } catch(err) {
            return resModel;
        }
    }
}

AppController.ts

import { Request, Response } from "express";
import { UpdateQueryModel } from "./models";
import { AppRepository } from "./AppRepository"

export class AppController {
    public async updateUserNotes(req: Request, res: Response) {
        console.debug(`Request body info  : ${JSON.stringify(req.body)}`);
        const appRepos: AppRepository = new AppRepository();

        let resultList: UpdateDataResponseModel;
        let queryModel: UpdateQueryModel = req.body;
        console.info(`API Url: '${req.originalUrl}' with config: ${JSON.stringify(req.body)}`);

        if(queryModel && Object.keys(queryModel).length && queryModel.empno) {
            resultList = await appRepos.updateTableColumn(queryModel);
            console.silly(`Output Data: ${JSON.stringify(resultList, null, 2)}`);

            return res.status(200).send({
                msg     :   "Succesful Response",
                data    :   resultList
            });
        } else {
            return res.status(200).send({
                msg: `Invalid Query: ${JSON.stringify(queryModel)}`
            });
        }
    }
}

Notes列更新对我而言不起作用。

这是数据库连接池问题还是其他问题？请给出一些建议。

我正在接收“America/New_York”时区的数据。
我想将该数据从“America/New_York”转换为“Asia/Calcutta”。

如何使用Day.js来实现这一点？

在MySQL正则表达式模式匹配函数中，有一个'match_type' - 'n'。

其中代表，
。字符与行终止符匹配。默认值为 . 匹配在行尾停止。

有人可以解释一下如何使用该匹配类型吗？

来源：

• MySQL：https://dev.mysql.com/doc/refman/8.3/en/regexp.html#function_regexp-like
• 甲骨文：https://docs.oracle.com/cd/B13789_01/server.101/b10759/conditions018.htm

我没有找到这样的例子那些文档。