0.16.0 (latest) 0.15.0 0.14.1 0.13.0 0.12.1 0.11.1 0.10.0 0.9.0 0.8.0 0.7.0 0.6.1 0.5.0 0.4.1

    PostgresEngine(
        key: object,
        pool: sqlalchemy.ext.asyncio.engine.AsyncEngine,
        loop: typing.Optional[asyncio.events.AbstractEventLoop],
        thread: typing.Optional[threading.Thread],
    )

A class for managing connections to a Cloud SQL for Postgres database.

## Methods

### PostgresEngine

    PostgresEngine(
        key: object,
        pool: sqlalchemy.ext.asyncio.engine.AsyncEngine,
        loop: typing.Optional[asyncio.events.AbstractEventLoop],
        thread: typing.Optional[threading.Thread],
    )

PGEngine constructor.

| **Parameters** ||
|---|---|
| **Name** | **Description** |
| `key` | `object` Prevent direct constructor usage. |
| `pool` | `AsyncEngine` Async engine connection pool. |
| `loop` | `Optional[asyncio.AbstractEventLoop]` Async event loop used to create the engine. |
| `thread` | `Optional[Thread]` Thread used to create the engine async. |

| **Exceptions** ||
|---|---|
| **Type** | **Description** |
| `Exception` | If the constructor is called directly by the user. |

### _ainit_chat_history_table

    _ainit_chat_history_table(table_name: str, schema_name: str = "public") -> None

Create a Cloud SQL table to store chat history.

| **Parameters** ||
|---|---|
| **Name** | **Description** |
| `table_name` | `str` Table name to store chat history. |
| `schema_name` | `str` Schema name to store chat history table. Default: "public". |

### _ainit_checkpoint_table

    _ainit_checkpoint_table(
        table_name: str = "checkpoints", schema_name: str = "public"
    ) -> None

Create PgSQL tables to save checkpoints.

| **Parameters** ||
|---|---|
| **Name** | **Description** |
| `schema_name` | `str` The schema name to store the checkpoint tables. Default: "public". |
| `table_name` | `str` The PgSQL database table name. Default: "checkpoints". |

### _aload_table_schema

    _aload_table_schema(
        table_name: str, schema_name: str = "public"
    ) -> sqlalchemy.sql.schema.Table

Load table schema from existing table in PgSQL database.

| **Returns** ||
|---|---|
| **Type** | **Description** |
| `(sqlalchemy.Table)` | The loaded table. |

### _create

    _create(
        project_id: str,
        region: str,
        instance: str,
        database: str,
        ip_type: typing.Union[str, google.cloud.sql.connector.enums.IPTypes],
        user: typing.Optional[str] = None,
        password: typing.Optional[str] = None,
        loop: typing.Optional[asyncio.events.AbstractEventLoop] = None,
        thread: typing.Optional[threading.Thread] = None,
        quota_project: typing.Optional[str] = None,
        iam_account_email: typing.Optional[str] = None,
        engine_args: typing.Mapping = {},
    ) -> langchain_google_cloud_sql_pg.engine.PostgresEngine

Create a PostgresEngine instance.

| **Parameters** ||
|---|---|
| **Name** | **Description** |
| `project_id` | `str` GCP project ID. |
| `region` | `str` Postgres instance region. |
| `instance` | `str` Postgres instance name. |
| `database` | `str` Database name. |
| `ip_type` | `Union[str, IPTypes]` IP address type. Defaults to IPTypes.PUBLIC. |
| `user` | `Optional[str]` Postgres user name. Defaults to None. |
| `password` | `Optional[str]` Postgres user password. Defaults to None. |
| `loop` | `Optional[asyncio.AbstractEventLoop]` Async event loop used to create the engine. |
| `thread` | `Optional[Thread]` Thread used to create the engine async. |
| `quota_project` | `Optional[str]` Project that provides quota for API calls. |
| `iam_account_email` | `Optional[str]` IAM service account email. Defaults to None. |
| `engine_args` | `Mapping` Additional arguments that are passed directly to `sqlalchemy.ext.asyncio.mymodule.MyClass.create_async_engine`. This can be used to specify additional parameters to the underlying pool during it's creation. |

| **Exceptions** ||
|---|---|
| **Type** | **Description** |
| `ValueError` | If only one of `user` and `password` is specified. |

### afrom_instance

    afrom_instance(
        project_id: str,
        region: str,
        instance: str,
        database: str,
        user: typing.Optional[str] = None,
        password: typing.Optional[str] = None,
        ip_type: typing.Union[
            str, google.cloud.sql.connector.enums.IPTypes
        ] = IPTypes.PUBLIC,
        quota_project: typing.Optional[str] = None,
        iam_account_email: typing.Optional[str] = None,
        engine_args: typing.Mapping = {},
    ) -> langchain_google_cloud_sql_pg.engine.PostgresEngine

Create a PostgresEngine from a Postgres instance.

| **Parameters** ||
|---|---|
| **Name** | **Description** |
| `project_id` | `str` GCP project ID. |
| `region` | `str` Postgres instance region. |
| `instance` | `str` Postgres instance name. |
| `database` | `str` Database name. |
| `user` | `Optional[str], optional` Postgres user name. Defaults to None. |
| `password` | `Optional[str], optional` Postgres user password. Defaults to None. |
| `ip_type` | `Union[str, IPTypes], optional` IP address type. Defaults to IPTypes.PUBLIC. |
| `quota_project` | `Optional[str]` Project that provides quota for API calls. |
| `iam_account_email` | `Optional[str], optional` IAM service account email. Defaults to None. |
| `engine_args` | `Mapping` Additional arguments that are passed directly to `sqlalchemy.ext.asyncio.mymodule.MyClass.create_async_engine`. This can be used to specify additional parameters to the underlying pool during it's creation. |

| **Returns** ||
|---|---|
| **Type** | **Description** |
| `PostgresEngine` | A newly created PostgresEngine instance. |

### ainit_chat_history_table

    ainit_chat_history_table(table_name: str, schema_name: str = "public") -> None

Create a Cloud SQL table to store chat history.

| **Parameter** ||
|---|---|
| **Name** | **Description** |
| `table_name` | `str` Table name to store chat history. |

### ainit_checkpoint_table

    ainit_checkpoint_table(
        table_name: str = "checkpoints", schema_name: str = "public"
    ) -> None

Create an PgSQL table to save checkpoint messages.

| **Parameters** ||
|---|---|
| **Name** | **Description** |
| `schema_name` | `str` The schema name to store checkpoint tables. Default: "public". |
| `table_name` | `str` The PgSQL database table name. Default: "checkpoints". |

### ainit_document_table

    ainit_document_table(
        table_name: str,
        schema_name: str = "public",
        content_column: str = "page_content",
        metadata_columns: list[langchain_postgres.v2.engine.Column] = [],
        metadata_json_column: str = "langchain_metadata",
        store_metadata: bool = True,
    ) -> None

Create a table for saving of langchain documents.

| **Parameters** ||
|---|---|
| **Name** | **Description** |
| `table_name` | `str` The PgSQL database table name. |
| `schema_name` | `str` The schema name to store PgSQL database table. Default: "public". |
| `content_column` | `str` Name of the column to store document content. Default: "page_content". |
| `metadata_columns` | `list[sqlalchemy.Column]` A list of SQLAlchemy Columns to create for custom metadata. Optional. |
| `metadata_json_column` | `str` The column to store extra metadata in JSON format. Default: "langchain_metadata". Optional. |
| `store_metadata` | `bool` Whether to store extra metadata in a metadata column if not described in 'metadata' field list (Default: True). |

| **Exceptions** ||
|---|---|
| **Type** | **Description** |
| `DuplicateTableErro` |   |

### from_connection_string

    from_connection_string(
        url: str | sqlalchemy.engine.url.URL, **kwargs: typing.Any
    ) -> langchain_google_cloud_sql_pg.engine.PostgresEngine

Create an PostgresEngine instance from arguments. These parameters are pass directly into sqlalchemy's create_async_engine function.

| **Parameters** ||
|---|---|
| **Name** | **Description** |
| `url` | `Union[str URL]` the URL used to connect to a database |
| `\*\*kwargs` | `Any, optional` sqlalchemy `create_async_engine` arguments |

| **Exceptions** ||
|---|---|
| **Type** | **Description** |
| `ValueError` | If `postgresql+asyncpg` is not specified as the PG driver |

