@@ -0,0 +1,1990 @@
+/*%0A * Licensed under the Apache License, Version 2.0 (the %22License%22);%0A * you may not use this file except in compliance with the License.%0A * You may obtain a copy of the License at%0A *%0A * http://www.apache.org/licenses/LICENSE-2.0%0A *%0A * Unless required by applicable law or agreed to in writing, software%0A * distributed under the License is distributed on an %22AS IS%22 BASIS,%0A * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.%0A * See the License for the specific language governing permissions and%0A * limitations under the License.%0A */%0Apackage org.jdbi.v3.sqlite3;%0A%0Aimport org.assertj.core.api.Assertions;%0Aimport org.jdbi.v3.core.Handle;%0Aimport org.jdbi.v3.core.HandleConsumer;%0Aimport org.jdbi.v3.core.Jdbi;%0Aimport org.jdbi.v3.sqlite3.SQLitePlugin;%0Aimport org.junit.After;%0Aimport org.junit.Before;%0Aimport org.junit.Test;%0A%0Aimport java.net.MalformedURLException;%0Aimport java.net.URI;%0Aimport java.net.URL;%0A%0Apublic class TestUrls %7B%0A%0A    Handle handle;%0A%0A    @Before%0A    public void setUp() throws Exception %7B%0A        Jdbi jdbi = Jdbi.create(%22jdbc:sqlite::memory:%22);%0A        jdbi.installPlugin(new SQLitePlugin());%0A        handle = jdbi.open();%0A        handle.useTransaction(handle -%3E %7B%0A            handle.execute(%22DROP TABLE IF EXISTS foo%22);%0A            handle.execute(%22CREATE TABLE foo(url TEXT);%22);%0A        %7D);%0A    %7D%0A%0A    @After%0A    public void tearDown() throws Exception %7B%0A        handle.close();%0A    %7D%0A%0A    @Test%0A    public void testInsertUrlSuccessful() %7B%0A        String goolgeString = %22http://www.google.com%22;%0A        URL googleUrl = null;%0A        try %7B%0A            googleUrl = URI.create(goolgeString).toURL();%0A        %7D catch (MalformedURLException e) %7B%0A            e.printStackTrace();%0A        %7D%0A%0A        handle.createUpdate(%22INSERT INTO foo VALUES (:url)%22)%0A                .bind(%22url%22, googleUrl)%0A                .execute();%0A%0A        Assertions.assertThat(handle.createQuery(%22SELECT * FROM foo%22).mapTo(String.class).findOnly()).isEqualTo(goolgeString);%0A    %7D%0A%0A%7D%0A

Add test for urls