snapp-interview

This is my solution for what Snapp team defined in this task.

I developed this by Go language and using PostgreSQL as database.

To run this you should create a database named "snapp", then create a table in the "snapp" using following script:

CREATE SEQUENCE queries_id_seq;

CREATE TABLE queries (
    id integer NOT NULL DEFAULT nextval('queries_id_seq'),
	term character varying(1000),
	millitime bigint
);

ALTER SEQUENCE queries_id_seq
OWNED BY queries.id;

How to use it

Send a search query to this service using the following REST API:

http://localhost:8585/index-search-query?query=.Please, email john.doe@foo.com by 03-09, re: m37-xq.

and use the following REST API for get the N Top queries in the h hours ago:

http://localhost:8585/return-queries?hour=1&count=100