/*
 * Copyright 2016 LINE Corporation
 *
 * LINE Corporation licenses this file to you under the Apache License,
 * version 2.0 (the "License"); you may not use this file except in compliance
 * with the License. You may obtain a copy of the License at:
 *
 *   http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS, WITHOUT
 * WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the
 * License for the specific language governing permissions and limitations
 * under the License.
 */

package com.example.bot.spring;

import java.io.IOException;
import java.nio.file.Files;
import java.nio.file.Path;
import javax.annotation.PostConstruct;
import javax.sql.DataSource;
import java.sql.*;

import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.context.annotation.AnnotationConfigApplicationContext;
import org.springframework.stereotype.Component;
import org.springframework.web.bind.annotation.RequestMapping;

@SpringBootApplication
public class KitchenSinkApplication {
    @Autowired
    private DataSource dataSource;

    static Path downloadedContentDir;
    
    public static void main(String[] args) throws IOException {
        downloadedContentDir = Files.createTempDirectory("line-bot");
        SpringApplication.run(KitchenSinkApplication.class, args);
   }

    @PostConstruct
    @RequestMapping("/db")
    public void myRealMainMethod() throws SQLException {
        Statement stmt = dataSource.getConnection().createStatement();
        stmt.executeUpdate("DROP TABLE IF EXISTS ticks");
        stmt.executeUpdate("CREATE TABLE ticks (tick timestamp)");
        stmt.executeUpdate("INSERT INTO ticks VALUES (now())");
        ResultSet rs = stmt.executeQuery("SELECT tick FROM ticks");
        while (rs.next()) {
            System.out.println("Read from DB: " + rs.getTimestamp("tick"));
        }
    }

}

@@ -1575,558 +1575,7 @@
  %7D%0A%0A
-    @PostConstruct%0A    @RequestMapping(%22/db%22)%0A    public void myRealMainMethod() throws SQLException %7B%0A        Statement stmt = dataSource.getConnection().createStatement();%0A        stmt.executeUpdate(%22DROP TABLE IF EXISTS ticks%22);%0A        stmt.executeUpdate(%22CREATE TABLE ticks (tick timestamp)%22);%0A        stmt.executeUpdate(%22INSERT INTO ticks VALUES (now())%22);%0A        ResultSet rs = stmt.executeQuery(%22SELECT tick FROM ticks%22);%0A        while (rs.next()) %7B%0A            System.out.println(%22Read from DB: %22 + rs.getTimestamp(%22tick%22));%0A        %7D%0A    %7D%0A
 %0A%7D%0A

Add existing file