Screenshot instructions:
Windows
Mac
Red Hat Linux
Ubuntu
Click URL instructions:
Right-click on ad, choose "Copy Link", then paste here →
(This may not be possible with some types of ads)
You can subscribe to this list here.
| 2006 |
Jan
|
Feb
|
Mar
(174) |
Apr
(50) |
May
(71) |
Jun
(129) |
Jul
(113) |
Aug
(141) |
Sep
(82) |
Oct
(142) |
Nov
(97) |
Dec
(72) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2007 |
Jan
(159) |
Feb
(213) |
Mar
(156) |
Apr
(151) |
May
(58) |
Jun
(166) |
Jul
(296) |
Aug
(198) |
Sep
(89) |
Oct
(133) |
Nov
(150) |
Dec
(122) |
| 2008 |
Jan
(144) |
Feb
(65) |
Mar
(71) |
Apr
(69) |
May
(143) |
Jun
(111) |
Jul
(113) |
Aug
(159) |
Sep
(81) |
Oct
(135) |
Nov
(107) |
Dec
(200) |
| 2009 |
Jan
(168) |
Feb
(109) |
Mar
(141) |
Apr
(128) |
May
(119) |
Jun
(132) |
Jul
(136) |
Aug
(154) |
Sep
(151) |
Oct
(181) |
Nov
(223) |
Dec
(169) |
| 2010 |
Jan
(103) |
Feb
(209) |
Mar
(201) |
Apr
(183) |
May
(134) |
Jun
(113) |
Jul
(110) |
Aug
(159) |
Sep
(138) |
Oct
(96) |
Nov
(116) |
Dec
(94) |
| 2011 |
Jan
(97) |
Feb
(188) |
Mar
(157) |
Apr
(158) |
May
(118) |
Jun
(102) |
Jul
(137) |
Aug
(113) |
Sep
(104) |
Oct
(108) |
Nov
(91) |
Dec
(162) |
| 2012 |
Jan
(189) |
Feb
(136) |
Mar
(153) |
Apr
(142) |
May
(90) |
Jun
(141) |
Jul
(67) |
Aug
(77) |
Sep
(113) |
Oct
(68) |
Nov
(101) |
Dec
(122) |
| 2013 |
Jan
(60) |
Feb
(77) |
Mar
(77) |
Apr
(129) |
May
(189) |
Jun
(155) |
Jul
(106) |
Aug
(123) |
Sep
(53) |
Oct
(142) |
Nov
(78) |
Dec
(102) |
| 2014 |
Jan
(143) |
Feb
(93) |
Mar
(35) |
Apr
(26) |
May
(27) |
Jun
(41) |
Jul
(45) |
Aug
(27) |
Sep
(37) |
Oct
(24) |
Nov
(22) |
Dec
(20) |
| 2015 |
Jan
(17) |
Feb
(15) |
Mar
(34) |
Apr
(55) |
May
(33) |
Jun
(31) |
Jul
(27) |
Aug
(17) |
Sep
(22) |
Oct
(26) |
Nov
(27) |
Dec
(22) |
| 2016 |
Jan
(20) |
Feb
(24) |
Mar
(23) |
Apr
(13) |
May
(17) |
Jun
(14) |
Jul
(31) |
Aug
(23) |
Sep
(24) |
Oct
(31) |
Nov
(23) |
Dec
(16) |
| 2017 |
Jan
(24) |
Feb
(20) |
Mar
(27) |
Apr
(24) |
May
(28) |
Jun
(18) |
Jul
(18) |
Aug
(23) |
Sep
(30) |
Oct
(17) |
Nov
(12) |
Dec
(12) |
| 2018 |
Jan
(27) |
Feb
(23) |
Mar
(13) |
Apr
(15) |
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| S | M | T | W | T | F | S |
|---|---|---|---|---|---|---|
|
|
|
|
1
(5) |
2
(6) |
3
(5) |
4
(6) |
|
5
(10) |
6
(1) |
7
(3) |
8
(4) |
9
(4) |
10
|
11
(1) |
|
12
(3) |
13
(15) |
14
(8) |
15
(4) |
16
(2) |
17
(2) |
18
(3) |
|
19
|
20
(3) |
21
(6) |
22
(7) |
23
(2) |
24
|
25
(6) |
|
26
(7) |
27
(2) |
28
(11) |
29
(10) |
|
|
|
|
From: sqlalchemy <mike_mp@zz...> - 2012-02-01 16:21:28
|
#1401: support self-referential auto-joins when the foreign key joins to itself
---------------------------+---------------------------------------
Reporter: guest | Owner: zzzeek
Type: defect | Status: new
Priority: high | Milestone: 0.x.xx
Component: orm | Severity: very major - up to 2 days
Resolution: | Keywords:
Progress State: in queue |
---------------------------+---------------------------------------
Comment (by zzzeek):
just to experiment with annotations in the primaryjoin:
{{{
#!diff
diff -r 42694965987f lib/sqlalchemy/orm/properties.py
--- a/lib/sqlalchemy/orm/properties.py Wed Feb 01 10:14:28 2012 -0500
+++ b/lib/sqlalchemy/orm/properties.py Wed Feb 01 11:19:26 2012 -0500
@@ -1052,6 +1052,9 @@
"'secondaryjoin' is needed as well."
% self)
+ from sqlalchemy.sql import util as sql_util
+ self.primaryjoin = sql_util._deep_annotate(self.primaryjoin,
{'_nothing':True}, set())
+
def _columns_are_mapped(self, *cols):
"""Return True if all columns in the given collection are
mapped by the tables referenced by this :class:`.Relationship`.
}}}
what fails here, at least one thing, is _create_lazy_clause() calculates
improperly when it checks the "binds" collection. We might want to make
some small tests of annotated columns to see if they behave correctly in
hash lookups (we seem to have this in test_selectable, though still seeing
odd behavior here).
--
Ticket URL: <http://www.sqlalchemy.org/trac/ticket/1401#comment:11>;
sqlalchemy <http://www.sqlalchemy.org/>;
The Database Toolkit for Python
|
|
From: sqlalchemy <mike_mp@zz...> - 2012-02-01 16:06:58
|
#1401: support self-referential auto-joins when the foreign key joins to itself
---------------------------+---------------------------------------
Reporter: guest | Owner: zzzeek
Type: defect | Status: new
Priority: high | Milestone: 0.x.xx
Component: orm | Severity: very major - up to 2 days
Resolution: | Keywords:
Progress State: in queue |
---------------------------+---------------------------------------
Comment (by zzzeek):
OK here's another approach that is much simpler, though it wouldn't work
for situations where the join condition has a more complex relationship
than "col == col", perhaps it can be further improved:
{{{
#!diff
diff -r 42694965987f lib/sqlalchemy/orm/properties.py
--- a/lib/sqlalchemy/orm/properties.py Wed Feb 01 10:14:28 2012 -0500
+++ b/lib/sqlalchemy/orm/properties.py Wed Feb 01 11:04:50 2012 -0500
@@ -1477,6 +1477,7 @@
def _create_joins(self, source_polymorphic=False,
source_selectable=None,
dest_polymorphic=False,
dest_selectable=None, of_type=None):
+
if source_selectable is None:
if source_polymorphic and self.parent.with_polymorphic:
source_selectable =
self.parent._with_polymorphic_selectable
@@ -1539,7 +1540,8 @@
secondary_aliasizer.traverse(secondaryjoin)
else:
primary_aliasizer = ClauseAdapter(dest_selectable,
- exclude=self.local_side,
+
exclude=self.local_side.difference(self.remote_side),
+ half_include =
self.remote_side.intersection(self.local_side),
equivalents=self.mapper._equivalent_columns)
if source_selectable is not None:
primary_aliasizer.chain(
diff -r 42694965987f lib/sqlalchemy/sql/expression.py
--- a/lib/sqlalchemy/sql/expression.py Wed Feb 01 10:14:28 2012 -0500
+++ b/lib/sqlalchemy/sql/expression.py Wed Feb 01 11:04:50 2012 -0500
@@ -3342,9 +3342,13 @@
def _from_objects(self):
return self.left._from_objects + self.right._from_objects
- def _copy_internals(self, clone=_clone, **kw):
+ def _copy_internals(self, clone=_clone, half_include=None, **kw):
+ do_half = half_include is not None and \
+ self.left in half_include and \
+ self.right is self.left
self.left = clone(self.left, **kw)
- self.right = clone(self.right, **kw)
+ if not do_half:
+ self.right = clone(self.right, **kw)
def get_children(self, **kwargs):
return self.left, self.right
diff -r 42694965987f lib/sqlalchemy/sql/util.py
--- a/lib/sqlalchemy/sql/util.py Wed Feb 01 10:14:28 2012 -0500
+++ b/lib/sqlalchemy/sql/util.py Wed Feb 01 11:04:50 2012 -0500
@@ -669,8 +669,8 @@
s.c.col1 == table2.c.col1
"""
- def __init__(self, selectable, equivalents=None, include=None,
exclude=None, adapt_on_names=False):
- self.__traverse_options__ = {'stop_on':[selectable]}
+ def __init__(self, selectable, equivalents=None, include=None,
exclude=None, half_include=None, adapt_on_names=False):
+ self.__traverse_options__ = {'stop_on':[selectable],
'half_include':half_include}
self.selectable = selectable
self.include = include
self.exclude = exclude
}}}
--
Ticket URL: <http://www.sqlalchemy.org/trac/ticket/1401#comment:10>;
sqlalchemy <http://www.sqlalchemy.org/>;
The Database Toolkit for Python
|
|
From: sqlalchemy <mike_mp@zz...> - 2012-02-01 15:39:16
|
#1401: support self-referential auto-joins when the foreign key joins to itself
---------------------------+---------------------------------------
Reporter: guest | Owner: zzzeek
Type: defect | Status: new
Priority: high | Milestone: 0.x.xx
Component: orm | Severity: very major - up to 2 days
Resolution: | Keywords:
Progress State: in queue |
---------------------------+---------------------------------------
Changes (by zzzeek):
* priority: medium => high
--
Ticket URL: <http://www.sqlalchemy.org/trac/ticket/1401#comment:9>;
sqlalchemy <http://www.sqlalchemy.org/>;
The Database Toolkit for Python
|
|
From: sqlalchemy <mike_mp@zz...> - 2012-02-01 15:38:41
|
#1401: support self-referential auto-joins when the foreign key joins to itself
---------------------------+---------------------------------------
Reporter: guest | Owner: zzzeek
Type: defect | Status: new
Priority: medium | Milestone: 0.x.xx
Component: orm | Severity: very major - up to 2 days
Resolution: | Keywords:
Progress State: in queue |
---------------------------+---------------------------------------
Comment (by zzzeek):
another test case to support is attached, based on our own
test_relationships
--
Ticket URL: <http://www.sqlalchemy.org/trac/ticket/1401#comment:8>;
sqlalchemy <http://www.sqlalchemy.org/>;
The Database Toolkit for Python
|
|
From: sqlalchemy <mike_mp@zz...> - 2012-02-01 15:15:11
|
#2378: open up reset_on_return to allow commit also
-----------------------------------+-----------------------------------
Reporter: zzzeek | Owner: zzzeek
Type: enhancement | Status: closed
Priority: medium | Milestone: 0.7.6
Component: pool | Severity: trivial - <10 minutes
Resolution: fixed | Keywords:
Progress State: completed/closed |
-----------------------------------+-----------------------------------
Changes (by zzzeek):
* status: new => closed
* resolution: => fixed
* status_field: in queue => completed/closed
Comment:
r42694965987f
--
Ticket URL: <http://www.sqlalchemy.org/trac/ticket/2378#comment:1>;
sqlalchemy <http://www.sqlalchemy.org/>;
The Database Toolkit for Python
|