diff options
Diffstat (limited to 'backend/init.go')
| -rw-r--r-- | backend/init.go | 27 |
1 files changed, 12 insertions, 15 deletions
diff --git a/backend/init.go b/backend/init.go index 4db3009..20f7c2e 100644 --- a/backend/init.go +++ b/backend/init.go @@ -7,7 +7,6 @@ import ( // InitStarsTable initialises the stars table func InitStarsTable(db *sql.DB) { - log.Println("Preparing the query") var query = `CREATE TABLE IF NOT EXISTS public.stars ( star_id bigserial, @@ -21,9 +20,9 @@ func InitStarsTable(db *sql.DB) { OIDS = FALSE ); -ALTER TABLE public.stars - OWNER to postgres;` - log.Println("Executing the query") +ALTER TABLE public.stars OWNER to postgres;` + + log.Println(query) _, err := db.Exec(query) if err != nil { log.Fatalf("[ E ] InitNodesTable query: %v \n\t\t\tquery: %s\n", err, query) @@ -33,30 +32,28 @@ ALTER TABLE public.stars // InitNodesTable initialises the nodes table func InitNodesTable(db *sql.DB) { - log.Println("creating the query") var query = `CREATE TABLE IF NOT EXISTS public.nodes ( node_id bigserial NOT NULL, box_width numeric, - total_mass numeric, + total_mass numeric DEFAULT 0, depth integer, - star_id bigint, - root_id bigint, + timestep integer, + star_id bigint DEFAULT 0, + root_id bigint DEFAULT 0, isleaf boolean, box_center numeric[], - center_of_mass numeric[], - subnodes bigint[], + center_of_mass numeric[] DEFAULT '{0,0}'::numeric[], + subnode bigint[] DEFAULT '{0,0,0,0}'::bigint[], PRIMARY KEY (node_id) ) WITH ( OIDS = FALSE ); -ALTER TABLE public.nodes - OWNER to postgres;` - log.Println("done creating the query") - log.Println("executing the query") +ALTER TABLE public.nodes OWNER to postgres;` + + log.Println(query) _, err := db.Exec(query) - log.Println("done executing the query") if err != nil { log.Fatalf("[ E ] InitNodesTable query: %v \n\t\t\tquery: %s\n", err, query) } |
