lp:~thekorn/zeitgeist/db_schema_3

Branch merges

Propose for merging

No branches dependent on this one.

Merged into lp:zeitgeist/0.1 at revision 1635

Siegfried Gevatter: Approve on 2010-11-16

Seif Lotfy: Approve on 2010-11-15

Mikkel Kamstrup Erlandsen: Pending requested 2010-11-15

Diff: 123 lines (+32/-16)

5 files modified

_zeitgeist/engine/__init__.py (+1/-1)
_zeitgeist/engine/main.py (+9/-5)
_zeitgeist/engine/sql.py (+9/-8)
_zeitgeist/engine/upgrades/core_2_3.py (+11/-0)
test/sql-test.py (+2/-2)

api

Related source package recipes

No recipes using this branch. (?)

Create packaging recipe

Related snap packages

Related bugs

Bug #673394: Queries for subj_uri and subj_origin are using no index	Undecided	Fix Released
Bug #673452: Using the subj_origin column of event_view is slower than it should be	Undecided	Fix Released

Link a bug report

Related blueprints

1638. By Markus Korn on 2010-11-15

fixed another comment

1637. By Markus Korn on 2010-11-15

fixed typo

1636. By Markus Korn on 2010-11-15

merged changes from lp:zeitgeist

1635. By Markus Korn on 2010-11-12

merged changes from lp:zeitgeist

1634. By Markus Korn on 2010-11-12

introduced new DB schema 3

1633. By Markus Korn on 2010-11-12

merged changes from lp:zeitgeist

1632. By Markus Korn on 2010-11-12

merged changes from lp:zeitgeist

1631. By Markus Korn on 2010-11-12

Replaced subj_uri_id by subj_id, as these ids are in fact the same.

1630. By Markus Korn on 2010-11-10

Use 'subj_uri_id' instead of 'subj_uri' in some FindEvent queries, as
grouping by INT is faster than grouping by CHAR.

1629. By Markus Korn on 2010-11-10

Renamed event_view.subj_origin -> event_view.subj_origin_uri and
event_view.subj_origin_id -> event_view.subj_origin and removed redundant
sub-select-query in definition of event_view (LP: #673452)