original_string: public function buildQuery( $table_name, $type, $params = null )
      {
          if ( $type == "find" )
          {
              $sub_sql = isset($params["sub_sql"]) ? $params["sub_sql"] : null;
          
              $sql = "SELECT * FROM $table_name";
              
              if ( isset($sub_sql) )
              {
                  $sql .= " " . $sub_sql;
              }
              
              $sql .= ";";
          }
          else if ( $type == "update" )
          {
              $columns = isset($params["columns"]) ? $params["columns"] : null;
              
              $sql = "UPDATE $table_name SET ";
              
              foreach ( $columns as $column )
              {
                  $sql .= $column["name"] . "=:" . $column["name"] . ",";
              }
              
              $sql = rtrim( $sql, ", " );
              $sql .= " WHERE ";
              
              foreach ( $columns as $column )
              {
                  $sql .= $column["name"] . "=:snap_" . $column["name"] . " AND ";
              }
              
              $sql = rtrim( $sql, " AND " );
              $sql .= ";";
          }
          else if ( $type == "insert" )
          {
              $columns = isset($params["columns"]) ? $params["columns"] : null;
              
              $sql = "INSERT INTO $table_name (";
              
              foreach ( $columns as $column )
              {
                  $sql .= $column["name"] . ", ";;
              }
              
              $sql = rtrim( $sql, ", " );
              
              $sql .= ") VALUES (";
              
              foreach ( $columns as $column )
              {
                  $sql .= ":" . $column["name"] . ", ";
              }
              
              $sql = rtrim( $sql, ", " );
              $sql .= ");";
          }
          
          return $this->prepare( $sql );
      }
code: public function buildQuery( $table_name, $type, $params = null )
      {
          if ( $type == "find" )
          {
              $sub_sql = isset($params["sub_sql"]) ? $params["sub_sql"] : null;
          
              $sql = "SELECT * FROM $table_name";
              
              if ( isset($sub_sql) )
              {
                  $sql .= " " . $sub_sql;
              }
              
              $sql .= ";";
          }
          else if ( $type == "update" )
          {
              $columns = isset($params["columns"]) ? $params["columns"] : null;
              
              $sql = "UPDATE $table_name SET ";
              
              foreach ( $columns as $column )
              {
                  $sql .= $column["name"] . "=:" . $column["name"] . ",";
              }
              
              $sql = rtrim( $sql, ", " );
              $sql .= " WHERE ";
              
              foreach ( $columns as $column )
              {
                  $sql .= $column["name"] . "=:snap_" . $column["name"] . " AND ";
              }
              
              $sql = rtrim( $sql, " AND " );
              $sql .= ";";
          }
          else if ( $type == "insert" )
          {
              $columns = isset($params["columns"]) ? $params["columns"] : null;
              
              $sql = "INSERT INTO $table_name (";
              
              foreach ( $columns as $column )
              {
                  $sql .= $column["name"] . ", ";;
              }
              
              $sql = rtrim( $sql, ", " );
              
              $sql .= ") VALUES (";
              
              foreach ( $columns as $column )
              {
                  $sql .= ":" . $column["name"] . ", ";
              }
              
              $sql = rtrim( $sql, ", " );
              $sql .= ");";
          }
          
          return $this->prepare( $sql );
      }
code_tokens: public function buildQuery ( $ table_name , $ type , $ params = null ) { if ( $ type == "find" ) { $ sub_sql = isset ( $ params [ "sub_sql" ] ) ? $ params [ "sub_sql" ] : null ; $ sql = "SELECT * FROM $table_name" ; if ( isset ( $ sub_sql ) ) { $ sql .= " " . $ sub_sql ; } $ sql .= ";" ; } else if ( $ type == "update" ) { $ columns = isset ( $ params [ "columns" ] ) ? $ params [ "columns" ] : null ; $ sql = "UPDATE $table_name SET " ; foreach ( $ columns as $ column ) { $ sql .= $ column [ "name" ] . "=:" . $ column [ "name" ] . "," ; } $ sql = rtrim ( $ sql , ", " ) ; $ sql .= " WHERE " ; foreach ( $ columns as $ column ) { $ sql .= $ column [ "name" ] . "=:snap_" . $ column [ "name" ] . " AND " ; } $ sql = rtrim ( $ sql , " AND " ) ; $ sql .= ";" ; } else if ( $ type == "insert" ) { $ columns = isset ( $ params [ "columns" ] ) ? $ params [ "columns" ] : null ; $ sql = "INSERT INTO $table_name (" ; foreach ( $ columns as $ column ) { $ sql .= $ column [ "name" ] . ", " ; ; } $ sql = rtrim ( $ sql , ", " ) ; $ sql .= ") VALUES (" ; foreach ( $ columns as $ column ) { $ sql .= ":" . $ column [ "name" ] . ", " ; } $ sql = rtrim ( $ sql , ", " ) ; $ sql .= ");" ; } return $ this -> prepare ( $ sql ) ; }
docstring: Builds a query, returns a query object
docstring_tokens: Builds a query returns a query object