안녕하세요. 강의 너무 잘 듣고 있습니다. 아래 코드가 대충 어떤 의미인지는 이해가 가는데 정확히 알고 싶어서요. 아래 코드 해석 좀 해주실 수 있을까요? # 5. Stopwords 불용어 제거 meaningful_words = [ w for w in words if not w in stops ] # 6. 어간추출 stemming_words = [ stemmer . stem ( w ) for w in meaningful_words ]
안녕하세요 선생님. 좋은 강의 잘 듣고 있습니다. orderV3_page() 함수를 생성해보고 query를 돌려보다가 문득 궁금증이 생겨 질문 드립니다. ################################시스템 로그 시작################################### select order0_.order_id as order_id1_6_0_, member1_.member_id as member_i1_4_1_, delivery2_.delivery_id as delivery1_2_2_, order0_.delivery_id as delivery4_6_0_, order0_.member_id as member_i5_6_0_, order0_.order_date as order_da2_6_0_, order0_.status as status3_6_0_, member1_.city as city2_4_1_, member1_.street as street3_4_1_, member1_.zipcode as zipcode4_4_1_, member1_.name as name5_4_1_, delivery2_.city as city2_2_2_, delivery2_.street as street3_2_2_, delivery2_.zipcode as zipcode4_2_2_, delivery2_.status as status5_2_2_ from orders order0_ inner join member member1_ on order0_.member_id=member1_.member_id inner join delivery delivery2_ on order0_.delivery_id=delivery2_.delivery_id limit ? 2020-03-22 18:52:21.584 INFO 22089 --- [nio-8080-exec-2] p6spy : #1584870741584 | took 1ms | statement | connection 14| url jdbc:h2:tcp://localhost/~/jpashop select order0_.order_id as order_id1_6_0_, member1_.member_id as member_i1_4_1_, delivery2_.delivery_id as delivery1_2_2_, order0_.delivery_id as delivery4_6_0_, order0_.member_id as member_i5_6_0_, order0_.order_date as order_da2_6_0_, order0_.status as status3_6_0_, member1_.city as city2_4_1_, member1_.street as street3_4_1_, member1_.zipcode as zipcode4_4_1_, member1_.name as name5_4_1_, delivery2_.city as city2_2_2_, delivery2_.street as street3_2_2_, delivery2_.zipcode as zipcode4_2_2_, delivery2_.status as status5_2_2_ from orders order0_ inner join member member1_ on order0_.member_id=member1_.member_id inner join delivery delivery2_ on order0_.delivery_id=delivery2_.delivery_id limit ? select order0_.order_id as order_id1_6_0_, member1_.member_id as member_i1_4_1_, delivery2_.delivery_id as delivery1_2_2_, order0_.delivery_id as delivery4_6_0_, order0_.member_id as member_i5_6_0_, order0_.order_date as order_da2_6_0_, order0_.status as status3_6_0_, member1_.city as city2_4_1_, member1_.street as street3_4_1_, member1_.zipcode as zipcode4_4_1_, member1_.name as name5_4_1_, delivery2_.city as city2_2_2_, delivery2_.street as street3_2_2_, delivery2_.zipcode as zipcode4_2_2_, delivery2_.status as status5_2_2_ from orders order0_ inner join member member1_ on order0_.member_id=member1_.member_id inner join delivery delivery2_ on order0_.delivery_id=delivery2_.delivery_id limit 100; 2020-03-22 18:52:21.619 DEBUG 22089 --- [nio-8080-exec-2] org.hibernate.SQL : select orderitems0_.order_id as order_id5_5_1_, orderitems0_.order_item_id as order_it1_5_1_, orderitems0_.order_item_id as order_it1_5_0_, orderitems0_.count as count2_5_0_, orderitems0_.item_id as item_id4_5_0_, orderitems0_.order_id as order_id5_5_0_, orderitems0_.order_price as order_pr3_5_0_ from order_item orderitems0_ where orderitems0_.order_id in ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) 2020-03-22 18:52:21.621 INFO 22089 --- [nio-8080-exec-2] p6spy : #1584870741621 | took 0ms | statement | connection 14| url jdbc:h2:tcp://localhost/~/jpashop select orderitems0_.order_id as order_id5_5_1_, orderitems0_.order_item_id as order_it1_5_1_, orderitems0_.order_item_id as order_it1_5_0_, orderitems0_.count as count2_5_0_, orderitems0_.item_id as item_id4_5_0_, orderitems0_.order_id as order_id5_5_0_, orderitems0_.order_price as order_pr3_5_0_ from order_item orderitems0_ where orderitems0_.order_id in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) select orderitems0_.order_id as order_id5_5_1_, orderitems0_.order_item_id as order_it1_5_1_, orderitems0_.order_item_id as order_it1_5_0_, orderitems0_.count as count2_5_0_, orderitems0_.item_id as item_id4_5_0_, orderitems0_.order_id as order_id5_5_0_, orderitems0_.order_price as order_pr3_5_0_ from order_item orderitems0_ where orderitems0_.order_id in (4, 11, 18, 25, 32, 39, 46, 53, 60, 67); 2020-03-22 18:52:21.641 DEBUG 22089 --- [nio-8080-exec-2] org.hibernate.SQL : select item0_.item_id as item_id2_3_0_, item0_.name as name3_3_0_, item0_.price as price4_3_0_, item0_.stock_quantity as stock_qu5_3_0_, item0_.author as author6_3_0_, item0_.isbn as isbn7_3_0_, item0_.actor as actor8_3_0_, item0_.director as director9_3_0_, item0_.artist as artist10_3_0_, item0_.etc as etc11_3_0_, item0_.dtype as dtype1_3_0_ from item item0_ where item0_.item_id in ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) 2020-03-22 18:52:21.643 INFO 22089 --- [nio-8080-exec-2] p6spy : #1584870741643 | took 0ms | statement | connection 14| url jdbc:h2:tcp://localhost/~/jpashop select item0_.item_id as item_id2_3_0_, item0_.name as name3_3_0_, item0_.price as price4_3_0_, item0_.stock_quantity as stock_qu5_3_0_, item0_.author as author6_3_0_, item0_.isbn as isbn7_3_0_, item0_.actor as actor8_3_0_, item0_.director as director9_3_0_, item0_.artist as artist10_3_0_, item0_.etc as etc11_3_0_, item0_.dtype as dtype1_3_0_ from item item0_ where item0_.item_id in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) select item0_.item_id as item_id2_3_0_, item0_.name as name3_3_0_, item0_.price as price4_3_0_, item0_.stock_quantity as stock_qu5_3_0_, item0_.author as author6_3_0_, item0_.isbn as isbn7_3_0_, item0_.actor as actor8_3_0_, item0_.director as director9_3_0_, item0_.artist as artist10_3_0_, item0_.etc as etc11_3_0_, item0_.dtype as dtype1_3_0_ from item item0_ where item0_.item_id in (2, 3, 9, 10, 16, 17, 23, 24, 30, 31, 37, 38, 44, 45, 51); 2020-03-22 18:52:21.654 DEBUG 22089 --- [nio-8080-exec-2] org.hibernate.SQL : select item0_.item_id as item_id2_3_0_, item0_.name as name3_3_0_, item0_.price as price4_3_0_, item0_.stock_quantity as stock_qu5_3_0_, item0_.author as author6_3_0_, item0_.isbn as isbn7_3_0_, item0_.actor as actor8_3_0_, item0_.director as director9_3_0_, item0_.artist as artist10_3_0_, item0_.etc as etc11_3_0_, item0_.dtype as dtype1_3_0_ from item item0_ where item0_.item_id in ( ?, ?, ?, ?, ? ) 2020-03-22 18:52:21.656 INFO 22089 --- [nio-8080-exec-2] p6spy : #1584870741656 | took 0ms | statement | connection 14| url jdbc:h2:tcp://localhost/~/jpashop select item0_.item_id as item_id2_3_0_, item0_.name as name3_3_0_, item0_.price as price4_3_0_, item0_.stock_quantity as stock_qu5_3_0_, item0_.author as author6_3_0_, item0_.isbn as isbn7_3_0_, item0_.actor as actor8_3_0_, item0_.director as director9_3_0_, item0_.artist as artist10_3_0_, item0_.etc as etc11_3_0_, item0_.dtype as dtype1_3_0_ from item item0_ where item0_.item_id in (?, ?, ?, ?, ?) select item0_.item_id as item_id2_3_0_, item0_.name as name3_3_0_, item0_.price as price4_3_0_, item0_.stock_quantity as stock_qu5_3_0_, item0_.author as author6_3_0_, item0_.isbn as isbn7_3_0_, item0_.actor as actor8_3_0_, item0_.director as director9_3_0_, item0_.artist as artist10_3_0_, item0_.etc as etc11_3_0_, item0_.dtype as dtype1_3_0_ from item item0_ where item0_.item_id in (52, 58, 59, 65, 66); 위의 로그를 보시면 item에 in query가 15개에서 끊기고, 나머지 5개에 대하여 다시 쿼리를 날려주는데, 원래 이렇게 끊기는게 정상일까요? ################################시스템 로그 끝################################### 여기서 궁금한 점은 실제 쿼리에서는 한번에 20개에 대해서 in query를 날려주는데 (3) 1) p6spy log 찍힐때만 15개 단위로 짤라져서 찍히는건지, - 이렇게 생각한 이유는 ``` "name": "decorator.datasource.flexy-pool.acquiring-strategy.increment-pool.max-overflow-pool-size", "type": "java.lang.Integer", "sourceType": "com.github.gavlyukovskiy.boot.jdbc.decorator.flexypool.FlexyPoolProperties$AcquiringStrategy$IncrementPool", "defaultValue": 15 ``` 라는 옵션을 찾아서 입니다. 2) 아니면 실제로 h2 db에도 쿼리가 2번 쪼개져서 나가는지 궁금합니다. - 실제로 h2가 전달받는 쿼리를 보고 싶은데 확인할 방법을 찾지 못하였습니다. 3) 아니면 HikariCP 커넥션 풀이 10개가 max라고 알고있는데 이런 커넥션 pool 갯수랑 상관이 있을까요? - 이렇게 생각한 이유는 2020-03-22 18:52:21.656 INFO 22089 --- [ nio-8080-exec-2 ] p6spy : #1584870741656 | took 0ms | statement | connection 15| url jdbc:h2:tcp://localhost/~/jpashop 에서 connection 갯수가 15라고 확인을 했어서 입니다. **결론: 왜 item 쿼리가 16번째에서 쪼개져서 한번 더 보내질까요?
안녕하세요 자동 로그인을 구현해보려고 하는데 몇주째 안되고 있어서 질문 드립니다.. 계정 정보를 쿠키에 암호화하여 저장해서 자동 로그인을 구현하려고 하고 있습니다. useEffect 에서 쿠키 확인 후에 dispatch 시키면 로그인 쿠키도 잘 넘어오고 정상적으로 로그인이 되는데요, SSR에서 구현하려고 _app.js 에 getInitialProps 안에 코드를 넣으면 될 것 같아서 const auto = ctx . req . cookies . auto ? JSON . parse ( ctx . req . cookies . auto ) : null ; ctx . store . dispatch ({ type : LOG_IN_REQUEST , data : { auto. email , auto. password } }); 대략 이런식으로 넣어서 사용하려고 했는데 유저 정보는 넘겨 받지만 서버쪽이나 브라우저에서 로그인을 인식하지 못하고 로그인 쿠키값도 넘어오지 않아서 axios.defaults.withCredentials = true; 이 값을 넣어도 안되더라구요.. 1. 이 방법이 잘 못된 방법인가요?.. 2. express session에서 쿠키값을 넘겨받지 못하고 로그인 되지 않는 이유가 무엇인가요?..
안녕하세요. 공부를 하다가 누군가에게 hibernate or JPA를 사용해보았냐는 질문을 받았습니다. JPA는 사용을 해보았다고 대답을 했으나 hibernate를 사용해봤는지 판단을 할 수 없었습니다. 그래서 찾아보니 hibernate와 JPA의 차이점을 찾아봤으나 hibernate는 JPA를 구현한것이다. 라는 답변을 찾을 수 있었으나 제가 이해한것이 맞는지 틀린지 판단을 할 수 없어서 질문드립니다. 1. entity를 설계하고 public interface MemberRepository extends JpaRepository<Member , Long> 와같이 JpaRepository를 구현했다 -> JPA를 사용 2. entity를 설계하고 entityManager를 활용하였다 -> hibernate 라고 이해를 하였습니다. 맞게 이해한것인가요 ?
if ( dataSet [ 줄 ][ 칸 ] === 'x' ) { e . currentTarget . textContent = '쾅!' ; alert ( '지뢰를 밟았습니다. Game Over!!' ); } else { let 주변 = [ dataSet [ 줄 ][ 칸 - 1 ], dataSet [ 줄 ][ 칸 + 1 ], ]; if ( dataSet [ 줄 - 1 ]) { 주변 = 주변 . concat ([ dataSet [ 줄 - 1 ][ 칸 - 1 ], dataSet [ 줄 - 1 ][ 칸 ], dataSet [ 줄 - 1 ][ 칸 + 1 ]]); } if ( dataSet [ 줄 + 1 ]) { 주변 = 주변 . concat ([ dataSet [ 줄 + 1 ][ 칸 - 1 ], dataSet [ 줄 + 1 ][ 칸 ], dataSet [ 줄 + 1 ][ 칸 + 1 ]]); } e . currentTarget . textContent = 주변 . filter (( e ) => { return e === 'x' ; }). length ; console . log ( 주변 ); } 여기서 줄의 경우에는 -1이 들어가면 에러가 뜨는데 칸의 경우는 -1이 들어가면 undefined이 뜨는데 왜그런지 모르겠습니다.
안녕하세요. Todo App 실습 중 궁금증이 생겨 질문드립니다. 할 일 완료 처리를 할 때, 해당 Key에 해당하는 Value의 completed가 바뀌는 것이 아니고, 추가로 Object가 생겨 completed와 item값이 바뀝니다. 새로고침 시, 제가 입력한 1/2/3/4 외에 Object의 1이 추가로 리스트에 보여지는 문제가 발생합니다. 혹시 저만 이런 문제가 발생하는지, 어떻게 고쳐야하는지 궁금합니다. 감사합니다.
이번 예제에서는 불러오려는 데이터의 총 개수가 150개라는 것을 아는 상태에서 진행했기 때문에 for i in range(1,151): 이 가능했는데요, 만약에 모를 때에는 어떻게 코드를 넣어주어야 하나요??? len() 함수 안에 어떤 값을 넣어야 하는지 모르겠습니다. 또한 지난 수업 때 write_cell.cell(i,1,result_lists[i-1]) 를 사용했는데요. i 가 행, 1이 열이라고 알고 있습니다. 그런데 3열에 써보고 싶어서 1 대신 3을 넣었더니 1열과 3열 모두 데이터가 작성되는데요, 3열에만 작성되야 하는것이 아닌가요??? 원래 1열, 3열 모두 작성되는 것인가요?? write_cell.cell(i,1,result_lists[i-1]) 대신 write_cell.cell(i,3,result_lists[i-1])으로 하고 진행했는데 1열, 3열 모두 작성된 결과가 출력되었습니다.
def __add__(self,x): return self._price + x._price 를 하면 선언한대로 두 가지 과일의 가격을 더하는 것은 알겠는데 세 가지 과일을 설정해서 가격을 모두 더하려고 s1+s2+s3를 해보니 에러가 뜨는데 3개 이상의 과일 가격을 더하려면 저 코드를 어떻게 수정해야 될까요??