admin panel – Sell Bundle at discount price, sell individual products in bundle at full price

I have a product bundle (for example skateboard), when all products in bundle are selected it will display a discount price. If a buyer wants to purchase just part of the bundle (for example just the wheels) they can buy that product at full price.

Can such an option be possible? If so how to configure it in the admin panel.

Is azure good place to start for an individual dev?

Is it feasible for an individual dev to use azure for hosting a web app? Would the cost be dependent on the load of the app service receives?

If you have any experience with this or any recommendations please share.

How to select multiple individual cells on Google Sheets on my Android mobile phone?

I use this feature all the time…

Having opened your sheet on Android, simply tap the cell you wish to access

enter image description hereand at the bottom of the screen you will see the place where you can Enter text or formula. Once done, tap the tick ✓ (right of screen at the end of the entry panel)

enter image description here

and then tap the tick ✓ at the top left hand side of the screen and the job is done.

enter image description here

You can only enter data in one cell at at time but if you are wishing to select a number of cells (for example to edit colours, formatting cell ranges etc), use the corners of the cell selected and drag to open a range (but you cannot enter data that way nor can you, for that matter, in a browser. Neither can you you cannot select multiple unconnected cells.

How to select multiple individual cells in Google Sheets Android app on mobile phone?

How to select multiple individual cells in Google Sheets Android app on mobile phone?

On Windows it is possible by using the CTRL button + left mouse button and select multiple cells, but I did not find any solution on Google Sheets Android app.

How to select individual cells on Google Sheets on my Android mobile phone?

How to select individual cells on Google Sheets on my Android mobile phone?

On Windows it is possible by using the CTRL button + left mouse button click, but I did not find any solution on Google Sheets for Android.

functional programming – Doesn’t “Always test through the public interface” contradict testing of individual composed functions?

I’m currently reading “Composing Software” by Eric Elliott, which is about functional programming in JavaScript. He states that if you compose multiple functions together, and that these functions have been fully tested in isolation – then you don’t need to unit test the composed function (as that can be done using an integrated test that performs all the side effects.)

But isn’t simply testing the individual functions violating the core TDD principle of “always test the public inteface, and not the implementation”? Arguably the composing of the smaller functions is an implementation detail. As long as my service performs the action that it says it will do, we shouldn’t really care about the small “private” functions being composed in order to get the right behaviour.

I’m trying to reconcile the two ideas but I’m struggling. The only way around this (that I can think of) is to mock the dependencies that my service needs so that it can be tested through the public interface, but going functional was my attempt to stop using mocks in the first place.

certificates – CA cert with many Subject Alternative Name (SAN) entries, versus individual certs in public production?

The idea of using SANs makes sense if you have, for example, one web server which takes care of several smaller websites (e.g. example.com and internal.example.com). In this case, having one certificate per web server, with SANs for each website reduces the amount of configuration overhead.

However, once you start to create what I like to call a “megacertificate”, meaning once certificate with uncountably many SANs, you will run into problems. This certificate, and its associated private key, will likely be distributed to many many different servers, meaning that your private key will be in many different places.

This in turn means that the attack surface has now grown exponentially, as it means one compromised server can now compromise all domains, even if they are on different physical servers.

(+) its easier to standardise the certificate options (i.e. hashing/cyphers) on a shared cert

This is false. First of all, the certificate itself does not define any cryptographic ciphers to be used by TLS, only which cryptographic operations are necessary to validate the certificate.

This means that two different physical servers – let’s call them alice.com and bob.com – can use the same certificate (with SAN entries for both), and yet still support completely different sets of ciphers. alice.com could support only state-of-the-art ciphers and bob.com may be stuck using insecure legacy ciphers for interoperability reasons.

The only valid reason I can think of at the moment why you might use SANs – aside from convenience during manual setup – is that an appliance or application may not support uploading several different certificates, yet needs to serve different domains.

performance – Disable remote http access for individual plugins in WordPress

I am creating a WordPress LMS website and to achieve my goals I need to install more than 40 plugins.

Some of the plugins send remote http requests for license check and it consumes a lot of resources and some time a cURL 28: timeout error occurs.

To disable remote http access for the whole WordPress system I can use the following code:
define( 'WP_HTTP_BLOCK_EXTERNAL', false );

Although this method works but messes up other plugins loading necessary CSS or JavaScript remotely.

Is there any way to disable remote http access for individual plugins or not and if there is please explain.

Thank you so much.

testing – If two individual branches pass unit tests, once they’re merged, is the result also guaranteed to pass unit tests?

Suppose we have two branches A and B which have been forked from master.

Both branches A and B make some changes and implement some unit tests. They pass all current and new tests, then are merged back into master. For simplicity, there are no merge conflicts.

Is it guaranteed that the resulting code on master will also pass the unit tests?

sql server – Split value from a date range in to individual values per date

I am modifying a SSRS sales report for my customer. I have already calculated the number of days and based on that the daily value. In the software you set the start and end date of the agreement which are visible on the report.

My customer wants to split the agreement value in to individual date values. Is there a way how I can split the date range in to individual dates? Then I would just group all the individual dates values from all agreements in to one daily total.

I am using SQL Server 2017 and Visual Studio 2013

enter image description here