๐Ÿ“š
TIL
  • README
  • Git
    • Basic
    • Remote Repository
    • Log & Diff
    • Rebase&Cherri-Pick
    • git-flow
  • DevOps
    • Monolithic vs MSA
    • Jenkins ์‹œ์ž‘ํ•˜๊ธฐ
    • Airflow ์‹œ์ž‘ํ•˜๊ธฐ
    • Airflow ์‹œ์ž‘ํ•˜๊ธฐ
    • Build Tools
      • maven
  • ๊ฐœ๋ฐœ ๋ฐฉ๋ฒ•๋ก 
    • TDD
  • Spring
    • IoC
    • Is Spring Bean Thread-Safe?
    • Spring Singleton
    • Component Scan
    • Spring Annotation
    • ์˜์กด ๊ด€๊ณ„ ์ฃผ์ž…(DI)
    • Lombok ํ™œ์šฉํ•˜๊ธฐ
    • Bean ์ƒ๋ช…์ฃผ๊ธฐ์™€ ์ฝœ๋ฐฑ
    • Bean Scope
    • AOP(1) - AOP๋ž€
    • AOP(2) - Aop Proxy
    • AOP(3) - Dynamic Proxy
    • AOP(4) - AspectJ
    • POJO
    • Spring ์„œ๋น„์Šค ๊ตฌ์กฐ
    • Transaction
    • JPA๋ž€?
    • JPA Entity
    • Spring Data JPA
    • Spring Data Specification
    • Model Mapping
    • Cache
    • restTemplate
    • YAML ํŒŒ์ผ ์„ค์ •
    • Spring Boot
      • H2 DB ์„ค์ •
      • ๋‹ค์ค‘ ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ์„ค์ •
      • Mybatis ์—ฐ๋™ํ•˜๊ธฐ
    • Spring Batch
      • Batch ์‹œ์ž‘ํ•ด๋ณด๊ธฐ
      • Batch Job Flow
      • Job
      • Step
      • Batch Scope & Job Parameter
      • JobRepository์™€ ๋ฉ”ํƒ€ํ…Œ์ด๋ธ”
      • Chunk ์ง€ํ–ฅ ํ”„๋กœ๊ทธ๋ž˜๋ฐ
      • ItemReader
      • ItemProcessor
      • ItemWriter
      • Batch Schedular
      • Job๋ณ„ Bean๋“ฑ๋กํ•˜๊ธฐ
      • Batch ๊ตฌํ˜„์‹œ ๋ฐœ์ƒํ•œ ์˜ค๋ฅ˜ ์ •๋ฆฌ
      • Spring Batch Scaling
        • Multithread Job๊ตฌํ˜„์‹œ ์ด์Šˆ์‚ฌํ•ญ
    • Spring test
      • Junit5
        • ํ…Œ์ŠคํŠธ ์ด๋ฆ„ ํ‘œ๊ธฐ
        • ํ…Œ์ŠคํŠธ ๊ทธ๋ฃน ์‚ฌ์ด์˜ ๊ด€๊ณ„
        • ํƒœ๊ทธ์™€ ํ•„ํ„ฐ๋ง
        • ๋™์  ํ…Œ์ŠคํŠธ
        • ํ…Œ์ŠคํŠธ LifeCycle
        • ํ…Œ์ŠคํŠธ ๋ฉ”์„œ๋“œ
        • ํ…Œ์ŠคํŠธ ์ˆœ์„œ
        • AssertJ
        • ํ…Œ์ŠคํŠธ ๋ณ‘๋ ฌ ์‹คํ–‰
        • AssertJ
        • Mock
      • Spring Boot Test DB ๋ถ„๋ฆฌ
      • Spring Batch Test
  • Web Application
    • Web Server & WAS
    • ๊ด€๋ จ ๊ฐœ๋… - HTTP API, HTML, CSR, SSR
    • Servlet
    • JSP
    • Cookie And Session
    • ์˜ˆ์™ธํŽ˜์ด์ง€
    • Java Bean
    • JDBC
    • Connection Pool
    • ํŒŒ์ผ ์—…๋กœ๋“œ
    • Expression Language
    • JSTL
    • FrontControllerํŒจํ„ด Command ํŒจํ„ด
    • Forwarding
    • MVC
    • ํšŒ์›๊ฐ€์ž…์˜ˆ์ œ
    • ์ฐธ๊ณ 
      • ๊ฐœ๋ฐœํ™˜๊ฒฝ์„ค์ •
  • Java+
    • SOAP/WSDL vs REST
    • WSDL์„ JAVA๋กœ ๋ณ€ํ™˜ํ•˜๊ธฐ
    • SOAP ํ†ต์‹  OPEN API๋กœ ๊ฐœ๋ฐœํ•ด๋ณด๊ธฐ
  • Java
    • Basic
      • ๋ณ€์ˆ˜์™€ ํƒ€์ž…
      • ์—ฐ์‚ฐ์ž
      • ์กฐ๊ฑด๋ฌธ๊ณผ ๋ฐ˜๋ณต๋ฌธ
      • ์ฐธ์กฐ ํƒ€์ž…
      • ํด๋ž˜์Šค
      • ์ƒ์†(Inheritance)
      • ์ธํ„ฐํŽ˜์ด์Šค(Interface)
      • ์ค‘์ฒฉ ํด๋ž˜์Šค์™€ ์ค‘์ฒฉ ์ธํ„ฐํŽ˜์ด์Šค
      • ์˜ˆ์™ธ ์ฒ˜๋ฆฌ
      • API - Object, System, Class, Math, Wrapper
      • API - String, StringBuffer, StringBuilder
      • Thread
      • Generic
      • Lambda
      • Collection - List, Set
      • Collection - Map
      • Collection - Tree
      • Collection - Stack, Queue
      • Stream
      • Reflection
      • ์ •๊ทœํ‘œํ˜„์‹
      • GUI
      • UML
      • Serializable
    • Advanced
      • OutOfMemoryError
      • AutoValue
      • meta-annotation
        • @Retention
        • @Target
        • @Repeatable
    • Effective Java 3/E
      • ITEM 1: Static Factory Method(์ •์  ๋ฉ”์†Œ๋“œ)
      • ITEM 2: Builder Pattern
      • ITEM 3: Singleton
      • ITEM 4: Private Constructor
      • ITEM 5: Dependency Injection
      • ITEM 6: Avoid Unnecessary Object
      • ITEM 7: Eliminate Object Reference
      • ITEM 8: Avoid finalizer and cleaner
      • ITEM 9: try-with-resources
      • ITEM 10: The gerneral contract when overriding equlas
      • ITEM 11: Overriding hashCode
      • ITEM 12: overriding toString
      • ITEM 13: overriding clone judiciously
      • ITEM 14: Consider implementing comparable
      • ITEM 15: ํด๋ž˜์Šค์™€ ๋ฉค๋ฒ„์˜ ์ ‘๊ทผ์„ ์ตœ์†Œํ™”ํ•ด๋ผ
      • ITEM 16: Use Accessor methods
      • ITEM 17: ๋ณ€๊ฒฝ ๊ฐ€๋Šฅ์„ฑ์„ ์ตœ์†Œํ™”ํ•ด๋ผ(๋ถˆ๋ณ€ ํด๋ž˜์Šค)
      • ITEM 18: ์ƒ์†๋ณด๋‹จ ์ปดํฌ์ง€์…˜์„ ์‚ฌ์šฉํ•ด๋ผ
      • ITEM 19: ์ƒ์†์„ ๊ณ ๋ คํ•ด ์„ค๊ณ„ํ•˜๊ณ  ๋ฌธ์„œํ™”ํ•ด๋ผ
      • ITEM 20: ์ถ”์ƒ ํด๋ž˜์Šค๋ณด๋‹ค ์ธํ„ฐํŽ˜์ด์Šค๋ฅผ ์šฐ์„ ํ•˜๋ผ
      • ITEM 21: ์ธํ„ฐํŽ˜์ด์Šค๋Š” ๊ตฌํ˜„ํ•˜๋Š” ์ชฝ์„ ์ƒ๊ฐํ•ด ์„ค๊ณ„ํ•ด๋ผ.
      • ITEM 22: ์ธํ„ฐํŽ˜์ด์Šค๋Š” ํƒ€์ž…์„ ์ •์˜ํ•˜๋Š” ์šฉ๋„๋กœ๋งŒ ์‚ฌ์šฉํ•ด๋ผ
      • ITEM 23: ํƒœ๊ทธ ๋‹ฌ๋ฆฐ ํด๋ž˜์Šค๋ณด๋‹ค ํด๋ž˜์Šค ๊ณ„์ธต๊ตฌ์กฐ๋ฅผ ํ™œ์šฉํ•ด๋ผ
      • ITEM 24: ๋ฉค๋ฒ„ ํด๋ž˜์Šค๋Š” ๋˜๋„๋ก static์œผ๋กœ ๊ตฌํ˜„ํ•ด๋ผ
      • ITEM 25: ํ†ฑ๋ ˆ๋ฒจ ํด๋ž˜์Šค๋Š” ํ•œ ํŒŒ์ผ์— ํ•˜๋‚˜๋งŒ ์ƒ์„ฑํ•ด๋ผ.
      • ITEM 26: Raw type์€ ์‚ฌ์šฉํ•˜์ง€ ๋งˆ๋ผ
      • ITEM 27: ๋น„๊ฒ€์‚ฌ ๊ฒฝ๊ณ ๋ฅผ ์ œ๊ฑฐํ•ด๋ผ
      • ITEM 28: ๋ฐฐ์—ด๋ณด๋‹ค๋Š” ๋ฆฌ์ŠคํŠธ๋ฅผ ์‚ฌ์šฉํ•ด๋ผ
      • ITEM 29: ์ด์™•์ด๋ฉด ์ œ๋„ค๋ฆญ ํƒ€์ž…์œผ๋กœ ๋งŒ๋“ค์–ด๋ผ
      • ITEM 30: ์ด์™•์ด๋ฉด ์ œ๋„ค๋ฆญ ๋ฉ”์„œ๋“œ๋กœ ๋งŒ๋“ค์–ด๋ผ
      • ITEM 31 : ํ•œ์ •์  ์™€์ผ๋“œ์นด๋“œ๋ฅผ ์‚ฌ์šฉํ•ด API ์œ ์—ฐ์„ฑ์„ ๋†’์—ฌ๋ผ
      • ITEM 32: ์ œ๋„ค๋ฆญ๊ณผ ๊ฐ€๋ณ€์ธ์ˆ˜๋ฅผ ํ•จ๊ป˜ ์“ธ ๋•Œ๋Š” ์‹ ์ค‘ํ•ด๋ผ
      • ITEM 33: ํƒ€์ž… ์•ˆ์ „ ์ด์ข… ์ปจํ…Œ์ด๋„ˆ๋ฅผ ๊ณ ๋ คํ•ด๋ผ
      • ITEM 34: int ์ƒ์ˆ˜ ๋Œ€์‹  ์—ด๊ฑฐ ํƒ€์ž…์„ ์‚ฌ์šฉํ•ด๋ผ
      • ITEM 35: ordinal ๋ฉ”์„œ๋“œ ๋Œ€์‹  ์ธ์Šคํ„ด์Šค ํ•„๋“œ๋ฅผ ์‚ฌ์šฉํ•ด๋ผ
      • ITEM 36: ๋น„ํŠธ ํ•„๋“œ ๋Œ€์‹  EnumSet์„ ์‚ฌ์šฉํ•ด๋ผ
      • ITEM 37: ordinal ์ธ๋ฑ์‹ฑ ๋Œ€์‹  EnumMap์„ ์‚ฌ์šฉํ•ด๋ผ
      • TEM 38 : ํ™•์žฅํ•  ์ˆ˜ ์žˆ๋Š” ์—ด๊ฑฐํƒ€์ž…์ด ํ•„์š”ํ•˜๋ฉด ์ธํ„ฐํŽ˜์ด์Šค๋ฅผ ์‚ฌ์šฉํ•ด๋ผ
      • ITEM 39: ๋ช…๋ช… ํŒจํ„ด๋ณด๋‹ค ์• ๋„ˆํ…Œ์ด์…˜์„ ์‚ฌ์šฉํ•ด๋ผ
      • ITEM 40: @Override ์–ด๋…ธํ…Œ์ด์…˜์„ ์ผ๊ด€๋˜๊ฒŒ ์‚ฌ์šฉํ•ด๋ผ
      • ITEM 41: ์ •์˜ํ•˜๋ ค๋Š” ๊ฒƒ์ด ํƒ€์ž…์ด๋ผ๋ฉด ๋งˆ์ปค ์ธํ„ฐํŽ˜์ด์Šค๋ฅผ ์‚ฌ์šฉํ•ด๋ผ
      • ITEM 42: ์ต๋ช… ํด๋ž˜์Šค๋ณด๋‹ค๋Š” ๋žŒ๋‹ค๋ฅผ ์‚ฌ์šฉํ•ด๋ผ
      • ITEM 43: ๋žŒ๋‹ค๋ณด๋‹ค๋Š” ๋ฉ”์„œ๋“œ ์ฐธ์กฐ๋ฅผ ์‚ฌ์šฉํ•ด๋ผ
      • ITEM 44: ํ‘œ์ค€ ํ•จ์ˆ˜ํ˜• ์ธํ„ฐํŽ˜์ด์Šค๋ฅผ ์‚ฌ์šฉํ•ด๋ผ
      • ITEM 45: ์ŠคํŠธ๋ฆผ์€ ์ฃผ์˜ํ•ด์„œ ์‚ฌ์šฉํ•ด๋ผ
      • ITEM 46: ์ŠคํŠธ๋ฆผ์—์„œ ๋ถ€์ž‘์šฉ ์—†๋Š” ํ•จ์ˆ˜๋ฅผ ์‚ฌ์šฉํ•ด๋ผ
      • ITEM 47: ๋ฐ˜ํ™˜ ํƒ€์ž…์œผ๋กœ๋Š” ์ŠคํŠธ๋ฆผ๋ณด๋‹ค ์ปฌ๋ ‰์…˜์ด ๋‚ซ๋‹ค.
      • ITEM 48: ์ŠคํŠธ๋ฆผ ๋ณ‘๋ ฌํ™”๋Š” ์ฃผ์˜ํ•ด์„œ ์‚ฌ์šฉํ•ด๋ผ
      • ITEM 49: ๋งค๊ฐœ๋ณ€์ˆ˜๊ฐ€ ์œ ํšจํ•œ์ง€ ๊ฒ€์‚ฌํ•ด๋ผ
      • ITEM 50: ์ ์‹œ์— ๋ฐฉ์–ด์  ๋ณต์‚ฌ๋ณธ์„ ๋งŒ๋“ค์–ด๋ผ
      • ITEM 51: ๋ฉ”์„œ๋“œ ์‹œ๊ทธ๋‹ˆ์ฒ˜๋ฅผ ์‹ ์ค‘ํžˆ ์„ค๊ณ„ํ•ด๋ผ
      • ITEM 52: ๋‹ค์ค‘์ •์˜๋Š” ์‹ ์ค‘ํžˆ ์‚ฌ์šฉํ•ด๋ผ
      • ITEM 53: ๊ฐ€๋ณ€์ธ์ˆ˜๋Š” ์‹ ์ค‘ํžˆ ์‚ฌ์šฉํ•ด๋ผ
      • ITEM 54: null์ด ์•„๋‹Œ, ๋นˆ ์ปฌ๋ ‰์…˜์ด๋‚˜ ๋ฐฐ์—ด์„ ๋ฐ˜ํ™˜ํ•ด๋ผ
      • ITEM 55: Optional ๋ฐ˜ํ™˜์€ ์‹ ์ค‘ํ•˜๊ฒŒ ํ•ด๋ผ
      • ITEM 56: ๊ณต๊ฐœ๋œ API ์š”์†Œ์—๋Š” ํ•ญ์ƒ ์ฃผ์„์„ ์ž‘์„ฑํ•ด๋ผ
      • ITEM 57: ์ง€์—ญ๋ณ€์ˆ˜์˜ ๋ฒ”์œ„๋ฅผ ์ตœ์†Œํ™”ํ•ด๋ผ
      • ITEM 58: ์ „ํ†ต์ ์ธ for ๋ฌธ๋ณด๋‹ค๋Š” for-each๋ฌธ์„ ์‚ฌ์šฉํ•ด๋ผ
      • ITEM 59: ๋ผ์ด๋ธŒ๋Ÿฌ๋ฆฌ๋ฅผ ์ตํžˆ๊ณ  ์‚ฌ์šฉํ•ด๋ผ
      • ITEM 60: ์ •ํ™•ํ•œ ๋‹ต์ด ํ•„์š”ํ•˜๋‹ค๋ฉด float์™€ double์€ ํ”ผํ•ด๋ผ
      • ITEM 61: ๋ฐ•์‹ฑ๋œ ๊ธฐ๋ณธ ํƒ€์ž…๋ณด๋‹ค๋Š” ๊ธฐ๋ณธ ํƒ€์ž…์„ ์‚ฌ์šฉํ•ด๋ผ
      • ITEM 62: ๋‹ค๋ฅธ ํƒ€์ž…์ด ์ ์ ˆํ•˜๋‹ค๋ฉด ๋ฌธ์ž์—ด ์‚ฌ์šฉ์„ ํ”ผํ•ด๋ผ
      • ITEM 63: ๋ฌธ์ž์—ด ์—ฐ๊ฒฐ์€ ๋А๋ฆฌ๋‹ˆ ์ฃผ์˜ํ•ด๋ผ
      • ITEM 64: ๊ฐ์ฒด๋Š” ์ธํ„ฐํŽ˜์ด์Šค๋ฅผ ์‚ฌ์šฉํ•ด ์ฐธ์กฐํ•ด๋ผ
      • ITEM 65: ๋ฆฌํ”Œ๋ ‰์…˜๋ณด๋‹ค๋Š” ์ธํ„ฐํŽ˜์ด์Šค๋ฅผ ์‚ฌ์šฉํ•ด๋ผ
      • ITEM 66: ๋„ค์ดํ‹ฐ๋ธŒ ๋ฉ”์„œ๋“œ๋Š” ์‹ ์ค‘ํžˆ ์‚ฌ์šฉํ•ด๋ผ
      • ITEM 67: ์ตœ์ ํ™”๋Š” ์‹ ์ค‘ํžˆ ํ•ด๋ผ
      • ITEM 68: ์ผ๋ฐ˜์ ์œผ๋กœ ํ†ต์šฉ๋˜๋Š” ๋ช…๋ช… ๊ทœ์น™์„ ๋”ฐ๋ผ๋ผ
    • ๊ฐ์ฒด์ง€ํ–ฅ ์„ค๊ณ„ ์›์น™(SOLID)
    • ๋””์ž์ธํŒจํ„ด
      • Strategy Pattern
      • Template Method Pattern
      • Factory Method Pattern
      • Singleton
      • Delegation
      • Proxy
      • Adapter Pattern
    • ์‹ค์Šต
      • ์ธํ„ฐํŽ˜์ด์Šค ์‹ค์Šต - Vehicle
      • ์ธํ„ฐํŽ˜์ด์Šค ์‹ค์Šต - Remote
      • GUI ์‹ค์Šต - Calculator
      • GUI ์‹ค์Šต - button
      • GUI ์‹ค์Šต - lotto
      • Thread ์‹ค์Šต - ์ขŒ์„์˜ˆ์•ฝ, ๋ฉ”์„ธ์ง€๋ณด๋‚ด๊ธฐ
    • Jar vs War
  • ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค
    • KEY
    • Index
    • Transaction
    • Trigger
    • Procedure / Function
    • Package
    • ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ๋ฐฐ์›€ํ„ฐ
      • ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ์‹œ์Šคํ…œ
      • ๊ด€๊ณ„๋ฐ์ดํ„ฐ ๋ชจ๋ธ
      • ๊ด€๊ณ„๋Œ€์ˆ˜์™€ SQL
    • MySQL
      • Database๋ž€
      • MySQL ์‹œ์ž‘ํ•˜๊ธฐ
      • MySQL Database
      • MySQL Table
      • CRUD
      • ๊ด€๊ณ„ํ˜• ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค
      • Server์™€ Client
    • PostgreSQL
    • NoSQL
      • Install Cassandra on mac
      • Cassandra๋ž€?
      • NiFi๋ž€
  • Algorithm
    • String
    • Recursion
    • Dynamic Programming
    • Array, Struct, Pointer
    • Math
    • Sort
    • List
    • Stack
    • Queue
    • Graph
    • Tree
    • Maze
    • AVL
    • ์ด์ง„ํƒ์ƒ‰ํŠธ๋ฆฌ(Binary Search Tree)
    • DFS์™€ BFS
    • ๋‹ค์ต์ŠคํŠธ๋ผ ์•Œ๊ณ ๋ฆฌ์ฆ˜(Dijkstra's Algorithm)
    • Red-Black ํŠธ๋ฆฌ
    • A* ์•Œ๊ณ ๋ฆฌ์ฆ˜
    • Heap
    • Huffman Coding
    • Priority Queue
    • Bellman-Ford ์•Œ๊ณ ๋ฆฌ์ฆ˜
    • C++
      • Class
      • STL
        • STL pair
        • STL Container - Associate Container
        • STL Container - Sequence Container
        • STL Container - Container Adapter
  • JavaScript
    • JABASCRIPT BASIC
    • Shallow Copy vs Deep Copy
    • OBJECT MODEL
    • NODE
    • ๋™๊ธฐ ์ฒ˜๋ฆฌ vs ๋น„๋™๊ธฐ ์ฒ˜๋ฆฌ
    • AJAX
    • CALLBACK
    • PROMISE
    • DEFERRER
    • UNDERSCORE
    • WEBPACK
    • SCOPE
    • EXECUTION CONTEXT
    • Image Object
    • BFCache๋ž€?
    • history.scrollRestoration
    • Intersection Observer
    • JWT - JSON Web Token
    • HTML vs JSON
  • Vue.js
    • ํ™˜๊ฒฝ์„ค์ •
    • Vue.js๋ž€?
    • Vue Instance
    • Vue Component
    • Vue Router
    • HTTP ํ†ต์‹ 
    • Template
    • Single File Component
    • Vue Animation
    • Vuex
    • Djnago์™€ ์—ฐ๋™ํ•˜๊ธฐ
  • Backbone.js
    • Model
    • Collection
    • Sync
    • view
  • Node.js
    • Doit! - ๋…ธ๋“œ๋กœ ๋งŒ๋“ค ์ˆ˜ ์žˆ๋Š” ๋Œ€ํ‘œ์ ์ธ ์„œ๋ฒ„์™€ ์šฉ๋„
    • Doit! - ๋…ธ๋“œ์— ๋Œ€ํ•ด ์•Œ์•„๋ณด๊ณ  ๊ฐœ๋ฐœ ๋„๊ตฌ ์„ค์น˜ํ•˜๊ธฐ
    • Doit! - ๋…ธ๋“œ ๊ฐ„๋‹จํ•˜๊ฒŒ ์‚ดํŽด๋ณด๊ธฐ
    • Doit! - ๋…ธ๋“œ์˜ ์ž๋ฐ”์Šคํฌ๋ฆฝํŠธ์™€ ์นœํ•ด์ง€๊ธฐ
    • Doit! - ๋…ธ๋“œ์˜ ๊ธฐ๋ณธ ๊ธฐ๋Šฅ ์•Œ์•„๋ณด๊ธฐ
    • Doit! - ์›น ์„œ๋ฒ„ ๋งŒ๋“ค๊ธฐ
    • Doit! - ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ์‚ฌ์šฉํ•˜๊ธฐ
    • Doit! - ์ต์Šคํ”„๋ ˆ์Šค ํ”„๋กœ์ ํŠธ๋ฅผ ๋ชจ๋“ˆํ™”ํ•˜๊ธฐ
    • Doit! - ๋ทฐ ํ…œํ”Œ๋ฆฟ ์ ์šฉํ•˜๊ธฐ
    • Doit! - ํŒจ์ŠคํฌํŠธ๋กœ ์‚ฌ์šฉ์ž ์ธ์ฆํ•˜๊ธฐ
    • Doit! - ์ฑ„ํŒ…์„œ๋ฒ„ ๋งŒ๋“ค๊ธฐ
    • Doit! - JSON-RPC ์„œ๋ฒ„ ๋งŒ๋“ค๊ธฐ
  • Python
    • Warning-Could not import the lzma module
    • Pandas
      • Pandas ์ž๋ฃŒ๊ตฌ์กฐ
      • Pandas ๋ฐ์ดํ„ฐ ์ž…์ถœ๋ ฅ
      • DataFrame Data ์‚ดํŽด๋ณด๊ธฐ
      • ์‹œ๊ฐํ™” ๋„๊ตฌ - Matplotlib
  • ML
    • ์ถ”์ฒœ ์‹œ์Šคํ…œ
      • Collaborative Filtering
      • Matrix Factorization
  • Django
    • Basic
      • ํ™˜๊ฒฝ์„ค์ •
      • About Django
      • Start Django Project
      • Secret Key ๊ด€๋ฆฌํ•˜๊ธฐ
      • Settings ๋ถ„๋ฆฌํ•˜๊ธฐ
      • Django App
      • Django View & URL (1)
      • Django Model
        • MySQL ์—ฐ๋™
      • Django Admin
      • Django View & URL (2)
      • Django Template
      • Django Template & View & URL
      • Django Static
      • Django form
    • Advanced
      • Django Generic View
      • Django Automated Testing
      • Django Extenstion Template
      • Django Model Package
      • Django OpenSSL setting
    • REST framework
      • Rest API
      • Serializers
      • ViewSet
    • Error
      • ํ™˜๊ฒฝ์„ค์ • zlib ์˜ค๋ฅ˜๋ฐœ์ƒ
      • ModuleNotFoundError
    • ํŒจํ‚ค์ง€
      • django-debug-toolbar
    • Vue.js ์—ฐ๋™ํ•˜๊ธฐ
  • Ruby
    • variable & input/output
    • ์กฐ๊ฑด๋ฌธ
    • ๋ฐ˜๋ณต๋ฌธ
    • Array & Hash
    • Method
    • Proc&Lamda
    • Class
  • Ruby on Rails
    • Scaffolding
    • Controller
    • Model
    • Model-M:N relation
    • Model Validation
    • ๋ฉ‹์‚ฌ 10์ฃผ์ฐจ ์ˆ˜์—…(Tip)
  • HTML/CSS
    • Udacity - Intro to HTML/CSS
    • Udacity - Responsive Web Design
    • Udacity - Responsive Images
    • HTML Basic
    • CSS Basic
    • HTML5 Sementic Tag
    • HTML ํ…์ŠคํŠธ ๊ด€๋ จ ํƒœ๊ทธ๋“ค
    • HTML5 ๋ฉ€ํ‹ฐ๋ฏธ๋””์–ด
    • HTML ํผ ๊ด€๋ จ ํƒœ๊ทธ๋“ค
    • ํ…์ŠคํŠธ ๊ด€๋ จ ์Šคํƒ€์ผ
    • ์ƒ‰์ƒ๊ณผ ๋ฐฐ๊ฒฝ์„ ์œ„ํ•œ ์Šคํƒ€์ผ
    • ๋ ˆ์ด์•„์›ƒ์„ ์œ„ํ•œ ์Šคํƒ€์ผ
    • CSS ํฌ์ง€์…”๋‹
    • ๋‹ค์žฌ๋‹ค๋Šฅํ•œ CSS3 ์„ ํƒ์ž
    • CSS์™€ ์• ๋‹ˆ๋ฉ”์ด์…˜
    • ๋ฐ˜์‘ํ˜• ์›น์ด๋ž€?
  • OS(์šด์˜์ฒด์ œ)
    • Linux
      • Daemon
      • Cron
      • ํ”„๋กœ์„ธ์Šค ๊ด€๋ จ ๋ช…๋ น์–ด
      • ํ…์ŠคํŠธ ํŒŒ์ผ ๋ช…๋ น์–ด
  • Network
    • ๋„คํŠธ์›Œํฌ ๊ธฐ๋ณธ ๊ฐœ๋…
    • ๋„คํŠธ์›Œํฌ ๊ธฐ๋ณธ ๊ทœ์น™
    • ๋ฌผ๋ฆฌ ๊ณ„์ธต
    • ๋ฐ์ดํ„ฐ ๋งํฌ ๊ณ„์ธต
    • ๋„คํŠธ์›Œํฌ ๊ณ„์ธต
    • ์ „์†ก ๊ณ„์ธต
    • ์‘์šฉ ๊ณ„์ธต
    • ๋„คํŠธ์›Œํฌ ์ „์ฒด ํ๋ฆ„
    • ๋ฌด์„  ๋žœ
  • IT ๊ธฐํƒ€์ง€์‹
    • NAS๋ž€
Powered by GitBook
On this page
  • ๋ชจ๋ธ ํด๋ž˜์Šค ์ƒ์„ฑ
  • ๋งˆ์ด๊ทธ๋ ˆ์ด์…˜ ํŒŒ์ผ๋กœ ํ…Œ์ด๋ธ” ์ƒ์„ฑ
  • ๋ฐ์ดํ„ฐ ์ถ”์ถœ
  • 1. Primary Key๋กœ ๊ฒ€์ƒ‰์„ ํ•œ๋‹ค. (find)
  • 2. ์ž„์˜์˜ ํ•„๋“œ๋กœ ๊ฒ€์ƒ‰(find_by)
  • 3. ์ง€์ •ํ•œ ํ•„๋“œ ๋ฐ์ดํ„ฐ๋ฅผ ๋ฐฐ์—ด ์ถ”์ถœ(pluck(column, ... ))
  • 4. ๋ฐ์ดํ„ฐ ์กด์žฌํ™•์ธ(exists?)
  • 5. Named Scope(์ด๋ฆ„์žˆ๋Š” ์Šค์ฝ”ํ”„)
  • 6. ๊ธฐ๋ณธ์Šค์ฝ”ํ”„ ์ •์˜(default_scope exp)
  • 7. ์กฐ๊ฑด์— ๋งž๋Š” ๋ ˆ์ฝ”๋“œ ์ˆ˜ ์ถ”์ถœ(count)
  • ํ‰๊ท (average(col)) / ์ตœ์†Œ(minimum(col)) / ์ตœ๋Œ€(maximum(col)) / ํ•ฉ (sum(col))
  • ๊ฒ€์ƒ‰์ฒ˜๋ฆฌ - ์ฟผ๋ฆฌ ๋ฉ”์„œ๋“œ
  • ๋ ˆ์ฝ”๋“œ ์ถ”๊ฐ€ / ์ˆ˜์ • / ์ œ๊ฑฐ
  • ์—ฌ๋Ÿฌ๊ฐœ ๋ ˆ์ฝ”๋“œ ํ•œ๋ฒˆ์— ์ˆ˜์ •(update_all(updates))
  • ๋ ˆ์ฝ”๋“œ ์ œ๊ฑฐ(destroy / delete / destroy_all(cond))
  • ํŠธ๋žœ์žญ์…˜ ์ฒ˜๋ฆฌ(transaction)
  • ์ถฉ๋Œ : ๋™์‹œ์— ์ˆ˜์ •ํ•˜๋Š” ๊ฒฝ์šฐ์— ๋ฐœ์ƒ
  • ์šฉ์–ด์ •๋ฆฌ

Was this helpful?

  1. Ruby on Rails

Model

๋ชจ๋ธ ํด๋ž˜์Šค ์ƒ์„ฑ

rails generate model name field:type

์ข…๋ฅ˜

์„ค๋ช…

์˜ˆ

๋ชจ๋ธ ํด๋ž˜์Šค

์ฒซ ๊ธ€์ž ๋Œ€๋ฌธ์ž,๋‹จ์ˆ˜ํ˜•

Book

๋ชจ๋ธ ํด๋ž˜์Šค ํŒŒ์ผ ์ด๋ฆ„

์ฒซ๊ธ€์ž ์†Œ๋ฌธ์ž, ๋‹จ์ˆ˜ํ˜•

book.rb

ํ…Œ์ด๋ธ”

์ฒซ๊ธ€์ž ์†Œ๋ฌธ์ž, ๋ณต์ˆ˜ํ˜•

books

ํ…Œ์ŠคํŠธ ์Šคํฌ๋ฆฝํŠธ

xxxx_test.rb(์ฒซ๊ธ€์ž ์†Œ๋ฌธ์ž,๋‹จ์ˆ˜ํ˜•)

book_test.rb

๋งˆ์ด๊ทธ๋ ˆ์ด์…˜ ํŒŒ์ผ๋กœ ํ…Œ์ด๋ธ” ์ƒ์„ฑ

๋งˆ์ด๊ทธ๋ ˆ์ด์…˜ : ํ…Œ์ด๋ธ” ๋ ˆ์ด์•„์›ƒ์„ ์ƒ์„ฑ ๋˜๋Š” ๋ณ€๊ฒฝํ•˜๊ธฐ ์œ„ํ•œ ๊ตฌ์กฐ.

rails dbconsoleor rails db์„ ์‚ฌ์šฉํ•˜๋ฉด config/database.yml์— ์ •์˜๋œ ์ •๋ณด๋ฅผ ๊ธฐ๋ฐ˜์œผ๋กœ ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ํด๋ผ์ด์–ธํŠธ๋ฅผ ์‹คํ–‰ํ•  ์ˆ˜ ์žˆ๋‹ค.

.tables : ํ…Œ์ด๋ธ” ๋ชฉ๋กํ‘œ์‹œ .schema books : booksํ…Œ์ด๋ธ”์˜ ๊ตฌ์กฐํ™•์ธ select*from books; : booksํ…Œ์ด๋ธ”๋‚ด์šฉํ™•์ธ

์ด๋•Œ ์ด์˜๊ฒŒ ๋ณด๊ณ ์‹ถ๋‹ค๋ฉด .headers on .mode columns๋ฅผ ํ•ด์ฃผ๋ฉด ๋œ๋‹ค.

.exit or .quit : ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ํด๋ผ์ด์–ธํŠธ ์ข…๋ฃŒ

๋ฐ์ดํ„ฐ ์ถ”์ถœ

1. Primary Key๋กœ ๊ฒ€์ƒ‰์„ ํ•œ๋‹ค. (find)

find(keys) keys:์ฃผ ํ‚ค(๋ฐฐ์—ด๋กœ ์ง€์ •ํ•  ์ˆ˜๋„ ์žˆ๋‹ค.)

2. ์ž„์˜์˜ ํ•„๋“œ๋กœ ๊ฒ€์ƒ‰(find_by)

:๊ฒ€์ƒ‰ ์กฐ๊ฑด์œผ๋กœ ๊ฐ€์žฅ ์ฒ˜์Œ ๊ฒ€์ƒ‰๋˜๋Š” ๋ ˆ์ฝ”๋“œ๋ฅผ ์ถ”์ถœํ•œ๋‹ค. find_by key: value [, ... ]

find_by๊ฐ€ ๋ฆฌํ„ดํ•˜๋Š” ๋ฐ์ดํ„ฐ๋Š” ํ•ญ์ƒ ํ•˜๋‚˜์ด๋‹ค. ๊ทธ๋Ÿฌ๋ฏ€๋กœ ํ…Œ์ด๋ธ” ์กฐ๊ฑด์— ๋งž๋Š” ๋ ˆ์ฝ”๋“œ๊ฐ€ ํ•˜๋‚˜๋งŒ ์žˆ์„๋•Œ๋งŒ ์‚ฌ์šฉํ•œ๋‹ค.

3. ์ง€์ •ํ•œ ํ•„๋“œ ๋ฐ์ดํ„ฐ๋ฅผ ๋ฐฐ์—ด ์ถ”์ถœ(pluck(column, ... ))

: ์—ฌ๋Ÿฌ๊ฐœ์˜ ํ•„๋“œ๋ฅผ ์ง€์ •ํ•ด์„œ ์ถ”์ถœํ•˜๋Š” ๊ฒƒ์ด ๊ฐ€๋Šฅํ•ด์กŒ๋‹ค.

ex) Book.where(publish: '์ œ์ดํŽ').pluck(:title, :price)

