Move projects and languages to database

RESOLVED FIXED

Status

Webtools Graveyard
Verbatim
RESOLVED FIXED
10 years ago
2 years ago

People

(Reporter: dschafer, Assigned: dschafer)

Tracking

Dependency tree / graph

Details

Attachments

(2 attachments, 1 obsolete attachment)

(Assignee)

Description

10 years ago
Currently, projects and languages are stored in pootle.prefs; these should be moved to a database.
(Assignee)

Updated

10 years ago
Blocks: 446443
(Assignee)

Comment 1

10 years ago
Created attachment 330831 [details] [diff] [review]
Patch moving projects and languages to database

First version of a patch moving language and project information to a database.  Thorough testing still needs to be done, but the major issue in this patch right now is the number of SQL queries.  Due to the removal of the "potree.languages" and "potree.projects" data structures, any and all accessing of project/language information requires a SQL query, so there are an absurd number of queries on most pages.
(Assignee)

Comment 2

10 years ago
Created attachment 330853 [details] [diff] [review]
Improved patch moving Languages / Projects

This improves upon the previous patch by storing a dictionary of languages and projects, to avoid unneeded SQL queries.  All of the major features have been tested with this code, and so it is committed in revision 7830.
Attachment #330831 - Attachment is obsolete: true
(Assignee)

Comment 3

10 years ago
Changed the storage of user's projects, languages, uilang and altsrc lang to use relational database techniques.

This is in revision 7831.

This should cover everything related to languages and projects, so marking this FIXED.
Status: ASSIGNED → RESOLVED
Last Resolved: 10 years ago
Resolution: --- → FIXED
(Assignee)

Comment 4

10 years ago
Created attachment 330865 [details] [diff] [review]
Patch to add relational information between tables.

Patch for above comment.
(Assignee)

Updated

10 years ago
Attachment #330865 - Attachment description: Patch for above comment → Patch to add relational information between tables.
(Assignee)

Updated

10 years ago
No longer blocks: 446443
(Assignee)

Updated

10 years ago
Blocks: 444621
(Assignee)

Updated

10 years ago
Blocks: 447680
Product: Webtools → Webtools Graveyard
You need to log in before you can comment on or make changes to this bug.