---

Praful Makani · sduskis · commit a247afadb356 · 2019-02-19T15:41:18.000-05:00
yaml --- r: 20575 b: refs/heads/autosynth-websecurityscanner c: 3bfe25e h: refs/heads/master i: 20573: 3d5befa 20571: df70906 20567: 913b4dd 20559: fafb720 20543: f200c22
diff --git a/[refs] b/[refs]
@@ -143,7 +143,7 @@ refs/heads/autosynth-speech: 75d6c62a9d07d3a3642980502a25d07fbde0f232
 refs/heads/autosynth-tasks: 5d6a4f686ffef2080506d3b613fc7563a8bba1cb
 refs/heads/autosynth-texttospeech: 2dcc5dc22be0f456caa1b6a8a4bcdace2641239c
 refs/heads/autosynth-trace: 8804c46bfe147702ee9c95669f17f42d3790cf23
-refs/heads/autosynth-websecurityscanner: 344fdac3aff9dad6052fec9ccde3085bb42e55b6
+refs/heads/autosynth-websecurityscanner: 3bfe25e44ed85a95c3a943647df23144223cd06e
 refs/heads/bigquerystorage: 06db74d123d7f8a3ef48755c2fcabed09faf8e64
 refs/heads/elharo-patch-1: ce159ef828d3c545991ff78e7b6e0d912a9453e9
 refs/heads/mrschmidt-numericadd: 96509abadf6190b7886d57fdd9b090da55f5171c
diff --git a/branches/autosynth-websecurityscanner/google-cloud-clients/google-cloud-bigquery/src/main/java/com/google/cloud/bigquery/QueryParameterValue.java b/branches/autosynth-websecurityscanner/google-cloud-clients/google-cloud-bigquery/src/main/java/com/google/cloud/bigquery/QueryParameterValue.java
@@ -25,6 +25,7 @@
 import java.io.Serializable;
 import java.math.BigDecimal;
 import java.util.ArrayList;
+import java.util.Date;
 import java.util.List;
 import javax.annotation.Nullable;
 import org.threeten.bp.Instant;
@@ -256,6 +257,8 @@ private static <T> StandardSQLTypeName classToType(Class<T> type) {
       return StandardSQLTypeName.FLOAT64;
     } else if (BigDecimal.class.isAssignableFrom(type)) {
       return StandardSQLTypeName.NUMERIC;
+    } else if (Date.class.isAssignableFrom(type)) {
+      return StandardSQLTypeName.DATE;
     }
     throw new IllegalArgumentException("Unsupported object type for QueryParameter: " + type);
   }
@@ -310,6 +313,9 @@ private static <T> String valueToStringOrNull(T value, StandardSQLTypeName type)
           // verify that the String is in the right format
           checkFormat(value, dateFormatter);
           return (String) value;
+        } else if (value instanceof Date) {
+          com.google.cloud.Date date = com.google.cloud.Date.fromJavaUtilDate((Date) value);
+          return date.toString();
         }
         break;
       case TIME:
diff --git a/branches/autosynth-websecurityscanner/google-cloud-clients/google-cloud-bigquery/src/test/java/com/google/cloud/bigquery/QueryParameterValueTest.java b/branches/autosynth-websecurityscanner/google-cloud-clients/google-cloud-bigquery/src/test/java/com/google/cloud/bigquery/QueryParameterValueTest.java
@@ -20,6 +20,8 @@
 
 import com.google.api.services.bigquery.model.QueryParameterType;
 import java.math.BigDecimal;
+import java.text.ParseException;
+import java.util.Date;
 import java.util.List;
 import org.junit.Test;
 
@@ -204,6 +206,17 @@ public void testDate() {
     assertThat(value.getArrayValues()).isNull();
   }
 
+  @Test
+  public void testStandardDate() throws ParseException {
+    com.google.cloud.Date gcDate = com.google.cloud.Date.parseDate("2016-09-18");
+    Date date = com.google.cloud.Date.toJavaUtilDate(gcDate);
+    QueryParameterValue value = QueryParameterValue.of(date, Date.class);
+    assertThat(value.getValue()).isEqualTo("2016-09-18");
+    assertThat(value.getType()).isEqualTo(StandardSQLTypeName.DATE);
+    assertThat(value.getArrayType()).isNull();
+    assertThat(value.getArrayValues()).isNull();
+  }
+
   @Test(expected = IllegalArgumentException.class)
   public void testInvalidDate() {
     // not supposed to have the time
