Skip to content

Instantly share code, notes, and snippets.

View appkr's full-sized avatar
🎯
Focusing

appkr appkr

🎯
Focusing
View GitHub Profile
@appkr
appkr / yark-shaving.md
Last active November 9, 2020 04:45
러시아 페인트공, 마세라티, 야크 털깍기

러시아 페인트공 알고리즘

페인트공이 첫날은 차선 페인트 작업을 300야드 칠함 둘째 날은 150야드 칠함 셋째 날은 30야드 칠함 첫 날은 어떻게 10배를 칠했는지 관리자가 묻자 저도 어쩔 수 없었습니다. 매일 페인트 통에서 점점 멀어지니까요

  • "조엘 온 소프트웨어" by 조엘스폴스키(스택오버플로, 트렐로 창업자)
@appkr
appkr / sql.md
Created November 6, 2020 08:16
SQL 합집합, 교집합, 차집합, 대칭차집합
CREATE TABLE tablea (str varchar(8), PRIMARY KEY (str));
CREATE TABLE tableb (str varchar(8), PRIMARY KEY (str));
INSERT INTO tablea (str) VALUES ('A'), ('B'), ('C'), ('D');
INSERT INTO tableb (str) VALUES ('C'), ('D'), ('E'), ('F');
-- 합집합
@appkr
appkr / postgis.md
Last active November 5, 2020 03:30
PostGIS, Postgre

101

Create table

CREATE DATABASE db_name ENCODING=utf8 lc_collate="C" template=template0;

-- Reconnect to `db_name` database
-- @see https://stackoverflow.com/questions/3949876/how-to-switch-databases-in-psql
CREATE EXTENSION postgis;
@appkr
appkr / DatabaseCleaner.java
Last active October 23, 2020 07:42
snippets for Integration Test (Test Isolation)
package ...;
import org.springframework.stereotype.Component;
import javax.sql.DataSource;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.HashSet;
@appkr
appkr / DatabaseConfiguration.java
Created March 17, 2020 12:50
Spring Database Connection 분리
@Configuration
@EnableJpaRepositories("package.to.repository")
@EnableJpaAuditing(auditorAwareRef = "springSecurityAuditorAware")
@EnableTransactionManagement
public class DatabaseConfiguration {
private final Logger log = LoggerFactory.getLogger(DatabaseConfiguration.class);
@Bean
@ConfigurationProperties(prefix = "spring.datasource.hikari.master")
@appkr
appkr / compare1.java
Last active September 15, 2020 07:41
Java Collection Comparison
public class Elem {
public String key;
public String value;
public Elem (String key, String value) {
this.key = key;
this.value = value;
}
public boolean equals(Object o) {
Elem other = (Elem) o;
return key.equals(other.key)
@appkr
appkr / ImmutabilityTest.java
Last active September 14, 2020 06:05
Is Java HashMap and ArrayList immutable? NOPE. The same is true for other languages.
package kata;
import org.junit.Test;
import java.util.*;
import static org.junit.Assert.*;
public class MutabilityTest {
@Test
public void isJavaMapImmutable() {
@appkr
appkr / OrderState.java
Created August 19, 2020 13:27
methods in Java Enum
// @see https://github.com/madvirus/ddd-start
public enum OrderState {
PAYMENT_WAITING {
public boolean isShippingChangeable() {
return true;
}
}, PREPARING {
public boolean isShippingChangeable() {
return true;
@appkr
appkr / curl.md
Created June 25, 2018 10:59
cURL error 77: error setting certificate verify locations

Problem

[2018-06-25 19:54:37] local.DEBUG: GuzzleHttp\Exception\RequestException: cURL error 77: error setting certificate verify locations:
  CAfile: /tmp/cacert.pem
  CApath: none (see http://curl.haxx.se/libcurl/c/libcurl-errors.html) in /Users/appkr/meshkorea/korean-address-database-laravel/vendor/guzzlehttp/guzzle/src/Handler/CurlFactory.php:187

Docker

@appkr
appkr / php_libicui18n_link_error_fix.md
Last active April 27, 2020 05:43
PHP libicui18n 링크 오류