ÅؽºÆ® :: Äõ¸® :: BuildSQL.

text :: query :: buildSQLÀº SQL Äõ¸® ºô´õÀÇ ±âº» Ŭ·¡½ºÀÔ´Ï´Ù.
Áö±Ý ´Ù¿î·Îµå

ÅؽºÆ® :: Äõ¸® :: BuildSQL. ¼øÀ§ ¹× ¿ä¾à

±¤°í

  • Rating:
  • ƯÇã:
  • Perl Artistic License
  • °¡°Ý:
  • FREE
  • °Ô½ÃÀÚ À̸§:
  • Loic Dachary
  • °Ô½ÃÀÚ À¥»çÀÌÆ®:
  • http://jspoker.pokersource.info/

ÅؽºÆ® :: Äõ¸® :: BuildSQL. ű×


ÅؽºÆ® :: Äõ¸® :: BuildSQL. ¼³¸í

text :: query :: buildSQLÀº SQL Äõ¸® ºô´õÀÇ ±âº» Ŭ·¡½ºÀÔ´Ï´Ù. text :: query :: buildsqlÀº SQL Äõ¸® ºô´õÀÇ ±âº» Ŭ·¡½ºÀÔ´Ï´Ù. ½Ä ³ëÇÁ ÆÐÅ°Áö ÅؽºÆ® :: Äõ¸® :: BuildSQLSQLDB; ÅؽºÆ® :: Äõ¸® :: BuildSQL; VARS QW (@ISA)¸¦ »ç¿ëÇϽʽÿÀ. @isa = qw (text :: query :: buildSQL); ±¸¹® Æ®¸®¸¦ ºôµåÇÏ´Â ¸ðµç build_ * ÇÔ¼ö¸¦ Á¤ÀÇÇÕ´Ï´Ù. Æ®¸® ³ëµå´Â ÀÔ´Ï´Ù. build_final_expression ÇÔ¼ö´Â ÇØ°á ¹æ¹ýÀ» »ç¿ëÇÏ¿© WHERE Àý¿¡¼­ ±¸¹® Æ®¸®¸¦ º¯È¯ÇÕ´Ï´Ù. °Ë»ö ¹üÀ§°¡ ÁöÁ¤µÇÁö ¾ÊÀº °æ¿ì (½ºÄÚÇÁ ¿¬»êÀÚ°¡¾ø´Â °£´ÜÇÑ Äõ¸® ¶Ç´Â °í±Þ Äõ¸®)¿¡¼­ ¹üÀ§´Â -fields_searched ¿É¼Ç¿¡¼­ Á¦°øÇÏ´Â ½°Ç¥·Î ±¸ºÐ µÈ ÇÊµå ¸ñ·ÏÀ¸·Î ¼³Á¤µË´Ï´Ù. °á°ú WHERE ÀýÀÌ ÀÛÀº µû¿ÈÇ¥·Î µÑ·¯½Î¿©ÀÖ´Â °æ¿ì -SELECT ¿É¼Ç°ú ÇÔ²² Á¦°øµÈ ¼±Åà ¼ø¼­¿¡ Á¤È®È÷ ÀÏÄ¡ ÇؾßÇÏ´Â °æ¿ì ¼±ÅÃµÈ ¼ø¼­°¡ Á¦°øµË´Ï´Ù. ÅäÅ«Àº ÀÓÀÇÀÇ ¹®ÀÚ¿­À» ³ªÅ¸³À´Ï´Ù. ·Î µÑ·¯½ÎÀÎ ¼³¸íÀº 0 ¶Ç´Â n ¹ø ¹Ýº¹µÇ´Â °ÍÀ» ÀǹÌÇÕ´Ï´Ù. expr : '¶Ç´Â'scope expr ¹× 'scope expr 'scope expr 'scope expr'expro_literal 'forebiden'scope expr_literal 'Çʼö'¹üÀ§ expr_literal '¼±ÅÃÀû'¼±Åà ¹üÀ§ exprop_literal 'Literal'scope expro_literal : ¸®ÅÍ·² ¹üÀ§ ¹üÀ§ : methodResolve ([], q1) ÇØ´ç WHERE ÀýÀ» ¹ÝȯÇÕ´Ï´Ù. Q1 ±¸¹® TREES.SortPlusMinus ([], Q1)´Â Çʼö ¹× frobiden ±¸¹® ³ëµå¸¦ Boolean µî¿­·Î º¯È¯ÇÕ´Ï´Ù. has_relevance°¡ false¸¦ ¹ÝȯÇÏ°í Àû¾îµµ ÇϳªÀÇ Çʼö ´Ü¾î°¡ ÀÖÀ¸¸é ù ¹ø° Çʼö ´Ü¾î°¡ ¼±ÅÃÀû ´Ü¾î ¸ñ·Ï¿¡ Ãß°¡µË´Ï´Ù .HAS_RELEVANCE ()´Â °ü·Ã¼º ¼øÀ§°¡ °¡´ÉÇϸé true¸¦ ¸®ÅÏÇÕ´Ï´Ù. ±×·¸Áö ¾ÊÀº °æ¿ì´Â falseÀÔ´Ï´Ù. SortPlusMinus ÇÔ¼ö¿¡ ÀÇÇØ »ç¿ëµË´Ï´Ù. ±âº»ÀûÀ¸·Î °ÅÁþÀ» ¹ÝȯÇÕ´Ï´Ù. °ü·Ã¼º ¼øÀ§´Â ºÒ°¡´ÉÇÒ °ÍÀ̹ǷΠ°£´ÜÇÑ °Ë»öÀÇ Àǹ̰¡ ¾à°£ ¼öÁ¤µË´Ï´Ù. + A B C¸¦ ¹¯´Â °æ¿ì A¿Í (B ¶Ç´Â C)°¡ Æ÷ÇÔ µÈ ¸ðµç ¹®¼­¸¦ º¸¿©ÁÝ´Ï´Ù. Á¤»óÀûÀÎ ÇൿÀº A¸¦ Æ÷ÇÔÇÏ°íÀÖ´Â ¸ðµç ¹®¼­¸¦ ¹ÝȯÇÏ°í (b ¶Ç´Â c)¸¦ Æ÷ÇÔÇϴ ù ¹ø°¸¦ º¸¿©ÁÖ±â À§ÇØ Á¤·ÄÇÏ´Â °ÍÀÔ´Ï´Ù. °ü·Ã¼º ¼øÀ§¸¦ »ç¿ëÇÒ ¼ö¾ø´Â °æ¿ì B, C °Ë»ö ¿ë¾î´Â ¾µ¸ð°¡ ¾ø½À´Ï´Ù. ±×·¡¼­ °ü·Ã ·©Å·À̾ø´Â °æ¿ì Äõ¸®ÀÇ Àǹ̸¦ º¯°æÇϱâ·Î °áÁ¤ÇÑ ÀÌÀ¯ÀÔ´Ï´Ù. Aptions- ºôµå _Final_Expression¿¡¼­ ¹Ýȯ ÇÑ ¹®ÀÚ¿­ÀÌ ÇØ°á ÇÔ¼ö¿¡ ÀÇÇØ »ý¼º µÈ ¹®ÀÚ¿­À» »ç¿ëÇÏ¿© __where__ ű׸¦ ´ëüÇÏ´Â ¹®ÀÚ¿­À» Á¦°øÇÕ´Ï´Ù. ´ëü µÈ ¹®ÀÚ¿­Àº build_final_expressionÀÇ ¹Ýȯ °ªÀÔ´Ï´Ù. build_final_expressionÀÇ ¹Ýȯ °ªÀº ÇØ°á ÇÔ¼öÀÇ °á°úÀÔ´Ï´Ù.-fields_searched fields_listfields_list´Â ½°Ç¥·Î ±¸ºÐ µÈ Çʵå À̸§ ¸ñ·ÏÀÔ´Ï´Ù. Äõ¸® ¹®ÀÚ¿­¿¡ ¹üÀ§°¡ Á¦°øµÇÁö ¾ÊÀ¸¸é ±âº» ¹üÀ§·Î »ç¿ëµË´Ï´Ù. ÀÌ ¿É¼ÇÀÌ Á¦°øµÇÁö ¾Ê°í ¹üÀ§ ¿¬»êÀÚ°¡ »ç¿ëµÇÁö ¾ÊÀº °æ¿ì build_final_expression ÇÔ¼ö´Â croakÀÔ´Ï´Ù. ´Ù½Ã quirements : ¡¤ perl ¿ä±¸ »çÇ× : ¡¤ Perl.


ÅؽºÆ® :: Äõ¸® :: BuildSQL. °ü·Ã ¼ÒÇÁÆ®¿þ¾î