callum-ryan commented on code in PR #534:
URL: https://github.com/apache/iceberg-rust/pull/534#discussion_r1714153827


##########
crates/catalog/sql/src/catalog.rs:
##########
@@ -141,21 +142,24 @@ impl SqlCatalog {
     }
 
     /// SQLX Any does not implement PostgresSQL bindings, so we have to do 
this.
-    pub async fn execute_statement(
-        &self,
-        query: &String,
-        args: Vec<Option<&String>>,
-    ) -> Result<Vec<AnyRow>> {
-        let query_with_placeholders: Cow<str> =
-            if self.sql_bind_style == SqlBindStyle::DollarNumeric {
-                let mut query = query.clone();
-                for i in 0..args.len() {
-                    query = query.replacen("?", &format!("${}", i + 1), 1);
+    pub fn build_query(&self, query: &str) -> String {
+        match self.sql_bind_style {
+            SqlBindStyle::DollarNumeric => {
+                let mut query = query.to_owned();
+                let mut i = 1;
+                while let Some(pos) = query.find('?') {

Review Comment:
   thanks! I have implemented it as a fold()



##########
crates/catalog/sql/src/catalog.rs:
##########
@@ -141,21 +142,24 @@ impl SqlCatalog {
     }
 
     /// SQLX Any does not implement PostgresSQL bindings, so we have to do 
this.
-    pub async fn execute_statement(
-        &self,
-        query: &String,
-        args: Vec<Option<&String>>,
-    ) -> Result<Vec<AnyRow>> {
-        let query_with_placeholders: Cow<str> =
-            if self.sql_bind_style == SqlBindStyle::DollarNumeric {
-                let mut query = query.clone();
-                for i in 0..args.len() {
-                    query = query.replacen("?", &format!("${}", i + 1), 1);
+    pub fn build_query(&self, query: &str) -> String {
+        match self.sql_bind_style {
+            SqlBindStyle::DollarNumeric => {
+                let mut query = query.to_owned();
+                let mut i = 1;
+                while let Some(pos) = query.find('?') {
+                    query.replace_range(pos..pos + 1, &format!("${}", i));
+                    i += 1;
                 }
-                Cow::Owned(query)
-            } else {
-                Cow::Borrowed(query)
-            };
+                query
+            }
+            _ => query.to_owned(),
+        }
+    }
+
+    /// Fetch a vec of AnyRows from a given query
+    pub async fn fetch_rows(&self, query: &str, args: Vec<Option<&String>>) -> 
Result<Vec<AnyRow>> {

Review Comment:
   fixed in a few places



-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: issues-unsubscr...@iceberg.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@iceberg.apache.org
For additional commands, e-mail: issues-h...@iceberg.apache.org

Reply via email to