search

ondras / wwwsqldesigner

WWW SQL Designer, your online SQL diagramming tool
https://sql.toad.cz/?keyword=online_library
BSD 3-Clause "New" or "Revised" License
2.86k stars 722 forks source link

Import postegresql from pgAdmin XML #274

Open RedouaneBALI opened 5 years ago

RedouaneBALI commented 5 years ago

Hello,

I don't manage to import my schema in the demo page. I export my database schema from pgAdmin and get a xml file using : SELECT "schema_to_xmlschema"('public', true, true, '') but nothing appear importing this data, even with the option 'postegresql' selected.

What is wrong ?

https://www.postgresql.org/docs/current/static/functions-xml.html

<xsd:schema
    xmlns:xsd="http://www.w3.org/2001/XMLSchema">

<xsd:simpleType name="BIGINT">
  <xsd:restriction base="xsd:long">
    <xsd:maxInclusive value="9223372036854775807"/>
    <xsd:minInclusive value="-9223372036854775808"/>
  </xsd:restriction>
</xsd:simpleType>

<xsd:simpleType name="VARCHAR">
  <xsd:restriction base="xsd:string">
  </xsd:restriction>
</xsd:simpleType>

<xsd:simpleType name="TIMESTAMP">
  <xsd:restriction base="xsd:dateTime">
    <xsd:pattern value="\p{Nd}{4}-\p{Nd}{2}-\p{Nd}{2}T\p{Nd}{2}:\p{Nd}{2}:\p{Nd}{2}(.\p{Nd}+)?"/>
  </xsd:restriction>
</xsd:simpleType>

<xsd:simpleType name="UDT.ONEPAY_DB.pg_catalog.text">
  <xsd:restriction base="xsd:string">
  </xsd:restriction>
</xsd:simpleType>

<xsd:simpleType name="INTEGER">
  <xsd:restriction base="xsd:int">
    <xsd:maxInclusive value="2147483647"/>
    <xsd:minInclusive value="-2147483648"/>
  </xsd:restriction>
</xsd:simpleType>

<xsd:simpleType name="BOOLEAN">
  <xsd:restriction base="xsd:boolean"></xsd:restriction>
</xsd:simpleType>

<xsd:simpleType name="DOUBLE">
  <xsd:restriction base="xsd:double"></xsd:restriction>
</xsd:simpleType>

<xsd:simpleType name="CHAR">
  <xsd:restriction base="xsd:string">
  </xsd:restriction>
</xsd:simpleType>

<xsd:simpleType name="SMALLINT">
  <xsd:restriction base="xsd:short">
    <xsd:maxInclusive value="32767"/>
    <xsd:minInclusive value="-32768"/>
  </xsd:restriction>
</xsd:simpleType>

<xsd:complexType name="SchemaType.oneP_DB.public">
  <xsd:sequence>
    <xsd:element name="action_trail" type="RowType.oneP_DB.public.action_trail" minOccurs="0" maxOccurs="unbounded"/>
    <xsd:element name="app_c" type="RowType.oneP_DB.public.app_c" minOccurs="0" maxOccurs="unbounded"/>
    <xsd:element name="app_c_ws_version" type="RowType.oneP_DB.public.app_c_ws_version" minOccurs="0" maxOccurs="unbounded"/>
    <xsd:element name="app_req_param" type="RowType.oneP_DB.public.app_req_param" minOccurs="0" maxOccurs="unbounded"/>
    <xsd:element name="app_req_status" type="RowType.oneP_DB.public.app_req_status" minOccurs="0" maxOccurs="unbounded"/>
    <xsd:element name="app_request" type="RowType.oneP_DB.public.app_request" minOccurs="0" maxOccurs="unbounded"/>
    <xsd:element name="audit_webservices" type="RowType.oneP_DB.public.audit_webservices" minOccurs="0" maxOccurs="unbounded"/>
    <xsd:element name="b_job_activation" type="RowType.oneP_DB.public.b_job_activation" minOccurs="0" maxOccurs="unbounded"/>
    <xsd:element name="b_job_execution" type="RowType.oneP_DB.public.b_job_execution" minOccurs="0" maxOccurs="unbounded"/>
    <xsd:element name="b_job_execution_context" type="RowType.oneP_DB.public.b_job_execution_context" minOccurs="0" maxOccurs="unbounded"/>
    <xsd:element name="b_job_execution_params" type="RowType.oneP_DB.public.b_job_execution_params" minOccurs="0" maxOccurs="unbounded"/>
    <xsd:element name="b_job_instance" type="RowType.oneP_DB.public.b_job_instance" minOccurs="0" maxOccurs="unbounded"/>
    <xsd:element name="b_launch_notify" type="RowType.oneP_DB.public.b_launch_notify" minOccurs="0" maxOccurs="unbounded"/>
    <xsd:element name="b_launch_notify_parameter" type="RowType.oneP_DB.public.b_launch_notify_parameter" minOccurs="0" maxOccurs="unbounded"/>
    <xsd:element name="b_step_execution" type="RowType.oneP_DB.public.b_step_execution" minOccurs="0" maxOccurs="unbounded"/>
    <xsd:element name="b_step_execution_context" type="RowType.oneP_DB.public.b_step_execution_context" minOccurs="0" maxOccurs="unbounded"/>
    <xsd:element name="channel_type" type="RowType.oneP_DB.public.channel_type" minOccurs="0" maxOccurs="unbounded"/>
    <xsd:element name="complementary_data" type="RowType.oneP_DB.public.complementary_data" minOccurs="0" maxOccurs="unbounded"/>
    <xsd:element name="contract_actions" type="RowType.oneP_DB.public.contract_actions" minOccurs="0" maxOccurs="unbounded"/>
    <xsd:element name="contract_attributes" type="RowType.oneP_DB.public.contract_attributes" minOccurs="0" maxOccurs="unbounded"/>
    <xsd:element name="debit_type" type="RowType.oneP_DB.public.debit_type" minOccurs="0" maxOccurs="unbounded"/>
    <xsd:element name="ep_contract" type="RowType.oneP_DB.public.ep_contract" minOccurs="0" maxOccurs="unbounded"/>
    <xsd:element name="ep_roles" type="RowType.oneP_DB.public.ep_roles" minOccurs="0" maxOccurs="unbounded"/>
    <xsd:element name="ep_user" type="RowType.oneP_DB.public.ep_user" minOccurs="0" maxOccurs="unbounded"/>
    <xsd:element name="erasing_header_config" type="RowType.oneP_DB.public.erasing_header_config" minOccurs="0" maxOccurs="unbounded"/>
    <xsd:element name="erasing_item_config" type="RowType.oneP_DB.public.erasing_item_config" minOccurs="0" maxOccurs="unbounded"/>
    <xsd:element name="logs_type" type="RowType.oneP_DB.public.logs_type" minOccurs="0" maxOccurs="unbounded"/>
    <xsd:element name="method_type" type="RowType.oneP_DB.public.method_type" minOccurs="0" maxOccurs="unbounded"/>
    <xsd:element name="nbo" type="RowType.oneP_DB.public.nbo" minOccurs="0" maxOccurs="unbounded"/>
    <xsd:element name="parameter" type="RowType.oneP_DB.public.parameter" minOccurs="0" maxOccurs="unbounded"/>
    <xsd:element name="p_c" type="RowType.oneP_DB.public.p_c" minOccurs="0" maxOccurs="unbounded"/>
    <xsd:element name="p_c_attributes" type="RowType.oneP_DB.public.p_c_attributes" minOccurs="0" maxOccurs="unbounded"/>
    <xsd:element name="p_c_channel_type" type="RowType.oneP_DB.public.p_c_channel_type" minOccurs="0" maxOccurs="unbounded"/>
    <xsd:element name="p_c_channel_type_activation" type="RowType.oneP_DB.public.p_c_channel_type_activation" minOccurs="0" maxOccurs="unbounded"/>
    <xsd:element name="p_c_channel_type_order" type="RowType.oneP_DB.public.p_c_channel_type_order" minOccurs="0" maxOccurs="unbounded"/>
    <xsd:element name="p_c_debit_type" type="RowType.oneP_DB.public.p_c_debit_type" minOccurs="0" maxOccurs="unbounded"/>
    <xsd:element name="p_deactivate" type="RowType.oneP_DB.public.p_deactivate" minOccurs="0" maxOccurs="unbounded"/>
    <xsd:element name="p_debit_type" type="RowType.oneP_DB.public.p_debit_type" minOccurs="0" maxOccurs="unbounded"/>
    <xsd:element name="p_method_category" type="RowType.oneP_DB.public.p_method_category" minOccurs="0" maxOccurs="unbounded"/>
    <xsd:element name="p_method_category_c" type="RowType.oneP_DB.public.p_method_category_c" minOccurs="0" maxOccurs="unbounded"/>
    <xsd:element name="p_method_c" type="RowType.oneP_DB.public.p_method_c" minOccurs="0" maxOccurs="unbounded"/>
    <xsd:element name="p_methods" type="RowType.oneP_DB.public.p_methods" minOccurs="0" maxOccurs="unbounded"/>
    <xsd:element name="p_service_provider" type="RowType.oneP_DB.public.p_service_provider" minOccurs="0" maxOccurs="unbounded"/>
    <xsd:element name="pcct_complementary_data" type="RowType.oneP_DB.public.pcct_complementary_data" minOccurs="0" maxOccurs="unbounded"/>
    <xsd:element name="pmnt" type="RowType.oneP_DB.public.pmnt" minOccurs="0" maxOccurs="unbounded"/>
    <xsd:element name="pmnt_attribute" type="RowType.oneP_DB.public.pmnt_attribute" minOccurs="0" maxOccurs="unbounded"/>
    <xsd:element name="psp_notification" type="RowType.oneP_DB.public.psp_notification" minOccurs="0" maxOccurs="unbounded"/>
    <xsd:element name="psp_notification_parameter" type="RowType.oneP_DB.public.psp_notification_parameter" minOccurs="0" maxOccurs="unbounded"/>
    <xsd:element name="psp_status" type="RowType.oneP_DB.public.psp_status" minOccurs="0" maxOccurs="unbounded"/>
    <xsd:element name="psp_status_updated" type="RowType.oneP_DB.public.psp_status_updated" minOccurs="0" maxOccurs="unbounded"/>
    <xsd:element name="report_config" type="RowType.oneP_DB.public.report_config" minOccurs="0" maxOccurs="unbounded"/>
    <xsd:element name="report_config_attributes" type="RowType.oneP_DB.public.report_config_attributes" minOccurs="0" maxOccurs="unbounded"/>
    <xsd:element name="report_generation_history" type="RowType.oneP_DB.public.report_generation_history" minOccurs="0" maxOccurs="unbounded"/>
    <xsd:element name="report_recipient_email" type="RowType.oneP_DB.public.report_recipient_email" minOccurs="0" maxOccurs="unbounded"/>
    <xsd:element name="report_recipients" type="RowType.oneP_DB.public.report_recipients" minOccurs="0" maxOccurs="unbounded"/>
    <xsd:element name="response_type" type="RowType.oneP_DB.public.response_type" minOccurs="0" maxOccurs="unbounded"/>
    <xsd:element name="rest_conf_security" type="RowType.oneP_DB.public.rest_conf_security" minOccurs="0" maxOccurs="unbounded"/>
    <xsd:element name="rest_service_config" type="RowType.oneP_DB.public.rest_service_config" minOccurs="0" maxOccurs="unbounded"/>
    <xsd:element name="schema_version" type="RowType.oneP_DB.public.schema_version" minOccurs="0" maxOccurs="unbounded"/>
    <xsd:element name="store" type="RowType.oneP_DB.public.store" minOccurs="0" maxOccurs="unbounded"/>
    <xsd:element name="store_p_attributes" type="RowType.oneP_DB.public.store_p_attributes" minOccurs="0" maxOccurs="unbounded"/>
    <xsd:element name="store_p_c_channel" type="RowType.oneP_DB.public.store_p_c_channel" minOccurs="0" maxOccurs="unbounded"/>
    <xsd:element name="t" type="RowType.oneP_DB.public.t" minOccurs="0" maxOccurs="unbounded"/>
    <xsd:element name="t_detail" type="RowType.oneP_DB.public.t_detail" minOccurs="0" maxOccurs="unbounded"/>
    <xsd:element name="t_logs" type="RowType.oneP_DB.public.t_logs" minOccurs="0" maxOccurs="unbounded"/>
    <xsd:element name="t_status" type="RowType.oneP_DB.public.t_status" minOccurs="0" maxOccurs="unbounded"/>
    <xsd:element name="t_type" type="RowType.oneP_DB.public.t_type" minOccurs="0" maxOccurs="unbounded"/>
    <xsd:element name="user_c_role" type="RowType.oneP_DB.public.user_c_role" minOccurs="0" maxOccurs="unbounded"/>
    <xsd:element name="vw_contract" type="RowType.oneP_DB.public.vw_contract" minOccurs="0" maxOccurs="unbounded"/>
    <xsd:element name="vw_p_c_attributes" type="RowType.oneP_DB.public.vw_p_c_attributes" minOccurs="0" maxOccurs="unbounded"/>
    <xsd:element name="web_service_type" type="RowType.oneP_DB.public.web_service_type" minOccurs="0" maxOccurs="unbounded"/>
    <xsd:element name="ws_pwd_info" type="RowType.oneP_DB.public.ws_pwd_info" minOccurs="0" maxOccurs="unbounded"/>
  </xsd:sequence>
</xsd:complexType>

<xsd:element name="public" type="SchemaType.oneP_DB.public"/>

</xsd:schema>
ondras commented 5 years ago

Hi,

your XML is completely incompatible with WWWSQLDesigner's XML :) Both apps are using different XML dialects. It might be possible to create a XSL transformation to convert your XML into WWWSQLDesigner's XML, but I am currently out of time and knowledge to do so.