Class MSSQLDocumentSaver (0.2.0)

MSSQLDocumentSaver(
    engine: langchain_google_cloud_sql_mssql.engine.MSSQLEngine,
    table_name: str,
    content_column: typing.Optional[str] = None,
    metadata_json_column: typing.Optional[str] = None,
)

A class for saving langchain documents into a Cloud SQL MSSQL database table.

Methods

MSSQLDocumentSaver

MSSQLDocumentSaver(
    engine: langchain_google_cloud_sql_mssql.engine.MSSQLEngine,
    table_name: str,
    content_column: typing.Optional[str] = None,
    metadata_json_column: typing.Optional[str] = None,
)

MSSQLDocumentSaver allows for saving of langchain documents in a database. If the table doesn't exists, a table with default schema will be created. The default schema:

  • page_content (type: text)
  • langchain_metadata (type: JSON)
Parameters
Name Description
engine MSSQLEngine

MSSQLEngine object to connect to the MSSQL database.

table_name str

The name of table for saving documents.

content_column str

The column to store document content. Deafult: page_content. Optional.

metadata_json_column str

The name of the JSON column to use as the metadata’s base dictionary. Default: langchain_metadata. Optional.

add_documents

add_documents(docs: typing.List[langchain_core.documents.base.Document]) -> None

Save documents in the DocumentSaver table. Document’s metadata is added to columns if found or stored in langchain_metadata JSON column.

Parameter
Name Description
docs List[langchain_core.documents.Document]

a list of documents to be saved.

delete

delete(docs: typing.List[langchain_core.documents.base.Document]) -> None

Delete all instances of a document from the DocumentSaver table by matching the entire Document object.

Parameter
Name Description
docs List[langchain_core.documents.Document]

a list of documents to be deleted.