MySQL Adapter: Database Field Comments

[basilieus]

I made a little deal where it adds the comment for field names into the comments for the variables inside the class.

So if you added a comment on a field in MySQL (not tested on anything else) it will add that comment to the class file (above the variable).

Check it out.

[VexedPanda]

Very cool. I wonder if there's a way to pull that info into the form drafts too.

[alex94040]

This is absolutely awesome. I'm very much looking forward to it in the core.

Side note: please add a comment to one of the examples to let people know about this functionality.

[alex94040]

I just tested this out. I had to make small mods to QMySqliDatabase.class.php - changing the way the Comment is retrieved from the DB - as it was crashing on my box. Now it's fine. Everything else works like a charm.

Note that this feature only works on the MySQL adapter - for all other adapters, the comment will be ignored. I'd love to see other adapters implement this, too - the core plumbing is already there.

Uploading the new patch; leaving it around for a few days to let others comment, and let's check this puppy in!

[alex94040]

New patch

[akrohn]

When this is checked in, I would take a look to adapt it for the SQL Server adapter.

[VexedPanda]

Has this been tested with all 3 MySql adapters?

[alex94040]

No, it has not. Whoever tests/code reviews this, please check with all 3 versions of the adapter.

[MikeHostetler]

(In [482]) Fixes #238, code by basilieus and alex94040, review by MikeHostetler?