Loading [MathJax]/jax/output/CommonHTML/config.js
前往小程序，Get更优阅读体验！
立即前往
文档建议反馈控制台
首页
学习
活动
专区
圈层
工具
MCP广场
文章/答案/技术大牛
发布
首页
学习
活动
专区
圈层
工具
MCP广场
返回腾讯云官网
社区首页 >专栏 >使用pgCompare比对不同pg的数据差异

使用pgCompare比对不同pg的数据差异

原创
作者头像
保持热爱奔赴山海
发布于 2024-06-28 02:55:34
发布于 2024-06-28 02:55:34
5190
举报
文章被收录于专栏：数据库相关数据库相关
关联问题
换一批

官方项目地址： https://github.com/CrunchyData/pgCompare

限制

代码语言：txt
AI代码解释
复制
    日期/时间戳仅与秒精度（DDMMYYYYYYHH24MISS）进行比较。
    不支持的数据类型：blob、long、longraw、byta。
    执行跨平台比较时数据类型布尔值的限制。
    待比较的表必须有主键（没有主键会在比对的时候被自动跳过，日志中提示 Table xx has no Primary Key, skipping reconciliation）
    如果target的行比source的多，则不会被报告出来

前置条件

代码语言：txt
AI代码解释
复制
    Java version 21 or higher.
    Maven 3.9 or higher.
    Postgres version 15 or higher (to use for the pgCompare Data Compare repository).
    Necessary JDBC drivers (Postgres and Oracle currently supported).

准备2个pg实例

代码语言：txt
AI代码解释
复制
我这里用的是单机版的pg15和pg16
pg15作为source端， pg16作为target端。
create database db1;
\c db1;
然后在db1里创建一些表，并写入测试数据。

编译安装

代码语言：txt
AI代码解释
复制
cd /root/pgCompare/pgCompare-v.0.2.0

export JAVA_HOME=/usr/local/software/jdk-22.0.1
export CLASSPATH=.:$JAVA_HOME/jre/lib/rt.jar:$JAVA_HOME/lib/dt.jar:$JAVA_HOME/lib/tools.jar
export PATH=$JAVA_HOME/bin:$PATH
mvn --version    
Apache Maven 3.9.1 (2e178502fcdbffc201671fb2537d0cb4b4cc58f8)
Maven home: /usr/local/software/maven
Java version: 22.0.1, vendor: Oracle Corporation, runtime: /home/software/jdk-22.0.1
Default locale: en_US, platform encoding: UTF-8
OS name: "linux", version: "6.8.9-1.el7.elrepo.x86_64", arch: "amd64", family: "unix"


mvn clean install

准备配置文件

代码语言：txt
AI代码解释
复制
cd target
cp ../pgcompare.properties.sample /root/pgcompare.properties

修改后的配置文件

代码语言：txt
AI代码解释
复制
cat pgcompare.properties | egrep -v '^#'

batch-fetch-size = 2000  # 设置从源或目标数据库检索行的获取大小
batch-commit-size = 2000  # 提交大小控制并发插入到 dc_source/dc_target 暂存表中的数组大小和行数
batch-progress-report-size = 1000000  # 定义 mod 中用于报告进度的行数
loader-threads = 2  # 设置将数据加载到临时表中的线程数。默认值为 4。设置为 0 可禁用加载器线程
message-queue-size = 100  # 加载线程使用的消息队列的大小（nbr 个消息）。默认值为 100
number-cast: notation     # 定义哈希函数中数字的转换方式（符号|标准）。默认为符号（科学计数法）
observer-throttle = true   # 设置为 true 或 false，指示加载器线程暂停并等待观察器线程赶上来，然后再继续将更多数据加载到暂存表中。
observer-throttle-size = 2000000  # 加载器线程休眠并等待观察器线程清除之前加载的行数
observer-vacuum = true  # 设置为 true 或 false，指示观察者是否在检查点期间对暂存表执行真空清理
log-destination = stdout  # 设置临时暂存表的并行工作器数量。默认值为 0

log-level = INFO  # 测试期间，建议改为 DEBUG
database-sort = true

repo-host=192.168.31.181
repo-port=5432
repo-dbname=pgcompare
repo-user=dts
repo-password=dts
repo-schema=pgcompare
repo-sslmode: disable

source-name=pg15
source-type=postgres
source-host=192.168.31.181
source-port=5432
source-dbname=db1
source-user=dts
source-password=dts
source-database-hash=true
source-sslmode=disable

target-name=pg16
target-type=postgres
target-host=192.168.31.181
target-port=5436
target-dbname=db1
target-user=dts
target-password=dts
target-database-hash=true
target-sslmode=disable

在repo-host的pg上创建存储库

代码语言：txt
AI代码解释
复制
create database pgcompare;

调整下pgcompare的repo-user的隔离级别

代码语言：txt
AI代码解释
复制
alter user dts set transaction_isolation='read committed';

TIPS：如果使用默认的RR隔离级别，在执行后续的 java -jar pgcompare.jar --batch=0 会报如下的错误
[2024-06-28 09:32:20] [SEVERE ] [dbCommon ] Error executing simple update (UPDATE dc_result SET source_cnt=source_cnt+? WHERE cid=?):  ERROR: could not serialize access due to concurrent update

初始化存储库

代码语言：txt
AI代码解释
复制
java -jar pgcompare.jar --init

