unity-scope-click

Merge lp:~stolowski/unity-scope-click/new-departments into lp:unity-scope-click/devel

  1. new-departments
  2. Merge into devel
Proposed by Paweł Stołowski
Status: Merged
Approved by: dobey
Approved revision: 409
Merged at revision: 405
Proposed branch: lp:~stolowski/unity-scope-click/new-departments
Merge into: lp:unity-scope-click/devel
Diff against target: 133 lines (+103/-1)
3 files modified
HACKING (+5/-0)
data/update_schema.sh (+97/-0)
libclickscope/click/departments-db.cpp (+1/-1)
To merge this branch: bzr merge lp:~stolowski/unity-scope-click/new-departments
Reviewer Review Type Date Requested Status
dobey (community) Approve
PS Jenkins bot (community) continuous-integration Approve
Review via email: mp+231209@code.launchpad.net

Commit message

Provide updated departments to match latest server changes. Bumped schema to 3.

Description of the change

Provide updated departments to match latest server changes: schema is bumped from 2 to 3, and update script is executed on first boot after updating click scope package; the script replaces existing department mappings and moves packages into new departments.

The default departments db has also been updated for first-boot experience.

To post a comment you must log in.
Revision history for this message
dobey (dobey) :
review: Needs Information
Revision history for this message
Paweł Stołowski (stolowski) wrote :

This is described in the README file of init-departments tools; I've added a pointer to HACKING.

Revision history for this message
PS Jenkins bot (ps-jenkins) wrote :

PASSED: Continuous integration, rev:408
http://jenkins.qa.ubuntu.com/job/unity-team-unity-scope-click-devel-ci/272/
Executed test runs:
    SUCCESS: http://jenkins.qa.ubuntu.com/job/unity-team-unity-scope-click-devel-utopic-amd64-ci/247
    SUCCESS: http://jenkins.qa.ubuntu.com/job/unity-team-unity-scope-click-devel-utopic-armhf-ci/246
        deb: http://jenkins.qa.ubuntu.com/job/unity-team-unity-scope-click-devel-utopic-armhf-ci/246/artifact/work/output/*zip*/output.zip
    SUCCESS: http://jenkins.qa.ubuntu.com/job/unity-team-unity-scope-click-devel-utopic-i386-ci/246

Click here to trigger a rebuild:
http://s-jenkins.ubuntu-ci:8080/job/unity-team-unity-scope-click-devel-ci/272/rebuild

review: Approve (continuous-integration)
Revision history for this message
PS Jenkins bot (ps-jenkins) wrote :

PASSED: Continuous integration, rev:409
http://jenkins.qa.ubuntu.com/job/unity-team-unity-scope-click-devel-ci/273/
Executed test runs:
    SUCCESS: http://jenkins.qa.ubuntu.com/job/unity-team-unity-scope-click-devel-utopic-amd64-ci/248
    SUCCESS: http://jenkins.qa.ubuntu.com/job/unity-team-unity-scope-click-devel-utopic-armhf-ci/247
        deb: http://jenkins.qa.ubuntu.com/job/unity-team-unity-scope-click-devel-utopic-armhf-ci/247/artifact/work/output/*zip*/output.zip
    SUCCESS: http://jenkins.qa.ubuntu.com/job/unity-team-unity-scope-click-devel-utopic-i386-ci/247

Click here to trigger a rebuild:
http://s-jenkins.ubuntu-ci:8080/job/unity-team-unity-scope-click-devel-ci/273/rebuild

review: Approve (continuous-integration)
Revision history for this message
dobey (dobey) wrote :

I think we should try to get the default db removed from version control as soon as possible. Also, having multiple READMEs in a single project is a bit weird. I'll file a bug for that though. And hopefully we can switch to API calls to the server to do this sort of updating, very soon, rather than having to create a bunch of SQL statements to update the db. But I'll approve this as is, given the current situation.

review: Approve

Preview Diff

