diff options
-rwxr-xr-x | cli.py | 10 |
1 files changed, 6 insertions, 4 deletions
@@ -90,10 +90,12 @@ def load_biblehub(db, f): 'VALUES (?, ?, ?)', (v['book'], v['chapter'], v['verse'])) for translation, text in v['translations'].items(): - conn.execute('INSERT OR IGNORE INTO translated_verses ' - '(translation, book, chapter, nr, text) ' - 'VALUES (?, ?, ?, ?, ?)', - (translation, cur_book, v['chapter'], v['verse'], text)) + text = text.strip() + if text != '': + conn.execute('INSERT OR IGNORE INTO translated_verses ' + '(translation, book, chapter, nr, text) ' + 'VALUES (?, ?, ?, ?, ?)', + (translation, cur_book, v['chapter'], v['verse'], text)) click.echo(str(round(time.time() - timer, 3)) + 's') db.commit() |