1178641 - Move away from the multi database architecture & use the Django ORM

Status: RESOLVED FIXED

(Tree Management :: Treeherder, defect, P2)

Description

[Mauro Doglio [:mdoglio]]

We have recently talked about moving to a more standard database architecture, with a unified database containing both reference and job data. This includes:
- create orm classes for every db table.
- adapt the api to use the new unified db schema.
- convert all the JobsModel methods into a orm counterpart, potentially switching to raw sql where necessary.

Comment 1

[Mauro Doglio [:mdoglio]]

After some coding on this I still think it's a good idea but we need to tackle the problem in a more incremental way. I'll mark some bugs as blockers to keep track of the progress on this.

Comment 3

[Armen [:armenzg]]

Hi wlach, what is your current timeline for this?

Comment 4

[William Lachance (:wlach)]

(In reply to Armen Zambrano [:armenzg] (EDT/UTC-4) from comment #3)
> Hi wlach, what is your current timeline for this?

I am hoping to have this mostly finished (pending reviews) within ~1 week. The largest piece of work is bug 1306674.

Comment 5

[William Lachance (:wlach)]

treeherder no longer uses datasource in any way \o/