db-container

This Repo contains the main "database" running an http-api exposing the quadtree.

API-Endpoints

Endpoint	Description	POST parameters
"/"	Index
"/new"	Create a new star	w
"/printall"	Print all the trees in json
"/insert/{treeindex}"	Insert the given star into the selected tree	x, y, vx, vy, m
"/starlist/{treeindex}"	List all the stars in the selected tree
"/dumptree/{treeindex}"	Dump the json of the selected tree
"/updatetotalmass/{treeindex}"	Update the total mass in the selected tree
"/updatecenterofmass/{treeindex}"	Update the center of mass in the selected tree
"/metrics"	Get the overall metrics
"/export/{treeindex}"	Export the selected tree to db/{treeindex}.json
"/fastinsert/{filename}"	Insert the selected file into a new tree

Tables

nodes

-- Table: public.nodes

-- DROP TABLE public.nodes;

CREATE TABLE public.nodes
(
    node_id bigint NOT NULL DEFAULT nextval('nodes_node_id_seq'::regclass),
    box_center_x numeric,
    box_center_y numeric,
    box_width numeric,
    center_of_mass_x numeric,
    center_of_mass_y numeric,
    total_mass numeric,
    depth numeric,
    star_id bigint,
    "subnode_A" bigint,
    "subnode_B" bigint,
    "subnode_C" bigint,
    "subnode_D" bigint,
    CONSTRAINT nodes_pkey PRIMARY KEY (node_id)
)
WITH (
    OIDS = FALSE
)
TABLESPACE pg_default;

ALTER TABLE public.nodes
    OWNER to postgres;