如何区分 2 个 SQLite 文件?

How can I diff 2 SQLite files?(如何区分 2 个 SQLite 文件?)
本文介绍了如何区分 2 个 SQLite 文件?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

在 Mac 上使用 SQLite-manager(以其 XUL 形式).

Using SQLite-manager (in its XUL form) on a Mac.

如何将 SQLite 文件与团队中其他人提交的文件区分开来,并合并他的更改?

How can I diff a SQLite file from one submitted by someone else on the team, and incorporate his changes?

谢谢.

推荐答案

我相信您可以结合使用以下内容:

I believe you could use the following, in combination:

$ diff sqlite-file-1.sql sqlite-file-2.sql > sqlite-patch.diff
$ patch -p0 sqlite-file-1.sql sqlite-patch.diff

我希望这对你有用.否则,我强烈建议您查阅手册页:

I hope that works for you. Otherwise, I highly suggest consulting the man-pages:

$ man diff
$ man patch

好的,这是整个演练.

首先,转储数据库:

$ sqlite test1.sql .dump > test1.sql.txt
$ sqlite test2.sql .dump > test2.sql.txt

接下来,生成一个差异文件:

Next, generate a diff file:

$ diff -u test1.sql.txt test2.sql.txt > patch-0.1.diff

最后,应用补丁:

$ patch -p0 test1.sql.txt patch-0.1.diff

这篇关于如何区分 2 个 SQLite 文件?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持编程学习网!

本站部分内容来源互联网,如果有图片或者内容侵犯您的权益请联系我们删除!

相关文档推荐

FastAPI + Tortoise ORM + FastAPI Users (Python) - Relationship - Many To Many(FastAPI+Tortoise ORM+FastAPI用户(Python)-关系-多对多)
Window functions not working in pd.read_sql; Its shows error(窗口函数在pd.read_sql中不起作用;它显示错误)
(Closed) Leaflet.js: How I can Do Editing Geometry On Specific Object I Select Only?((已关闭)Leaflet.js:如何仅在我选择的特定对象上编辑几何图形?)
in sqlite update trigger with multiple if/Case Conditions(在具有多个IF/CASE条件的SQLite UPDATE触发器中)
Android: Why is Room so slow?(Android:为什么Room这么慢?)
SQL Server 2017 - How to pass a parameter in a SELECT inside a dynamic SQL(SQL Server 2017-如何在动态SQL内的SELECT中传递参数)