architecture – Logical grouping of properties vs class structure

The architecture i’m working with is that we have three services:

  1. Main service that takes care of the business logic. It exposes an internal API to proxy service in XML protocol.
  2. Proxy service that takes care of the routing logic. It exposes a public API to third party servies in JSON protocol.
  3. Third party services which are aggregated through proxy service to main service

Let’s have a simple example with two interfaces. One which starts a football match and another which sets the results for it.

<?xml version="1.0" encoding="UTF-8"?>
<createFootballMatch>
    <matchDetails>
        <id>12345</id>
        <startTime>DateTime</startTime>
        <venue>Allianz Arena</venue>
    </matchDetails>
    ... more properties
</createFootballMatch>

<?xml version="1.0" encoding="UTF-8"?>
<footballMatchResults>
    <matchDetails>
        <id>12345</id>
        <venue>Allianz Arena</venue>
        <endTime>DateTime</endTime>
    </matchDetails>
    .. more properties
</footballMatchResults>

Both APIs have matchDetails object, however, one of them has startTime and another endTime. If documentation is auto-generated based on the properties that the class has, then the documentation would have matchDetails specifying startTime and endTime as optional properties, however, in their respective APIs, neither of them is optional. Thus, the main service opts for exposing the interfaces as:

<?xml version="1.0" encoding="UTF-8"?>
<createFootballMatch>
    <matchDetails>
        <id>12345</id>
        <venue>Allianz Arena</venue>
    </matchDetails>
    <startTime>DateTime</startTime>
    ... more properties
</createFootballMatch>

<?xml version="1.0" encoding="UTF-8"?>
<footballMatchResults>
    <matchDetails>
        <id>12345</id>
        <venue>Allianz Arena</venue>
    </matchDetails>
    <endTime>DateTime</endTime>
    .. more properties
</footballMatchResults>

This leaves matchDetails as a class that can be reused between two properties. In the JSON API, however, the proxy service does not care about the underlying class structure, and can map it any way it wants (moreover documentation is not auto generated), thus it could be done as:

/createFootballMatch
{
    "matchDetails": {
        "id": 12345,
        "startTime": "DateTime",
        "venue": "Allianz Arena"
    }
    .. more properties
}
/footballMatchResults
{
    "matchDetails": {
        "id": 12345,
        "endTime": "DateTime",
        "venue": "Allianz Arena"
    }
    .. more properties
}

Since the proprety endTime and startTime are details of the match, logically, it could be represented in the matchDetails object. What would be the better approach – follow the class structure or keep the API logical and have more complex mapping between services?

Get First and Last value in Oracle 11g grouping pattern values

I need get CD_OPERACAO, first DT_HR_INICIAL and last DT_HR_FINAL, in 12c I used to MATCH_RECOGNIZE but in Oracle 11g I can’t find the solution.

enter image description here

Example output that i need:

enter image description here

I’m trying it

select * from (
select CD_OPERACAO,
min(DT_HR_INICIAL) over (partition by CD_OPERACAO ORDER BY DT_HR_INICIAL) DT_HR_INICIAL,
max(DT_HR_FINAL) over (partition by CD_OPERACAO) DT_HR_FINAL
from table
)

Grouping rows by value templates

Is there any option to automatically group rows by their values if they fit certain criteria or template?
For example I want to group all iOS 14* records into one and all Android 8* into other

Plus group 5 records with smallest number of users into one.


Source data

Android 10 4259
iOS 14.6 4067
Android 11 1818
Android 9 1562
iOS 14.4.2 1016
Android 8.1.0 458
Android 8.0.0 348
iOS 14.4 341

Android 10 4259
iOS 14.6 4067
Android 11 1818
Android 9 1562
iOS 14.4.2 1016
Android 8.1.0 458
Android 8.0.0 348
iOS 14.4.2 341
iOS 14 1
iOS 12.1.3 1
iOS 12.4.2 1
iOS 13.2 1
Android 7.0.0 1

Google sheets – grouping rows by value templates

Is there any option to automatically group rows by their values if they fit certain criteria or template?
For example I want to group all iOS 14* records into one and all Android 8* into other

enter image description here

Plus group 5 records with smallest number of users into one.

enter image description here

Google sheets – grouping rows by value templates

Google sheets – grouping rows by value templates – Ask Different

Grouping Around a Point and Moving Together With Steering Behaviors

I have a group of enemies that move together. I have them grouped around a point by setting their target to be a point. I have combined the “Seek” (“Arrive” has the same issue in this case) and “Separate” steering behaviors to achieve this. My issue stems from the fact that they all want to move to that point, effectively fighting for the center (The separate steering behavior just has them doing this at a distance). Is there any way I could group them together like this without having them fight for the center? I don’t want to have set positions as that would be quite unnatural looking and ill-fitting for my game. I also think a flow field would have the same issues (I’m, not sure about that).

Group by clause for grouping empty or null data in sql server


Your privacy


By clicking “Accept all cookies”, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our Cookie Policy.




Which Google Analytics channel grouping would you use for an email being sent legally by a third-party to their subscribers?

We have permission for a third party to send some information about us in one of their newsletters. And we want to use the appropriate tracking.

Would you treat this as display (as it’s an advert)? I’d use display if it was a banner ad on a third-party site.

Or would you use email as the medium even though it’s not in one of our own emails?

8 – Grouping in Views jumbles row numbers returned by Result Counter

Grouping in a View is being used to show a list of items in a table, each row is numbered using Result Counter. However, the View uses grouping which causes the results to be jumbled. See enclosed image.

Any ideas how to renumber the rows correctly, also is there a way list the row numbers in reverse order.

Row numbers from Result Counter are jumbled when Views uses grouping

UI for customized grouping

I’m building a lean CV (resume) management system (web-based) for HR people. Some users want to group CV by position, some like to group by skills, some like school, .etc, some even think of their quirky criteria.

Any suggested keywords for UI I should look up?

Thanks

DreamProxies - Cheapest USA Elite Private Proxies 100 Private Proxies 200 Private Proxies 400 Private Proxies 1000 Private Proxies 2000 Private Proxies 5000 Private Proxies ExtraProxies.com - Buy Cheap Private Proxies Buy 50 Private Proxies Buy 100 Private Proxies Buy 200 Private Proxies Buy 500 Private Proxies Buy 1000 Private Proxies Buy 2000 Private Proxies ProxiesLive.com Proxies-free.com New Proxy Lists Every Day Proxies123.com Buy Cheap Private Proxies; Best Quality USA Private Proxies