32 lines
885 B
JavaScript
32 lines
885 B
JavaScript
const { Pool } = require('pg');
|
|
const pool = new Pool({
|
|
host: '47.116.196.11',
|
|
port: 15432,
|
|
database: 'postgresql',
|
|
user: 'postgresql',
|
|
password: 'Jchl1528'
|
|
});
|
|
|
|
const query = `
|
|
SELECT
|
|
COUNT(*) as total_count,
|
|
COUNT(apply_dept_id) as has_apply_dept_id_count,
|
|
COUNT(apply_dept_name) as has_apply_dept_name_count,
|
|
COUNT(*) - COUNT(apply_dept_name) as apply_dept_name_null_count,
|
|
COUNT(main_surgeon_id) as has_main_surgeon_id_count,
|
|
COUNT(main_surgeon_name) as has_main_surgeon_name_count,
|
|
COUNT(*) - COUNT(main_surgeon_name) as main_surgeon_name_null_count
|
|
FROM hisdev.cli_surgery
|
|
WHERE delete_flag = '0'
|
|
`;
|
|
|
|
pool.query(query, (err, res) => {
|
|
if (err) {
|
|
console.error('Error:', err.message);
|
|
} else {
|
|
console.log('=== 当前 cli_surgery 表空值统计 ===');
|
|
console.log(JSON.stringify(res.rows[0], null, 2));
|
|
}
|
|
pool.end();
|
|
});
|