fiskaly / grafana.surrealdb Goto Github PK

improvement: Is it possible to add variables in a Grafana plugin representing, for example, the geolocation position.coords in a variable $__position?
what do you think ?
thanks in advence

when i try to create a database with the api of grafana namespace is missing.
i send this json:
{'name': 'Surrealdb', 'type': 'fiskaly-surrealdb-datasource', 'typeName': 'SurrealDB', 'url': 'surrealdb:8000', 'access': 'proxy', 'withCredentials': False, 'basicAuth': False, 'jsonData': {'database': 'test', 'location': 'surrealdb:8000', 'namespace': 'test', 'username': 'root', 'password': 'root'}, 'uid': 'surrealdb', 'isDefault': True, 'database': 'fiskaly-surrealdb-datasource'}
a this end point:
POST /api/datasources
when i login and show the new database i get this:

the namespace is missing .
can you test it and verify.
thanks

In order to have this data source plugin published in the Grafana plugin catalog we have received the following change requests:

• provide missing hide functionality (either frontend or backend side) of a given data source
• rework the metric query mode user experience
• handle query state changes correctly in the frontend to only send necessary JSON data along with the query request
• provide clear separation of plugin.Datasource configuration and JSON data model and JSON secrets, see:

  grafana.surrealdb/pkg/plugin/datasource.go

  Line 43 in fcd65cf

  Password string `json:"password"` // secrets

• remove necessary getResource frontend calls and still not used backend logic, see: https://github.com/fiskaly/grafana.surrealdb/blob/v0.1.0/src/datasource.ts#L26 and

  grafana.surrealdb/pkg/plugin/datasource.go

  Lines 636 to 655 in fcd65cf

  	func (r *Datasource) CallResource(ctx context.Context, request *backend.CallResourceRequest, response backend.CallResourceResponseSender) error {
  	// log.DefaultLogger.Info(fmt.Sprintf("CallResource: %s", request.Path))
  	switch request.Path {
  	// case "TODO":
  	// return response.Send(
  	// &backend.CallResourceResponse{
  	// Status: http.StatusOK,
  	// Body: []byte(`{}`),
  	// },
  	// )
  	default:
  	return response.Send(
  	&backend.CallResourceResponse{
  	Status: http.StatusNotFound,
  	Body: []byte(`{}`),
  	},
  	)
  	}
  	}

• replace the panic() with an empty string, see:

  grafana.surrealdb/pkg/plugin/datasource.go

  Line 221 in fcd65cf

  panic(fmt.Sprintf("invalid QueryMode state '%d'", r))

• remove query syntax checks and use directly the checks by the underlying data source, see:

  grafana.surrealdb/pkg/plugin/datasource.go

  Lines 279 to 284 in fcd65cf

  	if strings.HasPrefix(surql, "select") == false &&
  	strings.HasPrefix(surql, "SELECT") == false &&
  	strings.HasPrefix(surql, "info") == false &&
  	strings.HasPrefix(surql, "INFO") == false &&
  	strings.HasPrefix(surql, "return") == false &&
  	strings.HasPrefix(surql, "RETURN") == false {

Hello ,
i create a timeserie:

{
    "id": "timetable:03jl9sgvaey8b2bh53tq",
    "location": "location:361820095V6",
    "person": "person:CLEA",
    "timestamp": "2024-02-22 21:41:01.123333"
}
or
{
    "id": "timetable:03jl9sgvaey8b2bh53tq",
    "location": "location:361820095V6",
    "person": "person:CLEA",
    "timestamp": "2024-02-22T21:41:01.123333"
}

i want to view it on grafana but the field timestamp doesnt work for date selection
and i cant see it in table mode:

the field timestamp is empty.
even if i choose timeseries ...

the timerange doesnt affect the result

is there a specific way to save timestamp ? what form ?
thanks in advance
lucile

hello,
I try to use surrealdb plugin to anotate.
it is visible in the dashboard but no way to write query.
is it possible to add the query textarea ?
thanks.

It miss thé Query SQL for variable.

is it possible to make this plugin work with live query in grafana : datasource with live support.
it needs channel

In order to dissect different the metric rate functions of a given query, provide a "group by" functionality for the rate computations.