format 75
"sql" // iplan::database::sql
  revision 3
  modified_by 5 "jviqueira"
  // class settings
  //class diagram settings
  draw_all_relations default hide_attributes default hide_operations default hide_getset_operations default show_members_full_definition default show_members_visibility default show_members_stereotype default show_members_context default show_members_multiplicity default show_members_initialization default show_attribute_modifiers default member_max_width 0 show_parameter_dir default show_parameter_name default package_name_in_tab default class_drawing_mode default drawing_language default show_context_mode default auto_label_position default show_relation_modifiers default show_relation_visibility default show_infonote default shadow default show_stereotype_properties default
  //use case diagram settings
  package_name_in_tab default show_context default auto_label_position default draw_all_relations default class_drawing_mode default shadow default show_stereotype_properties default
  //sequence diagram settings
  show_full_operations_definition default write_horizontally default class_drawing_mode default drawing_language default draw_all_relations default shadow default show_stereotype_properties default show_class_context_mode default show_msg_context_mode default
  //collaboration diagram settings
  show_full_operations_definition default show_hierarchical_rank default write_horizontally default drawing_language default package_name_in_tab default show_context default show_msg_context default draw_all_relations default shadow default show_stereotype_properties default
  //object diagram settings
   write_horizontally default package_name_in_tab default show_context default auto_label_position default draw_all_relations default shadow default show_stereotype_properties default
  //component diagram settings
  package_name_in_tab default show_context default auto_label_position default draw_all_relations default shadow default
  draw_component_as_icon default show_component_req_prov default show_component_rea default show_stereotype_properties default
  //deployment diagram settings
  package_name_in_tab default show_context default write_horizontally default auto_label_position default draw_all_relations default shadow default
  draw_component_as_icon default show_component_req_prov default show_component_rea default show_stereotype_properties default
  //state diagram settings
  package_name_in_tab default show_context default auto_label_position default write_trans_label_horizontally default show_trans_definition default draw_all_relations default shadow default
  show_activities default region_horizontally default drawing_language default show_stereotype_properties default
  //activity diagram settings
  package_name_in_tab default show_context default show_opaque_action_definition default auto_label_position default write_flow_label_horizontally default draw_all_relations default shadow default
  show_infonote default drawing_language default show_stereotype_properties default
  
  php_dir "iplan/database/sql"
  classview 147589 "SQL Classes"
    //class diagram settings
    draw_all_relations default hide_attributes default hide_operations default hide_getset_operations default show_members_full_definition default show_members_visibility default show_members_stereotype default show_members_context default show_members_multiplicity default show_members_initialization default show_attribute_modifiers default member_max_width 0 show_parameter_dir default show_parameter_name default package_name_in_tab default class_drawing_mode default drawing_language default show_context_mode default auto_label_position default show_relation_modifiers default show_relation_visibility default show_infonote default shadow default show_stereotype_properties default
    //collaboration diagram settings
    show_full_operations_definition default show_hierarchical_rank default write_horizontally default drawing_language default package_name_in_tab default show_context default show_msg_context default draw_all_relations default shadow default show_stereotype_properties default
    //object diagram settings
     write_horizontally default package_name_in_tab default show_context default auto_label_position default draw_all_relations default shadow default show_stereotype_properties default
    //sequence diagram settings
    show_full_operations_definition default write_horizontally default class_drawing_mode default drawing_language default draw_all_relations default shadow default show_stereotype_properties default show_class_context_mode default show_msg_context_mode default
    //state diagram settings
    package_name_in_tab default show_context default auto_label_position default write_trans_label_horizontally default show_trans_definition default draw_all_relations default shadow default
    show_activities default region_horizontally default drawing_language default show_stereotype_properties default
    //class settings
    //activity diagram settings
    package_name_in_tab default show_context default show_opaque_action_definition default auto_label_position default write_flow_label_horizontally default draw_all_relations default shadow default
    show_infonote default drawing_language default show_stereotype_properties default
    associated_deployment_view deploymentview_ref 154373 // Deployment SQL
    classdiagram 141061 "Terms Classes"
      draw_all_relations no hide_attributes default hide_operations default hide_getset_operations default show_members_full_definition default show_members_visibility default show_members_stereotype default show_members_context default show_members_multiplicity default show_members_initialization default show_attribute_modifiers default member_max_width 0 show_parameter_dir default show_parameter_name default package_name_in_tab default class_drawing_mode default drawing_language default show_context_mode default auto_label_position default show_relation_modifiers default show_relation_visibility default show_infonote default shadow default show_stereotype_properties default
      comment "Esta capa tiene la filosofia de que NO ESTAMOS MANEJANDO BASES DE DATOS DISTINTAS, sino que estamos manejando CONEXIONES A BASES DE DATOS. La conexión sabe como hacer las cosas."
      size A4-Landscape
    end

    class 188933 "Transaction"
      visibility package 
      cpp_decl ""
      java_decl ""
      php_decl "${comment}${final}${visibility}${abstract}class ${name}${extends}${implements} {
