Revision fbafd482
| b/snf-pithos-backend/pithos/backends/lib/sqlalchemy/node.py | ||
|---|---|---|
| 1206 | 1206 |
s = s.where(v.c.serial == a.c.serial) |
| 1207 | 1207 |
s = s.where(a.c.domain == domain) |
| 1208 | 1208 |
s = s.where(a.c.node == n.c.node) |
| 1209 |
s = s.where(a.c.is_latest is True)
|
|
| 1209 |
s = s.where(a.c.is_latest == True)
|
|
| 1210 | 1210 |
if paths: |
| 1211 | 1211 |
s = s.where(n.c.path.in_(paths)) |
| 1212 | 1212 |
|
| b/snf-pithos-backend/pithos/backends/lib/sqlalchemy/public.py | ||
|---|---|---|
| 118 | 118 |
def public_get(self, path): |
| 119 | 119 |
s = select([self.public.c.url]) |
| 120 | 120 |
s = s.where(and_(self.public.c.path == path, |
| 121 |
self.public.c.active)) |
|
| 121 |
self.public.c.active == True))
|
|
| 122 | 122 |
r = self.conn.execute(s) |
| 123 | 123 |
row = r.fetchone() |
| 124 | 124 |
r.close() |
| ... | ... | |
| 130 | 130 |
s = select([self.public.c.path, self.public.c.url]) |
| 131 | 131 |
s = s.where(self.public.c.path.like( |
| 132 | 132 |
self.escape_like(prefix) + '%', escape=ESCAPE_CHAR)) |
| 133 |
s = s.where(self.public.c.active) |
|
| 133 |
s = s.where(self.public.c.active == True)
|
|
| 134 | 134 |
r = self.conn.execute(s) |
| 135 | 135 |
rows = r.fetchall() |
| 136 | 136 |
r.close() |
| ... | ... | |
| 139 | 139 |
def public_path(self, public): |
| 140 | 140 |
s = select([self.public.c.path]) |
| 141 | 141 |
s = s.where(and_(self.public.c.url == public, |
| 142 |
self.public.c.active)) |
|
| 142 |
self.public.c.active == True))
|
|
| 143 | 143 |
r = self.conn.execute(s) |
| 144 | 144 |
row = r.fetchone() |
| 145 | 145 |
r.close() |
Also available in: Unified diff