Mercurial > hgbook
view web/hgbook/load_elements.py @ 687:188efaefe001
How to make all-ids.dat.
author | Bryan O'Sullivan <bos@serpentine.com> |
---|---|
date | Thu, 19 Mar 2009 22:45:02 -0700 |
parents | ad304b606163 |
children |
line wrap: on
line source
#!/usr/bin/env python # # This script updates the contents of the comments_element table. # It's fugly, but a lot less painful than trying to use Django's # fixtures system. import os, sys sys.path.append(os.path.dirname(__file__)) import dbutil os.system('make -C ../../en all-ids.dat') conn = dbutil.connect() c = conn.cursor() c.execute('''load data local infile "../../en/all-ids.dat" replace into table comments_element fields terminated by "|"''') print 'Database updated'