Kuan-Yin Chen kevchentw
kevchentw
/ trigger.sql
Last active
December 1, 2021 05:56
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| CREATE TRIGGER `trigger JobDescriptionHook` AFTER UPDATE ON `JOB` | |
| FOR EACH ROW IF OLD.text_description <> NEW.text_description THEN | |
| CALL JobDescriptionHook(NEW.id); | |
| END IF | |
| DELIMITER $$ | |
| CREATE DEFINER=`root`@`%` PROCEDURE `JobDescriptionHook`(IN `job_id_var` INT) | |
| BEGIN | |
| DECLARE tag_id_var INT; |
kevchentw
/ recommend.sql
Created
December 1, 2021 03:22
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| BEGIN | |
| DECLARE cur CURSOR FOR | |
| SELECT Y.job_id as job_id | |
| FROM ( | |
| SELECT job_id, similar_factor | |
| FROM (SELECT js2.user_id as user_id, COUNT(*) as similar_factor | |
| FROM JOB_STATUS as js JOIN JOB_STATUS as js2 ON (js.job_id = js2.job_id AND js.user_id <> js2.user_id) | |
| WHERE js.user_id = my_user_id | |
| GROUP BY js2.user_id |
kevchentw
/ UpdateJobTag.sql
Created
November 27, 2021 03:38
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| CREATE PROCEDURE UpdateJobTag(IN tag_id INT) | |
| BEGIN | |
| DECLARE cur CURSOR FOR SELECT id FROM job WHERE job_desc LIKE CONCAT('%', @tag_name, '%'); | |
| DECLARE job_id INT; | |
| OPEN cur; | |
| BEGIN | |
| DECLARE exit_flag BOOLEAN DEFAULT FALSE; |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| def parse(s): | |
| s = s.split(' ')[::-1] | |
| stack = [] | |
| for i in s: | |
| if i in ["+", "-", "*", "/"]: | |
| a, b = stack.pop(), stack.pop() | |
| if i == "+": | |
| stack.append(a + b) | |
| if i == "-": | |
| stack.append(a - b) |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| from collections import deque | |
| def l(): | |
| bank = ["hot","dot","dog","lot","log","cog"] | |
| start = "hit" | |
| end = "cog" | |
| q = deque([[start, 1]]) | |
| while q: | |
| word, length = q.popleft() |
kevchentw
/ 10885_pmd_after.txt
Created
November 18, 2021 20:46
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /home/kevchentw/repo/openapi-generator/samples/client/petstore/java/okhttp-gson/src/main/java/org/openapitools/client/ApiCallback.java:16: UnnecessaryImport: Unused import 'java.io.IOException' | |
| /home/kevchentw/repo/openapi-generator/samples/client/petstore/java/okhttp-gson/src/main/java/org/openapitools/client/ApiClient.java:16: UnnecessaryImport: Unused import 'okhttp3.*' | |
| /home/kevchentw/repo/openapi-generator/samples/client/petstore/java/okhttp-gson/src/main/java/org/openapitools/client/ApiClient.java:27: UnnecessaryImport: Unused import 'org.apache.oltu.oauth2.common.message.types.GrantType' | |
| /home/kevchentw/repo/openapi-generator/samples/client/petstore/java/okhttp-gson/src/main/java/org/openapitools/client/ApiClient.java:46: UnnecessaryImport: Unused import 'java.security.cert.X509Certificate' | |
| /home/kevchentw/repo/openapi-generator/samples/client/petstore/java/okhttp-gson/src/main/java/org/openapitools/client/ApiClient.java:56: UnnecessaryImport: Unused import 'org.openapitools.client.auth.HttpBearerAuth' |
kevchentw
/ 10885_pmd_before.txt
Created
November 18, 2021 20:45
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /home/kevchentw/repo/openapi-generator/samples/client/petstore/java/okhttp-gson/src/main/java/org/openapitools/client/ApiCallback.java:16: UnnecessaryImport: Unused import 'java.io.IOException' | |
| /home/kevchentw/repo/openapi-generator/samples/client/petstore/java/okhttp-gson/src/main/java/org/openapitools/client/ApiClient.java:16: UnnecessaryImport: Unused import 'okhttp3.*' | |
| /home/kevchentw/repo/openapi-generator/samples/client/petstore/java/okhttp-gson/src/main/java/org/openapitools/client/ApiClient.java:27: UnnecessaryImport: Unused import 'org.apache.oltu.oauth2.common.message.types.GrantType' | |
| /home/kevchentw/repo/openapi-generator/samples/client/petstore/java/okhttp-gson/src/main/java/org/openapitools/client/ApiClient.java:46: UnnecessaryImport: Unused import 'java.security.cert.X509Certificate' | |
| /home/kevchentw/repo/openapi-generator/samples/client/petstore/java/okhttp-gson/src/main/java/org/openapitools/client/ApiClient.java:56: UnnecessaryImport: Unused import 'org.openapitools.client.auth.HttpBearerAuth' |
kevchentw
/ findbugs_10885.txt
Created
November 18, 2021 20:41
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| M V EI2: org.openapitools.client.model.FormatTest.setByte(byte[]) may expose internal representation by storing an externally mutable object into FormatTest._byte At FormatTest.java:[line 284] | |
| M V EI2: org.openapitools.client.model.FormatTest._byte(byte[]) may expose internal representation by storing an externally mutable object into FormatTest._byte At FormatTest.java:[line 267] | |
| M V EI: org.openapitools.client.model.FormatTest.getByte() may expose internal representation by returning FormatTest._byte At FormatTest.java:[line 279] | |
| M B Se: org.gradle.cli.CommandLineParser$CaseInsensitiveStringComparator implements Comparator but not Serializable At CommandLineParser.java:[lines 505-511] | |
| M B Se: org.gradle.cli.CommandLineParser$OptionStringComparator implements Comparator but not Serializable At CommandLineParser.java:[lines 515-525] | |
| M P WMI: new org.openapitools.client.auth.RetryingOAuth(String, String, OAuthFlow, String, Map) makes inefficient use of keySet iterator instead of entrySet iterator At Retr |
kevchentw
/ findbugs_10783.txt
Created
November 17, 2021 23:14
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| M B CN: org.openapitools.client.RFC3339DateFormat defines clone() but doesn't implement Cloneable At RFC3339DateFormat.java:[line 53] | |
| M D RCN: Redundant nullcheck of childCdm, which is known to be non-null in org.openapitools.client.JSON$ClassDiscriminatorMapping.getClassForElement(JsonNode, Set) Redundant null check at JSON.java:[line 148] | |
| M V EI2: org.openapitools.client.model.FormatTest.setByte(byte[]) may expose internal representation by storing an externally mutable object into FormatTest._byte At FormatTest.java:[line 314] | |
| M V EI2: org.openapitools.client.model.FormatTest._byte(byte[]) may expose internal representation by storing an externally mutable object into FormatTest._byte At FormatTest.java:[line 293] | |
| M V EI: org.openapitools.client.model.FormatTest.getByte() may expose internal representation by returning FormatTest._byte At FormatTest.java:[line 307] | |
| M B Se: org.gradle.cli.CommandLineParser$CaseInsensitiveStringComparator implements Comparator but not Serializable At CommandLineParser. |
kevchentw
/ pmd_10783_after.txt
Created
November 17, 2021 23:08
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /home/kevchentw/repo/openapi-generator/samples/client/petstore/java/jersey2-java8/src/main/java/org/openapitools/client/ApiClient.java:1024: ControlStatementBraces: This statement should have braces | |
| /home/kevchentw/repo/openapi-generator/samples/client/petstore/java/jersey2-java8/src/main/java/org/openapitools/client/ApiClient.java:1042: ControlStatementBraces: This statement should have braces | |
| /home/kevchentw/repo/openapi-generator/samples/client/petstore/java/jersey2-java8/src/main/java/org/openapitools/client/ApiClient.java:1046: ControlStatementBraces: This statement should have braces | |
| /home/kevchentw/repo/openapi-generator/samples/client/petstore/java/jersey2-java8/src/main/java/org/openapitools/client/ApiClient.java:1048: ControlStatementBraces: This statement should have braces | |
| /home/kevchentw/repo/openapi-generator/samples/client/petstore/java/jersey2-java8/src/main/java/org/openapitools/client/ApiClient.java:1193: EmptyCatchBlock: Avoid empty catch blocks | |
| /home/kevchentw/repo/openapi-generator/sample |
NewerOlder