def load_auth_trees(self):

        self.auth_austro_tree = dendropy.Tree.get_from_path("authoritative_trees/austronesian/no_labels", "newick")
        self.auth_austro_trans = load_translate_file("authoritative_trees/austronesian/wals_compatible_translate")

        self.auth_indo_trees = self.load_indo_trees("authoritative_trees/indo-european/no_labels", 500)
        self.auth_indo_trans = load_translate_file("authoritative_trees/indo-european/wals_compatible_translate")
    def load_wals_data(self):

        conn = sqlite3.connect("../WALS2SQL/wals.db")
        cursor = conn.cursor()
        cursor.execute('''PRAGMA cache_size = -25000''')
        cursor.execute('''CREATE TEMPORARY TABLE speedyfeatures AS SELECT name, value_id, wals_code FROM data_points INNER JOIN dense_features on data_points.feature_id = dense_features.id''')
        cursor.execute('''CREATE INDEX wals_code_index ON speedyfeatures(wals_code)''')

        self.wals_austro_trans = load_translate_file("generated_trees/austro.translate")
        self.wals_indo_trans = load_translate_file("generated_trees/indo.translate")
        self.austrolangs = wals2sql.get_languages_by_family(conn, cursor, "Austronesian")
        self.indolangs = wals2sql.get_languages_by_family(conn, cursor, "Indo-European")

        cursor.close()
        conn.close()
#!/usr/bin/env python

# Super gross script to make some demonstration IE trees with
# human friendly names

import glob
from fileio import load_translate_file

revtrans = load_translate_file("generated_trees/indo.translate")
names = revtrans.keys()
trans = {}
for name in names:
    trans[revtrans[name]] = name

for i in range(1,11):
    fp = open("generated_trees/combination/indo/tree_%d.tree" % i, "r")
    string = fp.read()
    fp.close()
    for number in trans:
        print "Replacing ", number, " with ", trans[number]
        string = string.replace("(%d:" % number, "(%s:" % trans[number])
        string = string.replace(",%d:" % number, ",%s:" % trans[number])
    fp = open("demo-trees/demo_indo_%d.tree" % i, "w")
    fp.write(string)
    fp.close()

backtrans = load_translate_file("generated_trees/indo.translate")
trans = {}
for key in backtrans:
    trans[backtrans[key]] = key