<commit_before>var db = new Sqlite
db.open(":memory:")
db.execute("CREATE TABLE foo (i INTEGER, f DOUBLE, t TEXT);")
db.execute("INSERT INTO foo (i, f, t) VALUES (1, 2.0, 'foo');")
db.execute("INSERT INTO foo (i, f, t) VALUES (3, NULL, 'bar');")
for (row <- db.query("SELECT * FROM foo;")) {
    var list = for (elt <- row) yield elt.toString
    println(list.reduceLeft(_ + " " + _))
}
db.close()
<commit_msg>clean up example a little more<commit_after>var db = new Sqlite
db.open(":memory:")
db.execute("CREATE TABLE foo (i INTEGER, f DOUBLE, t TEXT);")
db.execute("INSERT INTO foo (i, f, t) VALUES (1, 2.0, 'foo');")
db.execute("INSERT INTO foo (i, f, t) VALUES (3, NULL, 'bar');")
for (row <- db.query("SELECT * FROM foo;"))
    println(row.map(_.toString).reduceLeft(_ + " " + _))
db.close()

{'fraction_non_alphanumeric': 0.20828105395232122, 'fraction_numerical': 0.010037641154328732, 'mean_word_length': 4.355704697986577, 'pattern_counts': {'":': 2, '<': 6, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '3977939', 'n_tokens_mistral': 311, 'n_tokens_neox': 289, 'n_words': 94}