Question: I have a application that writes logs to postgres database in the format attached. You have to create a Flask REST API that connects to

I have a application that writes logs to postgres database in the format attached. You have to create a Flask REST API that connects to the DB and returns the following stats.

a. Number of logs at a certain time. b. Peak time for GET and POST requests. c. Hour wise frequency of logs. d. The ratio of Status code 200 vs other status code for a given URL. e. The 5 most requested URLs.

I have a application that writes logs to postgres database in the

Staus IP 10.128.2.1 10.128.2.1 10.128.2.1 10.131.2.1 10.130.2.1 10.130.2.1 10.128.2.1 10.131.2.1 10.131.2.1 10.131.2.1 10.131.2.1 10.130.2.1 10.130.2.1 10.130.2.1 10.130.2.1 10.129.2.1 10.131.0.1 10.131.0.1 10.130.2.1 10.131.2.1 10.131.2.1 10.128.2.1 10.131.0.1 10.128.2.1 10.131.0.1 10.129.2.1 10.131.0.1 10.128.2.1 10.131.2.1 10.131.2.1 10.131.2.1 10.131.2.1 10.131.2.1 10.131.2.1 10.131.2.1 10.131.2.1 Time [29/Nov/2017:06:58:55 [29/Nov/2017:06:59:02 [29/Nov/2017:06:59:03 [29/Nov/2017:06:59:04 [29/Nov/2017:06:59:06 [29/Nov/2017:06:59:19 [29/Nov/2017:06:59:19 [29/Nov/2017:06:59:19 [29/Nov/2017:06:59:30 [29/Nov/2017:06:59:37 [29/Nov/2017:06:59:37 [29/Nov/2017:07:00:19 [29/Nov/2017:07:00:21 [29/Nov/2017:13:31:27 [29/Nov/2017:13:31:28 [29/Nov/2017:13:38:03 [29/Nov/2017:13:38:04 [29/Nov/2017:13:38:07 [29/Nov/2017:13:38:19 [29/Nov/2017:13:38:20 [29/Nov/2017:13:38:20 [29/Nov/2017:13:38:20 [29/Nov/2017:13:38:20 [29/Nov/2017:13:38:20 [29/Nov/2017:13:38:20 [29/Nov/2017:13:38:20 [29/Nov/2017:13:38:21 [29/Nov/2017:13:38:21 [29/Nov/2017:13:38:23 [29/Nov/2017:13:46:46 [29/Nov/2017:13:46:50 [29/Nov/2017:13:46:53 [29/Nov/2017:13:46:54 [29/Nov/2017:13:47:04 [29/Nov/2017:13:47:05 [29/Nov/2017:13:47:16 URL GET /login.php HTTP/1.1 POST /process.php HTTP/1.1 GET /home.php HTTP/1.1 GET /js/vendor/moment.min.js HTTP/1.1 GET /bootstrap-3.3.7/js/bootstrap.js HTTP/1.1 GET /profile.php?user=bala HTTP/1.1 GET /js/jquery.min.js HTTP/1.1 GET /is/chart.min.js HTTP/1.1 GET /edit.php?name=bala HTTP/1.1 GET /logout.php HTTP/1.1 GET /login.php HTTP/1.1 GET /login.php HTTP/1.1 GET /login.php HTTP/1.1 GET/ HTTP/1.1 GET /login.php HTTP/1.1 POST /process.php HTTP/1.1 GET /home.php HTTP/1.1 GET /contestproblem.php?name=RUET%2001%20Server%20Testing%20Contest HTTP/1.1 GET/ HTTP/1.1 GET /login.php HTTP/1.1 GET /css/bootstrap.min.css HTTP/1.1 GET /css/font-awesome.min.css HTTP/1.1 GET /cssormalize.css HTTP/1.1 GET /css/style.css HTTP/1.1 GET /js/vendor/modernizr-2.8.3.min.js HTTP/1.1 GET /css/main.css HTTP/1.1 GET /js/vendor/jquery-1.12.0.min.js HTTP/1.1 GET /bootstrap-3.3.7/js/bootstrap.min.js HTTP/1.1 GET /fonts/fontawesome-webfont.woff2?v=4.6.3 HTTP/1.1 GET/ HTTP/1.1 GET /contestproblem.php?name=RUET%2001%20Server%20Testing%20Contest HTTP/1.1 GET /logout.php HTTP/1.1 GET /login.php HTTP/1.1 POST /process.php HTTP/1.1 GET /login.php?value=fail HTTP/1.1 POST /process.php HTTP/1.1 200 302 200 200 200 200 200 200 200 302 200 200 200 302 200 302 200 200 302 200 200 200 200 200 200 200 200 200 200 200 200 302 200 302 200 302 Staus IP 10.128.2.1 10.128.2.1 10.128.2.1 10.131.2.1 10.130.2.1 10.130.2.1 10.128.2.1 10.131.2.1 10.131.2.1 10.131.2.1 10.131.2.1 10.130.2.1 10.130.2.1 10.130.2.1 10.130.2.1 10.129.2.1 10.131.0.1 10.131.0.1 10.130.2.1 10.131.2.1 10.131.2.1 10.128.2.1 10.131.0.1 10.128.2.1 10.131.0.1 10.129.2.1 10.131.0.1 10.128.2.1 10.131.2.1 10.131.2.1 10.131.2.1 10.131.2.1 10.131.2.1 10.131.2.1 10.131.2.1 10.131.2.1 Time [29/Nov/2017:06:58:55 [29/Nov/2017:06:59:02 [29/Nov/2017:06:59:03 [29/Nov/2017:06:59:04 [29/Nov/2017:06:59:06 [29/Nov/2017:06:59:19 [29/Nov/2017:06:59:19 [29/Nov/2017:06:59:19 [29/Nov/2017:06:59:30 [29/Nov/2017:06:59:37 [29/Nov/2017:06:59:37 [29/Nov/2017:07:00:19 [29/Nov/2017:07:00:21 [29/Nov/2017:13:31:27 [29/Nov/2017:13:31:28 [29/Nov/2017:13:38:03 [29/Nov/2017:13:38:04 [29/Nov/2017:13:38:07 [29/Nov/2017:13:38:19 [29/Nov/2017:13:38:20 [29/Nov/2017:13:38:20 [29/Nov/2017:13:38:20 [29/Nov/2017:13:38:20 [29/Nov/2017:13:38:20 [29/Nov/2017:13:38:20 [29/Nov/2017:13:38:20 [29/Nov/2017:13:38:21 [29/Nov/2017:13:38:21 [29/Nov/2017:13:38:23 [29/Nov/2017:13:46:46 [29/Nov/2017:13:46:50 [29/Nov/2017:13:46:53 [29/Nov/2017:13:46:54 [29/Nov/2017:13:47:04 [29/Nov/2017:13:47:05 [29/Nov/2017:13:47:16 URL GET /login.php HTTP/1.1 POST /process.php HTTP/1.1 GET /home.php HTTP/1.1 GET /js/vendor/moment.min.js HTTP/1.1 GET /bootstrap-3.3.7/js/bootstrap.js HTTP/1.1 GET /profile.php?user=bala HTTP/1.1 GET /js/jquery.min.js HTTP/1.1 GET /is/chart.min.js HTTP/1.1 GET /edit.php?name=bala HTTP/1.1 GET /logout.php HTTP/1.1 GET /login.php HTTP/1.1 GET /login.php HTTP/1.1 GET /login.php HTTP/1.1 GET/ HTTP/1.1 GET /login.php HTTP/1.1 POST /process.php HTTP/1.1 GET /home.php HTTP/1.1 GET /contestproblem.php?name=RUET%2001%20Server%20Testing%20Contest HTTP/1.1 GET/ HTTP/1.1 GET /login.php HTTP/1.1 GET /css/bootstrap.min.css HTTP/1.1 GET /css/font-awesome.min.css HTTP/1.1 GET /cssormalize.css HTTP/1.1 GET /css/style.css HTTP/1.1 GET /js/vendor/modernizr-2.8.3.min.js HTTP/1.1 GET /css/main.css HTTP/1.1 GET /js/vendor/jquery-1.12.0.min.js HTTP/1.1 GET /bootstrap-3.3.7/js/bootstrap.min.js HTTP/1.1 GET /fonts/fontawesome-webfont.woff2?v=4.6.3 HTTP/1.1 GET/ HTTP/1.1 GET /contestproblem.php?name=RUET%2001%20Server%20Testing%20Contest HTTP/1.1 GET /logout.php HTTP/1.1 GET /login.php HTTP/1.1 POST /process.php HTTP/1.1 GET /login.php?value=fail HTTP/1.1 POST /process.php HTTP/1.1 200 302 200 200 200 200 200 200 200 302 200 200 200 302 200 302 200 200 302 200 200 200 200 200 200 200 200 200 200 200 200 302 200 302 200 302

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

You are working on an application which creates lots of log every day. Sample logs are shown in the table below. You need to write the code to analyse the logs and share insights. Build the following...

ISFM-300 Case Study, Stage 2: Business Process Analysis and Functional Requirements Before you begin this assignment, be sure you: 1. Have completed all previously assigned readings, particularly...

can someone solve this Modern workstations typically have memory systems that incorporate two or three levels of caching. Explain why they are designed like this. [4 marks] In order to investigate...

In this project you will complete the implementation of a Java program that helps a user maintain a library of their favorite songs. The library is in the form of a list of songs. The program stores...

I have to create a program in C and I can't figure it out. The program has to read a source file. Please help. /******************************************************************** PROJECT: Glossary...

7/15/2016 Leadership: Theory, Application, & Skill Development, 5e PRINTED BY: e9f1fdcd538746b@placeholder.18085.edu. Printing is for personal, private use only. No part of this book may be...

Protecting Your Trademark ENHANCING YOUR RIGHTS THROUGH FEDERAL REGISTRATION Basic Facts About Trademarks United States Patent and Trademark Office MESSAGE FROM THE USPTO Thank you for requesting a...

Ottawa, Ontario, February 23, 2022 PRESENT: Mr. Justice Sbastien Grammond BETWEEN: MARYAM DAHER ELIAS Applicant and THE MINISTER OF CITIZENSHIP AND IMMIGRATION Respondent JUDGMENT AND REASONS [1] Ms....

Elias v. Canada (Citizenship and Immigration), 2022 FC 252 (CanLII) Document History(0) Cited documents(5) Treatment(2) CanLII Connects(2) PDF Date: 2022-02-23 File number: IMM-1239-21 Citation:...

Please do not respond through AI tools like ChatGPT or Gemini, as nearly all their answers have been consistently incorrect. Please agree to answer the MCQ questions only if you have the knowledge to...

What is the likely relationship between the interest income ratio and the noninterest income ratio?

What is the difference between the cash basis and accrual basis of accounting?

1 : 4 4 : 2 0 remaining Page 2 2 of 2 6 Question 2 1 ( 4 points ) Listen If 1 0 - year T - bonds have a yield of 6 . 2 % , 1 0 - year corporate bonds yield 7 . 9 % , the maturity risk premium on all...

Consider a (15,3) cyclic code. a) Show that g(D) = 1 +D3 + D6 + D + D12 is a generator polynomial of this code. [4 marks) b) Suppose a codeword has been transmitted across a channel and the received...

Question Is there any type of disability plan that provides both employer payment of deductible premiums and non-taxation of benefits to the employee?

Question Is there ever any advantage in designing an HRA that discriminates by covering only specific executives?

Question Is it possible to design an HRA that excludes rank and file employees by funding the HRA with a health insurance contract?