### from_engine_args

    from_engine_args(
        url: str | sqlalchemy.engine.url.URL, **kwargs: typing.Any
    ) -> langchain_google_cloud_sql_pg.engine.PostgresEngine

Create an PostgresEngine instance from arguments. These parameters are pass directly into sqlalchemy's create_async_engine function.

| **Parameters** ||
|---|---|
| **Name** | **Description** |
| `url` | `Union[str URL]` the URL used to connect to a database |
| `\*\*kwargs` | `Any, optional` sqlalchemy `create_async_engine` arguments |

| **Exceptions** ||
|---|---|
| **Type** | **Description** |
| `ValueError` | If `postgresql+asyncpg` is not specified as the PG driver |

### from_instance

    from_instance(
        project_id: str,
        region: str,
        instance: str,
        database: str,
        user: typing.Optional[str] = None,
        password: typing.Optional[str] = None,
        ip_type: typing.Union[
            str, google.cloud.sql.connector.enums.IPTypes
        ] = IPTypes.PUBLIC,
        quota_project: typing.Optional[str] = None,
        iam_account_email: typing.Optional[str] = None,
        engine_args: typing.Mapping = {},
    ) -> langchain_google_cloud_sql_pg.engine.PostgresEngine

Create a PostgresEngine from a Postgres instance.

| **Parameters** ||
|---|---|
| **Name** | **Description** |
| `project_id` | `str` GCP project ID. |
| `region` | `str` Postgres instance region. |
| `instance` | `str` Postgres instance name. |
| `database` | `str` Database name. |
| `user` | `Optional[str], optional` Postgres user name. Defaults to None. |
| `password` | `Optional[str], optional` Postgres user password. Defaults to None. |
| `ip_type` | `Union[str, IPTypes], optional` IP address type. Defaults to IPTypes.PUBLIC. |
| `quota_project` | `Optional[str]` Project that provides quota for API calls. |
| `iam_account_email` | `Optional[str], optional` IAM service account email. Defaults to None. |
| `engine_args` | `Mapping` Additional arguments that are passed directly to `sqlalchemy.ext.asyncio.mymodule.MyClass.create_async_engine`. This can be used to specify additional parameters to the underlying pool during it's creation. |

| **Returns** ||
|---|---|
| **Type** | **Description** |
| `PostgresEngine` | A newly created PostgresEngine instance. |

### init_chat_history_table

    init_chat_history_table(table_name: str, schema_name: str = "public") -> None

Create a Cloud SQL table to store chat history.

| **Parameters** ||
|---|---|
| **Name** | **Description** |
| `table_name` | `str` Table name to store chat history. |
| `schema_name` | `str` Schema name to store chat history table. Default: "public". |

### init_checkpoint_table

    init_checkpoint_table(
        table_name: str = "checkpoints", schema_name: str = "public"
    ) -> None

Create Cloud SQL tables to store checkpoints.

| **Parameters** ||
|---|---|
| **Name** | **Description** |
| `schema_name` | `str` The schema name to store checkpoint tables. Default: "public". |
| `table_name` | `str` The PgSQL database table name. Default: "checkpoints". |

### init_document_table

    init_document_table(
        table_name: str,
        schema_name: str = "public",
        content_column: str = "page_content",
        metadata_columns: list[langchain_postgres.v2.engine.Column] = [],
        metadata_json_column: str = "langchain_metadata",
        store_metadata: bool = True,
    ) -> None

Create a table for saving of langchain documents.

| **Parameters** ||
|---|---|
| **Name** | **Description** |
| `table_name` | `str` The PgSQL database table name. |
| `schema_name` | `str` The schema name to store PgSQL database table. Default: "public". |
| `content_column` | `str` Name of the column to store document content. Default: "page_content". |
| `metadata_columns` | `list[sqlalchemy.Column]` A list of SQLAlchemy Columns to create for custom metadata. Optional. |
| `metadata_json_column` | `str` The column to store extra metadata in JSON format. Default: "langchain_metadata". Optional. |
| `store_metadata` | `bool` Whether to store extra metadata in a metadata column if not described in 'metadata' field list (Default: True). |

| **Exceptions** ||
|---|---|
| **Type** | **Description** |
| `DuplicateTableErro` |   |