[2024-06-27 19:18:55] [INFO   ] [main                    ] Starting - rid: 1719487134959 
[2024-06-27 19:18:55] [INFO   ] [main                    ] Version: 0.2.0 
[2024-06-27 19:18:55] [INFO   ] [main                    ] Batch Number: 0 
[2024-06-27 19:18:55] [INFO   ] [main                    ] Recheck Out of Sync: false 
[2024-06-27 19:18:55] [INFO   ] [main                    ] Parameters:  
[2024-06-27 19:18:55] [INFO   ] [main                    ]   target-port=5436 
[2024-06-27 19:18:55] [INFO   ] [main                    ]   observer-vacuum=true 
[2024-06-27 19:18:55] [INFO   ] [main                    ]   source-port=5432 
[2024-06-27 19:18:55] [INFO   ] [main                    ]   source-user=dts 
[2024-06-27 19:18:55] [INFO   ] [main                    ]   target-type=postgres 
[2024-06-27 19:18:55] [INFO   ] [main                    ]   batch-commit-size=2000 
[2024-06-27 19:18:55] [INFO   ] [main                    ]   stage-table-parallel=0 
[2024-06-27 19:18:55] [INFO   ] [main                    ]   source-name=pg15 
[2024-06-27 19:18:55] [INFO   ] [main                    ]   message-queue-size=100 
[2024-06-27 19:18:55] [INFO   ] [main                    ]   repo-sslmode=disable 
[2024-06-27 19:18:55] [INFO   ] [main                    ]   target-dbname=db1 
[2024-06-27 19:18:55] [INFO   ] [main                    ]   target-sslmode=disable 
[2024-06-27 19:18:55] [INFO   ] [main                    ]   batch-fetch-size=2000 
[2024-06-27 19:18:55] [INFO   ] [main                    ]   source-type=postgres 
[2024-06-27 19:18:55] [INFO   ] [main                    ]   database-sort=true 
[2024-06-27 19:18:55] [INFO   ] [main                    ]   repo-dbname=pgcompare 
[2024-06-27 19:18:55] [INFO   ] [main                    ]   target-host=192.168.31.181 
[2024-06-27 19:18:55] [INFO   ] [main                    ]   repo-port=5432 
[2024-06-27 19:18:55] [INFO   ] [main                    ]   loader-threads=2 
[2024-06-27 19:18:55] [INFO   ] [main                    ]   repo-schema=pgcompare 
[2024-06-27 19:18:55] [INFO   ] [main                    ]   config-file=pgcompare.properties 
[2024-06-27 19:18:55] [INFO   ] [main                    ]   repo-user=dts 
[2024-06-27 19:18:55] [INFO   ] [main                    ]   batch-progress-report-size=1000000 
[2024-06-27 19:18:55] [INFO   ] [main                    ]   source-dbname=db1 
[2024-06-27 19:18:55] [INFO   ] [main                    ]   observer-throttle-size=2000000 
[2024-06-27 19:18:55] [INFO   ] [main                    ]   observer-throttle=true 
[2024-06-27 19:18:55] [INFO   ] [main                    ]   source-database-hash=true 
[2024-06-27 19:18:55] [INFO   ] [main                    ]   number-cast=notation 
[2024-06-27 19:18:55] [INFO   ] [main                    ]   source-host=192.168.31.181 
[2024-06-27 19:18:55] [INFO   ] [main                    ]   target-database-hash=true 
[2024-06-27 19:18:55] [INFO   ] [main                    ]   log-level=INFO 
[2024-06-27 19:18:55] [INFO   ] [main                    ]   log-destination=stdout 
[2024-06-27 19:18:55] [INFO   ] [main                    ]   target-user=dts 
[2024-06-27 19:18:55] [INFO   ] [main                    ]   source-sslmode=disable 
[2024-06-27 19:18:55] [INFO   ] [main                    ]   target-name=pg16 
[2024-06-27 19:18:55] [INFO   ] [main                    ]   repo-host=192.168.31.181 
[2024-06-27 19:18:55] [INFO   ] [main                    ] Connecting to repository database

查看存储库

代码语言：txt
AI代码解释
复制
pgcompare=# \dn
		List of schemas
   Name    |       Owner       
-----------+-------------------
 pgcompare | dts
 public    | pg_database_owner
(2 rows)

pgcompare=# set search_path ='pgcompare';
SET
pgcompare=# \dt
			  List of relations
  Schema   |       Name       | Type  | Owner 
-----------+------------------+-------+-------
 pgcompare | dc_object        | table | dts
 pgcompare | dc_result        | table | dts
 pgcompare | dc_source        | table | dts
 pgcompare | dc_table         | table | dts
 pgcompare | dc_table_history | table | dts
 pgcompare | dc_target        | table | dts
(6 rows)

自动tables注册

代码语言：txt
AI代码解释
复制
java -jar pgcompare.jar --discovery public  # 注意这里public指的是schema

[2024-06-27 19:21:54] [INFO   ] [main                    ] Starting - rid: 1719487314311 
[2024-06-27 19:21:54] [INFO   ] [main                    ] Version: 0.2.0 
[2024-06-27 19:21:54] [INFO   ] [main                    ] Batch Number: 0 
[2024-06-27 19:21:54] [INFO   ] [main                    ] Recheck Out of Sync: false 
[2024-06-27 19:21:54] [INFO   ] [main                    ] Parameters:  
[2024-06-27 19:21:54] [INFO   ] [main                    ]   target-port=5436 
[2024-06-27 19:21:54] [INFO   ] [main                    ]   observer-vacuum=true 
[2024-06-27 19:21:54] [INFO   ] [main                    ]   source-port=5432 
[2024-06-27 19:21:54] [INFO   ] [main                    ]   source-user=dts 
[2024-06-27 19:21:54] [INFO   ] [main                    ]   target-type=postgres 
[2024-06-27 19:21:54] [INFO   ] [main                    ]   batch-commit-size=2000 
[2024-06-27 19:21:54] [INFO   ] [main                    ]   stage-table-parallel=0 
[2024-06-27 19:21:54] [INFO   ] [main                    ]   source-name=pg15 
[2024-06-27 19:21:54] [INFO   ] [main                    ]   message-queue-size=100 
[2024-06-27 19:21:54] [INFO   ] [main                    ]   repo-sslmode=disable 
[2024-06-27 19:21:54] [INFO   ] [main                    ]   target-dbname=db1 
[2024-06-27 19:21:54] [INFO   ] [main                    ]   target-sslmode=disable 
[2024-06-27 19:21:54] [INFO   ] [main                    ]   batch-fetch-size=2000 
[2024-06-27 19:21:54] [INFO   ] [main                    ]   source-type=postgres 
[2024-06-27 19:21:54] [INFO   ] [main                    ]   database-sort=true 
[2024-06-27 19:21:54] [INFO   ] [main                    ]   repo-dbname=pgcompare 
[2024-06-27 19:21:54] [INFO   ] [main                    ]   target-host=192.168.31.181 
[2024-06-27 19:21:54] [INFO   ] [main                    ]   repo-port=5432 
[2024-06-27 19:21:54] [INFO   ] [main                    ]   loader-threads=2 
[2024-06-27 19:21:54] [INFO   ] [main                    ]   repo-schema=pgcompare 
[2024-06-27 19:21:54] [INFO   ] [main                    ]   config-file=pgcompare.properties 
[2024-06-27 19:21:54] [INFO   ] [main                    ]   repo-user=dts 
[2024-06-27 19:21:54] [INFO   ] [main                    ]   batch-progress-report-size=1000000 
[2024-06-27 19:21:54] [INFO   ] [main                    ]   source-dbname=db1 
[2024-06-27 19:21:54] [INFO   ] [main                    ]   observer-throttle-size=2000000 
[2024-06-27 19:21:54] [INFO   ] [main                    ]   observer-throttle=true 
[2024-06-27 19:21:54] [INFO   ] [main                    ]   source-database-hash=true 
[2024-06-27 19:21:54] [INFO   ] [main                    ]   number-cast=notation 
[2024-06-27 19:21:54] [INFO   ] [main                    ]   source-host=192.168.31.181 
[2024-06-27 19:21:54] [INFO   ] [main                    ]   target-database-hash=true 
[2024-06-27 19:21:54] [INFO   ] [main                    ]   log-level=INFO 
[2024-06-27 19:21:54] [INFO   ] [main                    ]   log-destination=stdout 
[2024-06-27 19:21:54] [INFO   ] [main                    ]   target-user=dts 
[2024-06-27 19:21:54] [INFO   ] [main                    ]   source-sslmode=disable 
[2024-06-27 19:21:54] [INFO   ] [main                    ]   target-name=pg16 
[2024-06-27 19:21:54] [INFO   ] [main                    ]   repo-host=192.168.31.181 
[2024-06-27 19:21:54] [INFO   ] [main                    ] Connecting to repository database 
[2024-06-27 19:21:55] [INFO   ] [main                    ] Connecting to source database 
[2024-06-27 19:21:55] [INFO   ] [main                    ] Connecting to target database 
[2024-06-27 19:21:55] [INFO   ] [main                    ] Performaning table discovery for schema: db1 
[2024-06-27 19:21:55] [INFO   ] [main                    ] Shutting down

