이응기역

find . -type f | perl -ne 'print $1 if m/\.([^.\/]+)$/' | sort -u

stackoverflow.com/questions/1842254/how-can-i-find-all-of-the-distinct-file-extensions-in-a-folder-hierarchy

$ echo "SELECT now()" | mysql.exe -uuserid1234 -ppwd1234\!@ -h 127.0.0.1 -P 3306 mydb
now()
2021-02-09 14:53:14

(stackoverflow.com/questions/6150675/how-to-feed-mysql-queries-from-bash)

# application.yml ===============================================
visitor1:
  height: 170
  userid: HongKildong
  
/* ReadProp.java  ==============================================*/
package com.example.demo;

import org.springframework.beans.factory.annotation.Value;
import org.springframework.stereotype.Component;

@Component
public class ReadProp {
    @Value("${visitor1.userid}")
    private String userid;

    @Value("${visitor1.height}")
    private int height;

    @Value("${visitor1.hpno:01099887766}") // set default value
    private String hpno;

    @Override
    public String toString() {
        return  "    userid:" + userid 
        		+ ", height:" + height
        		+ ",   hpno:" + hpno
        		+ "";
    }
}
 
/* ReadYmlValueTests.java ====================================*/
package com.example.demo;

import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;

@SpringBootTest
class ReadYmlValueTests {

	@Autowired
	ReadProp person;

	@Test
	void contextLoads() {
	}


	@Test
	public void userTest(){
		System.out.println(person.toString());
	}

}

public static String[] insertSqls ={	
	"INSERT INTO noti_table(LOG_ID, REG_DT)  "
	+ "SELECT NVL(MAX(LOG_ID), 0) ERROR_LOG_ID , now()\r\n"
	+ "from src_table "
	+ "where 1=1\r\n"
	+ " and DATE_FORMAT(REG_DT, '%Y%m%d') = ? \r\n"
	,
	"INSERT INTO noti_table(LOG_ID, REG_DT)  "
	+ "SELECT NVL(MAX(LOG_ID), 0) ERROR_LOG_ID , now() \r\n"
	+ "from src_table \r\n"
	+ "where REGR_ID = 'API'\r\n"
	+ "and RESP_CD != '200'\r\n"
	+ "and DATE_FORMAT(REG_DT, '%Y%m%d') = ? "
} 
			
Arrays.asList(insertSqls).forEach((String qry) -> {
	System.out.println("qry15:" + qry);
	jdbcTemplate.update(qry, requestDate.substring(0 ,8));
});
			

배치 parameter 바꿔서 실행

         return jobBuilderFactory.get("notiMailJob")
-                .start(notiDbStep())
+                .start(notiDbStep(null))

<script type="text/javascript">
document.onreadystatechange = () => {
  if (document.readyState === 'complete') {
	// Script to hide/show menu
	var button = document.querySelector('#menu-button');
	console.log('b11:', button);
	var menu = document.querySelector('#menu');
	button.addEventListener('click', function (event) {
		  if (menu.style.display == "") {
			  menu.style.display = "none";
			  button.innerHTML = "Show Menu";
		  } else {
			  menu.style.display = "";
			  button.innerHTML = "Hide Menu";
		  }
		}
	  );

  }
};
</script>
<button id="menu-button">Hide Menu</button>
<nav id="menu">
  <ul>
    <li>Item 1</li>
    <li>Item 2</li>
    <li>Item 3</li>
  </ul>
</nav>

strwaberry,

mysql.xs.dll not found

=> 

Copying C:\strawberry\c\bin\libmysql.dll_ to c:\strawberry\perl\vendor\lib\auto\mysql

(https://github.com/perl5-dbi/DBD-mysql/issues/318)