Annotation of db/prgsrc/Makefile, revision 1.92
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.89 boris 35: RSPARAMS= 2000 150
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\
1.92 ! boris 73: dbdefs.pl \
! 74: cw.pl
1.1 boris 75:
1.12 boris 76:
77: HTMLS = contribute.html \
78: copyright.html \
79: copyright_mozg.html \
80: credits.html \
81: dbmain.html \
82: footer.html \
83: guestbook.html \
84: index.html \
85: random.html \
86: reklama.html \
1.58 boris 87: reklama_bottom.html\
1.90 roma7 88: dbxml.php\
1.12 boris 89: search.html
90:
91:
1.13 boris 92:
1.1 boris 93: DBBIN = ../bin
94: MANDIR = ../man
1.10 boris 95: LIBDIR = ../lib
1.6 boris 96: CGIBIN = $(ROOT)/public_html/cgi-bin
1.13 boris 97: HTMLDIR = $(ROOT)/public_html/dimrub/db
1.1 boris 98:
1.40 boris 99: TEXTS = $(wildcard $(SRCDIR)/*.txt) $(SRCDIR)/index
100: IMAGES = $(wildcard $(IMAGEDIR)/*.jpg)
101: IMAGENAMES= $(notdir $(IMAGES))
102:
103:
104:
1.10 boris 105: BININSTALL = ${DBSCRIPTS:%=$(DBBIN)/%}
1.1 boris 106: CGIINSTALL = ${CGISCRIPTS:%.cgi=$(CGIBIN)/%.cgi}
1.10 boris 107: LIBINSTALL = ${LIBS:%=$(LIBDIR)/%}
1.13 boris 108: HTMLINSTALL = ${HTMLS:%.html=$(HTMLDIR)/%.html}
1.40 boris 109: IMAGEINSTALL = ${IMAGENAMES:%=$(INSTALLIMAGEDIR)/%}
110:
1.84 boris 111:
1.40 boris 112: all: $(LIBINSTALL) $(BININSTALL) $(CGIINSTALL) $(HTMLINSTALL) $(IMAGEINSTALL)
113:
1.10 boris 114:
1.1 boris 115:
1.39 boris 116:
1.1 boris 117:
1.11 boris 118: $(DBBIN)/%.pl: %.pl
1.1 boris 119: ${PERL} -c $<
120: - pod2man --center "Internet Club DB" $< > $*.1
121: - install -m $(LMODE) $*.1 $(MANDIR)/man1
1.10 boris 122: - rm $*.1
1.1 boris 123: if [ -f $@ ]; then mv $@ $(TMPSAV); fi
124: cp $< $@
125: chmod $(PMODE) $@
126: if [ -f $(TMPSAV)/$(@F) ]; then rm -f $(TMPSAV)/$(@F); fi
1.33 boris 127:
1.1 boris 128: $(CGIBIN)/%.cgi: %.cgi
129: ${PERL} -c $<
130: - pod2man --center "Internet Club DB" $< > $*.1
131: - install -m $(LMODE) $*.1 $(MANDIR)/man1
1.10 boris 132: - rm $*.1
1.1 boris 133: if [ -f $@ ]; then mv $@ $(TMPSAV); fi
134: cp $< $@
135: chmod $(PMODE) $@
136: if [ -f $(TMPSAV)/$(@F) ]; then rm -f $(TMPSAV)/$(@F); fi
137:
138:
1.10 boris 139:
140: $(LIBDIR)/%.pm: %.pm
141: ${PERL} -c $<
142: - pod2man --center "Internet Club DB" $< > $*.3
143: - install -m $(LMODE) $*.3 $(MANDIR)/man3
144: - rm $*.3
1.11 boris 145: if [ -f $@ ]; then mv $@ $(TMPSAV); fi
146: cp $< $@
147: chmod $(LMODE) $@
148: if [ -f $(TMPSAV)/$(@F) ]; then rm -f $(TMPSAV)/$(@F); fi
149:
150:
151: $(LIBDIR)/%.pl: %.pl
152: ${PERL} -c $<
153: - pod2man --center "Internet Club DB" $< > $*.3
154: - install -m $(LMODE) $*.3 $(MANDIR)/man3
155: - rm $*.3
156: if [ -f $@ ]; then mv $@ $(TMPSAV); fi
157: cp $< $@
158: chmod $(LMODE) $@
159: if [ -f $(TMPSAV)/$(@F) ]; then rm -f $(TMPSAV)/$(@F); fi
160:
161:
162: $(LIBDIR)/%.cnf: %.cnf
163: ${PERL} -c $<
164: - pod2man --center "Internet Club DB" $< > $*.5
165: - install -m $(LMODE) $*.5 $(MANDIR)/man5
166: - rm $*.5
1.10 boris 167: if [ -f $@ ]; then mv $@ $(TMPSAV); fi
168: cp $< $@
169: chmod $(LMODE) $@
170: if [ -f $(TMPSAV)/$(@F) ]; then rm -f $(TMPSAV)/$(@F); fi
171:
172:
1.12 boris 173: $(HTMLDIR)/%.html: %.html
174: cp $< $@
175:
1.10 boris 176:
1.40 boris 177: $(INSTALLIMAGEDIR)/%: $(IMAGEDIR)/%
178: cp $< $@
1.1 boris 179:
180: srcdeliver:
181: $(RSYNC) $(SRCDIR) $(KULICHKI):$(DESTSRCDIR)
182:
183:
1.40 boris 184: imagedeliver:
1.49 boris 185: cvs update $(SRCDIR)
1.60 boris 186: $(RSYNC) $(IMAGEDIR)/ $(KULICHKI):$(DESTIMAGEDIR)/
1.40 boris 187:
1.1 boris 188: prgdeliver:
189: $(RSYNC) ./ $(KULICHKI):$(DESTPRGSRC)
190:
1.40 boris 191: dbdeliver: imagedeliver
1.51 roma7 192: echo "Starting delivering" | mail -s"Starting delivering" $(DELIVERER)
1.91 boris 193: mysqldump --default-character-set=koi8r --add-drop-table -u piataev chgk $(TABLES) > $(DUMPDIR)/chgkdump
1.59 boris 194: echo "delete from hash;" >> $(DUMPDIR)/chgkdump
1.16 boris 195: gzip $(DUMPDIR)/chgkdump
196: $(SCP) $(DUMPDIR)/chgkdump.gz $(KULICHKI):$(DESTDUMPDIR)
1.46 boris 197: echo "Delivered" | mail -s"Database delivered" $(DELIVERER)
1.12 boris 198:
1.24 roma7 199: update:
1.50 boris 200: cvs update
1.21 roma7 201: cvs update $(SRCDIR)
1.48 roma7 202: cvs update $(DICTDIR)
1.50 boris 203: $(MAKE) all
1.39 boris 204: $(MAKE) $(TIMESTAMP)
205:
206: $(TIMESTAMP): $(TEXTS)
1.27 roma7 207: mysql -upiataev chgk <delq.sql
1.36 boris 208: $(DBBIN)/mkdb.pl
209: $(DBBIN)/updateindex.pl -i$(SRCDIR)/index
210: $(DBBIN)/updatedb.pl $(SRCDIR)/*.txt 2>&1 | tee $(UPDATELOG)
1.43 roma7 211: $(DBBIN)/findequal.pl
1.36 boris 212: $(DBBIN)/makeauthors.pl
1.34 boris 213: if [ -s $(UAUTHORS) ]; then \
214: mail -sUauthors $(AUTHORCHECKER) < $(UAUTHORS); \
215: fi
216: if [ -s $(UNSORTED) ]; then \
217: mail -sUnsorted $(INDEXWRITER) <$(UNSORTED);\
218: else \
1.36 boris 219: $(DBBIN)/mkRS.pl; \
220: $(DBBIN)/updateRS2.pl $(RSPARAMS);\
1.47 roma7 221: echo "Ready to deliver" | mail -s"Ready to deliver" $(DELIVERER);\
1.34 boris 222: fi
1.39 boris 223: touch $(TIMESTAMP)
224:
1.33 boris 225:
226: authorsdeliver:
1.42 roma7 227: mysqldump --add-drop-table -u piataev chgk Authors A2Q equalto > $(DUMPDIR)/chgkdump.0
1.33 boris 228: sed 's/TYPE=ISAM PACK_KEYS=1//g' $(DUMPDIR)/chgkdump.0 > $(DUMPDIR)/chgkdump
229: gzip $(DUMPDIR)/chgkdump
230: rm $(DUMPDIR)/chgkdump.0
231: $(SCP) $(DUMPDIR)/chgkdump.gz $(KULICHKI):$(DESTDUMPDIR)
232:
1.52 boris 233:
234: dbfill:
235: echo "Starting filling Kulichki database" | mail -s"Starting dbfill" $(DELIVERER)
1.86 boris 236: ssh $(KULICHKI) "export LANG=ru_RU.KOI8-R; \
237: echo 'ВНИМАНИЕ! Идёт заливка Базы вопросов. \
1.55 boris 238: Результаты поиска в Базе могут быть неполны' \
1.73 boris 239: > ~/public_html/dimrub/db/date;\
1.88 boris 240: gunzip -c /var/tmp/chgkdump.gz | mysql -u piataev chgk;\
1.73 boris 241: date > ~/public_html/dimrub/db/date"
1.74 boris 242: echo "Finished filling Kulichki database" | mail -s"Finished dbfill" $(DELIVERER); \
1.77 boris 243: $(DBBIN)/stats.pl >> $(SRCDIR)/fill.log; \
1.76 boris 244: cvs commit -m "Database filled" $(SRCDIR)
1.67 boris 245:
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>