/
apgdiff.rb
64 lines (51 loc) 路 1.65 KB
/
apgdiff.rb
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
class Apgdiff < Formula
desc "Another PostgreSQL diff tool"
homepage "https://www.apgdiff.com/"
url "https://github.com/fordfrog/apgdiff/archive/refs/tags/release_2.7.0.tar.gz"
sha256 "932a7e9fef69a289f4c7bed31a9c0709ebd2816c834b65bad796bdc49ca38341"
license "MIT"
livecheck do
url :stable
regex(/^release[._-]v?(\d+(?:\.\d+)+)$/i)
end
bottle do
sha256 cellar: :any_skip_relocation, all: "f52732f8db636f2d122c471ea2e36b02e10b73ba23048040aafa44f79ff0dd69"
end
head do
url "https://github.com/fordfrog/apgdiff.git", branch: "develop"
depends_on "ant" => :build
end
depends_on "openjdk"
def install
jar = "releases/apgdiff-#{version}.jar"
if build.head?
system "ant", "-Dnoget=1"
jar = Dir["dist/apgdiff-*.jar"].first
end
libexec.install jar
bin.write_jar_script libexec/File.basename(jar), "apgdiff"
end
test do
sql_orig = testpath/"orig.sql"
sql_new = testpath/"new.sql"
sql_orig.write <<~EOS
SET search_path = public, pg_catalog;
SET default_tablespace = '';
CREATE TABLE testtable (field1 integer);
ALTER TABLE public.testtable OWNER TO fordfrog;
EOS
sql_new.write <<~EOS
SET search_path = public, pg_catalog;
SET default_tablespace = '';
CREATE TABLE testtable (field1 integer,
field2 boolean DEFAULT false NOT NULL);
ALTER TABLE public.testtable OWNER TO fordfrog;
EOS
expected = <<~EOS.strip
ALTER TABLE testtable
\tADD COLUMN field2 boolean DEFAULT false NOT NULL;
EOS
result = pipe_output("#{bin}/apgdiff #{sql_orig} #{sql_new}").strip
assert_equal result, expected
end
end