4. ๋ฐ์ดํ„ฐ ์กด์žฌํ™•์ธ(exists?)

: ๋ฐ์ดํ„ฐ๋ฅผ ์ถ”์ถœํ•˜์ง€ ์•Š๊ณ  ์ง€์ •๋œ ๋ฐ์ดํ„ฐ๊ฐ€ ์žˆ๋Š”์ง€ ์—†๋Š”์ง€ ์ •๋„๋งŒ ํ™•์ธํ•˜๊ณ  ์‹ถ์„๋•Œ.

5. Named Scope(์ด๋ฆ„์žˆ๋Š” ์Šค์ฝ”ํ”„)

scope name , -> {exp} : ํŠน์ •ํ•œ ์กฐ๊ฑด์‹ ๋˜๋Š” ์ •๋ ฌ์‹์„ ๋ฏธ๋ฆฌ ๋ชจ๋ธ์ชฝ์— ์ด๋ฆ„์„ ๋ถ™์—ฌ ์ €์žฅํ•ด๋‘๊ณ , ํ›„์— ์ด์šฉํ•˜๊ณ  ์‹ถ์„๋•Œ ์ด๋ฆ„์„ ํ˜ธ์ถœํ•ด์„œ ์‚ฌ์šฉํ•œ๋‹ค.

