XE 초보인데요...

XML query가 제대로 안 와닿아서요 ㅠ

혹시 이 밑에 쿼리들 SQL로 바꿔주실 수 있나요??

SELECT문은 어느정도 이해가 되는데 UPDATE나 DELETE같은 경우는 좀 힘드네요 ㅠ.ㅠ

전체가 아니라도 좋으니 일부분이라도 번역해 주세요.

감사합니다.

• 1. <query id="getMemberList" action="select">
     <tables>
        <table name="member" />
     </tables>
  2. 
     <columns>
        <column name="*" />
     </columns>
  3. 
     <conditions>
         <condition operation="equal" column="is_admin" var="is_admin" />
        <condition operation="equal" column="denied" var="is_denied" pipe="and" />
        <group pipe="and">
             <condition operation="like" column="user_id" var="s_user_id" />
             <condition operation="like" column="user_name" var="s_user_name" pipe="or" />
             <condition operation="like" column="nick_name" var="s_nick_name" pipe="or" />
             <condition operation="like" column="email_address" var="s_email_address" pipe="or" />
             <condition operation="like_prefix" column="regdate" var="s_regdate" pipe="or" />
             <condition operation="like_prefix" column="last_login" var="s_last_login" pipe="or" />
         </group>
     </conditions>
     
     <navigation>
         <index var="sort_index" default="member_srl" order="desc" />
         <list_count var="list_count" default="20" />
         <page_count var="page_count" default="10" />
         <page var="page" default="1" />
     </navigation>
     </query>
• document.getMonthlyArchivedList : 모듈을 '년월'일을 기준으로 group by 한 결과를 가져옴

1. <query id="getMonthlyArchivedList" action="select">
   <tables>
       <table name="documents" />
   </tables>
   
   <columns>
       <column name="substr(regdate,1,6)" alias="month"/>
       <column name="count(*)" alias="count" />
   </columns>
   
   <conditions>
      <condition operation="in" column="module_srl" var="module_srl" filter="number" />
   </conditions>
   
   <groups>
       <group column="substr(regdate,1,6)" />
   </groups>
   </query>

 

Insert 예제

• document.insertCategory : 문서 카테고리 추가

  1. <query id="insertCategory" action="insert">
     <tables>
         <table name="document_categories" />
     </tables>
     
     <columns>
         <column name="category_srl" var="category_srl" filter="number" notnull="notnull" />
         <column name="module_srl" var="module_srl" filter="number" default="0" notnull="notnull" />
         <column name="title" var="title" notnull="notnull" minlength="2" maxlength="250" />
         <column name="document_count" var="document_count" default="0" />
         <column name="regdate" var="regdate" default="curdate()" />
         <column name="last_update" var="last_update" default="curdate()" />
         <column name="list_order" var="list_order" default="0" />
     </columns>
     </query>

 

update 예제

• document.updateCategory : 특정 카테고리의 제목이나 순서, 최근 수정일을 변경

  1. <query id="updateCategory" action="update">
     <tables>
         <table name="document_categories" />
     </tables>
     
     <columns>
         <column name="title" var="title" />
         <column name="list_order" var="list_order" />
         <column name="last_update" var="last_update" default="curdate()" />
     </columns>
     
     <conditions>
         <condition operation="equal" column="category_srl" var="category_srl" filter="number" notnull="notnull" />
     </conditions>
     </query>

 

delete 예제

• document.deleteCategory : 특정 카테고리를 삭제

  1. <query id="deleteCategory" action="delete">
     <tables>
         <table name="document_categories" />
     </tables>
     
     <conditions>
         <condition operation="equal" column="category_srl" var="category_srl" filter="number" notnull="notnull" />
     </conditions>
     </query>