On Wed, 3 May 2017 04:16:50 -0700 (PDT) tscv11 <tsc.v...@gmail.com> wrote:
> So now I have my work cut out for me. I'm very open to > hearing suggestions or requests regarding a possible > sqlite3 plugin for Leo (my basic idea is to create a read/write > relationship between db3 files and Leo outlines, via Leo). So are you wanting to read (and write?) a representation of your habit tracking app. from SQLite, or read and write Leo outlines in general from SQLite? The former might be a good starting point. Something like con = sqlite3.connect("mydb.sqlite3") cur = con.cursor() cur.execute("select name from habit_types") for row in cur.fetchall(): name = row[0] node = p.insertAsLastChild() node.h = name c.redraw() Now Edward's going to tell me you should call something other than c.redraw() at the end, but I bet that would work ;-) Cheers -Terry -- You received this message because you are subscribed to the Google Groups "leo-editor" group. To unsubscribe from this group and stop receiving emails from it, send an email to leo-editor+unsubscr...@googlegroups.com. To post to this group, send email to leo-editor@googlegroups.com. Visit this group at https://groups.google.com/group/leo-editor. For more options, visit https://groups.google.com/d/optout.