sustain | Personal blog powered by Jekyll | Theme library

I've created a filterbox to show all selected checked texts in a box. When you click the checkbox the item automatically displays into the box. At this point, I'm trying to remove the [i] beside the text when its in the filter box, but I'm experiencing difficulty.

...

I have put together together a list of items in an HTML file and each time I check an item in the list I want it to appear where it says "Filter will display here" as a button" I've run a console.log over the js code and it says: "item not checked."

...

I was creating a binary tree using linked list in java, which inserts the value according to the height of the tree i.e if the height is even or odd. I wrote a code which initially had no temporary node for insertion of values to the root node and further left or right subtree nodes. But when I displayed this tree, output had no root node as if it was overwritten.
Below is the code of my initial program. Concentrate on public void insert_node() function.

...

I need some help with the bootstrap accordion

I want to add the border-bottom-color: red for the header of an item "Collapsible Group Item" div when it's open
and remove it when the div is closed

I am trying to add the class through Jquery and that class will have the border-bottom-color: red CSS.
but it's not working, can someone tell me where I am wrong

Expected:
When the div is open the class will get add else it will get removed

Result of the code I have written:
The color is getting added to all the div at the same time irrespective of open div

...

So I have the following code, where I'm fetching data to be rendered in my component. However, if the useEffect is set to run once, it wont render the data inside the component, and having it constantly running is not sustainable.

...

I would like to find a sustainable solution for storing FCM tokens used for push notifications. I am using React Native with Firebase.

The requirements are:

1. User-based application
2. Multiple devices per user supported
3. No stale tokens stored at any time.

My current approach is:

Maintain a table user_devices with columns:

• user_id,
• device_uuid
• fcm_token

Maintain a uniqueness constraint on fcm_token and device_uuid.

Upon key events, including but not limited to:

• application startup
• sign in
• onTokenRefresh

send the following to the backend:

• device unique id
• FCM registration token
• user id, if there is one (done through authentication token)

The backend then upserts a row with the above values. If the device uuid exists, that means, we overwrite the token (and, potentially, the user_id) for that device uuid.

The above approach is flawed because:

• device unique id can change at any point (device reset, update, app reinstall, etc...)
• registration token can change at any point

In other words, the table ends up storing many stale tokens and the application backend sends notifications to those stale tokens.

Additionally, the "Devices" frontend page (which shows the user their registered devices and reads from the above table) shows many duplicate devices that, really, represent the same device but have different device uuids.

One mitigation step could be to periodically send notifications to all tokens stored in the table with dry_run=true. Then, remove rows with tokens for which an error occurred. This is bad because it implies there is a period during which tokens are stale in the table.

I have scanned multiple resources online, including FCM documentation, but there is no mention on storing and maintaining those tokens in a real-world application. Are there any suggested approaches?

...

I have three columns:

...

I'm working on a quarterly report. The report should look something like this:

col Calculation Source table Start_Balance Sum at start of time period Account_balance Sell Transactions Sum of all sell values between the two time periods Transactions Buy Transactions Sum of all buy values between the two time periods Transactions End Balance Sum at the end of time period Account_balance

so e.g.

Calculation sum Start_Balance 1000 Sell Transactions 500 Buy Transactions 750 End Balance 1250

The problem here is that I'm working with a relational star schema, one of the facts is semi-additive and the other is additive, so they behave differently on the time dimension.

In my case I'm using Cognos analytics, but I think this problem goes for any BI tool. What would be best practice to deal with this issue? I'm certain I can come up with some sql query that combines these two tables into one table which the report reads from, but this doesn't seem like best practice, or is it? Another approach would be to create some measures in the BI tool, I'm not a big fan of this approach because it seems to be least sustainable approach, and I'm unfamiliar with it.

...

I'm trying to scrape historical ESG data from Sustainalytics on Yahoo Finance using Python. Specifically, let's say I want the last 10 years of ESG scores of a given list of constituents.

The following code lines provides up-to-date ESG scores. But I would like to scrape past-ESG performance. I am essentially looking for yearly (monthly, if possible) ESG from Jan 2010 till Dec 2020. I would like to automate the scraping and save the data in a txt or csv file.

...