Codegen not creating [Collumn]Default constants properly

[joe]

Currently all database 'Gen' classes are being created with NULL defaults constants.

For example in our table, we have a column named UserName with a default of 'Guest'. In the TableNameGen class file, there is a constant being created named UserNameDefault being set to NULL. However, it should be set to 'Guest'.

I have a fix for MySqli adapter. Line 566 in QMySqliDatabase.class.php QMySqliDatabaseField::__construct(), add right after if ($objRow["Field"] == $this->strOriginalName) {

$this->strDefault = $objRow["Default"];

After adding this, we are able to use the constant TableName::UserNameDefault, and $objTableName->Initialize() works as expected.

I have to work on learning how to generate and upload a diff.

[joe]

Other adapters seem to be affected too. But, since I don't run those database adapters, I cannot test them.

[vaibhav]

Thanks Joe for the wonderful work. It is working perfectly.

@Other Developers: I am unaware of how MySql is handled in QCubed so I am refraining myself from committing this patch. The patch submitted by Joe works perfectly though.

[vaibhav]

Also, I am using PostgreSQL and it is working all fine for me.

[vaibhav]

@other lead devs: If anyone has an experience with MySQL and has tested this patch, please tell me. I plan to commit it within a week as it seems to solve the problem on my end.

Regards,
Vaibhav