# {py:mod}`nexusLIMS.tui.common.db_utils`

```{py:module} nexusLIMS.tui.common.db_utils
```

```{autodoc2-docstring} nexusLIMS.tui.common.db_utils
:parser: autodoc2_docstrings_parser
:allowtitles:
```

## Module Contents

### Functions

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

* - {py:obj}`check_uniqueness <nexusLIMS.tui.common.db_utils.check_uniqueness>`
  - ```{autodoc2-docstring} nexusLIMS.tui.common.db_utils.check_uniqueness
    :parser: autodoc2_docstrings_parser
    :summary:
    ```
* - {py:obj}`get_session_log_count <nexusLIMS.tui.common.db_utils.get_session_log_count>`
  - ```{autodoc2-docstring} nexusLIMS.tui.common.db_utils.get_session_log_count
    :parser: autodoc2_docstrings_parser
    :summary:
    ```
* - {py:obj}`find_conflicting_instrument <nexusLIMS.tui.common.db_utils.find_conflicting_instrument>`
  - ```{autodoc2-docstring} nexusLIMS.tui.common.db_utils.find_conflicting_instrument
    :parser: autodoc2_docstrings_parser
    :summary:
    ```
````

### API

````{py:function} check_uniqueness(session: sqlmodel.Session, model: type, field_name: str, value: typing.Any, exclude_pk: typing.Any | None = None) -> bool
:canonical: nexusLIMS.tui.common.db_utils.check_uniqueness

```{autodoc2-docstring} nexusLIMS.tui.common.db_utils.check_uniqueness
:parser: autodoc2_docstrings_parser
```
````

````{py:function} get_session_log_count(session: sqlmodel.Session, instrument_pid: str) -> int
:canonical: nexusLIMS.tui.common.db_utils.get_session_log_count

```{autodoc2-docstring} nexusLIMS.tui.common.db_utils.get_session_log_count
:parser: autodoc2_docstrings_parser
```
````

````{py:function} find_conflicting_instrument(session: sqlmodel.Session, field_name: str, value: typing.Any, exclude_pid: str | None = None) -> nexusLIMS.db.models.Instrument | None
:canonical: nexusLIMS.tui.common.db_utils.find_conflicting_instrument

```{autodoc2-docstring} nexusLIMS.tui.common.db_utils.find_conflicting_instrument
:parser: autodoc2_docstrings_parser
```
````