api_plugin_db_table_create() method in cacti plugins

[kdas]

Hi All,

I am trying to create a table in cacti database from my plugin.

The query is below

CREATE TABLE `kpi_param` (
`kpi_id` int(3) NOT NULL,
`param_id` int(3) NOT NULL,
PRIMARY KEY (`kpi_id`,`param_id`),
KEY `fk_kpi_param_param1` (`param_id`),
KEY `fk_kpi_param_kpi1` (`kpi_id`),
CONSTRAINT `fk_kpi_param_kpi1` FOREIGN KEY (`kpi_id`) REFERENCES `kpi` (`kpi_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `fk_kpi_param_param1` FOREIGN KEY (`param_id`) REFERENCES `param` (`param_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


As per the api_plugin_db_table_create() there are no references of foreign keys.
How do we get the above query in a api_plugin_db_table_create() format?
especially foreign key , References information.

My implementation:
function kpi_param_table(){

global $config,$database_default;
include_once($config["library_path"]."/database.php");
$data=array();
$data['columns'][]=array('name' => 'kpi_id',
'type' => 'bigint(25)',
'unsigned' => 'unsigned',
'NULL' => false,
'auto_increment' => true
);
$data['columns'][]=array('name' => 'param_id',
'type' => 'int(3)',
'unsigned' => 'unsigned',
'NULL' => false
);
$data['primary']='kpi_id';
$data['type']='MyISAM';
$data['comment']='kpi param Data Table';
api_plugin_db_table_create ('param kpi','kpi_param',$data);

}

Aprreciate your help.

Thanks.

Regards,
Das

[rony]

Well....

Mostly it doesn't support foreign keys because the default database engine in mysql does not.

[TheWitness]

I suggest that you don't use the API function for setting up Fk's. You should instead use the 'create' syntax and wrap it into a function called "db_execute". So, it would go something like this:

Code: Select all

db_execute("CREATE TABLE IF NOT EXISTS...");

Then, please log an enhancement request at http://bugs.cacti.net under the plugins section to allow the specification of Fk's in the API.

TheWitness