이응기역

mysql -NB -u root my_database -e 'show create procedure `myProcedure`' |\
xargs -n 1 -d '\t' echo |\
egrep '^CREATE' |\
xargs --null echo -e >

stackoverflow.com/questions/2518459/mysql-mysqldump-routines-to-only-export-1-stored-procedure-by-name-and-not/7080270#7080270

support.microsoft.com/en-us/windows/change-default-programs-in-windows-10-e5d82cad-17d1-c53b-3505-f10a32e1894d

stackoverflow.com/questions/15844213/what-does-variable-variable-mean-in-javascript

select -- *
COLUMN_NAME, COLUMN_COMMENT, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH, COLUMN_KEY, 
CASE
WHEN IS_NULLABLE = 'YES'
THEN 'N'
ELSE 'Y'
END as NOTNULL
, COLUMN_DEFAULT
from information_schema.columns
where table_schema = 'mytableschema'
and table_name = 'MY_TABLE'
order by ordinal_position
;

find  /c/pjt -type f  -print0| xargs -0 grep -i 02356

(serverfault.com/questions/268368/how-can-i-handle-spaces-in-file-names-when-using-xargs-on-find-results)

* Error Message :

org.springframework.dao.InvalidDataAccessApiUsageException: No enum constant

* 원인:JPA 쪽에서 enum 으로 선언된 mysql table 컬럼에 ''(빈문자열) 이 들어있다

* 조치

UPDATE MYTABLE SET ENUM_COLUMN = NULL WHERE ENUM_COLUMN = '' 

윈도 찾기에서 '환경' 입력

SELECT TABLE_NAME, TABLE_COMMENT 
FROM INFORMATION_SCHEMA.TABLES 
WHERE TABLE_SCHEMA='myschema' 
ORDER BY 1   

 git bash (included in git gui)
 
  ( .bashrc 설정은 https://emflant.tistory.com/122 )

package com.test.sample;

import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import java.util.Set;
import java.util.concurrent.ConcurrentHashMap;
import java.util.function.Function;
import java.util.function.Predicate;
import java.util.stream.Collectors;

public class StreamTest {
	
	final static int FETCH_MAX_SIZE = 2;
	
	public static void main (String[] args) {
		
		List<Map<String, Object>> prdList = new ArrayList<Map<String, Object>>();
		List<Map<String, Object>> prdList2 = new ArrayList<Map<String, Object>>();
		for (int i=0; i < 10; i++) {
			Map<String, Object> product = new HashMap<>();
			product.put("prdNo", i + 1000);
			product.put("ordQty", i + 30);
			
			if (i%2 == 0) {
				product.put("useYn", "N");
			}
			else  {
				product.put("useYn", "Y");
			}
			prdList.add(product);
		}
		
		System.out.printf("\n\n");
		System.out.printf("prdList:" + prdList);

		prdList2 = 
		prdList.stream().filter(distinctByPrdNo(m -> m.get("prdNo")))
		.filter(t->t.get("useYn").equals("Y"))
		.limit(FETCH_MAX_SIZE).collect(Collectors.toList());

		System.out.printf("\n\n");
		System.out.printf("prdList:" + prdList);

		System.out.printf("\n\n");
		System.out.printf("prdList2:" + prdList2);

	}
	
	private static <T> Predicate<T> distinctByPrdNo(Function<? super T, ?> keyExtractor) {
		Set<Object> seen = ConcurrentHashMap.newKeySet();
		return t -> seen.add(keyExtractor.apply(t));
	}
}