ex)

 scope :top10, -> {newer.limit(10)}

6. ๊ธฐ๋ณธ์Šค์ฝ”ํ”„ ์ •์˜(default_scope exp)

: ๋ชจ๋ธ ๊ด€๋ จ ๋ฉ”์„œ๋“œ๋ฅผ ํ˜ธ์ถœํ•  ๋•Œ ์ž๋™์œผ๋กœ ์กฐ๊ฑด์ด ์ ์šฉ๋˜๊ฒŒํ•˜๋Š” ๊ธฐ๋ณธ์Šค์ฝ”ํ”„

ex)

default_scope{order(updated_at: :desc)}

7. ์กฐ๊ฑด์— ๋งž๋Š” ๋ ˆ์ฝ”๋“œ ์ˆ˜ ์ถ”์ถœ(count)

: ํŠน์ • ์กฐ๊ฑด์— ๋งž๋Š” ๊ฒฐ๊ณผ ์ง‘ํ•ฉ ๊ฐœ์ˆ˜๋ฅผ ์ถ”์ถœํ•  ๋•Œ ์‚ฌ์šฉ.

ex)

Book.where(school: 'konkuk').count

ํ‰๊ท (average(col)) / ์ตœ์†Œ(minimum(col)) / ์ตœ๋Œ€(maximum(col)) / ํ•ฉ (sum(col))

