Doctrine DBAL

Use column comments for further Doctrine Type Inference

Details

  • Type: New Feature New Feature
  • Status: Resolved 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

is duplicated by

Bug - A problem which impairs or prevents the functions of the product. DBAL-90 SchemaManager not able to reverse-engineer mapping type 'array'. Defaults to 'text' on reverse-engineering

  • Minor - Minor loss of function, or other problem where easy workaround is present.
  • Resolved - A resolution has been taken, and it is awaiting verification by reporter. From here issues are either reopened, or are closed.

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
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
Permalink
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
Vote (0)
Watch (1)

Dates

  • Created:
    Updated:
    Resolved: