Menu

XML format for SQL sentences

Developers
2008-10-23
2013-05-22
  • Miguel Calle

    Miguel Calle - 2008-10-23

    I create this thread just for discussing about how would be the tags set and the structure for the XML file which will be use in SQL queries. I think it would be great to use the same XML format for multi-threading and simple SQL queries.

    Any idea?

     
    • Marat Dyatko

      Marat Dyatko - 2008-10-23

      > I create this thread just for discussing about how would be the tags set and the structure for the XML file which will be use in SQL queries. 

      Tonight I and Denis finished translating core to DOMDocument.
      And now I can start writing documentation.

      All simple tags we are have. For example:
              <update name="personal" table="user_info" action="post:save">
                  <about is="post:about" nl2br="true" match=".+" />
                  <birthday is="post:birthday" match="[0-9]{1,4}" />
                  <marriage is="post:marriage" match="[0-3]" />
                  <city_id is="post:city_id" match="[0-9]{1,3}" />
                  <smoke_id is="post:smoke_id" match="[0-3]" />
                  <alko_id is="post:alko_id" match="[0-3]" />
                  <grant_id is="post:grant_id" match="[0-3]" />
                  <meet_place_id is="post:meet_place_id" match="[0-3]" />
                  <where>
                      <and>

                      <id is="class:user|id" match="[0-9]+"/>

                      </and>   
                      <and>

                      <dir is="0" match=".+"/>

                      </and>                       
                  </where>
              </update>
              <select name="userinfo" table="user_info">
                  <allfields />
                  <join from="cities" type="left" key="city_id">
                      <name as="city" />
                  </join>
                  <where>
                      <and>

                      <id is="class:user|id" match="[0-9]+"/>

                      </and>   
                      <and>

                      <dir in="0,1" match=".+"/>

                      </and>                       
                  </where>
              </select>
              <select name="cities" table="cities">
                  <allfields />
              </select>

      > I think it would be great to use the same XML format for multi-threading and simple SQL queries. 

      Yep, multi-threading is very important feature.
      And with new core it will be more simple.

      I hope commit new core to SVN tonight.

       
      • Ben

        Ben - 2008-10-26

        Peace Guys,

        just a quick question. When you talk about multi-threading the core, you aren't talking about forking, are you?
        As far as I know forking is only available on Unix systems and would limit the scripts environments.

        Peace

         
        • Marat Dyatko

          Marat Dyatko - 2008-10-26

          I was answered to Miguel about forking in Windows

          "Most of web-servers works under UNIX-like systems control.
          So, I think, XAMP must be more oriented to FreeBSD or Linux.
          Windows - shit, that's true and we must adapt to this :-)

          Btw, in future PHP classes will be translated to C++ for compiling CGI script.
          Now I'm search man who takes this job."

           
    • Miguel Calle

      Miguel Calle - 2008-10-26

      Yes you are right, PHP multithreading is not available for windows, just for unix like OS. Maybe in the future...

       

Log in to post a comment.

MongoDB Logo MongoDB