๊ฒ€์ƒ‰์ฒ˜๋ฆฌ - ์ฟผ๋ฆฌ ๋ฉ”์„œ๋“œ

:find, find_by ๋ฉ”์„œ๋“œ์™€ ๋‹ค๋ฅด๊ฒŒ ํ˜ธ์ถœํ•˜๋Š” ์‹œ์ ์—๋Š” ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค์— ์ ‘๊ทผํ•˜์ง€ ์•Š๋Š”๋‹ค. ์ดํ›„์— ์ฟผ๋ฆฌ ๊ฒฐ๊ณผ๊ฐ€ ํ•„์š”ํ•œ ์‹œ์ ์— ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค์— ์ ‘๊ทผํ•œ๋‹ค. (์ง€์—ฐ๋กœ๋“œ(Lazy Load))

1.where

  • where(exp) : ๊ธฐ๋ณธ์ ์ธ ์กฐ๊ฑด์‹ (exp๋Š” ์กฐ๊ฑด์‹์„ ๋‚˜ํƒ€๋‚ด๋Š” ํ•ด์‹œ)

    ex) @books = Book.where(name: 'dahye') where์—์„œ AND๋Š” ,, BETWEEN ์€ .., IN์€ name: [dahye, miyoen]์„ ํ†ตํ•ด์„œ ์—ฌ๋Ÿฌ๊ฐ€์ง€ ์กฐ๊ฑด์„ ํ•œ๋ฒˆ์— ๊ฒ€์ƒ‰ํ•  ์ˆ˜ ์žˆ๋‹ค.

  • where((exp [value, ... ]) : placeholder(๋งค๊ฐœ ๋ณ€์ˆ˜๋ฅผ ๋‘๋Š” ์žฅ์†Œ)๋ฅผ ์ด์šฉํ•œ ์กฐ๊ฑด์‹.

2.not : ๋ถ€์ •์กฐ๊ฑด์‹

ex) Book.where.not(isbn: parmas[:id])