[H/L] Next/Prev Comment, [J/K] Next/Prev File, [N/P] Next/Prev Hunk
1=== modified file 'HACKING'
2--- HACKING 2014-05-16 21:08:36 +0000
3+++ HACKING 2014-08-18 15:33:02 +0000
4@@ -65,3 +65,8 @@
5 $ make coverage-html
6
7 The html will be left on the coveragereport directory.
8+
9+Updating departments db
10+-----------------------
11+See tools/init-departments/README for details about how to re-create departments database
12+file found in data/departments.db.
13
14=== modified file 'data/departments.db'
15Binary files data/departments.db 2014-08-05 17:12:54 +0000 and data/departments.db 2014-08-18 15:33:02 +0000 differ
16=== modified file 'data/update_schema.sh'
17--- data/update_schema.sh 2014-08-06 17:31:50 +0000
18+++ data/update_schema.sh 2014-08-18 15:33:02 +0000
19@@ -52,4 +52,101 @@
20 UPDATE meta SET value='2' WHERE name='version';
21 END TRANSACTION;
22 _UPDATE_TO_VER2
23+SCHEMA_VERSION=$(sqlite3 "$DBFILE" "SELECT value FROM meta WHERE name='version'")
24+fi
25+
26+if [ "x$SCHEMA_VERSION" = "x2" ]
27+then
28+ sqlite3 "$DBFILE" << _UPDATE_TO_VER3
29+ BEGIN TRANSACTION;
30+ UPDATE pkgmap SET deptid='developer-tools' WHERE deptid='3d';
31+ UPDATE pkgmap SET deptid='developer-tools' WHERE deptid='computing-robotics';
32+ UPDATE pkgmap SET deptid='developer-tools' WHERE deptid='debugging';
33+ UPDATE pkgmap SET deptid='developer-tools' WHERE deptid='electronics';
34+ UPDATE pkgmap SET deptid='developer-tools' WHERE deptid='engineering';
35+ UPDATE pkgmap SET deptid='developer-tools' WHERE deptid='ides';
36+ UPDATE pkgmap SET deptid='developer-tools' WHERE deptid='profiling';
37+ UPDATE pkgmap SET deptid='developer-tools' WHERE deptid='version-control';
38+ UPDATE pkgmap SET deptid='developer-tools' WHERE deptid='web-development';
39+ UPDATE pkgmap SET deptid='science-engineering' WHERE deptid='astronomy';
40+ UPDATE pkgmap SET deptid='science-engineering' WHERE deptid='biology';
41+ UPDATE pkgmap SET deptid='science-engineering' WHERE deptid='chemistry';
42+ UPDATE pkgmap SET deptid='science-engineering' WHERE deptid='geography';
43+ UPDATE pkgmap SET deptid='science-engineering' WHERE deptid='geology';
44+ UPDATE pkgmap SET deptid='science-engineering' WHERE deptid='mathematics';
45+ UPDATE pkgmap SET deptid='science-engineering' WHERE deptid='medicine';
46+ UPDATE pkgmap SET deptid='science-engineering' WHERE deptid='physics';
47+ UPDATE pkgmap SET deptid='games' WHERE deptid='board-games';
48+ UPDATE pkgmap SET deptid='games' WHERE deptid='card-games';
49+ UPDATE pkgmap SET deptid='games' WHERE deptid='puzzles';
50+ UPDATE pkgmap SET deptid='games' WHERE deptid='role-playing';
51+ UPDATE pkgmap SET deptid='books-comics' WHERE deptid='books-magazines';
52+ UPDATE pkgmap SET deptid='communication' WHERE deptid='chat';
53+ UPDATE pkgmap SET deptid='communication' WHERE deptid='file-sharing';
54+ UPDATE pkgmap SET deptid='communication' WHERE deptid='internet';
55+ UPDATE pkgmap SET deptid='communication' WHERE deptid='mail';
56+ UPDATE pkgmap SET deptid='communication' WHERE deptid='web-browsers';
57+ UPDATE pkgmap SET deptid='graphics' WHERE deptid='drawing';
58+ UPDATE pkgmap SET deptid='graphics' WHERE deptid='graphic-interface-design';
59+ UPDATE pkgmap SET deptid='graphics' WHERE deptid='photography';
60+ UPDATE pkgmap SET deptid='graphics' WHERE deptid='publishing';
61+ UPDATE pkgmap SET deptid='graphics' WHERE deptid='scanning-ocr';
62+ UPDATE pkgmap SET deptid='personalisation' WHERE deptid='localization';
63+ UPDATE pkgmap SET deptid='personalisation' WHERE deptid='themes-tweaks';
64+ UPDATE pkgmap SET deptid='productivity' WHERE deptid='office';
65+ UPDATE pkgmap SET deptid='music-audio' WHERE deptid='sound-video';
66+ UPDATE pkgmap SET deptid='universal-accessaccessibility' WHERE deptid='universal-access';
67+ UPDATE pkgmap SET deptid='accessories' WHERE deptid='viewers';
68+
69+ DELETE FROM depts;
70+ INSERT INTO depts (deptid,parentid) VALUES ('travel-local', '');
71+ INSERT INTO depts (deptid,parentid) VALUES ('productivity', '');
72+ INSERT INTO depts (deptid,parentid) VALUES ('finance', '');
73+ INSERT INTO depts (deptid,parentid) VALUES ('universal-accessaccessibility', '');
74+ INSERT INTO depts (deptid,parentid) VALUES ('entertainment', '');
75+ INSERT INTO depts (deptid,parentid) VALUES ('communication', '');
76+ INSERT INTO depts (deptid,parentid) VALUES ('graphics', '');
77+ INSERT INTO depts (deptid,parentid) VALUES ('science-engineering', '');
78+ INSERT INTO depts (deptid,parentid) VALUES ('news-magazines', '');
79+ INSERT INTO depts (deptid,parentid) VALUES ('accessories', '');
80+ INSERT INTO depts (deptid,parentid) VALUES ('sports', '');
81+ INSERT INTO depts (deptid,parentid) VALUES ('developer-tools', '');
82+ INSERT INTO depts (deptid,parentid) VALUES ('games', '');
83+ INSERT INTO depts (deptid,parentid) VALUES ('books-comics', '');
84+ INSERT INTO depts (deptid,parentid) VALUES ('music-audio', '');
85+ INSERT INTO depts (deptid,parentid) VALUES ('shopping', '');
86+ INSERT INTO depts (deptid,parentid) VALUES ('education', '');
87+
88+ DELETE FROM deptnames;
89+ INSERT INTO deptnames (deptid,locale,name) VALUES ('books-comics','en_US','Books & Comics');
90+ INSERT INTO deptnames (deptid,locale,name) VALUES ('business','en_US','Business');
91+ INSERT INTO deptnames (deptid,locale,name) VALUES ('communication','en_US','Communication');
92+ INSERT INTO deptnames (deptid,locale,name) VALUES ('developer-tools','en_US','Developer Tools');
93+ INSERT INTO deptnames (deptid,locale,name) VALUES ('education','en_US','Education');
94+ INSERT INTO deptnames (deptid,locale,name) VALUES ('entertainment','en_US','Entertainment');
95+ INSERT INTO deptnames (deptid,locale,name) VALUES ('finance','en_US','Finance');
96+ INSERT INTO deptnames (deptid,locale,name) VALUES ('food-drink','en_US','Food & Drink');
97+ INSERT INTO deptnames (deptid,locale,name) VALUES ('games','en_US','Games');
98+ INSERT INTO deptnames (deptid,locale,name) VALUES ('graphics','en_US','Graphics');
99+ INSERT INTO deptnames (deptid,locale,name) VALUES ('health-fitness','en_US','Lifestyle');
100+ INSERT INTO deptnames (deptid,locale,name) VALUES ('lifestyle','en_US','Health & Fitness');
101+ INSERT INTO deptnames (deptid,locale,name) VALUES ('media-video','en_US','Media & Video');
102+ INSERT INTO deptnames (deptid,locale,name) VALUES ('medical','en_US','Medical');
103+ INSERT INTO deptnames (deptid,locale,name) VALUES ('music-audio','en_US','Music & Audio');
104+ INSERT INTO deptnames (deptid,locale,name) VALUES ('news-magazines','en_US','News & Magazines');
105+ INSERT INTO deptnames (deptid,locale,name) VALUES ('personalisation','en_US','Personalisation');
106+ INSERT INTO deptnames (deptid,locale,name) VALUES ('productivity','en_US','Productivity');
107+ INSERT INTO deptnames (deptid,locale,name) VALUES ('reference','en_US','Reference');
108+ INSERT INTO deptnames (deptid,locale,name) VALUES ('science-engineering','en_US','Science & Engineering');
109+ INSERT INTO deptnames (deptid,locale,name) VALUES ('shopping','en_US','Shopping');
110+ INSERT INTO deptnames (deptid,locale,name) VALUES ('social-networking','en_US','Social Networking');
111+ INSERT INTO deptnames (deptid,locale,name) VALUES ('sports','en_US','Sports');
112+ INSERT INTO deptnames (deptid,locale,name) VALUES ('travel-local','en_US','Travel & Local');
113+ INSERT INTO deptnames (deptid,locale,name) VALUES ('universal-accessaccessibility','en_US','Universal Access/Accessibility');
114+ INSERT INTO deptnames (deptid,locale,name) VALUES ('weather','en_US','Weather');
115+ INSERT INTO deptnames (deptid,locale,name) VALUES ('accessories','en_US','Utilities');
116+
117+ UPDATE meta SET value='3' WHERE name='version';
118+ END TRANSACTION;
119+_UPDATE_TO_VER3
120 fi
121
122=== modified file 'libclickscope/click/departments-db.cpp'
123--- libclickscope/click/departments-db.cpp 2014-08-05 14:16:26 +0000
124+++ libclickscope/click/departments-db.cpp 2014-08-18 15:33:02 +0000
125@@ -150,7 +150,7 @@
126 //
127 // note: this will fail due to unique constraint, but that's fine; it's expected to succeed only when new database is created; in other
128 // cases the version needs to be bumped in the update_schema.sh script.
129- query.exec("INSERT INTO meta (name, value) VALUES ('version', 2)");
130+ query.exec("INSERT INTO meta (name, value) VALUES ('version', 3)");
131
132 if (!db_.commit())
133 {

Subscribers

People subscribed via source and target branches

to all changes: