Last active
October 1, 2024 18:58
-
-
Save rodydavis/e80a5919ca531793ddbf86fecf8538e3 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
package plugins | |
import ( | |
"context" | |
"encoding/json" | |
"fmt" | |
"os" | |
"strconv" | |
sqlite_vec "github.com/asg017/sqlite-vec-go-bindings/cgo" | |
"github.com/google/generative-ai-go/genai" | |
"github.com/labstack/echo/v5" | |
"github.com/pocketbase/dbx" | |
"github.com/pocketbase/pocketbase" | |
"github.com/pocketbase/pocketbase/apis" | |
"github.com/pocketbase/pocketbase/core" | |
"github.com/pocketbase/pocketbase/models" | |
"github.com/pocketbase/pocketbase/models/schema" | |
"github.com/pocketbase/pocketbase/tools/types" | |
"google.golang.org/api/option" | |
) | |
func VectorStore(app *pocketbase.PocketBase, collections ...string) error { | |
sqlite_vec.Auto() | |
client, err := createGoogleAiClient() | |
if err != nil { | |
return err | |
} | |
app.OnAfterBootstrap().Add(func(e *core.BootstrapEvent) error { | |
for _, target := range collections { | |
collection, _ := app.Dao().FindCollectionByNameOrId(target) | |
if collection == nil { | |
err := createVectorCollection(app, target) | |
if err != nil { | |
return err | |
} | |
} | |
} | |
return nil | |
}) | |
app.OnModelAfterCreate().Add(func(e *core.ModelEvent) error { | |
tbl := e.Model.TableName() | |
for _, target := range collections { | |
if tbl == target { | |
err := modelModify(app, target, client, e) | |
if err != nil { | |
return err | |
} | |
} | |
} | |
return nil | |
}) | |
app.OnModelAfterUpdate().Add(func(e *core.ModelEvent) error { | |
tbl := e.Model.TableName() | |
for _, target := range collections { | |
if tbl == target { | |
err := modelModify(app, target, client, e) | |
if err != nil { | |
return err | |
} | |
} | |
} | |
return nil | |
}) | |
app.OnModelAfterDelete().Add(func(e *core.ModelEvent) error { | |
tbl := e.Model.TableName() | |
for _, target := range collections { | |
if tbl == target { | |
err := modelDelete(app, target, e) | |
if err != nil { | |
return err | |
} | |
} | |
} | |
return nil | |
}) | |
app.OnBeforeServe().Add(func(e *core.ServeEvent) error { | |
group := e.Router.Group("/api/collections/:collectionIdOrName/records", apis.ActivityLogger(app)) | |
group.GET("/vector-search", func(c echo.Context) error { | |
target := c.PathParam("collectionIdOrName") | |
if _, err := app.Dao().FindCollectionByNameOrId(target); err != nil { | |
app.Logger().Error(fmt.Sprint(err)) | |
return err | |
} | |
title := c.QueryParam("title") | |
content := c.QueryParam("content") | |
k := c.QueryParam("k") | |
kNum := 5 | |
if k != "" { | |
val, err := strconv.Atoi(k) | |
if err == nil { | |
kNum = val | |
} | |
} | |
if content == "" { | |
return c.NoContent(204) | |
} | |
vector, err := googleAiEmbedContent(client, genai.TaskTypeRetrievalQuery, title, genai.Text(content)) | |
if err != nil { | |
return err | |
} | |
jsonVec, err := json.Marshal(vector) | |
if err != nil { | |
return err | |
} | |
stmt := "SELECT v.id, distance, v.content, v.created, v.updated " | |
stmt += "FROM " + target + "_embeddings " | |
stmt += "LEFT JOIN " + target + " v ON v.vector_id = " + target + "_embeddings.id " | |
stmt += "WHERE embedding MATCH {:embedding} " | |
stmt += "AND k = {:k};" | |
results := []dbx.NullStringMap{} | |
err = app.Dao().DB(). | |
NewQuery(stmt). | |
Bind(dbx.Params{ | |
"embedding": string(jsonVec), | |
"k": kNum, | |
}). | |
All(&results) | |
if err != nil { | |
app.Logger().Error(fmt.Sprint(err)) | |
return err | |
} | |
app.Logger().Info(fmt.Sprint(results)) | |
c.Response().Header().Set(echo.HeaderContentType, "application/json") | |
items := []map[string]any{} | |
for _, result := range results { | |
m := make(map[string]interface{}) | |
for key := range result { | |
val := result[key] | |
value, err := val.Value() | |
if err != nil || !val.Valid { | |
m[key] = nil | |
} else { | |
m[key] = value | |
} | |
} | |
items = append(items, m) | |
} | |
// TODO: Paging result | |
return c.JSON(200, items) | |
}) | |
return nil | |
}) | |
return nil | |
} | |
func modelDelete(app *pocketbase.PocketBase, target string, e *core.ModelEvent) error { | |
_, err := e.Dao.FindRecordById(e.Model.TableName(), e.Model.GetId()) | |
if err != nil { | |
return err | |
} | |
deleteEmbeddingsForRecord(app, target, e) | |
return nil | |
} | |
func modelModify(app *pocketbase.PocketBase, target string, client *genai.Client, e *core.ModelEvent) error { | |
record, err := e.Dao.FindRecordById(e.Model.TableName(), e.Model.GetId()) | |
if err != nil { | |
return err | |
} | |
title := record.GetString("title") | |
content := record.GetString("content") | |
result, err := googleAiEmbedContent(client, genai.TaskTypeRetrievalDocument, title, genai.Text(content)) | |
if err != nil { | |
return err | |
} | |
vector := "" | |
jsonVec, err := json.Marshal(result) | |
if err != nil { | |
vector = "[]" | |
} else { | |
vector = string(jsonVec) | |
} | |
deleteEmbeddingsForRecord(app, target, e) | |
{ | |
stmt := "INSERT INTO " + target + "_embeddings (embedding) " | |
stmt += "VALUES ({:embedding});" | |
res, err := app.DB().NewQuery(stmt).Bind(dbx.Params{ | |
"embedding": vector, | |
}).Execute() | |
if err != nil { | |
return nil | |
} | |
vectorId, err := res.LastInsertId() | |
if err != nil { | |
return err | |
} | |
record.Set("vector_id", vectorId) | |
} | |
if err := app.Dao().WithoutHooks().SaveRecord(record); err != nil { | |
return err | |
} | |
return nil | |
} | |
func deleteEmbeddingsForRecord(app *pocketbase.PocketBase, target string, e *core.ModelEvent) error { | |
record, err := e.Dao.FindRecordById(e.Model.TableName(), e.Model.GetId()) | |
if err != nil { | |
return err | |
} | |
type Meta struct { | |
Id string `db:"id" json:"id"` | |
} | |
vectorId := record.GetInt("vector_id") | |
items := []*Meta{} | |
stmt := "SELECT id FROM " + target + "_embeddings " | |
stmt += "WHERE id = {:id};" | |
err = app.DB().NewQuery(stmt).Bind(dbx.Params{ | |
"id": vectorId, | |
}).All(&items) | |
if err != nil { | |
return nil | |
} | |
stmt = "DELETE FROM " + target + "_embeddings " | |
stmt += "WHERE id = {:id}" | |
for _, item := range items { | |
_, err = app.DB().NewQuery(stmt).Bind(dbx.Params{ | |
"id": item.Id, | |
}).Execute() | |
if err != nil { | |
return nil | |
} | |
} | |
return nil | |
} | |
func createVectorCollection(app *pocketbase.PocketBase, target string, extraFields ...*schema.SchemaField) error { | |
fields := []*schema.SchemaField{ | |
{ | |
Name: "title", | |
Type: schema.FieldTypeText, | |
}, | |
{ | |
Name: "content", | |
Required: true, | |
Type: schema.FieldTypeText, | |
}, | |
{ | |
Name: "vector_id", | |
Type: schema.FieldTypeNumber, | |
}, | |
} | |
fields = append(fields, extraFields...) | |
collection := &models.Collection{ | |
Name: target, | |
Type: models.CollectionTypeBase, | |
Schema: schema.NewSchema(fields...), | |
Indexes: types.JsonArray[string]{ | |
"CREATE UNIQUE INDEX idx_" + target + " ON " + target + " (title, content, vector_id);", | |
}, | |
} | |
if err := app.Dao().SaveCollection(collection); err != nil { | |
return err | |
} | |
stmt := "CREATE VIRTUAL TABLE IF NOT EXISTS " + target + "_embeddings using vec0( " | |
stmt += " id INTEGER PRIMARY KEY AUTOINCREMENT, " | |
stmt += " embedding float[768] " | |
stmt += ");" | |
_, err := app.DB().NewQuery(stmt).Execute() | |
if err != nil { | |
return nil | |
} | |
return nil | |
} | |
func createGoogleAiClient() (*genai.Client, error) { | |
var apiKey string = os.Getenv("GOOGLE_AI_API_KEY") | |
ctx := context.Background() | |
client, err := genai.NewClient(ctx, option.WithAPIKey(apiKey)) | |
if err != nil { | |
return nil, err | |
} | |
return client, nil | |
} | |
func googleAiEmbedContent(client *genai.Client, taskType genai.TaskType, title string, parts ...genai.Part) ([]float32, error) { | |
ctx := context.Background() | |
model := googleAiEmbeddingModel(client) | |
model.TaskType = taskType | |
res, err := model.EmbedContentWithTitle(ctx, title, parts...) | |
if err != nil { | |
return nil, err | |
} | |
return res.Embedding.Values, nil | |
} | |
func googleAiEmbeddingModel(client *genai.Client) *genai.EmbeddingModel { | |
em := client.EmbeddingModel("text-embedding-004") | |
return em | |
} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Usage: