May 22, 2006, at 09:33 AM
Logbook /

20060520

The Balcony 2 by Brett Whiteley

Went to the movie to see The DaVinci Code. It is not as bad as I expected, I actually enjoyed most of it but boy is the end lame! Dare I say that I am glad I didn't read the book. Now I understand the cultural phenomena a bit better, religion, conspiracy theory, hope, reconciliation shake really hard ... a blockbuster. I must admit that I did laugh when Lagdon told Sophie she is related to Jesus and Mary-Magdalena.

Seems she (Mary-Magdalena) is a popular subject these days. It is at least the 3rd time this year that major media mention her and her gospel. One was for the magnificient Abel Ferrara movie, Mary with another french actress (Binoche).

I took 2 of my grand father's drawing to the framer and the Brett Whiteley I bought at the New South Wales Art Gallery when we were Down Under. I should get them back next Saturday.

On the geeky side of life, I recovered all my posts on {BK} v 3.0 and converted them to something manageable in Logbook. How? First by understanding PmWiki's file format (well documented by the way). Them by writing a little Python script that connected to the database and generated the files in the proper format (see code bellow). Finally I had to play and tweak a bit because on {BK} everything was in html (I used comments from the EnableHTML recipe).

import MySQLdb
import mx.DateTime

epoch=mx.DateTime.DateTimeFrom("1 Jan 1970")
now=mx.DateTime.now()
diff=now-epoch
t=int(diff.seconds)

db = MySQLdb.connect(host="sql.boardkulture.com", \
                     user="boardkulture.com", passwd="XXXXXX", \
                     db="boardkulture.com")
cursor=db.cursor()
cursor.execute("select * from v3_weblog")
result=cursor.fetchall()
s=set()
for record in result:
    id,text,date=record
    filename="Logbook.%4i%2i%2i" % (date.year,date.month,date.day)
    filename=filename.replace(' ','0')

    text=text.replace('<img src="','<img src="http://www.3kwa.com/')
    text=text.replace('\r\n','')
    text=text.replace('"',"'")

    if filename in s:
        f=open("wiki.d/%s" % filename,"a")
        f.write("%0a%0a----%0a%0a")
        f.write("%s" % text)
        f.close()
    else:
        f=open("wiki.d/%s" % filename,"w")
        f.write("version=2.1.3 urlencoded=1\n")
        f.write("time=%i\n" % t)
        f.write("text=%s" % text)
        f.close()
    s.add(filename)

In the process I discovered a new bug in Logbook that I need to fix. Some days don't show up on the calendar. If you want to see such a shadow entry check 20011231. If you want to see all entries in the Logbook the best thing is to type Logbook/ in the search (I know noone will do ... that's too hard).

An unexpected consequence is that it seems to have had an impact on the recent changes display ... will have to figure that one out.

I showed carca MyGoogleMap and we have decided that when we meet (2 weeks) we will confront ideas on doing a Google Maps mash-up for France (now that it is available) ... stay tuned ;)

blog comments powered by Disqus