查看pg存储库，可以看到已经采集到表信息了

（它会把source和target的表都采集进来）

代码语言：txt
AI代码解释
复制
pgcompare=# select * from dc_table;
 tid | source_schema | source_table | target_schema | target_table | batch_nbr | parallel_degree | mod_column | status | table_filter | column_map 
-----+---------------+--------------+---------------+--------------+-----------+-----------------+------------+--------+--------------+------------
  19 | public        | t1           | public        | t1           |         1 |               1 | NULL       | ready  | NULL         | NULL
  20 | public        | t2           | public        | t2           |         1 |               1 | NULL       | ready  | NULL         | NULL
  21 | public        | t3           | public        | t3           |         1 |               1 | NULL       | ready  | NULL         | NULL
  22 | public        | t5           | public        | t5           |         1 |               1 | NULL       | ready  | NULL         | NULL
  23 | public        | tb           | public        | tb           |         1 |               1 | NULL       | ready  | NULL         | NULL
  24 | public        | ttt          | public        | ttt          |         1 |               1 | NULL       | ready  | NULL         | NULL
(6 rows)

执行数据比较

代码语言：txt
AI代码解释
复制
java -jar pgcompare.jar --batch=0   # 批次号的默认值为 0表示所有批次
	
[2024-06-28 10:14:01] [INFO   ] [main                    ] Starting - rid: 1719540841891 
[2024-06-28 10:14:02] [INFO   ] [main                    ] Version: 0.2.0 
[2024-06-28 10:14:02] [INFO   ] [main                    ] Batch Number: 0 
[2024-06-28 10:14:02] [INFO   ] [main                    ] Recheck Out of Sync: false 
[2024-06-28 10:14:02] [INFO   ] [main                    ] Parameters:  
[2024-06-28 10:14:02] [INFO   ] [main                    ]   target-port=5436 
[2024-06-28 10:14:02] [INFO   ] [main                    ]   observer-vacuum=true 
[2024-06-28 10:14:02] [INFO   ] [main                    ]   source-port=5432 
[2024-06-28 10:14:02] [INFO   ] [main                    ]   source-user=dts 
[2024-06-28 10:14:02] [INFO   ] [main                    ]   target-type=postgres 
[2024-06-28 10:14:02] [INFO   ] [main                    ]   batch-commit-size=2000 
[2024-06-28 10:14:02] [INFO   ] [main                    ]   stage-table-parallel=0 
[2024-06-28 10:14:02] [INFO   ] [main                    ]   source-name=pg15 
[2024-06-28 10:14:02] [INFO   ] [main                    ]   message-queue-size=100 
[2024-06-28 10:14:02] [INFO   ] [main                    ]   repo-sslmode=disable 
[2024-06-28 10:14:02] [INFO   ] [main                    ]   target-dbname=db1 
[2024-06-28 10:14:02] [INFO   ] [main                    ]   target-sslmode=disable 
[2024-06-28 10:14:02] [INFO   ] [main                    ]   batch-fetch-size=2000 
[2024-06-28 10:14:02] [INFO   ] [main                    ]   source-type=postgres 
[2024-06-28 10:14:02] [INFO   ] [main                    ]   database-sort=true 
[2024-06-28 10:14:02] [INFO   ] [main                    ]   repo-dbname=pgcompare 
[2024-06-28 10:14:02] [INFO   ] [main                    ]   target-host=192.168.31.181 
[2024-06-28 10:14:02] [INFO   ] [main                    ]   repo-port=5432 
[2024-06-28 10:14:02] [INFO   ] [main                    ]   loader-threads=2 
[2024-06-28 10:14:02] [INFO   ] [main                    ]   repo-schema=pgcompare 
[2024-06-28 10:14:02] [INFO   ] [main                    ]   config-file=pgcompare.properties 
[2024-06-28 10:14:02] [INFO   ] [main                    ]   repo-user=dts 
[2024-06-28 10:14:02] [INFO   ] [main                    ]   batch-progress-report-size=1000000 
[2024-06-28 10:14:02] [INFO   ] [main                    ]   source-dbname=db1 
[2024-06-28 10:14:02] [INFO   ] [main                    ]   observer-throttle-size=2000000 
[2024-06-28 10:14:02] [INFO   ] [main                    ]   observer-throttle=true 
[2024-06-28 10:14:02] [INFO   ] [main                    ]   source-database-hash=true 
[2024-06-28 10:14:02] [INFO   ] [main                    ]   number-cast=notation 
[2024-06-28 10:14:02] [INFO   ] [main                    ]   source-host=192.168.31.181 
[2024-06-28 10:14:02] [INFO   ] [main                    ]   target-database-hash=true 
[2024-06-28 10:14:02] [INFO   ] [main                    ]   log-level=DEBUG 
[2024-06-28 10:14:02] [INFO   ] [main                    ]   log-destination=stdout 
[2024-06-28 10:14:02] [INFO   ] [main                    ]   target-user=dts 
[2024-06-28 10:14:02] [INFO   ] [main                    ]   source-sslmode=disable 
[2024-06-28 10:14:02] [INFO   ] [main                    ]   target-name=pg16 
[2024-06-28 10:14:02] [INFO   ] [main                    ]   repo-host=192.168.31.181 
[2024-06-28 10:14:02] [INFO   ] [main                    ] Connecting to repository database 
[2024-06-28 10:14:02] [INFO   ] [main                    ] Connecting to source database 
[2024-06-28 10:14:02] [INFO   ] [main                    ] Connecting to target database 
[2024-06-28 10:14:02] [INFO   ] [main                    ] Start reconciliation 
[2024-06-28 10:14:02] [INFO   ] [main                    ] Clearing data compare findings 
[2024-06-28 10:14:02] [INFO   ] [DatabaseUtility         ] Building column expressions for public.t1 
[2024-06-28 10:14:02] [INFO   ] [DatabaseUtility         ] Building column expressions for public.t1 
[2024-06-28 10:14:02] [INFO   ] [ReconcileController     ] Source Columns:  
[2024-06-28 10:14:02] [INFO   ] [ReconcileController     ] Target Columns:  
[2024-06-28 10:14:02] [INFO   ] [ReconcileController     ] Source Compare Hash SQL: SELECT md5(concat_ws('|',coalesce(trim(to_char(b,'0.9999999999EEEE')),' '))) pk_hash, '{'||'"b": ' || b||'}' pk, md5(concat_ws('','0')) FROM public.t1 WHERE 1=1  
[2024-06-28 10:14:02] [INFO   ] [ReconcileController     ] Target Compare Hash SQL: SELECT md5(concat_ws('|',coalesce(trim(to_char(b,'0.9999999999EEEE')),' '))) pk_hash, '{'||'"b": ' || b||'}' pk, md5(concat_ws('','0')) FROM public.t1 WHERE 1=1  
[2024-06-28 10:14:02] [INFO   ] [ReconcileController     ] Starting compare hash threads 
[2024-06-28 10:14:02] [INFO   ] [ReconcileController     ] Creating data compare staging tables 
[2024-06-28 10:14:02] [INFO   ] [ReconcileController     ] Starting compare thread 0 
[2024-06-28 10:14:02] [INFO   ] [Observer-c23-t0         ] Starting reconcile observer 
[2024-06-28 10:14:02] [INFO   ] [Observer-c23-t0         ] Connecting to repository database 
[2024-06-28 10:14:02] [INFO   ] [Reconcile-source-c23-t0 ] Start database reconcile thread 
[2024-06-28 10:14:02] [INFO   ] [Reconcile-target-c23-t0 ] Start database reconcile thread 
[2024-06-28 10:14:02] [INFO   ] [Reconcile-source-c23-t0 ] Connecting to repository database 
[2024-06-28 10:14:02] [INFO   ] [Reconcile-target-c23-t0 ] Connecting to repository database 
[2024-06-28 10:14:02] [INFO   ] [loader-source-t0-i1     ] Start repository loader thread 
[2024-06-28 10:14:02] [INFO   ] [loader-target-t0-i1     ] Start repository loader thread 
[2024-06-28 10:14:02] [INFO   ] [loader-source-t0-i2     ] Start repository loader thread 
[2024-06-28 10:14:02] [INFO   ] [loader-source-t0-i1     ] Connecting to repository database 
[2024-06-28 10:14:02] [INFO   ] [loader-target-t0-i2     ] Start repository loader thread 
[2024-06-28 10:14:02] [INFO   ] [loader-target-t0-i2     ] Connecting to repository database 
[2024-06-28 10:14:02] [INFO   ] [loader-target-t0-i1     ] Connecting to repository database 
[2024-06-28 10:14:02] [INFO   ] [loader-source-t0-i2     ] Connecting to repository database 
[2024-06-28 10:14:02] [INFO   ] [Reconcile-source-c23-t0 ] Connecting to source database 
[2024-06-28 10:14:02] [INFO   ] [Reconcile-target-c23-t0 ] Connecting to target database 
[2024-06-28 10:14:02] [INFO   ] [Reconcile-target-c23-t0 ] Complete. Total rows loaded: 9 
[2024-06-28 10:14:02] [INFO   ] [Reconcile-source-c23-t0 ] Complete. Total rows loaded: 6 
[2024-06-28 10:14:03] [INFO   ] [loader-source-t0-i1     ] Loader thread complete. 
[2024-06-28 10:14:03] [INFO   ] [loader-target-t0-i2     ] Loader thread complete. 
[2024-06-28 10:14:03] [INFO   ] [loader-target-t0-i1     ] Loader thread complete. 
[2024-06-28 10:14:03] [INFO   ] [loader-source-t0-i2     ] Loader thread complete. 
[2024-06-28 10:14:04] [INFO   ] [ReconcileController     ] Waiting for hash threads to complete 
[2024-06-28 10:14:04] [INFO   ] [ReconcileController     ] Waiting for reconcile threads to complete 
[2024-06-28 10:14:04] [INFO   ] [Observer-c23-t0         ] Matched 6 rows 
[2024-06-28 10:14:08] [INFO   ] [Observer-c23-t0         ] Staging table cleanup 
[2024-06-28 10:14:08] [INFO   ] [ReconcileController     ] Analyzing: Step 1 of 3 - Missing on Source 
[2024-06-28 10:14:08] [INFO   ] [ReconcileController     ] Analyzing: Step 2 of 3 - Missing on Target 
[2024-06-28 10:14:08] [INFO   ] [ReconcileController     ] Analyzing: Step 3 of 3 - Not Equal 
[2024-06-28 10:14:08] [INFO   ] [ReconcileController     ] Reconciliation Complete: Table = t1; Status = out-of-sync ; Equal = 6; Not Equal = 0; Missing Source = 3; Missing Target = 0 
[2024-06-28 10:14:08] [INFO   ] [main                    ] Start reconciliation 
[2024-06-28 10:14:08] [INFO   ] [main                    ] Clearing data compare findings 
[2024-06-28 10:14:08] [INFO   ] [DatabaseUtility         ] Building column expressions for public.t2 
[2024-06-28 10:14:08] [INFO   ] [DatabaseUtility         ] Building column expressions for public.t2 
[2024-06-28 10:14:08] [INFO   ] [ReconcileController     ] Source Columns:  
[2024-06-28 10:14:08] [INFO   ] [ReconcileController     ] Target Columns:  
[2024-06-28 10:14:08] [INFO   ] [ReconcileController     ] Source Compare Hash SQL: SELECT md5(concat_ws('|',coalesce(trim(to_char(b,'0.9999999999EEEE')),' '))) pk_hash, '{'||'"b": ' || b||'}' pk, md5(concat_ws('','0')) FROM public.t2 WHERE 1=1  
[2024-06-28 10:14:08] [INFO   ] [ReconcileController     ] Target Compare Hash SQL: SELECT md5(concat_ws('|',coalesce(trim(to_char(b,'0.9999999999EEEE')),' '))) pk_hash, '{'||'"b": ' || b||'}' pk, md5(concat_ws('','0')) FROM public.t2 WHERE 1=1  
[2024-06-28 10:14:08] [INFO   ] [ReconcileController     ] Starting compare hash threads 
[2024-06-28 10:14:08] [INFO   ] [ReconcileController     ] Creating data compare staging tables 
[2024-06-28 10:14:08] [INFO   ] [ReconcileController     ] Starting compare thread 0 
[2024-06-28 10:14:08] [INFO   ] [Observer-c24-t0         ] Starting reconcile observer 
[2024-06-28 10:14:08] [INFO   ] [loader-source-t0-i1     ] Start repository loader thread 
[2024-06-28 10:14:08] [INFO   ] [Reconcile-target-c24-t0 ] Start database reconcile thread 
[2024-06-28 10:14:08] [INFO   ] [Reconcile-source-c24-t0 ] Start database reconcile thread 
[2024-06-28 10:14:08] [INFO   ] [Observer-c24-t0         ] Connecting to repository database 
[2024-06-28 10:14:08] [INFO   ] [loader-target-t0-i1     ] Start repository loader thread 
[2024-06-28 10:14:08] [INFO   ] [loader-target-t0-i1     ] Connecting to repository database 
[2024-06-28 10:14:08] [INFO   ] [loader-source-t0-i1     ] Connecting to repository database 
[2024-06-28 10:14:08] [INFO   ] [loader-source-t0-i2     ] Start repository loader thread 
[2024-06-28 10:14:08] [INFO   ] [loader-target-t0-i2     ] Start repository loader thread 
[2024-06-28 10:14:08] [INFO   ] [loader-target-t0-i2     ] Connecting to repository database 
[2024-06-28 10:14:08] [INFO   ] [Reconcile-target-c24-t0 ] Connecting to repository database 
[2024-06-28 10:14:08] [INFO   ] [Reconcile-source-c24-t0 ] Connecting to repository database 
[2024-06-28 10:14:08] [INFO   ] [loader-source-t0-i2     ] Connecting to repository database 
[2024-06-28 10:14:08] [INFO   ] [Reconcile-target-c24-t0 ] Connecting to target database 
[2024-06-28 10:14:08] [INFO   ] [Reconcile-source-c24-t0 ] Connecting to source database 
[2024-06-28 10:14:08] [INFO   ] [Reconcile-target-c24-t0 ] Complete. Total rows loaded: 2 
[2024-06-28 10:14:08] [INFO   ] [Reconcile-source-c24-t0 ] Complete. Total rows loaded: 3 
[2024-06-28 10:14:09] [INFO   ] [loader-target-t0-i1     ] Loader thread complete. 
[2024-06-28 10:14:09] [INFO   ] [loader-source-t0-i1     ] Loader thread complete. 
[2024-06-28 10:14:09] [INFO   ] [loader-target-t0-i2     ] Loader thread complete. 
[2024-06-28 10:14:09] [INFO   ] [loader-source-t0-i2     ] Loader thread complete. 
[2024-06-28 10:14:10] [INFO   ] [ReconcileController     ] Waiting for hash threads to complete 
[2024-06-28 10:14:10] [INFO   ] [ReconcileController     ] Waiting for reconcile threads to complete 
[2024-06-28 10:14:10] [INFO   ] [Observer-c24-t0         ] Matched 2 rows 
[2024-06-28 10:14:14] [INFO   ] [Observer-c24-t0         ] Staging table cleanup 
[2024-06-28 10:14:14] [INFO   ] [ReconcileController     ] Analyzing: Step 1 of 3 - Missing on Source 
[2024-06-28 10:14:14] [INFO   ] [ReconcileController     ] Analyzing: Step 2 of 3 - Missing on Target 
[2024-06-28 10:14:14] [INFO   ] [ReconcileController     ] Analyzing: Step 3 of 3 - Not Equal 
[2024-06-28 10:14:14] [INFO   ] [ReconcileController     ] Reconciliation Complete: Table = t2 ; Status = out-of-sync ; Equal = 2; Not Equal = 0; Missing Source = 0; Missing Target = 1 
[2024-06-28 10:14:14] [INFO   ] [main                    ] Start reconciliation 
[2024-06-28 10:14:14] [INFO   ] [main                    ] Clearing data compare findings 
[2024-06-28 10:14:14] [INFO   ] [DatabaseUtility         ] Building column expressions for public.t3 
[2024-06-28 10:14:14] [INFO   ] [DatabaseUtility         ] Building column expressions for public.t3 
[2024-06-28 10:14:14] [INFO   ] [ReconcileController     ] Source Columns: address,remark 
[2024-06-28 10:14:14] [INFO   ] [ReconcileController     ] Target Columns: address,remark 
[2024-06-28 10:14:14] [INFO   ] [ReconcileController     ] Source Compare Hash SQL: SELECT md5(concat_ws('|',coalesce(trim(to_char(id,'0.9999999999EEEE')),' '))) pk_hash, '{'||'"id": ' || id||'}' pk, md5(concat_ws('',coalesce(address::text,' ')||coalesce(remark::text,' '))) FROM public.t3 WHERE 1=1  
[2024-06-28 10:14:14] [INFO   ] [ReconcileController     ] Target Compare Hash SQL: SELECT md5(concat_ws('|',coalesce(trim(to_char(id,'0.9999999999EEEE')),' '))) pk_hash, '{'||'"id": ' || id||'}' pk, md5(concat_ws('',coalesce(address::text,' ')||coalesce(remark::text,' '))) FROM public.t3 WHERE 1=1  
[2024-06-28 10:14:14] [INFO   ] [ReconcileController     ] Starting compare hash threads 
[2024-06-28 10:14:14] [INFO   ] [ReconcileController     ] Creating data compare staging tables 
[2024-06-28 10:14:15] [INFO   ] [ReconcileController     ] Starting compare thread 0 
[2024-06-28 10:14:15] [INFO   ] [Observer-c25-t0         ] Starting reconcile observer 
[2024-06-28 10:14:15] [INFO   ] [Reconcile-target-c25-t0 ] Start database reconcile thread 
[2024-06-28 10:14:15] [INFO   ] [Reconcile-source-c25-t0 ] Start database reconcile thread 
[2024-06-28 10:14:15] [INFO   ] [loader-source-t0-i1     ] Start repository loader thread 
[2024-06-28 10:14:15] [INFO   ] [Observer-c25-t0         ] Connecting to repository database 
[2024-06-28 10:14:15] [INFO   ] [loader-target-t0-i1     ] Start repository loader thread 
[2024-06-28 10:14:15] [INFO   ] [loader-target-t0-i1     ] Connecting to repository database 
[2024-06-28 10:14:15] [INFO   ] [loader-source-t0-i2     ] Start repository loader thread 
[2024-06-28 10:14:15] [INFO   ] [loader-source-t0-i2     ] Connecting to repository database 
[2024-06-28 10:14:15] [INFO   ] [Reconcile-source-c25-t0 ] Connecting to repository database 
[2024-06-28 10:14:15] [INFO   ] [loader-target-t0-i2     ] Start repository loader thread 
[2024-06-28 10:14:15] [INFO   ] [loader-source-t0-i1     ] Connecting to repository database 
[2024-06-28 10:14:15] [INFO   ] [Reconcile-target-c25-t0 ] Connecting to repository database 
[2024-06-28 10:14:15] [INFO   ] [loader-target-t0-i2     ] Connecting to repository database 
[2024-06-28 10:14:15] [INFO   ] [Reconcile-target-c25-t0 ] Connecting to target database 
[2024-06-28 10:14:15] [INFO   ] [Reconcile-source-c25-t0 ] Connecting to source database 
[2024-06-28 10:14:15] [INFO   ] [Reconcile-target-c25-t0 ] Complete. Total rows loaded: 6 
[2024-06-28 10:14:15] [INFO   ] [Reconcile-source-c25-t0 ] Complete. Total rows loaded: 5 
[2024-06-28 10:14:16] [INFO   ] [loader-target-t0-i1     ] Loader thread complete. 
[2024-06-28 10:14:16] [INFO   ] [loader-source-t0-i2     ] Loader thread complete. 
[2024-06-28 10:14:16] [INFO   ] [loader-source-t0-i1     ] Loader thread complete. 
[2024-06-28 10:14:16] [INFO   ] [loader-target-t0-i2     ] Loader thread complete. 
[2024-06-28 10:14:17] [INFO   ] [ReconcileController     ] Waiting for hash threads to complete 
[2024-06-28 10:14:17] [INFO   ] [ReconcileController     ] Waiting for reconcile threads to complete 
[2024-06-28 10:14:17] [INFO   ] [Observer-c25-t0         ] Matched 4 rows 
[2024-06-28 10:14:21] [INFO   ] [Observer-c25-t0         ] Staging table cleanup 
[2024-06-28 10:14:21] [INFO   ] [ReconcileController     ] Analyzing: Step 1 of 3 - Missing on Source 
[2024-06-28 10:14:21] [INFO   ] [ReconcileController     ] Analyzing: Step 2 of 3 - Missing on Target 
[2024-06-28 10:14:21] [INFO   ] [ReconcileController     ] Analyzing: Step 3 of 3 - Not Equal 
[2024-06-28 10:14:21] [INFO   ] [ReconcileController     ] Reconciliation Complete: Table = t3 ; Status = out-of-sync ; Equal = 4; Not Equal = 0; Missing Source = 2; Missing Target = 1 
[2024-06-28 10:14:21] [INFO   ] [main                    ] Processed 3 tables 
[2024-06-28 10:14:21] [INFO   ] [main                    ] Table Summary: Table = t1 ; Status = out-of-sync ; Equal = 6; Not Equal = 0; Missing Source = 3; Missing Target = 0 
[2024-06-28 10:14:21] [INFO   ] [main                    ] Table Summary: Table = t2 ; Status = out-of-sync ; Equal = 2; Not Equal = 0; Missing Source = 0; Missing Target = 1 
[2024-06-28 10:14:21] [INFO   ] [main                    ] Table Summary: Table = t3 ; Status = out-of-sync ; Equal = 4; Not Equal = 0; Missing Source = 2; Missing Target = 1 
[2024-06-28 10:14:21] [INFO   ] [main                    ] Run Summary:  Elapsed Time (seconds) = 19; Total Rows Processed = 19; Total Out-of-Sync = 7; Through-put (rows/per second

查看pg存储库的结果

代码语言：txt
AI代码解释
复制
	pgcompare=# select * from dc_result;
	 cid |      rid      | table_name |   status    |          compare_dt           | equal_cnt | missing_source_cnt | missing_target_cnt | not_equal_cnt | source_cnt | target_cnt 
	-----+---------------+------------+-------------+-------------------------------+-----------+--------------------+--------------------+---------------+------------+------------
	  11 | 1719540297159 | t1         | out-of-sync | 2024-06-28 10:04:58.066141+08 |         6 |                  3 |                  0 |             0 |          6 |          9
	  12 | 1719540297159 | t2         | out-of-sync | 2024-06-28 10:05:04.188957+08 |         2 |                  0 |                  1 |             0 |          3 |          2

官方给出的查询的SQL语句

代码语言：txt
AI代码解释
复制

1、上次运行的结果
	WITH mr AS (SELECT max(rid) rid FROM dc_result)
	SELECT compare_dt, table_name, status, source_cnt total_cnt, equal_cnt, not_equal_cnt, missing_source_cnt+missing_target_cnt missing_cnt
	FROM dc_result r
		 JOIN mr ON (mr.rid=r.rid)
	ORDER BY table_name;

结构
pgcompare-# ORDER BY table_name;
          compare_dt           | table_name |   status    | total_cnt | equal_cnt | not_equal_cnt | missing_cnt 
-------------------------------+------------+-------------+-----------+-----------+---------------+-------------
 2024-06-28 10:37:59.375011+08 | t1         | out-of-sync |         6 |         6 |             0 |           3
 2024-06-28 10:38:05.552199+08 | t2         | out-of-sync |         3 |         2 |             0 |           1
 2024-06-28 10:38:11.672654+08 | t3         | in-sync     |         2 |         2 |             0 |           0
 2024-06-28 10:38:17.797341+08 | t4         | skipped     |         0 |         0 |             0 |           0
(4 rows)


2、不同步的行（注意：如果target的行比source的多，则不会被报告出来）
	SELECT coalesce(s.table_name,t.table_name) table_name,
	   coalesce(s.batch_nbr, t.batch_nbr) batch_nbr,
       coalesce(s.thread_nbr,t.thread_nbr) thread_nbr,
       CASE WHEN s.compare_result='n' THEN 'out-of-sync'
            WHEN s.compare_result='m' THEN 'missing target'
            WHEN t.compare_result='m' THEN 'missing source'
            ELSE 'unknown'
       END compare_result,
       coalesce(s.pk,t.pk) primary_key       
	FROM dc_source s
		 CROSS JOIN dc_target t;

pgcompare-#  CROSS JOIN dc_target t;
 table_name | batch_nbr | thread_nbr | compare_result | primary_key 
------------+-----------+------------+----------------+-------------
 t2         |         1 |          0 | missing target | {"b": 567}
 t2         |         1 |          0 | missing target | {"b": 567}
 t2         |         1 |          0 | missing target | {"b": 567}
(3 rows)

如果发现差异，请使用--check选项运行比较：

代码语言：txt
AI代码解释
复制
java -jar pgcompare.jar --batch=0 --check

当初始比较期间事务可能正在进行时，此重新检查过程非常有用。
重新检查仅检查已标记为存在差异的行。如果行仍然不匹配，则会报告详细信息。否则，行将被清除并标记为同步。

其它：

代码语言：txt
AI代码解释
复制
如果在执行完pgcompare后，数据库里面又增加或者减少了表，则需要重新执行 下面的操作：

0、清空pgcompare下面的各个表（清掉后便于查看最新数据，不清的话则需要根据compare_dt时间戳来判断是哪一次执行的比对操作）
	truncate table pgcompare.dc_object        ;
	truncate table pgcompare.dc_result        ;
	truncate table pgcompare.dc_source        ;
	truncate table pgcompare.dc_table         ;
	truncate table pgcompare.dc_table_history ;
	truncate table pgcompare.dc_target        ;


1、java -jar pgcompare.jar --discovery public


2、查看pg存储库的是否采集到表信息
	pgcompare=# select * from dc_table;
	 tid | source_schema | source_table | target_schema | target_table | batch_nbr | parallel_degree | mod_column | status | table_filter | column_map 
	-----+---------------+--------------+---------------+--------------+-----------+-----------------+------------+--------+--------------+------------
	   6 | public        | t1           | public        | t1           |         1 |               1 | NULL       | ready  | NULL         | NULL
	   7 | public        | t2           | public        | t2           |         1 |               1 | NULL       | ready  | NULL         | NULL
	   8 | public        | t3           | public        | t3           |         1 |               1 | NULL       | ready  | NULL         | NULL
	(3 rows)


3、java -jar pgcompare.jar --batch=0
	
	
4、查看比对的结果
	pgcompare=# select * from dc_result;
	 cid |      rid      | table_name |   status    |          compare_dt           | equal_cnt | missing_source_cnt | missing_target_cnt | not_equal_cnt | source_cnt | target_cnt 
	-----+---------------+------------+-------------+-------------------------------+-----------+--------------------+--------------------+---------------+------------+------------
	  17 | 1719540698085 | t1         | out-of-sync | 2024-06-28 10:11:39.071168+08 |         6 |                  3 |                  0 |             0 |          6 |          9
	  18 | 1719540698085 | t2         | out-of-sync | 2024-06-28 10:11:45.231873+08 |         2 |                  0 |                  1 |             0 |          3 |          2
	  19 | 1719540698085 | t3         | in-sync     | 2024-06-28 10:11:51.378574+08 |         3 |                  0 |                  0 |             0 |          3 |          3
	(3 rows)


5、找出不同步的行（注意：如果target的行比source的多，则不会被报告出来）
		SELECT coalesce(s.table_name,t.table_name) table_name,
	   coalesce(s.batch_nbr, t.batch_nbr) batch_nbr,
       coalesce(s.thread_nbr,t.thread_nbr) thread_nbr,
       CASE WHEN s.compare_result='n' THEN 'out-of-sync'
            WHEN s.compare_result='m' THEN 'missing target'
            WHEN t.compare_result='m' THEN 'missing source'
            ELSE 'unknown'
       END compare_result,
       coalesce(s.pk,t.pk) primary_key       
		FROM dc_source s
		 CROSS JOIN dc_target t;

原创声明：本文系作者授权腾讯云开发者社区发表，未经许可，不得转载。

如有侵权，请联系 cloudcommunity@tencent.com 删除。

postgresql

原创声明：本文系作者授权腾讯云开发者社区发表，未经许可，不得转载。

如有侵权，请联系 cloudcommunity@tencent.com 删除。

postgresql
评论
登录后参与评论
暂无评论
登录 后参与评论
推荐阅读
编辑精选文章
换一批
商家下载中心设计演进之路｜得物技术
1993
重构这件“小”事儿 ｜ 得物技术
2361
一文读懂10种最经典的设计模式
6839
一篇文搞定消息队列选型
2546
腾讯写码6年，我总结的技术人核心竞争力
3686
醍醐灌顶！异地多活架构设计看这篇就够了
4229
C#开发BIMFACE系列41 服务端API之模型对比
apic#sdkide
　　在建筑施工图审查系统中，设计单位提交设计完成的模型/图纸，审查专家审查模型/图纸。审查过程中如果发现不符合规范的地方，则流程退回到设计单位，设计单位人员根据审查意见重新调整设计，调整完成后再次提交到审查专家。此时为了便于专家审查，需要知道当前轮次的模型/图纸与上一轮次的模型/图纸发生了哪些异动，针对异动情况进行审查即可。
张传宁IT讲堂
2021/10/13
3690
C#开发BIMFACE系列30 服务端API之模型对比1：发起模型对比
apihttpshttp网络安全
　　在实际项目中，由于需求变更经常需要对模型文件进行修改。为了便于用户了解模型在修改前后发生的变化，BIMFACE提供了模型在线对比功能，可以利用在线的模型对比接口，通过简单的四个步骤实现模型在线对比。模型对比可以对两个文件/模型进行差异性分析，确定两个文件/模型之间构件的几何和属性差异，包括增加的构件、删除的构件和修改的构件。 模型对应可以用于进行文件/模型的版本对比。
张传宁IT讲堂
2020/03/18
4620
C#开发BIMFACE系列34 服务端API之模型对比5：获取模型构件对比差异
httpshttpc#网络安全网站
　　BIMFACE平台提供了服务端“获取修改构件属性差异”API，其返回的结果也是一个列表，仅针对修改的构件（不包含新增、删除的构件），是指对于一个修改过的构件ID，其修改前后分别新增、删除了哪些属性，或是属性值发生了变化。
张传宁IT讲堂
2020/03/18
3170
C#开发BIMFACE系列34 服务端API之模型对比5：获取模型构件对比差异
C#开发BIMFACE系列12 服务端API之文件转换
c#asp.nethttphttps网络安全
在模型成功进行转换后，模型内的BIM信息会在云端进行解析，抽取并结构化入库。这些信息包含：
张传宁IT讲堂
2019/09/18
1.7K0
C#开发BIMFACE系列40 服务端API之模型集成
c#http网站
　　随着建筑信息化模型技术的发展，越来越多的人选择在云端浏览建筑模型。现阶段的云端模型浏览大多是基于文件级别，一次只可以浏览一个模型文件中的内容。而在工程项目模型设计的过程中，通常由多个设计师协同设计，不同的设计师负责不同的专业领域（例如建筑、结构、水电等）。如果想要在云端浏览整个项目工程，就需要把这些组成部分集成起来一起展示。更近一步，如果要在集成的模型之上进行业务集成的话，就要求在集成过程中对构件按单体，楼层，专业，构件分类，系统类型等进行分类或映射。
张传宁IT讲堂
2021/10/13
5750
C#开发BIMFACE系列16 服务端API之获取模型数据1：查询满足条件的构件ID列表
httphttpsc#网络安全
源文件/模型转换完成之后，可以获取模型的具体数据。本篇介绍根据文件ID查询满足条件的构件ID列表。
张传宁IT讲堂
2019/09/18
9860
C#开发BIMFACE系列16 服务端API之获取模型数据1：查询满足条件的构件ID列表
C#开发BIMFACE系列39 网页集成开发3：审图系统中三维模型比对
apisdkide
　　在建筑施工图审查系统中，设计单位提交设计完成的模型/图纸，审查专家审查模型/图纸。审查过程中如果发现不符合规范的地方，则流程退回到设计单位，设计单位人员根据审查意见重新调整设计，调整完成后再次提交到审查专家。此时为了便于专家审查，需要知道当前轮次的模型/图纸与上一轮次的模型/图纸发生了哪些异动，针对异动情况进行审查即可。
张传宁IT讲堂
2020/04/30
4310
C#开发BIMFACE系列39 网页集成开发3：审图系统中三维模型比对
C#开发BIMFACE系列33 服务端API之模型对比4：获取模型对比结果
apihttpsc#网络安全网站
　　模型对比可以对两个文件/模型进行差异性分析，确定两个文件/模型之间构件的几何和属性差异，包括增加的构件、删除的构件和修改的构件。 模型对应可以用于进行文件/模型的版本对比。
张传宁IT讲堂
2020/03/18
6750
C#开发BIMFACE系列35 服务端API之模型对比6：获取模型构建对比分类树
httpshttpc#网络安全网站
　　BIMFACE平台提供了服务端“获取模型对比构件分类树”API。目录树返回结果以树状层级关系显示了增删改的构件信息，里面无法区分哪些构建是新增、修改或者删除的，所以在实际项目中使用意义不大。
张传宁IT讲堂
2020/03/18
4200
C#开发BIMFACE系列32 服务端API之模型对比3：批量获取模型对比状态
https网络安全
　　在《C#开发BIMFACE系列31 服务端API之模型对比2：获取模型对比状态》中介绍了根据对比ID，获取一笔记录的对比状态。由于模型对比是在BIMFACE云端进行的，通常需要5~10分钟，在等待对比的过程中还可以发起更多的模型对比，最后通过接口一次性批量获取模型对比状态 。
张传宁IT讲堂
2020/03/18
4330
C#开发BIMFACE系列14 服务端API之批量获取转换状态详情
httphttpsc#网络安全
上一篇《C#开发BIMFACE系列13 服务端API之获取转换状态》中介绍了根据文件ID查询单个文件的转换状态。
张传宁IT讲堂
2019/09/18
6240
C#开发BIMFACE系列44 服务端API之计算图纸对比差异项来源自哪个图框
apisdkidec#
在前两篇博客《C#开发BIMFACE系列42 服务端API之图纸对比》、《C#开发BIMFACE系列43 服务端API之图纸拆分》中介绍了单文件多图框的拆分与对比
张传宁IT讲堂
2021/10/15
3160
C#开发BIMFACE系列45 服务端API之创建离线数据包
https网络安全sdkide
BIMFACE的常规应用方式有公有云与私有化部署两种方式，并且浏览模型或者图纸需要使用ViewToken，ViewToken 有效期为12小时，过期后需要调用接口重新生成。该过程稍微有点麻烦且性能可能受到网络等环境的影响。本文介绍第三种更加便捷高效的方式。
张传宁IT讲堂
2021/10/18
3650
C#开发BIMFACE系列50 Web网页中使用jQuery加载模型与图纸
网站sdkidejqueryjavascript
在前一篇博客《C#开发BIMFACE系列49 Web网页集成BIMFACE应用的技术方案》中介绍了目前市场主流的Web开发技术与应用框架，其中前端脚本的应用在国内分2大派系 jQuery 与 Vue.js。
张传宁IT讲堂
2021/10/21
8640
C#开发BIMFACE系列29 服务端API之获取模型数据14：获取图纸列表
c#httpshttp网络安全
一个三维模型中可能包含对应多张二维图纸列表，本篇主要介绍如何获取模型文件对应的图纸列表。
张传宁IT讲堂
2019/09/18
5430
C#开发BIMFACE系列29 服务端API之获取模型数据14：获取图纸列表
C#开发BIMFACE系列51 Web网页中使用Vue.js加载模型与图纸
编程算法sdkidejquery网站
在前一篇博客《C#开发BIMFACE系列50 Web网页中使用jQuery加载模型与图纸》中详细介绍了在网页中使用jQuery加载模型与图纸
张传宁IT讲堂
2021/10/21
1.4K0
C#开发BIMFACE系列43 服务端API之图纸拆分
apisdkide
在上一篇博客《C#开发BIMFACE系列42 服务端API之图纸对比》的最后留了一个问题，在常规业务场景下，一个.dwg文件中包含多个图框，如下图
张传宁IT讲堂
2021/10/15
3990
C#开发BIMFACE系列37 网页集成开发1：审图系统中加载模型或图纸
api编程算法c#sdkjavascript
在之前的《C#开发BIMFACE系列》中主要介绍了BIMFACE平台提供的服务端API接口的封装开发与测试过程。
张传宁IT讲堂
2020/03/18
8010
C#开发BIMFACE系列37 网页集成开发1：审图系统中加载模型或图纸
C#开发BIMFACE系列46 服务端API之离线数据包下载及结构详解
存储数据库sqlsdkaccess
在前一篇博客《C#开发BIMFACE系列45 服务端API之创建离线数据包》中通过调用接口成功的创建一个离线数据包
张传宁IT讲堂
2021/10/18
6840
C#开发BIMFACE系列18 服务端API之获取模型数据3：获取构件属性
httpshttpc#网络安全
请求地址：GET https://api.bimface.com/data/v2/files/{fileId}/elements/{elementId}
张传宁IT讲堂
2019/09/18
6330
C#开发BIMFACE系列18 服务端API之获取模型数据3：获取构件属性
推荐阅读
编辑精选文章
商家下载中心设计演进之路｜得物技术重构这件“小”事儿 ｜ 得物技术一文读懂10种最经典的设计模式一篇文搞定消息队列选型腾讯写码6年，我总结的技术人核心竞争力醍醐灌顶！异地多活架构设计看这篇就够了
相关讨论
图片对比识别？访问服务端 401？无法提取对比照？
相关课程
轻量应用构建训练营AI绘画-StableDiffusion图像生成C/Python
C#开发BIMFACE系列41 服务端API之模型对比
3690
C#开发BIMFACE系列30 服务端API之模型对比1：发起模型对比
4620
C#开发BIMFACE系列34 服务端API之模型对比5：获取模型构件对比差异
3170
C#开发BIMFACE系列12 服务端API之文件转换
1.7K0
C#开发BIMFACE系列40 服务端API之模型集成
5750
C#开发BIMFACE系列16 服务端API之获取模型数据1：查询满足条件的构件ID列表
9860
C#开发BIMFACE系列39 网页集成开发3：审图系统中三维模型比对
4310
C#开发BIMFACE系列33 服务端API之模型对比4：获取模型对比结果
6750
C#开发BIMFACE系列35 服务端API之模型对比6：获取模型构建对比分类树
4200
C#开发BIMFACE系列32 服务端API之模型对比3：批量获取模型对比状态
4330
C#开发BIMFACE系列14 服务端API之批量获取转换状态详情
6240
C#开发BIMFACE系列44 服务端API之计算图纸对比差异项来源自哪个图框
3160
C#开发BIMFACE系列45 服务端API之创建离线数据包
3650
C#开发BIMFACE系列50 Web网页中使用jQuery加载模型与图纸
8640
C#开发BIMFACE系列29 服务端API之获取模型数据14：获取图纸列表
5430
C#开发BIMFACE系列51 Web网页中使用Vue.js加载模型与图纸
1.4K0
C#开发BIMFACE系列43 服务端API之图纸拆分
3990
C#开发BIMFACE系列37 网页集成开发1：审图系统中加载模型或图纸
8010
C#开发BIMFACE系列46 服务端API之离线数据包下载及结构详解
6840
C#开发BIMFACE系列18 服务端API之获取模型数据3：获取构件属性
6330
相关推荐
C#开发BIMFACE系列41 服务端API之模型对比
更多 >
张传宁IT讲堂0
LV.0
这个人很懒，什么都没有留下～
文章
268
获赞
584
专栏
3
作者相关精选
换一批
加入讨论
的问答专区 >
Delphi Shen0
相关课程
一站式学习中心 >
轻量应用构建训练营
3065人在学
云服务器
轻量应用服务器
云计算
AI绘画-StableDiffusion图像生成
1703人在学
大模型图像创作引擎
高性能应用服务
C/Python
1022人在学
c 语言
python
领券

腾讯云开发者

扫码关注腾讯云开发者

扫码关注腾讯云开发者

领取腾讯云代金券

热门产品

热门推荐

更多推荐

Copyright © 2013 - 2025 Tencent Cloud. All Rights Reserved. 腾讯云 版权所有 

深圳市腾讯计算机系统有限公司 ICP备案/许可证号：粤B2-20090059 深公网安备号 44030502008569

腾讯云计算（北京）有限责任公司 京ICP证150476号 |  京ICP备11018762号 | 京公网安备号11010802020287

问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档

Copyright © 2013 - 2025 Tencent Cloud.

All Rights Reserved. 腾讯云 版权所有

登录 后参与评论
1