On Wed, Dec 22, 2010 at 10:44:49PM -0500, Ben Timby wrote:
> Oleg, I tried this out, my code is:
>
> --
> joins = []
> alias1 = Path
> path_parts = path.split(os.sep)
> for depth, part in enumerate(path_parts):
> alias2 = sqlbuilder.Alias(Path)
> joins.append(sqlbuilder.LEFTJOINOn(alias1,
Hi!
On Mon, Dec 20, 2010 at 09:46:16PM -0500, Ben Timby wrote:
> class Path(sqlobject.SQLObject):
> parent = sqlobject.ForeignKey('SyncPath', cascade=True)
As far as I understand from the following query, 'SyncPath' should be
just 'path', right?
> path = sqlobject.StringCol(alternateI
I am using an adjacency list to store file system paths.
--
class Path(sqlobject.SQLObject):
parent = sqlobject.ForeignKey('SyncPath', cascade=True)
path = sqlobject.StringCol(alternateID=True)
--
I would like to retrieve an object given it's path in one fell swoop.
Below is an example...
