Porting DBForge Functionality from CI 1.6

[kolanos]

I decided to try my hand at porting DBForge functionality over from CI 1.6 to Kohana. I have attached what I have done so far, the MySQL and MySQLi drivers are fully functional, however the Postgre and SQLite drivers required more testing/tweaking.

Features:

• Create database (MySQL, MySQLi, and Postgre only)
• Drop database (MySQL, MySQLi, and Postgre only)
• Create table (MySQL, MySQLi, and Postgre only)
• Drop table (MySQL, MySQLi, and Postgre only)
• Alter tables

More info: http://codeigniter.com/user_guide/database/forge.html

The DBForge functionality could be really useful for modules, where modules could create databases/tables on the fly.

[kolanos]

diff files and i18n translations (some need to be revised)

[zombor]

We really have no intention of including this functionality in the core. Feel free to host and maintain this as an add-on module.

[Shadowhand]

I'd like to leave this open for review, possibly as an official module. Thanks kolanos!

[kolanos]

I am looking into converting this into a module, as per zombor's suggestion.

[kolanos]

I have tried two methods with only partial success. What is the suggested way to extend the Database library, including the drivers?

[kolanos]

Ok, here's version 0.1 of the DBForge module. It currently only has MySQL and MySQLi drivers and i18n for en_US and en_GB. I plant o have the other drivers and language files included in 0.2.

Please review, test and report back any bugs/suggestions.

Thanks!

[kolanos]

version 0.1 of DBForge as a module

[BrandX]

I guess this hasn't been looked at for a while, but the migrations mod I ported from Kohana duplicates a lot of this functionality. Any suggestions on how to marry the two?

[kolanos]

BrandX, where can I find the migrations mod?

[BrandX]

I've attached my working version of the migrations mod.