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