Until you publish a web service on GCP while studying JQuery and Python

Introduction

Since COVID-19 has a lot of time left, I wondered if I could publish some services to the outside using JQuery, Python, etc., which I have a little knowledge of. After thinking about it, I decided to make what I wanted to use. It is ** editing the usage history of Mobile Suica so that it can be easily used for expense settlement **. Click here for the finished product https://www.mobilesuica.work

Writer's level

――I first touched the program 25 years ago when I used C language in university research. ――I didn't touch it at all after graduating from university, but about 10 years ago I started making scripts to hit Ruby and Visual Basic a little bit, and about 2 years ago to hit the REST API with Python (including studying my own products). ――From around February 2020, ask a detailed person in the company to teach you how to implement this architecture called Javascript + Python + Docker. --No experience in making so-called product level products

architecture

The following configuration was used to study containers and public clouds.

-** Reverse proxy with Nginx ** --Use ** jwilder / nginx-proxy ** for reverse proxy --For certificate creation, ** docker-letsencrypt-nginx-proxy-companion **. I found it easier to use this as a set with the above, so I decided to use it. -** Flask ** REST API server --For reading PDF files, use ** tabula-py ** to convert to CSV as it is --Process CSV with ** Pandas ** --Client processing with JQuery --Table display / file output is ** datatables ** -Use ** Bootstrap ** --Operates with f1-micro / Container-Optimized-OS on GCP.

Specification creation

As any member of society who goes around will understand, the usage history of Mobile Suica is difficult to use.

1. Can only be output as PDF
2. Since the filter has only the date, it is not possible to omit the history of shopping at convenience stores where expenses cannot be settled.
3. There is no total value in the first place
4. The usage amount is negative in the form of "difference"
5. There are useless items such as "out", "in", and "remaining amount"

The goal is to create a Web service that solves all the above complaints. The functions planned to be implemented are as follows

--You can upload the PDF file downloaded from the Mobile Suica site as it is. --Display on the browser as a table in the same format as the Mobile Suica site --Allow items to be freely filtered with check boxes, etc. --Add the total value of the filtered results --Output the filtered result to a file

From the next time, I will explain how to implement it on the server side in Python.