from langchain_google_cloud_sql_mysql import  MySQLEngine, MySQLVectorStore

# create connection pool engine
engine = MySQLEngine.from_instance("my-project-id", "us-central1", "my-instance", "my-database")

# initialize vector store table
engine.init_vectorstore_table(table_name="vector_store", vector_size=768)

# base constructor
vector_store = MySQLVectorStore(
    engine,
    embedding_service=embeddings_service,
    table_name="vector_store",
)

# create VectorStore from LangChain Documents
vector_store = MySQLVectorStore.from_documents(
    docs,
    embedding=embeddings_service,
    engine=engine,
    table_name="vector_store",
    ids=ids,
)

# create VectorStore from texts
vector_store = MySQLVectorStore.from_texts(
    texts,
    embedding=embeddings_service,
    engine=engine,
    table_name="vector_store",
    metadatas=metadatas,
    ids=ids,
)