rest-example-go's Introduction

rest-example-go

JSON for Postman

{"first_name":"Josh","last_name":"Green","email":"[email protected]","password":"a"}

Dump database

DROP TABLE IF EXISTS "users";
DROP SEQUENCE IF EXISTS users_seq;
CREATE SEQUENCE users_seq INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 1 CACHE 1;

CREATE TABLE "public"."users" (
    "id" integer DEFAULT nextval('users_seq') NOT NULL,
    "first_name" character varying(255) NOT NULL,
    "last_name" character varying(255) NOT NULL,
    "email" character varying(255) NOT NULL,
    "password" character varying(255) NOT NULL,
    "sex" smallint DEFAULT '1' NOT NULL,
    CONSTRAINT "users_pkey" PRIMARY KEY ("id")
) WITH (oids = false);

INSERT INTO "users" ("id", "first_name", "last_name", "email", "password", "sex") VALUES
(2,	'My Name',	'My Name',	'[email protected]',	'My Name',	1),
(3,	'Duncan',	'Stewart',	'[email protected]',	'1',	1),
(4,	'Teagan',	'Harrison',	'[email protected]',	'2',	1),
(5,	'Duncan1',	'Stewart',	'[email protected]',	'',	1),
(10,	'Jon',	'Doe',	'[email protected]',	'a',	0),
(13,	'Duncan2',	'Stewart2',	'[email protected]',	'w',	1),
(15,	'Josh',	'Green',	'[email protected]',	'a',	0),
(1,	'Qwer',	'Qwertov',	'[email protected]',	'',	1);

Example config.json

{

"database": {

"connectionType": "postgres",

"connectionString": "user=postgres dbname=apirepository sslmode=disable"

},
  
"server": {

"port": 3000

}

}

Recommend Projects