niklasrosenstein/python-baserow-client

Python client for Baserow.io

👋 Hi, I'm Niklas. I like Python, Kubernetes and Tooling.

python-baserow-client's Issues

Add support for deleting rows

Consider caching/session for ORM

Most ORMs require a "session" that keeps track of data during a sequence of operations on the ORM layer (e.g. querying, creating, updating or deleting rows). In ORMs for transactional databases, the session often also represents the transaction. Baserow is not transactional, but we could still benefit from caching within the same session when querying. This would be particularly important when using linked rows with back-referecning columns in Baserow which could infinitely load rows of table A and B when loading either once within the same session should be sufficient.

List table fields does not work if table contains formula fields

Thanks a lot for writing this python baserow client! This is very useful for us.

Currently when I attempt to list table fields:

for db in client.list_database_table_fields(580):
    print(db)     

I get an error:

  File ~/micromamba/envs/cads_data_exchange/lib/python3.10/site-packages/dat
 │  abind/json/converters.py:147, in <genexpr>(.0)
 │      143     def _length_check() -> None:
 │      144         pass
 │      146 values: t.Iterable[t.Any] = (
 │  --> 147     ctx.spawn(val, item_type, idx).convert()
 │      148     for idx, (val, item_type) in enumerate(zip(ctx.value, item_typ
 │  es_iterator))
 │      149 )
 │      151 if ctx.direction == Direction.SERIALIZE:
 │      152     if not isinstance(ctx.value, python_type):
 │
 │  File ~/micromamba/envs/cads_data_exchange/lib/python3.10/site-packages/dat
 │  abind/core/context.py:123, in Context.convert(self)
 │      120 def convert(self) -> t.Any:
 │      121     """Invoke the #convert_func with *self*."""
 │  --> 123     return self.convert_func(self)
 │
 │  File ~/micromamba/envs/cads_data_exchange/lib/python3.10/site-packages/dat
 │  abind/core/converter.py:84, in Module.convert(self, ctx)
 │       82 for converter in self.get_converters(ctx):
 │       83     try:
 │  ---> 84         return converter.convert(ctx)
 │       85     except NotImplementedError:
 │       86         pass
 │
 │  File ~/micromamba/envs/cads_data_exchange/lib/python3.10/site-packages/dat
 │  abind/json/converters.py:805, in UnionConverter.convert(self, ctx)
 │      803         raise ConversionError.expected(self, ctx, t.Mapping)
 │      804     member_name = self._get_deserialize_member_name(ctx, ctx.value
 │  , style, discriminator_key)
 │  --> 805     member_type = union.members.get_type_by_id(member_name)
 │      807 else:
 │      808     # Identify the member type based on the Python value type.
 │      809     member_name = union.members.get_type_id(type(ctx.value))
 │
 │  File ~/micromamba/envs/cads_data_exchange/lib/python3.10/site-packages/dat
 │  abind/core/union.py:104, in StaticUnionMembers.get_type_by_id(self, type_i
 │  d)
 │      102     member = self.members[type_id]
 │      103 except KeyError:
 │  --> 104     raise ValueError(f"{type_id!r} is not a type ID of {self}")
 │      106 if isinstance(member, types.FunctionType):
 │      107     member = self._eval_cache[type_id] = member()
 │
 │  ValueError: 'formula' is not a type ID of StaticUnionMembers(members={'tex
 │  t': <class 'baserow.field_types.TextTableField'>, 'long_text': <class 'bas
 │  erow.field_types.LongTextTableField'>, 'number': <class 'baserow.field_typ
 │  es.NumberTableField'>, 'single_select': <class 'baserow.field_types.Single
 │  SelectTableField'>, 'url': <class 'baserow.field_types.UrlTableField'>, 'l
 │  ink_row': <class 'baserow.field_types.LinkRowTableField'>, 'boolean': <cla
 │  ss 'baserow.field_types.BooleanTableField'>, 'file': <class 'baserow.field
 │  _types.FileTableField'>})

It seems like formula fields had not been implemented yet?

ORM support for single-select columns

• Reading single-select cells from Baserow gives back an object of the form {"id": 0, "name": "Option", "color": "#33aaff"}. The ORM should convert this into a Python type.
• When updating the value of a single-select from Python, the ID of the option needs to be specified. The ORM should allow a string value to be set instead and be able to translate that to the ID internally (the Baserow API expects the option ID when creating/updating rows).
  • This means we either need to track the available options in the database mapping or query it once the first time that information is needed (if it's possible to do that with a long lived token). If both is possible, maybe we should give people the option. (Frequently changing the available options would require frequent re-generating of the database mapping).

Add documentation in GH pages