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
Benjamin Eberlei made changes -
Field Original Value New Value
Link This issue is duplicated by DBAL-90 [ DBAL-90 ]
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
Benjamin Eberlei made changes -
Status Open [ 1 ] In Progress [ 3 ]
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.
Benjamin Eberlei made changes -
Status In Progress [ 3 ] Resolved [ 5 ]
Resolution Fixed [ 1 ]
Benjamin Eberlei made changes -
Workflow jira [ 11759 ] jira-feedback2 [ 17656 ]
Benjamin Eberlei made changes -
Workflow jira-feedback2 [ 17656 ] jira-feedback3 [ 20011 ]
This list may be incomplete, as errors occurred whilst retrieving source from linked applications:
  • Request to http://www.doctrine-project.org/fisheye/ failed: Error in remote call to 'FishEye 0 (http://www.doctrine-project.org/fisheye/)' (http://www.doctrine-project.org/fisheye) [AbstractRestCommand{path='/rest-service-fe/search-v1/crossRepositoryQuery', params={query=DBAL-42, expand=changesets[-21:-1].revisions[0:29],reviews}, methodType=GET}] : Received status code 503 (Service Temporarily Unavailable)

People

  • Assignee:
    Benjamin Eberlei
    Reporter:
    Benjamin Eberlei
Vote (0)
Watch (1)

Dates

  • Created:
    Updated:
    Resolved: