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