${members}}
"
      python_2_2 python_decl ""
      idl_decl ""
      explicit_switch_type ""
      
      classrelation 189701 // <generalisation>
	relation 189189 ---|>
	  a public
	    php "${type}"
	    classrelation_ref 189701 // <generalisation>
	  b parent class_ref 174469 // Term
      end
    end

    class 174597 "SearchTerm"
      abstract visibility package 
      cpp_decl ""
      java_decl ""
      php_decl "${comment}${final}${visibility}${abstract}class ${name}${extends}${implements} {
${members}}
"
      python_2_2 python_decl ""
      idl_decl ""
      explicit_switch_type ""
      
      comment "Las ideas de las constantes y la conformación aproximada de esta jerarquía de clases se tomo de la API de javamail."
      classrelation 196229 // <generalisation>
	relation 195717 ---|>
	  a public
	    php "${type}"
	    classrelation_ref 196229 // <generalisation>
	  b parent class_ref 174469 // Term
      end
    end

    class 174725 "Result"
      visibility package 
      cpp_decl ""
      java_decl ""
      php_decl "${comment}${final}${visibility}${abstract}class ${name}${extends}${implements} {
${members}}
"
      python_2_2 python_decl ""
      idl_decl ""
      explicit_switch_type ""
      
    end

    class 195461 "Atom"
      visibility package 
      cpp_decl ""
      java_decl ""
      php_decl "${comment}${final}${visibility}${abstract}class ${name}${extends}${implements} {
${members}}
"
      python_2_2 python_decl ""
      idl_decl ""
      explicit_switch_type ""
      
      classrelation 202757 // <generalisation>
	relation 202245 ---|>
	  a public
	    php "${type}"
	    classrelation_ref 202757 // <generalisation>
	  b parent class_ref 174597 // SearchTerm
      end

      operation 198661 "Atom"
	class_operation preserve_cpp_body_indent public return_type class_ref 195461 // Atom
	nparams 1
	  param in name "value" explicit_type "string"
	
	preserve_java_body_indent 
	preserve_php_body_indent php_def "  ${comment}${final}${visibility}${abstract}function ${name}${(}${p0}${v0}${)}
{
  ${body}}
"
	preserve_python_body_indent 
	
      end
    end

    class 182405 "In"
      visibility package 
      cpp_decl ""
      java_decl ""
      php_decl "${comment}${final}${visibility}${abstract}class ${name}${extends}${implements} {
${members}}
"
      python_2_2 python_decl ""
      idl_decl ""
      explicit_switch_type ""
      
      classrelation 183173 // <generalisation>
	relation 182661 ---|>
	  a public
	    php "${type}"
	    classrelation_ref 183173 // <generalisation>
	  b parent class_ref 174597 // SearchTerm
      end

      operation 198917 "In"
	class_operation preserve_cpp_body_indent public return_type class_ref 182405 // In
	nparams 2
	  param in name "data" type class_ref 195461 // Atom
	  param in name "list" explicit_type "array"
	
	preserve_java_body_indent 
	preserve_php_body_indent php_def "  ${comment}${final}${visibility}${abstract}function ${name}${(}${p0}${v0}, ${p1}${v1}${)}
{
  ${body}}