3.order(sort) : ๋ฐ์ดํ„ฐ์ •๋ ฌ

4.redorder : ๋ฐ์ดํ„ฐ ์žฌ์ •๋ ฌ

5.select(cols) : ์ถ”์ถœํ•  ํ•„๋“œ ๋ช…์‹œ์  ์ง€์ •

6.distinct([flag]) : ์ค‘๋ณต๋˜์ง€ ์•Š๋Š” ๋ ˆ์ฝ”๋“œ ์ถ”์ถœ(์ค‘๋ณต์ œ๊ฑฐ)

7.limit(rows) / offset(off) : ์ง€์ •๋ฒ”์œ„ ๋ ˆ์ฝ”๋“œ ์ถ”์ถœ

8.first/ last : ์ฒซ ๋ ˆ์ฝ”๋“œ / ๋งˆ์ง€๋ง‰ ๋ ˆ์ฝ”๋“œ ์ถ”์ถœ

9.group(key) : ๋ฐ์ดํ„ฐ ๊ทธ๋ฃนํ™”(ํŠน์ •ํ•œ ํ‚ค๋กœ ๋ฐ์ดํ„ฐ๋ฅผ ๊ทธ๋ฃนํ™”ํ•˜๊ณ  ์‹ถ์€ ๊ฒฝ์šฐ

10.having(exp, [,value, ... ]) : ๊ทธ๋ฃนํ™”ํ•œ ๊ฒฐ๊ณผ์— ์ถ”๊ฐ€ ์กฐ๊ฑด

11.! : ๋์— !๋ฅผ ๋ถ™์—ฌ ์กฐ๊ฑด์‹์„ ์—ฌ๋Ÿฌ๊ฐœ์˜ ์ค„์—๊ฑธ์ณ ๋‹จ๊ณ„์ ์œผ๋กœ ์ ์šฉํ•˜๋Š”๊ฒŒ ๊ฐ€๋Šฅํ•ด์ง.

12.unscope(skips) : ์ฟผ๋ฆฌ๋กœ ๋งŒ๋“  ์กฐ๊ฑด์ œ๊ฑฐ

13.none : ์•„๋ฌด๊ฒƒ๋„ ์—†๋Š” ๊ฒฐ๊ณผ

๋ ˆ์ฝ”๋“œ ์ถ”๊ฐ€ / ์ˆ˜์ • / ์ œ๊ฑฐ

์—ฌ๋Ÿฌ๊ฐœ ๋ ˆ์ฝ”๋“œ ํ•œ๋ฒˆ์— ์ˆ˜์ •(update_all(updates))

ex)

Book.where(publish: 'ํ•œ๋น›๋ฏธ๋””์–ด').update_all(publish: 'jpub')

๋ ˆ์ฝ”๋“œ ์ œ๊ฑฐ(destroy / delete / destroy_all(cond))

: destroy๋Š” SELECT -> DELETE ์ˆœ์„œ, delete๋Š” DELETE๋งŒ ํ˜ธ์ถœํ•œ๋‹ค. ์ด๋Ÿฌํ•œ ์ฐจ์ด๋กœ association or callback ๊ธฐ๋Šฅ์— ์ฐจ์ด๊ฐ€ ๋‚œ๋‹ค. ๊ฐ„๋‹จํ•˜๊ฒŒ ๋ฐ์ดํ„ฐ ์ œ๊ฑฐ๋งŒ ํ•  ๋•Œ๋Š” delete๋ฅผ ์‚ฌ์šฉํ•˜๋Š”๊ฒŒ ์ข‹๋‹ค.

: destroy_all์€ ํŠน์ •์กฐ๊ฑด์— ๋งž๋Š” ๋ ˆ์ฝ”๋“œ๋ฅผ ํ•œ๊บผ๋ฒˆ์— ์ œ๊ฑฐํ• ๋•Œ ์‚ฌ์šฉ.

ํŠธ๋žœ์žญ์…˜ ์ฒ˜๋ฆฌ(transaction)

