Annotation of db/prgsrc/Makefile, revision 1.84
1.84 ! boris 1: HOSTNAME=$(shell hostname)
! 2: ifeq ($(HOSTNAME),bilbo)
! 3: ROOT=/home/znatoki
! 4: endif
1.6 boris 5: ifndef ROOT
1.83 boris 6: ROOT = $(HOME)
1.6 boris 7: endif
1.1 boris 8: PERL = perl
9: TMPSAV = /tmp
10: PMODE = 775
11: LMODE = 664
1.83 boris 12: KULICHKI=chgk-db-boris@ledorub.chgk.info
1.80 boris 13: RSYNC = rsync -ruvptCe ssh --delete --progress
1.16 boris 14: SCP=scp
1.83 boris 15: DESTSRCDIR=~chgk-db/public_html/dimrub/src/
1.23 roma7 16: SRCDIR=../baza
1.48 roma7 17: DICTDIR=../dict
1.40 boris 18: IMAGEDIR=$(SRCDIR)/images
1.83 boris 19: DESTIMAGEDIR=~chgk-db/public_html/images/db
1.40 boris 20: INSTALLIMAGEDIR=$(ROOT)/public_html/images/db
1.83 boris 21: DESTPRGSRC=~chgk-db/db/prgsrc
22: DESTCGIBIN=~chgk-db/public_html/cgi-bin
1.1 boris 23: DUMPDIR=../dump
1.17 boris 24: DESTDUMPDIR=/var/tmp/
1.42 roma7 25: TABLES= Questions Tournaments word2question nf nests Authors A2Q equalto
1.38 roma7 26: INDEXWRITER= rubash@yandex.ru, roma7@zaba.ru
1.34 boris 27: #INDEXWRITER= boris
28: AUTHORCHECKER = roma7@zaba.ru
29: #AUTHORCHECKER = boris
30: DELIVERER = roma7@zaba.ru, boris
1.35 boris 31: #DELIVERER = boris
1.34 boris 32: UPDATELOG = $(DUMPDIR)/update.log
33: UAUTHORS=$(DUMPDIR)/uauthors
34: UNSORTED=$(DUMPDIR)/unsorted
1.69 boris 35: RSPARAMS= 2000 75
1.39 boris 36: TIMESTAMP= $(DUMPDIR)/timestamp
1.1 boris 37:
38: DBSCRIPTS = mkdb.pl \
39: updatem.pl \
40: updatedb.pl \
41: changecities.pl\
42: createindex.pl\
43: updateindex.pl \
1.8 boris 44: addlinks.pl \
1.9 boris 45: deletefiles.pl\
1.10 boris 46: renamefile.pl \
1.11 boris 47: makecheck.pl\
48: mkRS.pl\
1.14 boris 49: delRS.pl\
1.11 boris 50: updateRS.pl\
51: updateRS1.pl\
1.15 boris 52: updateRS2.pl\
53: updateRS3.pl\
1.11 boris 54: dumpRS.pl\
1.45 roma7 55: findequal.pl\
1.11 boris 56: dumpin2out.pl\
57: dump2dump.pl\
58: checkPBS.pl\
1.34 boris 59: loaddump.pl \
1.57 boris 60: makeauthors.pl\
1.77 boris 61: chronicles.pl\
1.78 boris 62: stats.pl \
63: validate.pl
1.11 boris 64:
65: LIBS = chgkfiles.pm \
1.10 boris 66: common.pl\
67: chgk.cnf\
1.11 boris 68: dbchgk.pm\
69: check.pl
1.10 boris 70:
1.1 boris 71:
1.70 boris 72: CGISCRIPTS = db.cgi\
73: dbdefs.pl
1.1 boris 74:
1.12 boris 75:
76: HTMLS = contribute.html \
77: copyright.html \
78: copyright_mozg.html \
79: credits.html \
80: dbmain.html \
81: footer.html \
82: guestbook.html \
83: index.html \
84: random.html \
85: reklama.html \
1.58 boris 86: reklama_bottom.html\
1.12 boris 87: search.html
88:
89:
1.13 boris 90:
1.1 boris 91: DBBIN = ../bin
92: MANDIR = ../man
1.10 boris 93: LIBDIR = ../lib
1.6 boris 94: CGIBIN = $(ROOT)/public_html/cgi-bin
1.13 boris 95: HTMLDIR = $(ROOT)/public_html/dimrub/db
1.1 boris 96:
1.40 boris 97: TEXTS = $(wildcard $(SRCDIR)/*.txt) $(SRCDIR)/index
98: IMAGES = $(wildcard $(IMAGEDIR)/*.jpg)
99: IMAGENAMES= $(notdir $(IMAGES))
100:
101:
102:
1.10 boris 103: BININSTALL = ${DBSCRIPTS:%=$(DBBIN)/%}
1.1 boris 104: CGIINSTALL = ${CGISCRIPTS:%.cgi=$(CGIBIN)/%.cgi}
1.10 boris 105: LIBINSTALL = ${LIBS:%=$(LIBDIR)/%}
1.13 boris 106: HTMLINSTALL = ${HTMLS:%.html=$(HTMLDIR)/%.html}
1.40 boris 107: IMAGEINSTALL = ${IMAGENAMES:%=$(INSTALLIMAGEDIR)/%}
108:
1.84 ! boris 109:
1.40 boris 110: all: $(LIBINSTALL) $(BININSTALL) $(CGIINSTALL) $(HTMLINSTALL) $(IMAGEINSTALL)
111:
1.10 boris 112:
1.1 boris 113:
1.39 boris 114:
1.1 boris 115:
1.11 boris 116: $(DBBIN)/%.pl: %.pl
1.1 boris 117: ${PERL} -c $<
118: - pod2man --center "Internet Club DB" $< > $*.1
119: - install -m $(LMODE) $*.1 $(MANDIR)/man1
1.10 boris 120: - rm $*.1
1.1 boris 121: if [ -f $@ ]; then mv $@ $(TMPSAV); fi
122: cp $< $@
123: chmod $(PMODE) $@
124: if [ -f $(TMPSAV)/$(@F) ]; then rm -f $(TMPSAV)/$(@F); fi
1.33 boris 125:
1.1 boris 126: $(CGIBIN)/%.cgi: %.cgi
127: ${PERL} -c $<
128: - pod2man --center "Internet Club DB" $< > $*.1
129: - install -m $(LMODE) $*.1 $(MANDIR)/man1
1.10 boris 130: - rm $*.1
1.1 boris 131: if [ -f $@ ]; then mv $@ $(TMPSAV); fi
132: cp $< $@
133: chmod $(PMODE) $@
134: if [ -f $(TMPSAV)/$(@F) ]; then rm -f $(TMPSAV)/$(@F); fi
135:
136:
1.10 boris 137:
138: $(LIBDIR)/%.pm: %.pm
139: ${PERL} -c $<
140: - pod2man --center "Internet Club DB" $< > $*.3
141: - install -m $(LMODE) $*.3 $(MANDIR)/man3
142: - rm $*.3
1.11 boris 143: if [ -f $@ ]; then mv $@ $(TMPSAV); fi
144: cp $< $@
145: chmod $(LMODE) $@
146: if [ -f $(TMPSAV)/$(@F) ]; then rm -f $(TMPSAV)/$(@F); fi
147:
148:
149: $(LIBDIR)/%.pl: %.pl
150: ${PERL} -c $<
151: - pod2man --center "Internet Club DB" $< > $*.3
152: - install -m $(LMODE) $*.3 $(MANDIR)/man3
153: - rm $*.3
154: if [ -f $@ ]; then mv $@ $(TMPSAV); fi
155: cp $< $@
156: chmod $(LMODE) $@
157: if [ -f $(TMPSAV)/$(@F) ]; then rm -f $(TMPSAV)/$(@F); fi
158:
159:
160: $(LIBDIR)/%.cnf: %.cnf
161: ${PERL} -c $<
162: - pod2man --center "Internet Club DB" $< > $*.5
163: - install -m $(LMODE) $*.5 $(MANDIR)/man5
164: - rm $*.5
1.10 boris 165: if [ -f $@ ]; then mv $@ $(TMPSAV); fi
166: cp $< $@
167: chmod $(LMODE) $@
168: if [ -f $(TMPSAV)/$(@F) ]; then rm -f $(TMPSAV)/$(@F); fi
169:
170:
1.12 boris 171: $(HTMLDIR)/%.html: %.html
172: cp $< $@
173:
1.10 boris 174:
1.40 boris 175: $(INSTALLIMAGEDIR)/%: $(IMAGEDIR)/%
176: cp $< $@
1.1 boris 177:
178: srcdeliver:
179: $(RSYNC) $(SRCDIR) $(KULICHKI):$(DESTSRCDIR)
180:
181:
1.40 boris 182: imagedeliver:
1.49 boris 183: cvs update $(SRCDIR)
1.60 boris 184: $(RSYNC) $(IMAGEDIR)/ $(KULICHKI):$(DESTIMAGEDIR)/
1.40 boris 185:
1.1 boris 186: prgdeliver:
187: $(RSYNC) ./ $(KULICHKI):$(DESTPRGSRC)
188:
1.40 boris 189: dbdeliver: imagedeliver
1.51 roma7 190: echo "Starting delivering" | mail -s"Starting delivering" $(DELIVERER)
1.82 boris 191: mysqldump --default-character-set=koi8r --add-drop-table --compatible=mysql323 -u piataev chgk $(TABLES) > $(DUMPDIR)/chgkdump
1.59 boris 192: echo "delete from hash;" >> $(DUMPDIR)/chgkdump
1.16 boris 193: gzip $(DUMPDIR)/chgkdump
194: $(SCP) $(DUMPDIR)/chgkdump.gz $(KULICHKI):$(DESTDUMPDIR)
1.46 boris 195: echo "Delivered" | mail -s"Database delivered" $(DELIVERER)
1.12 boris 196:
1.24 roma7 197: update:
1.50 boris 198: cvs update
1.21 roma7 199: cvs update $(SRCDIR)
1.48 roma7 200: cvs update $(DICTDIR)
1.50 boris 201: $(MAKE) all
1.39 boris 202: $(MAKE) $(TIMESTAMP)
203:
204: $(TIMESTAMP): $(TEXTS)
1.27 roma7 205: mysql -upiataev chgk <delq.sql
1.36 boris 206: $(DBBIN)/mkdb.pl
207: $(DBBIN)/updateindex.pl -i$(SRCDIR)/index
208: $(DBBIN)/updatedb.pl $(SRCDIR)/*.txt 2>&1 | tee $(UPDATELOG)
1.43 roma7 209: $(DBBIN)/findequal.pl
1.36 boris 210: $(DBBIN)/makeauthors.pl
1.34 boris 211: if [ -s $(UAUTHORS) ]; then \
212: mail -sUauthors $(AUTHORCHECKER) < $(UAUTHORS); \
213: fi
214: if [ -s $(UNSORTED) ]; then \
215: mail -sUnsorted $(INDEXWRITER) <$(UNSORTED);\
216: else \
1.36 boris 217: $(DBBIN)/mkRS.pl; \
218: $(DBBIN)/updateRS2.pl $(RSPARAMS);\
1.47 roma7 219: echo "Ready to deliver" | mail -s"Ready to deliver" $(DELIVERER);\
1.34 boris 220: fi
1.39 boris 221: touch $(TIMESTAMP)
222:
1.33 boris 223:
224: authorsdeliver:
1.42 roma7 225: mysqldump --add-drop-table -u piataev chgk Authors A2Q equalto > $(DUMPDIR)/chgkdump.0
1.33 boris 226: sed 's/TYPE=ISAM PACK_KEYS=1//g' $(DUMPDIR)/chgkdump.0 > $(DUMPDIR)/chgkdump
227: gzip $(DUMPDIR)/chgkdump
228: rm $(DUMPDIR)/chgkdump.0
229: $(SCP) $(DUMPDIR)/chgkdump.gz $(KULICHKI):$(DESTDUMPDIR)
230:
1.52 boris 231:
232: dbfill:
233: echo "Starting filling Kulichki database" | mail -s"Starting dbfill" $(DELIVERER)
1.56 boris 234: ssh $(KULICHKI) "echo 'ВНИМАНИЕ! Идёт заливка Базы вопросов. \
1.55 boris 235: Результаты поиска в Базе могут быть неполны' \
1.73 boris 236: > ~/public_html/dimrub/db/date;\
1.71 boris 237: cd db/prgsrc; \
1.63 boris 238: echo 'SELECT MAX(CreatedAt) FROM Tournaments' | \
239: mysql -u piataev --skip-column-names chgk >_timestamp.tmp;\
1.61 roma7 240: gunzip -c /var/tmp/chgkdump.gz | mysql -u piataev chgk;\
1.62 roma7 241: echo makehtml=1 | perl $(DESTCGIBIN)/db.cgi -z; \
1.66 boris 242: echo "1900-01-01" > _timestamp.tmp;\
243: echo makehtml=1 | perl $(DESTCGIBIN)/db.cgi -z; \
244: echo "1900-01-01" > _timestamp.tmp;\
245: echo makehtml=1 | perl $(DESTCGIBIN)/db.cgi -z; \
1.65 boris 246: rm -f _timestamp.tmp; \
1.73 boris 247: date > ~/public_html/dimrub/db/date"
1.74 boris 248: echo "Finished filling Kulichki database" | mail -s"Finished dbfill" $(DELIVERER); \
1.77 boris 249: $(DBBIN)/stats.pl >> $(SRCDIR)/fill.log; \
1.76 boris 250: cvs commit -m "Database filled" $(SRCDIR)
1.67 boris 251:
252: regenerate:
253: echo "Starting regenerating Kulichki database" | mail -s"Starting regenerate" $(DELIVERER)
1.68 boris 254: ssh $(KULICHKI) "\
1.67 boris 255: echo "1900-01-01" > _timestamp.tmp;\
256: echo makehtml=1 | perl $(DESTCGIBIN)/db.cgi -z; \
1.68 boris 257: echo "1900-01-01" > _timestamp.tmp;\
258: echo makehtml=1 | perl $(DESTCGIBIN)/db.cgi -z; \
259: echo "1900-01-01" > _timestamp.tmp;\
260: echo makehtml=1 | perl $(DESTCGIBIN)/db.cgi -z; \
261: rm -f _timestamp.tmp;" \
1.67 boris 262: echo "Finished regenerating Kulichki database" | mail -s"Finished regenrate" $(DELIVERER)
1.75 boris 263:
264:
265:
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>