Thank you Terry, those posts go to my "To-study" list for when I finish the
exam :D
On Mon, Nov 10, 2014 at 10:27 PM, 'Terry Brown' via leo-editor <
leo-editor@googlegroups.com> wrote:
> On Mon, 10 Nov 2014 15:12:15 -0600
> "'Terry Brown' via leo-editor" <leo-editor@googlegroups.com> wrote:
>
> > It's pretty trivial to translate Leo's data structure to these tables,
>
> So just for amusement, here's some code that does that:
>
> import sqlite3
> con = sqlite3.connect(":memory:")
> cur = con.cursor()
> cur.execute("create table node (node gnx, head text, body text)")
> cur.execute("create table link (parentnode gnx, childnode gnx,
> childposition int)")
> for nd in c.all_unique_nodes():
> cur.execute("insert into node values (?, ?, ?)", [nd.gnx, nd.h, nd.b])
> for n, child in enumerate(nd.children):
> cur.execute("insert into link values (?, ?, ?)", [nd.gnx,
> child.gnx, n])
> ans = cur.execute("select count(*) from node")
> g.es(ans.fetchone()[0], 'nodes')
> ans = cur.execute("select count(*) from link")
> g.es(ans.fetchone()[0], 'links')
>
> using SQLite3 (included in Python) and PEP 249
> http://legacy.python.org/dev/peps/pep-0249/
>
> SQLite3 has loose typing so it accepts the unknown type name "gnx", you
> could use "text" in another RDMS. The code doesn't create indexes or
> enforce the existence of a corresponding Node record for each link
> record, but that could be added. The question is, now that the
> outline's in a RDB, what to do with it?
>
> 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 http://groups.google.com/group/leo-editor.
> For more options, visit https://groups.google.com/d/optout.
>
--
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 http://groups.google.com/group/leo-editor.
For more options, visit https://groups.google.com/d/optout.
