# {py:mod}`ovo.core.database.db_proxy`

```{py:module} ovo.core.database.db_proxy
```

```{autodoc2-docstring} ovo.core.database.db_proxy
:allowtitles:
```

## Module Contents

### Classes

````{list-table}
:class: autosummary longtable
:align: left

* - {py:obj}`DBProxy <ovo.core.database.db_proxy.DBProxy>`
  - ```{autodoc2-docstring} ovo.core.database.db_proxy.DBProxy
    :summary:
    ```
````

### API

`````{py:class} DBProxy
:canonical: ovo.core.database.db_proxy.DBProxy

Bases: {py:obj}`sqlalchemy.orm.decl_api.DCTransformDeclarative`

```{autodoc2-docstring} ovo.core.database.db_proxy.DBProxy
```

````{py:method} _db()
:canonical: ovo.core.database.db_proxy.DBProxy._db

```{autodoc2-docstring} ovo.core.database.db_proxy.DBProxy._db
```

````

````{py:method} remove(*id_args, **kwargs)
:canonical: ovo.core.database.db_proxy.DBProxy.remove

```{autodoc2-docstring} ovo.core.database.db_proxy.DBProxy.remove
```

````

````{py:method} save_value(column: str, value, **kwargs)
:canonical: ovo.core.database.db_proxy.DBProxy.save_value

```{autodoc2-docstring} ovo.core.database.db_proxy.DBProxy.save_value
```

````

````{py:method} select(limit: int = None, order_by=None, **kwargs) -> typing.Sequence[typing.Self]
:canonical: ovo.core.database.db_proxy.DBProxy.select

```{autodoc2-docstring} ovo.core.database.db_proxy.DBProxy.select
```

````

````{py:method} count(**kwargs) -> int
:canonical: ovo.core.database.db_proxy.DBProxy.count

```{autodoc2-docstring} ovo.core.database.db_proxy.DBProxy.count
```

````

````{py:method} count_distinct(field='id', group_by=None, **kwargs) -> int | dict[typing.Any, int]
:canonical: ovo.core.database.db_proxy.DBProxy.count_distinct

```{autodoc2-docstring} ovo.core.database.db_proxy.DBProxy.count_distinct
```

````

````{py:method} get(*id_args, **kwargs) -> typing.Self
:canonical: ovo.core.database.db_proxy.DBProxy.get

```{autodoc2-docstring} ovo.core.database.db_proxy.DBProxy.get
```

````

````{py:method} get_value(column: str, *id_args, raw=False, **kwargs)
:canonical: ovo.core.database.db_proxy.DBProxy.get_value

```{autodoc2-docstring} ovo.core.database.db_proxy.DBProxy.get_value
```

````

````{py:method} select_values(column: str, order_by=None, **kwargs) -> list
:canonical: ovo.core.database.db_proxy.DBProxy.select_values

```{autodoc2-docstring} ovo.core.database.db_proxy.DBProxy.select_values
```

````

````{py:method} select_dict(key_column: str, value_column: str, order_by=None, **kwargs) -> dict
:canonical: ovo.core.database.db_proxy.DBProxy.select_dict

```{autodoc2-docstring} ovo.core.database.db_proxy.DBProxy.select_dict
```

````

````{py:method} select_unique_values(column: str, **kwargs) -> set
:canonical: ovo.core.database.db_proxy.DBProxy.select_unique_values

```{autodoc2-docstring} ovo.core.database.db_proxy.DBProxy.select_unique_values
```

````

````{py:method} select_dataframe(index_col: str = 'id', order_by=None, limit=None, **kwargs) -> pandas.DataFrame
:canonical: ovo.core.database.db_proxy.DBProxy.select_dataframe

```{autodoc2-docstring} ovo.core.database.db_proxy.DBProxy.select_dataframe
```

````

`````