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
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
|
EXTENSION = q3c
EXTVERSION := $(shell grep default_version ../$(EXTENSION).control | \
sed -e "s/default_version[[:space:]]*=[[:space:]]*'\([^']*\)'/\1/")
DOCS = README.md
OBJS = dump.o q3c.o q3c_poly.o q3cube.o
MODULE_big = q3c
DATA = scripts/q3c--$(EXTVERSION).sql
PG_CONFIG = pg_config
SHLIB_LINK += $(filter -lm, $(LIBS))
EXTRA_CLEAN = dump.c prepare prepare.o gen_data.o \
results/join.out results/cone.out results/ellipse.out \
results/version.out results/poly.out results/area.out \
gen_data
OPT = -O3
OPT_LOW = -O2
#DEBUG = -g3 -ggdb -DQ3C_DEBUG
PG_CPPFLAGS = $(DEBUG) $(OPT) -D_GNU_SOURCE -D__STDC_FORMAT_MACROS -DQ3C_VERSION='"'$(EXTVERSION)'"'
CPPFLAGS = $(CPPFLAGS) -D$(Q3CVERSION)
MYBINLIBS = -lm
# I have to use this instead of PG_LIBS, because PG_LIBS brings a
# bunch of libraries which are often not installed
PGXS := $(shell $(PG_CONFIG) --pgxs)
include $(PGXS)
dump.c: prepare
./prepare
prepare: prepare.o q3cube.o q3c_poly.o
$(CC) prepare.o q3cube.o q3c_poly.o $(MYBINLIBS) -o $@
gen_data: gen_data.c
$(CC) $< $(CPPFLAGS) $(MYBINLIBS) -o $@
test: gen_data
createdb q3c_test
psql q3c_test -c "CREATE TABLE test (ra double precision, dec double precision)"
psql q3c_test -c "CREATE TABLE test1 (ra double precision, dec double precision)"
psql q3c_test -c "CREATE TABLE test_pm0 (ra double precision, dec double precision, pmra real, pmdec real, epoch real)"
psql q3c_test -c "CREATE TABLE test_pm1 (ra double precision, dec double precision, pmra real, pmdec real, epoch real)"
psql q3c_test -c "CREATE TABLE test_small (ra double precision, dec double precision)"
./gen_data 1 1000000 | psql q3c_test -c "COPY test FROM STDIN WITH DELIMITER ' '"
./gen_data 2 1000000 | psql q3c_test -c "COPY test1 FROM STDIN WITH DELIMITER ' '"
./gen_data 3 100000 | psql q3c_test -c "COPY test_small FROM STDIN WITH DELIMITER ' '"
./gen_data 4 1000000 --withpm --pmscale=0 --randomepoch | psql q3c_test -c "COPY test_pm0 FROM STDIN WITH DELIMITER ' '"
./gen_data 5 1000000 --withpm --pmscale=1000 --epoch=2015 | psql q3c_test -c "COPY test_pm1 FROM STDIN WITH DELIMITER ' '"
psql q3c_test -c 'create extension q3c'
psql q3c_test -c 'CREATE INDEX q3c_idx1 ON test1 (q3c_ang2ipix(ra,dec))'
psql q3c_test -c 'CREATE INdex ON test_pm0 (q3c_ang2ipix(ra,dec))'
psql q3c_test -c 'CREATE INDEX on test_pm1 (q3c_ang2ipix(ra,dec))'
psql q3c_test -c 'CREATE INDEX q3c_idx ON test (q3c_ang2ipix(ra,dec))'
psql q3c_test -c 'CREATE INDEX q3c_idx_small ON test_small (q3c_ang2ipix(ra,dec))'
psql q3c_test -c 'ANALYZE test'
psql q3c_test -c 'ANALYZE test1'
psql q3c_test -c 'ANALYZE test_pm0'
psql q3c_test -c 'ANALYZE test_pm1'
psql q3c_test -c 'ANALYZE test_small'
mkdir -p results
cat sql/ang2ipix.sql | psql q3c_test > results/ang2ipix.out
diff results/ang2ipix.out expected/ang2ipix.expected
cat sql/cone.sql | psql q3c_test > results/cone.out
diff results/cone.out expected/cone.expected
cat sql/cone_join_rev.sql | psql q3c_test > results/cone.out
diff results/cone.out expected/cone.expected
cat sql/ellipse.sql | psql q3c_test > results/ellipse.out
diff results/ellipse.out expected/ellipse.expected
cat sql/join.sql | psql q3c_test > results/join.out
diff results/join.out expected/join.expected
cat sql/join_pm1.sql | psql q3c_test > results/join_pm1.out
diff results/join_pm1.out expected/join_pm1.expected
cat sql/join_pm2.sql | psql q3c_test > results/join_pm2.out
diff results/join_pm2.out expected/join_pm2.expected
cat sql/poly.sql | psql q3c_test > results/poly.out
diff results/poly.out expected/poly.expected
cat sql/version.sql | psql q3c_test > results/version.out
diff results/version.out expected/version.expected
cat sql/area.sql | psql q3c_test > results/area.out
diff results/area.out expected/area.expected
dropdb q3c_test
|