"
	preserve_python_body_indent 
	
      end
    end

    class 182277 "Compare"
      visibility package 
      cpp_decl ""
      java_decl ""
      php_decl "${comment}${final}${visibility}${abstract}class ${name}${extends}${implements} {
${members}}
"
      python_2_2 python_decl ""
      idl_decl ""
      explicit_switch_type ""
      
      classrelation 182917 // <generalisation>
	relation 182405 ---|>
	  a public
	    php "${type}"
	    classrelation_ref 182917 // <generalisation>
	  b parent class_ref 174597 // SearchTerm
      end

      attribute 197765 "EQ"
	class_attribute const_attribute public explicit_type "int"
	init_value "1"
	cpp_decl ""
	java_decl ""
	php_decl "  ${comment}${visibility}${const}${static}${var}${name}${value};
"
	python_decl ""
	idl_decl ""
      end

      attribute 197893 "LT"
	class_attribute const_attribute public explicit_type "int"
	init_value "2"
	cpp_decl ""
	java_decl ""
	php_decl "  ${comment}${visibility}${const}${static}${var}${name}${value};
"
	python_decl ""
	idl_decl ""
      end

      attribute 198021 "GT"
	class_attribute const_attribute public explicit_type "int"
	init_value "3"
	cpp_decl ""
	java_decl ""
	php_decl "  ${comment}${visibility}${const}${static}${var}${name}${value};
"
	python_decl ""
	idl_decl ""
      end

      attribute 198149 "LE"
	class_attribute const_attribute public explicit_type "int"
	init_value "4"
	cpp_decl ""
	java_decl ""
	php_decl "  ${comment}${visibility}${const}${static}${var}${name}${value};
"
	python_decl ""
	idl_decl ""
      end

      attribute 198277 "GE"
	class_attribute const_attribute public explicit_type "int"
	init_value "5"
	cpp_decl ""
	java_decl ""
	php_decl "  ${comment}${visibility}${const}${static}${var}${name}${value};
"
	python_decl ""
	idl_decl ""
      end

      attribute 198405 "NE"
	class_attribute const_attribute public explicit_type "int"
	init_value "6"
	cpp_decl ""
	java_decl ""
	php_decl "  ${comment}${visibility}${const}${static}${var}${name}${value};
"
	python_decl ""
	idl_decl ""
      end

      class 182149 "Between"
	visibility protected 
	cpp_decl ""
	java_decl ""
	php_decl "${comment}${final}${visibility}${abstract}class ${name}${extends}${implements} {
${members}}
"
	python_2_2 python_decl ""
	idl_decl ""
	explicit_switch_type ""
	
	classrelation 182789 // <generalisation>
	  relation 182277 ---|>
	    a public
	      php "${type}"
	      classrelation_ref 182789 // <generalisation>
	    b parent class_ref 174597 // SearchTerm
	end

	operation 198533 "Between"
	  class_operation preserve_cpp_body_indent public return_type class_ref 182149 // Between
	  nparams 3
	    param in name "data" type class_ref 195461 // Atom
	    param in name "minValue" type class_ref 195461 // Atom
	    param in name "maxValue" type class_ref 195461 // Atom
	  
	  preserve_java_body_indent 
	  preserve_php_body_indent php_def "  ${comment}${final}${visibility}${abstract}function ${name}${(}${p0}${v0}, ${p1}${v1}, ${p2}${v2}${)}
{
  ${body}}
"
	  preserve_python_body_indent 
	  
	end
      end

      attribute 198533 "LIKE"
	class_attribute const_attribute public explicit_type "int"
	init_value "7"
	cpp_decl ""
	java_decl ""
	php_decl "  ${comment}${visibility}${const}${static}${var}${name}${value};
"
	python_decl ""
	idl_decl ""
      end

      operation 198789 "Compare"
	class_operation preserve_cpp_body_indent public return_type class_ref 182277 // Compare
	nparams 2
	  param in name "firstValue" type class_ref 195461 // Atom
	  param in name "secondValue" type class_ref 195461 // Atom
	
	preserve_java_body_indent 
	preserve_php_body_indent php_def "  ${comment}${final}${visibility}${abstract}function ${name}${(}${p0}${v0}, ${p1}${v1}${)}
{
  ${body}}
"
	preserve_python_body_indent 
	
      end
    end

    class 182021 "Or"
      visibility package 
      cpp_decl ""
      java_decl ""
      php_decl "${comment}${final}${visibility}${abstract}class ${name}${extends}${implements} {
${members}}
"
      python_2_2 python_decl ""
      idl_decl ""
      explicit_switch_type ""
      
      classrelation 182661 // <generalisation>
	relation 182149 ---|>
	  a public
	    php "${type}"
	    classrelation_ref 182661 // <generalisation>
	  b parent class_ref 174597 // SearchTerm
      end

      operation 192005 "Or"
	class_operation preserve_cpp_body_indent public return_type class_ref 182021 // Or
	nparams 1
	  param in name "terms" explicit_type "array"
	
	preserve_java_body_indent 
	preserve_php_body_indent php_def "  ${comment}${final}${visibility}${abstract}function ${name}${(}${p0}${v0}${)}
{
  ${body}}
"
	preserve_python_body_indent 
	
	comment "Toma una lista de SearchTerm y los concatena por OR"
      end
    end

    class 181765 "And"
      visibility package 
      cpp_decl ""
      java_decl ""
      php_decl "${comment}${final}${visibility}${abstract}class ${name}${extends}${implements} {
${members}}
"
      python_2_2 python_decl ""
      idl_decl ""
      explicit_switch_type ""
      
      classrelation 182533 // <generalisation>
	relation 182021 ---|>
	  a public
	    php "${type}"
	    classrelation_ref 182533 // <generalisation>
	  b parent class_ref 174597 // SearchTerm
      end

      operation 191749 "And"
	class_operation preserve_cpp_body_indent public return_type class_ref 181765 // And
	nparams 1
	  param in name "Terms" explicit_type "array"
	
	preserve_java_body_indent 
	preserve_php_body_indent php_def "  ${comment}${final}${visibility}${abstract}function ${name}${(}${p0}${v0}${)}
{
  ${body}}
"
	preserve_python_body_indent 
	
	comment "Toma una lista de SearchTerm y los concatena por AND"
      end
    end

    class 175237 "Delete"
      visibility package 
      cpp_decl ""
      java_decl ""
      php_decl "${comment}${final}${visibility}${abstract}class ${name}${extends}${implements} {
${members}}
"
      python_2_2 python_decl ""
      idl_decl ""
      explicit_switch_type ""
      
      classrelation 175621 // <generalisation>
	relation 175109 ---|>
	  a public
	    php "${type}"
	    classrelation_ref 175621 // <generalisation>
	  b parent class_ref 174469 // Term
      end
    end

    class 175109 "Insert"
      visibility package 
      cpp_decl ""
      java_decl ""
      php_decl "${comment}${final}${visibility}${abstract}class ${name}${extends}${implements} {
${members}}
"
      python_2_2 python_decl ""
      idl_decl ""
      explicit_switch_type ""
      
      classrelation 175749 // <generalisation>
	relation 175237 ---|>
	  a public
	    php "${type}"
	    classrelation_ref 175749 // <generalisation>
	  b parent class_ref 174469 // Term
      end
    end

    class 174981 "Select"
      visibility package 
      cpp_decl ""
      java_decl ""
      php_decl "${comment}${final}${visibility}${abstract}class ${name}${extends}${implements} {
${members}}
"
      python_2_2 python_decl ""
      idl_decl ""
      explicit_switch_type ""
      
      classrelation 175493 // <generalisation>
	relation 174981 ---|>
	  a public
	    php "${type}"
	    classrelation_ref 175493 // <generalisation>
	  b parent class_ref 174469 // Term
      end
    end

    class 174469 "Term"
      abstract visibility package 
      cpp_decl ""
      java_decl ""
      php_decl "${comment}${final}${visibility}${abstract}class ${name}${extends}${implements} {
${members}}
"
      python_2_2 python_decl ""
      idl_decl ""
      explicit_switch_type ""
      
      comment "INSERT
UPDATE
DELETE
SELECT

Toma como parámetro opciona un SEARCHTERM

Esta estructura podría usarse para conformar además unidades de ejecución haciendo que el term sea un COMPOSITE, de esta forma se podría modelar una TRANSACTION."
      operation 191877 "toSQL"
	abstract preserve_cpp_body_indent cpp_virtual public explicit_return_type "string"
	nparams 0
	
	preserve_java_body_indent 
	preserve_php_body_indent php_def "  ${comment}${final}${visibility}${abstract}${static}function ${name}${(}${)}
{
  ${body}}
"
	preserve_python_body_indent 
	
	comment "Retorna la representación textual de la sentencia SQL que representa el término"
      end
    end

    class 174853 "Update"
      visibility package 
      cpp_decl ""
      java_decl ""
      php_decl "${comment}${final}${visibility}${abstract}class ${name}${extends}${implements} {
${members}}
"
      python_2_2 python_decl ""
      idl_decl ""
      explicit_switch_type ""
      
      classrelation 175365 // <generalisation>
	relation 174853 ---|>
	  a public
	    php "${type}"
	    classrelation_ref 175365 // <generalisation>
	  b parent class_ref 174469 // Term
      end
    end

    class 229637 "Execute"
      visibility package 
      cpp_decl ""
      java_decl ""
      php_decl "${comment}${final}${visibility}${abstract}class ${name}${extends}${implements} {
${members}}
"
      python_2_2 python_decl ""
      idl_decl ""
      explicit_switch_type ""
      
      classrelation 243973 // <generalisation>
	relation 243461 ---|>
	  a public
	    php "${type}"
	    classrelation_ref 243973 // <generalisation>
	  b parent class_ref 174469 // Term
      end
    end
  end

  deploymentview 154373 "Deployment SQL"
    //deployment diagram settings
    package_name_in_tab default show_context default write_horizontally default auto_label_position default draw_all_relations default shadow default
    draw_component_as_icon default show_component_req_prov default show_component_rea default show_stereotype_properties default
    artifact 150533 "In"
      stereotype "source"
      php_src "<?php
${comment}
${definition}
?>
"
      associated_classes
	class_ref 182405 // In
      end
    end

    artifact 150661 "Transaction"
      stereotype "source"
      php_src "<?php
${comment}
${definition}
?>
"
      associated_classes
	class_ref 188933 // Transaction
      end
    end

    artifact 150789 "SearchTerm"
      stereotype "source"
      php_src "<?php
${comment}
${definition}
?>
"
      associated_classes
	class_ref 174597 // SearchTerm
      end
    end

    artifact 150917 "Result"
      stereotype "source"
      php_src "<?php
${comment}
${definition}
?>
"
      associated_classes
	class_ref 174725 // Result
      end
    end

    artifact 151045 "Atom"
      stereotype "source"
      php_src "<?php
${comment}
${definition}
?>
"
      associated_classes
	class_ref 195461 // Atom
      end
    end

    artifact 151173 "Compare"
      stereotype "source"
      php_src "<?php
${comment}
${definition}
?>
"
      associated_classes
	class_ref 182277 // Compare
      end
    end

    artifact 151301 "Or"
      stereotype "source"
      php_src "<?php
${comment}
${definition}
?>
"
      associated_classes
	class_ref 182021 // Or
      end
    end

    artifact 151429 "And"
      stereotype "source"
      php_src "<?php
${comment}
${definition}
?>
"
      associated_classes
	class_ref 181765 // And
      end
    end

    artifact 151557 "Delete"
      stereotype "source"
      php_src "<?php
${comment}
${definition}
?>
"
      associated_classes
	class_ref 175237 // Delete
      end
    end

    artifact 151685 "Insert"
      stereotype "source"
      php_src "<?php
${comment}
${definition}
?>
"
      associated_classes
	class_ref 175109 // Insert
      end
    end

    artifact 151813 "Select"
      stereotype "source"
      php_src "<?php
${comment}
${definition}
?>
"
      associated_classes
	class_ref 174981 // Select
      end
    end

    artifact 151941 "Term"
      stereotype "source"
      php_src "<?php
${comment}
${definition}
?>
"
      associated_classes
	class_ref 174469 // Term
      end
    end

    artifact 152069 "Update"
      stereotype "source"
      php_src "<?php
${comment}
${definition}
?>
"
      associated_classes
	class_ref 174853 // Update
      end
    end
  end
end