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