Add Count functions in database about core HOT 7 CLOSED

ho yep now I get you 👍 , it'd say from the URL. /db/count/ a real URL will look like this:

/db/count/tasks where tasks is the collection name. You grab it via the getURLPath(path, 3) for instance. Do not use the soon deprecated ShiftPath function as of #62

from core.

this is how PG wants the field name to be when querying on a field. the data field is a JSONB and the syntax ``data->>'field-name' is the way to target a field name from the JSONB object.

Not sure why you're getting an error though. Technically you would not need this for the Count though, you'd use the same function to build the filters as the QueryDocument or the UpdateMany functions for instance.

Also the data field is only present on user's defined collection, not built-in SB collection, for example the sb_accounts has no data JSONB field, but is a real PG table without JSON data.

from core.

@dstpierre Can you review my PR?

from core.

How we'll get column name? From url like /db/count/{{column_name}} or from where?🤔

from core.

@VladPetriv there's no need to column_name. It's a count for the entire collection optionally based on filters (like the Query and the UpdateMany).

It counts the numbers of rows matching the filters, or without filters. It's an HTTP POST that's made to /db/count which accept a similar filters as the query function or no filter.

Hope that helps clarify. Let me know.

from core.

✅Got it. But from where you want to get collection name?🤔

from core.

Got it thanks✅

But also have a question about this:

field = fmt.Sprintf(`data->>'%s'`, field)

What does data->> mean?🤔 I never met it before.
Because in my case PosgreSQL returns this error pq: column "data" does not exist
If I remove this data->> it works fine🤔

PosgreSQL version
psql (PostgreSQL) 14.5 (Ubuntu 14.5-1.pgdg22.04+1)

from core.