bambooforest

            w_ids = []
            for w in words:
                if w:
                    w.update(corpus=self.corpus, language=self.language)
                    w_id, = insert_word(session_id_fk=s_id, utterance_id_fk=u_id, **w).inserted_primary_key
                else:
                    w_id = None
                w_ids.append(w_id)

            link_to_word = len(morphemes) == len(words) and None not in w_ids

bambooforest

select * 
from morphemes as m
	join utterances as u on m.utterance_id_fk = u.id
	left join words as w on m.word_id_fk = w.id
	join sessions s on u.session_id_fk = s.id
	left join speakers sp on u.speaker_id_fk = sp.id
	left join uniquespeakers on sp.uniquespeaker_id_fk = uniquespeakers.id
	order by s.id, u.id, w.id, m.id

bambooforest

Keybase proof

I hereby claim:

• I am bambooforest on github.
• I am bambooforest (https://keybase.io/bambooforest) on keybase.
• I have a public key whose fingerprint is 94B7 1DFD DE71 BE5B C8C2 4383 AB59 C808 0CEE 6784

To claim this, I am signing this object: