mirror of
https://github.com/featurebasedb/featurebase.git
synced 2026-09-07 17:15:56 +00:00
ea72396b4d
* Remove Node from data model; standardize on Worker This commit does a lot of things, but in general it attempts to simplify the data model by getting rid of the Node and NodeRole models. Instead, these will use the Worker model, which itself has individual boolean fields for role types. Get rid of roleType in some FreeWorker methods rename NodeService to WorkerRegistry simplify the freeworker interface fix the tests * Remove DeleteWorker method from workerJobService
16 lines
No EOL
774 B
Text
16 lines
No EOL
774 B
Text
add_column("workers", "role_compute", "bool", {"default": false})
|
|
add_column("workers", "role_translate", "bool", {"default": false})
|
|
add_column("workers", "role_query", "bool", {"default": false})
|
|
|
|
sql("update jobs set worker_id = wc.id from workers wc inner join workers wt on wc.address = wt.address and wc.database_id = wt.database_id and wc.role = 'compute' and wt.role = 'translate' where worker_id = wt.id;")
|
|
|
|
sql("update workers set role_compute = true where role = 'compute';")
|
|
|
|
sql("update workers set role_translate = true from workers wt where workers.address = wt.address and workers.role = 'compute' and wt.role = 'translate';")
|
|
|
|
sql("delete from workers where role = 'translate';")
|
|
|
|
drop_column("workers", "role")
|
|
|
|
drop_table("node_roles")
|
|
drop_table("nodes") |