Details

    • Type: Improvement Improvement
    • Status: Open
    • Priority: Critical Critical
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: 1.2
    • Labels:
      None

      Description

      Multiple schemas in one database should be supported fully in both ways: model (XML with new 'schema' elements/attributes) <-> database that supports multiple schemas

      1. lro.diff
        8 kB
        Laurent ROCHE

        Issue Links

          Activity

          Hide
          Laurent ROCHE added a comment -

          I have made a few fixes to be able to export/import data using schemas (on PostgreSQL), see files included at the end of the post.
          Most of them are quite ugly fixes but that works for me ... and still, they should not interfere with other people usage.

          Main problem fixed in included files were:

          • reading a model from XML file (schema is not handled then).
          • INSERT INTO was not prefexing table names with schema name.
          • writeDataToDatabase methods were not handling _determineSchema property.
            (neither was writeDataToXML but I fixed that previously - see september post).

          I've added a new method in class DatabaseIO:
          public Database read(String filename, String schema)
          to be able to pass the schema as a parameter.
          It's fixed in another way in DdlToDatabaseTask.

          If anybody is interested in more explanations, feel free to ask.

          Moving forward (in next versions), I would assume that it would be better to add the schema in the XML file produced.
          The question is: once in the file (e.g. in the <data> tag) that will mean only one schema per file,
          or per table (in each line) - that will mean being able to export the complete database with all schemas.

          The diff file applies to version 1.0 not the latest SVN files.

          Show
          Laurent ROCHE added a comment - I have made a few fixes to be able to export/import data using schemas (on PostgreSQL), see files included at the end of the post. Most of them are quite ugly fixes but that works for me ... and still, they should not interfere with other people usage. Main problem fixed in included files were: reading a model from XML file (schema is not handled then). INSERT INTO was not prefexing table names with schema name. writeDataToDatabase methods were not handling _determineSchema property. (neither was writeDataToXML but I fixed that previously - see september post). I've added a new method in class DatabaseIO: public Database read(String filename, String schema) to be able to pass the schema as a parameter. It's fixed in another way in DdlToDatabaseTask. If anybody is interested in more explanations, feel free to ask. Moving forward (in next versions), I would assume that it would be better to add the schema in the XML file produced. The question is: once in the file (e.g. in the <data> tag) that will mean only one schema per file , or per table (in each line) - that will mean being able to export the complete database with all schemas. The diff file applies to version 1.0 not the latest SVN files.

            People

            • Assignee:
              Thomas Dudziak
              Reporter:
              Thomas Dudziak
            • Votes:
              6 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

              • Created:
                Updated:

                Development