Regular Expression 處理 SQL INSERT 指令格式問題

Oracle

INSERT INTO JHI_USER(ID, LOGIN, PASSWD, FIRST_NAME, LAST_NAME, EMAIL, ACTIVATED, LANG_KEY, ACTIVATION_KEY, RESET_KEY, PASSWORDPERIOD, PASSWORDCHANGEDDATE, FORCETOCHANGEPASSWORD, CREATED_BY, CREATED_DATE, RESET_DATE, LAST_MODIFIED_BY, LAST_MODIFIED_DATE)
  VALUES(32, '85757', '$2auuuuuuuuuuu', '林XX', '林XX', NULL, 1, 'zh-tw', NULL, 'true', NULL, NULL, 0, 'system', TO_TIMESTAMP('2017-06-22 09:11:04:9000000','YYYY-MM-DD HH24:MI:SS:FF'), NULL, 'system', TO_TIMESTAMP('2017-08-31 09:06:58:612000000','YYYY-MM-DD HH24:MI:SS:FF'))
GO


Mysql

INSERT INTO JHI_USER(ID, LOGIN, PASSWD, FIRST_NAME, LAST_NAME, EMAIL, ACTIVATED, LANG_KEY, ACTIVATION_KEY, RESET_KEY, PASSWORDPERIOD, PASSWORDCHANGEDDATE, FORCETOCHANGEPASSWORD, CREATED_BY, CREATED_DATE, RESET_DATE, LAST_MODIFIED_BY, LAST_MODIFIED_DATE)
  VALUES(32, '85757', '$2auuuuuuuuuuu', '林XX', '林XX', NULL, 1, 'zh-tw', NULL, 'true', NULL, NULL, 0, 'system', STR_TO_DATE('2017-06-22 09:11:04:612000','%Y-%m-%d %H:%i:%s:%f'), NULL, 'system', STR_TO_DATE('2017-08-31 09:06:58:612000','%Y-%m-%d %H:%i:%s:%f'));


利用Notepad++  Regular Expression gular Expression 取代功能

Find what:        :[0-9]+','YYYY-MM-DD HH24:MI:SS:FF'\)

Replace with:    :612000','%Y-%m-%d %H:%i:%s:%f'\)

同時另外將   TO_TIMESTAMP 取代為 STR_TO_DATE

Overview of the java.util.concurrent

http://www.baeldung.com/java-util-concurrent

The best way to do batch processing with JPA and Hibernate

https://vladmihalcea.com/the-best-way-to-do-batch-processing-with-jpa-and-hibernate/

https://stackoverflow.com/questions/2773302/jpa-hibernate-bulkbatch-insert

Mysql clustering

https://shazi.info/%E6%9E%B6%E8%A8%AD-ha-%E9%AB%98%E5%8F%AF%E7%94%A8%E6%80%A7%EF%BC%9Amysql-cluster-%E5%8F%A2%E9%9B%86-7-4-115-6-29/

http://stackoverflow.max-everyday.com/2017/10/mysql-for-commercial/

http://www.clusterdb.com/mysql-cluster/using-clusterjpa-part-of-mysql-cluster-connector-for-java-a-tutorial

Easily secure your Spring Boot applications with Keycloak

https://developers.redhat.com/blog/2017/05/25/easily-secure-your-spring-boot-applications-with-keycloak/

How to use JPA correctly to avoid complaints of a slow application

https://zeroturnaround.com/rebellabs/how-to-use-jpa-correctly-to-avoid-complaints-of-a-slow-application/

Modified Java Script Value & Dynamic SQL

https://stackoverflow.com/questions/36918706/pentaho-insert-a-list-in-sql-where-clause

Spring Batch With Spring Boot

http://ashismo.github.io/java-spring/2017/05/16/Spring-Batch-with-Spring-Boot

Java Generic Type & get-put principle

https://stackoverflow.com/questions/1292109/explanation-of-the-get-put-principle

Java 8: java.time.*

https://www.mkyong.com/spring-boot/spring-boot-spring-data-jpa-java-8-date-and-time-jsr310/

RRD Tool

http://www.study-area.org/tips/rrdtool/rrdtool.html

http://ycfu.blog.mypc.tw/2008/05/rrdtool.html

http://blog.csdn.net/jndxjing/article/details/8014410

SQL Server Data Format

1.   Get Date in a format such as: 2017/09/11

CONVERT(char(10),DATEADD(day,-(1),GETDATE()) ,111) AS Date

Select Into v.s. Insert into From

1. Select Into

Create a new table in the destination database
select * into sif.dbo.callDetail from I3_IC.dbo.calldetail_viw;

2.  Insert into From

Insert into existing table, column needs to assigned explicitly. * may not work in some databases.

INSERT INTO table2 (column1, column2, column3, ...)
SELECT column1, column2, column3, ...
FROM table1
WHERE condition;

Pentaho Data Integration (Kettle)

http://ithelp.ithome.com.tw/articles/10186567

Logback

https://examples.javacodegeeks.com/enterprise-java/logback/logback-file-appender-example-2/

https://stackoverflow.com/questions/2488558/logback-to-log-different-messages-to-two-files

UI/UX process

https://blog.akanelee.me/posts/278602-ux-is-not-a-wireframe/

https://blog.akanelee.me/posts/686437-ui-design-process/

IOT

https://villesmartblog.wordpress.com/2016/11/29/iot-%E5%B8%B8%E7%94%A8%E7%9A%84%E5%82%B3%E8%BC%B8%E5%8D%94%E5%AE%9A%E4%BB%8B%E7%B4%B9/

JBOSS 教學

http://jbosstut-christina.rhcloud.com/archives/category/jboss-%E6%95%99%E5%AD%B8

The road ahead for WebLogic 12c

http://biemond.blogspot.tw/2013/10/the-road-ahead-for-weblogic-12c.html

Pollexsurvey data creation

1. Create data with excel template

2. Copy & paste to SQL Server Managment studio

3. Insert into local mysql database (Link server need to be configured in advance)
INSERT OPENQUERY(MYSQLLOCAL,'SELECT * FROM pollexsurvey.pls_respondent') SELECT * FROM pls_respondent WHERE uid > 4280;
INSERT OPENQUERY(MYSQLLOCAL,'SELECT * FROM pollexsurvey.pls_respondent_role') SELECT * FROM pls_respondent_role WHERE respondent_uid >  4280;
INSERT OPENQUERY(MYSQLLOCAL,'SELECT * FROM pollexsurvey.pls_respondentdetail_extsat2017') SELECT * FROM pls_respondentdetail_extsat2017 WHERE uid >  4280;

4. Delete data of earlier batches
delete from pollexsurvey.pls_respondent WHERE uid <=4280;
delete from pollexsurvey.pls_respondentdetail_extsat2017 WHERE uid <=4280;
delete from pollexsurvey.pls_respondent_role WHERE respondent_uid <=4280;

select count(*) from pollexsurvey.pls_respondent;
select count(*) from pollexsurvey.pls_respondentdetail_extsat2017;
select count(*) from pollexsurvey.pls_respondent_role;

5. Export the SQL