thanosql.resources._query

Module Contents

Classes

QueryLog

QueryType

Create a collection of name/value pairs.

QueryService

QueryLogService

Cannot exist without a parent QueryService

QueryTemplate

QueryTemplateService

Cannot exist without a parent QueryService

class thanosql.resources._query.QueryLog

Bases: thanosql.resources._model.BaseModel

query_id: str | None
statement_type: str | None
start_time: datetime.datetime | None
end_time: datetime.datetime | None
query: str
referer: str
state: str | None
destination_table_name: str | None
destination_schema: str | None
error_result: str | None
created_at: datetime.datetime | None
records: thanosql.resources._record.Records | None
class thanosql.resources._query.QueryType(*args, **kwds)

Bases: enum.Enum

Create a collection of name/value pairs.

Example enumeration:

>>> class Color(Enum):
...     RED = 1
...     BLUE = 2
...     GREEN = 3

Access them by:

  • attribute access:

    >>> Color.RED
    <Color.RED: 1>
    
  • value lookup:

    >>> Color(1)
    <Color.RED: 1>
    
  • name lookup:

    >>> Color['RED']
    <Color.RED: 1>
    

Enumerations can be iterated over, and know how many members they have:

>>> len(Color)
3
>>> list(Color)
[<Color.RED: 1>, <Color.BLUE: 2>, <Color.GREEN: 3>]

Methods can be added to enumerations, and members can have their own attributes – see the documentation for details.

THANOSQL = 'thanosql'
PSQL = 'psql'
class thanosql.resources._query.QueryService(client: thanosql._client.ThanoSQL)

Bases: thanosql._service.ThanoSQLService

execute(query: str | None = None, query_type: str = 'thanosql', template_id: int | None = None, template_name: str | None = None, parameters: dict | None = None, schema: str | None = None, table_name: str | None = None, overwrite: bool | None = None, max_results: int = 100) QueryLog
class thanosql.resources._query.QueryLogService(query: QueryService)

Bases: thanosql._service.ThanoSQLService

Cannot exist without a parent QueryService

list(search: str | None = None, offset: int | None = None, limit: int | None = None) dict
class thanosql.resources._query.QueryTemplate

Bases: thanosql.resources._model.BaseModel

id: int | None
name: str
query: str
parameters: List[str] | None = []
created_at: datetime.datetime | None
updated_at: datetime.datetime | None
class thanosql.resources._query.QueryTemplateService(query: QueryService)

Bases: thanosql._service.ThanoSQLService

Cannot exist without a parent QueryService

list(search: str | None = None, offset: int | None = None, limit: int | None = None, order_by: str | None = None) List[QueryTemplate]
create(name: str | None = None, query: str | None = None, dry_run: bool | None = None) QueryTemplate
get(name: str) QueryTemplate
update(current_name: str, new_name: str | None = None, query: str | None = None) QueryTemplate
delete(name: str) dict