LateNight | 《深夜》，陪你度过每一个无聊的虚度时光 / 老项目 不更新

I am trying to fetch data from firebase before mounted() hook is called, but firebase query is asynchronous function and I'm struggling to handle those. Here is my code snippet:

BackGround

I have a list of dicts which is the output of a PostGreSql query. This query will output places which are within a specified distance from a given place and details about them. Also built in is a key which tells the code whether a check box on a HTML page has been checked.

this is a shortened version of what is outputted;

dictresult=[{'name_': 'The Three Lions','latelogo': None, 'latenight': 1, 'latenight_checked': 1, 'food_avail': 1, 'food_avail_checked': 0}, {'name_': 'The Borough Hall', 'latelogo': None, 'latenight': 0, 'latenight_checked': 1, 'food_avail': 1, 'food_avail_checked': 0},{'name_': 'The Leathern Bottle', 'latelogo': None, 'latenight': 0, 'latenight_checked': 1, 'food_avail': 1, 'food_avail_checked': 0},{'name_': 'The Cricketers', 'latelogo': None, 'latenight': 1, 'latenight_checked': 1, 'food_avail': 1, 'food_avail_checked': 0}, {'name_': 'The Sun Inn', 'latelogo': None, 'latenight': 0, 'latenight_checked': 1, 'food_avail': 1, 'food_avail_checked': 0},{'The Charterhouse Arms', 'latelogo': None, 'latenight': 1, 'latenight_checked': 1, 'food_avail': 1, 'food_avail_checked': 0}]

this code is then run against it;

I have written an app which takes input from the user through an HTML page (for the problem part, it is just 4 tick boxes) into to a python app which sends a query though psycopg2 to PostgreSQL and returns a dict list which is render back to HTML for the user using flask.

Everything works as long as the columns which the user selects(by wanting live music for example) are correct within the database/sql query, if not I get a blank output. (hope this makes some sense).

code

this is how I create each of the sub queries depending on input of the user

I have been trying to extract key values value counts from json data in a column in Pandas without success. The format for the data can be found in the data frame:

i have following @CongfigurationProperties class

I'm having some trouble with writing the logic of this code. I've parsed data from this large api.

Code currently retrieves all program titles (there are multiple instances of the same title) and compares it with the late night show array, then prints them out once in their own

tag.

I'd like to somehow click a program title and display more JSON data.

I thought to compare the

innerHTML, to the title variable, and when its div is clicked, return the list of guests for that particular program. I've been playing with the logic, and not too sure if I'm on the right track.

Yelp business data with 100 instances, in the following format:

I've been working on parsing a JSON file to make it easier to work with in PostgreSQL and was wondering what the best method would be to parse a JSON dictionary into tuples?

For example the lines look like this for the two variables:

The first

In my attributes key I want to find in the array records that are Special and has latenight : True.