: ๋ชจ๋“  ๋ช…๋ น์–ด์˜ ์„ฑ๊ณต, ์‹คํŒจ๋ฅผ ํ•œ๊บผ๋ฒˆ์— ๋ชจ์•„์„œ ์ฒ˜๋ฆฌํ•˜๋Š” ๊ฒƒ์ด๋‹ค. ๋งŒ์•ฝ ํ•œ๊ฐœ๋ผ๋„ ์‹คํŒจํ•œ๋‹ค๋ฉด ํŠธ๋žœ์žญ์…˜ ์ฒ˜๋ฆฌ๋„ ์‹คํŒจํ•˜๊ณ  ์ด๋•Œ๊นŒ์ง€ ์‹คํ–‰๋๋˜ ๋ชจ๋“  ๋ช…๋ น์•„๊ฐ€ ๋ฌดํšจํ™”๋œ๋‹ค.

  • commmit : ํŠธ๋žœ์žญ์…˜ ์ฒ˜๋ฆฌ๋ฅผ ํ™•์ •ํ•˜๋Š” ๊ฒƒ

  • Rollback : ์ฒ˜๋ฆฌ๋ฅผ ์‹คํŒจํ•ด ํŠธ๋žœ์žญ์…˜ ์ƒํƒœ๋ฅผ ๋˜๋Œ๋ฆฌ๋Š”๊ฒƒ.

  • ํŠธ๋žœ์žญ์…˜ ๋ถ„๋ฆฌ ๋ ˆ๋ฒจ : ์—ฌ๋Ÿฌ๊ฐœ์˜ ํŠธ๋žœ์žญ์…˜์„ ๋™์‹œ ์‹คํ–‰ํ•œ ๊ฒฝ์šฐ์— ๋™์ž‘์„ ํ‘œ์‹œ. ๋ถ„๋ฆฌ ๋ ˆ๋ฒจ์ด ๋†’์œผ๋ฉด ๊ทธ๋งŒํผ ๋ฐ์ดํ„ฐ์˜ ์ •ํ•ฉ์„ฑ์€ ๋†’์•„์ง€์ง€๋งŒ ์‹คํ–‰์„ฑ์€ ๋‚ฎ์•„์ง„๋‹ค.

์ถฉ๋Œ : ๋™์‹œ์— ์ˆ˜์ •ํ•˜๋Š” ๊ฒฝ์šฐ์— ๋ฐœ์ƒ

  1. ํ…Œ์ด๋ธ”์— lock_version์ถ”๊ฐ€

  2. ๋™์‹œ์‹คํ–‰์ œ์–ด์ค€๋น„

  3. ์‹คํ–‰์ œ์–ด ์ž‘๋™ํ™•์ธ

  4. ์˜ˆ์™ธ๊ฒ€์ถœ๋œ ๊ฒฝ์šฐ์˜ ์ฒ˜๋ฆฌ

์šฉ์–ด์ •๋ฆฌ

rake db:seed : ์‹œ๋“œํŒŒ์ผ์„ ์ด์šฉํ•ด์„œ ๋ฐ์ดํ„ฐ๋ฅผ ์ดˆ๊ธฐํ™”ํ•˜๋Š” ๋ช…๋ น์–ด์ด๋‹ค. rake db:drop : ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ํŒŒ์ผ ์‚ญ์ œ

PreviousControllerNextModel-M:N relation

Last updated 4 years ago

Was this helpful?