Improved examples [skip ci]

ankane · ankane · commit 2ad0adf9d5a3 · 2025-01-13T02:48:05.000-08:00
diff --git a/examples/cohere/example.cpp b/examples/cohere/example.cpp
@@ -62,15 +62,15 @@ int main() {
     auto embeddings = fetch_embeddings(input, "search_document", api_key);
 
     for (size_t i = 0; i < input.size(); i++) {
-        tx.exec("INSERT INTO documents (content, embedding) VALUES ($1, $2)", {input[i], embeddings[i]});
+        tx.exec("INSERT INTO documents (content, embedding) VALUES ($1, $2)", pqxx::params{input[i], embeddings[i]});
     }
     tx.commit();
 
     std::string query = "forest";
     auto query_embedding = fetch_embeddings({query}, "search_query", api_key)[0];
     pqxx::result result = tx.exec("SELECT content FROM documents ORDER BY embedding <~> $1 LIMIT 5", pqxx::params{query_embedding});
-    for (auto const& row : result) {
-        std::cout << row[0].c_str() << std::endl;
+    for (const auto& row : result) {
+        std::cout << row[0].as<std::string>() << std::endl;
     }
 
     return 0;
diff --git a/examples/disco/example.cpp b/examples/disco/example.cpp
@@ -79,26 +79,26 @@ int main() {
 
     for (auto& user_id : recommender.user_ids()) {
         auto factors = pgvector::Vector(*recommender.user_factors(user_id));
-        tx.exec("INSERT INTO users (id, factors) VALUES ($1, $2)", {user_id, factors});
+        tx.exec("INSERT INTO users (id, factors) VALUES ($1, $2)", pqxx::params{user_id, factors});
     }
 
     for (auto& item_id : recommender.item_ids()) {
         auto factors = pgvector::Vector(*recommender.item_factors(item_id));
-        tx.exec("INSERT INTO movies (name, factors) VALUES ($1, $2)", {item_id, factors});
+        tx.exec("INSERT INTO movies (name, factors) VALUES ($1, $2)", pqxx::params{item_id, factors});
     }
 
     std::string movie = "Star Wars (1977)";
     std::cout << "Item-based recommendations for " << movie << std::endl;
     pqxx::result result = tx.exec("SELECT name FROM movies WHERE name != $1 ORDER BY factors <=> (SELECT factors FROM movies WHERE name = $1) LIMIT 5", pqxx::params{movie});
     for (auto const& row : result) {
-        std::cout << "- " << row[0].c_str() << std::endl;
+        std::cout << "- " << row[0].as<std::string>() << std::endl;
     }
 
     int user_id = 123;
     std::cout << std::endl << "User-based recommendations for " << user_id << std::endl;
-    result = tx.exec("SELECT name FROM movies ORDER BY factors <#> (SELECT factors FROM users WHERE id = $1) LIMIT 5", {user_id});
-    for (auto const& row : result) {
-        std::cout << "- " << row[0].c_str() << std::endl;
+    result = tx.exec("SELECT name FROM movies ORDER BY factors <#> (SELECT factors FROM users WHERE id = $1) LIMIT 5", pqxx::params{user_id});
+    for (const auto& row : result) {
+        std::cout << "- " << row[0].as<std::string>() << std::endl;
     }
 
     return 0;
diff --git a/examples/openai/example.cpp b/examples/openai/example.cpp
@@ -54,14 +54,14 @@ int main() {
     auto embeddings = fetch_embeddings(input, api_key);
 
     for (size_t i = 0; i < input.size(); i++) {
-        tx.exec("INSERT INTO documents (content, embedding) VALUES ($1, $2)", {input[i], pgvector::Vector(embeddings[i])});
+        tx.exec("INSERT INTO documents (content, embedding) VALUES ($1, $2)", pqxx::params{input[i], pgvector::Vector(embeddings[i])});
     }
     tx.commit();
 
     int document_id = 1;
-    pqxx::result result = tx.exec("SELECT content FROM documents WHERE id != $1 ORDER BY embedding <=> (SELECT embedding FROM documents WHERE id = $1) LIMIT 5", {document_id});
-    for (auto const& row : result) {
-        std::cout << row[0].c_str() << std::endl;
+    pqxx::result result = tx.exec("SELECT content FROM documents WHERE id != $1 ORDER BY embedding <=> (SELECT embedding FROM documents WHERE id = $1) LIMIT 5", pqxx::params{document_id});
+    for (const auto& row : result) {
+        std::cout << row[0].as<std::string>() << std::endl;
     }
 
     return 0;
