Doctrine DBAL
  1. Doctrine DBAL
  2. DBAL-42

Use column comments for further Doctrine Type Inference

    Details

    • Type: New Feature New Feature
    • Status: Resolved
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 2.1
    • Component/s: None
    • Labels:
      None

      Description

      Any custom type could use vendors column comment functionalities to allow more details on the specific type of a column that can be used inside the "listTableColumns()" method.

        Issue Links

          Activity

          Hide
          Benjamin Eberlei added a comment -

          MySQL, postfix column with "COMMENT 'The KEY obviously'"

          Postgres, COMMENT syntax (another SQL statement, narf!): http://www.postgresql.org/docs/8.3/static/sql-comment.html

          Oracle, COMMENT syntax (another SQL statement): http://www.stanford.edu/dept/itss/docs/oracle/10g/server.101/b10759/statements_4009.htm

          Sqlite: Nada

          Mssql: (woah this is ugly) http://msdn.microsoft.com/en-us/library/ms180047.aspx

          Show
          Benjamin Eberlei added a comment - MySQL, postfix column with "COMMENT 'The KEY obviously'" Postgres, COMMENT syntax (another SQL statement, narf!): http://www.postgresql.org/docs/8.3/static/sql-comment.html Oracle, COMMENT syntax (another SQL statement): http://www.stanford.edu/dept/itss/docs/oracle/10g/server.101/b10759/statements_4009.htm Sqlite: Nada Mssql: (woah this is ugly) http://msdn.microsoft.com/en-us/library/ms180047.aspx
          Hide
          Benjamin Eberlei added a comment -

          Implemented for Oracle, PostgreSQL and MySQL.

          Now for Array and Object types a Column Comment is appended of the format "(DC2Type:$type)" which is parsed when reading from the database.

          Show
          Benjamin Eberlei added a comment - Implemented for Oracle, PostgreSQL and MySQL. Now for Array and Object types a Column Comment is appended of the format "(DC2Type:$type)" which is parsed when reading from the database.

            People

            • Assignee:
              Benjamin Eberlei
              Reporter:
              Benjamin Eberlei
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: