function check_db()
{
// Define columns of the calendar table
$plugs_index_col = array();
$plugs_index_col["id"] = array('Field' => "id", 'Type' => "int(11)", 'carac' => "NOT NULL AUTO_INCREMENT");
$plugs_index_col["PLUG_ID"] = array('Field' => "PLUG_ID", 'Type' => "varchar(3)", 'default_value' => "NULL");
$plugs_index_col["PLUG_NAME"] = array('Field' => "PLUG_NAME", 'Type' => "varchar(30)", 'default_value' => "NULL");
$plugs_index_col["PLUG_TYPE"] = array('Field' => "PLUG_TYPE", 'Type' => "varchar(20)", 'default_value' => 'other', 'carac' => "NOT NULL");
$plugs_index_col["PLUG_TOLERANCE"] = array('Field' => "PLUG_TOLERANCE", 'Type' => "decimal(3,1)", 'default_value' => "NULL");
$plugs_index_col["PLUG_POWER"] = array('Field' => "PLUG_POWER", 'Type' => "int(11)", 'default_value' => "NULL");
$plugs_index_col["PLUG_POWER_MAX"] = array('Field' => "PLUG_POWER_MAX", 'Type' => "varchar(10)", 'default_value' => '1000', 'carac' => "NOT NULL");
$plugs_index_col["PLUG_REGUL"] = array('Field' => "PLUG_REGUL", 'Type' => "varchar(5)", 'default_value' => 'False', 'carac' => "NOT NULL");
$plugs_index_col["PLUG_REGUL_SENSOR"] = array('Field' => "PLUG_REGUL_SENSOR", 'Type' => "varchar(7)", 'default_value' => '1', 'carac' => "NOT NULL");
$plugs_index_col["PLUG_SENSO"] = array('Field' => "PLUG_SENSO", 'Type' => "varchar(1)", 'default_value' => 'T', 'carac' => "NOT NULL");
$plugs_index_col["PLUG_SENSS"] = array('Field' => "PLUG_SENSS", 'Type' => "varchar(1)", 'default_value' => '+', 'carac' => "NOT NULL");
$plugs_index_col["PLUG_REGUL_VALUE"] = array('Field' => "PLUG_REGUL_VALUE", 'Type' => "decimal(3,1)", 'default_value' => 35.0, 'carac' => "NOT NULL");
$plugs_index_col["PLUG_SECOND_TOLERANCE"] = array('Field' => "PLUG_SECOND_TOLERANCE", 'Type' => "decimal(3,1)", 'default_value' => 0.0, 'carac' => "NOT NULL");
$plugs_index_col["PLUG_COMPUTE_METHOD"] = array('Field' => "PLUG_COMPUTE_METHOD", 'Type' => "varchar(1)", 'default_value' => 'M', 'carac' => "NOT NULL");
$plugs_index_col["PLUG_MODULE"] = array('Field' => "PLUG_MODULE", 'Type' => "varchar(10)", 'default_value' => 'wireless', 'carac' => "NOT NULL");
$plugs_index_col["PLUG_NUM_MODULE"] = array('Field' => "PLUG_NUM_MODULE", 'Type' => "int(11)", 'default_value' => '0', 'carac' => "NOT NULL");
$plugs_index_col["PLUG_MODULE_OPTIONS"] = array('Field' => "PLUG_MODULE_OPTIONS", 'Type' => "varchar(20)", 'default_value' => '', 'carac' => "NOT NULL");
$plugs_index_col["PLUG_MODULE_OUTPUT"] = array('Field' => "PLUG_MODULE_OUTPUT", 'Type' => "int(11)", 'default_value' => '1', 'carac' => "NOT NULL");
$plugs_index_col["PLUG_START_OFFSET"] = array('Field' => "PLUG_START_OFFSET", 'Type' => "int(11)", 'default_value' => '0', 'carac' => "NOT NULL");
// Check if table configuration exists
$sql = "SHOW TABLES FROM bulcky LIKE 'plugs';";
$db = \db_priv_pdo_start("root");
try {
$sth = $db->prepare($sql);
$sth->execute();
$res = $sth->fetchAll(\PDO::FETCH_ASSOC);
} catch (\PDOException $e) {
$ret = $e->getMessage();
}
// If table exists, return
if ($res == null) {
// Buil MySQL command to create table
$sql = "CREATE TABLE plugs (" . "id int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY," . "PLUG_ID varchar(3) DEFAULT NULL," . "PLUG_NAME varchar(30) DEFAULT NULL," . "PLUG_TYPE varchar(20) NOT NULL DEFAULT 'other'," . "PLUG_TOLERANCE decimal(3,1) DEFAULT NULL," . "PLUG_POWER int(11) NULL DEFAULT 100," . "PLUG_POWER_MAX varchar(10) NOT NULL DEFAULT '1000'," . "PLUG_REGUL varchar(5) NOT NULL DEFAULT 'False'," . "PLUG_REGUL_SENSOR VARCHAR( 7 ) NOT NULL DEFAULT '1'," . "PLUG_SENSO varchar(1) NOT NULL DEFAULT 'T'," . "PLUG_SENSS varchar(1) NOT NULL DEFAULT '+'," . "PLUG_REGUL_VALUE decimal(3,1) NOT NULL DEFAULT '35.0'," . "PLUG_SECOND_TOLERANCE DECIMAL( 3, 1 ) NOT NULL DEFAULT '0.0'," . "PLUG_COMPUTE_METHOD VARCHAR( 1 ) NOT NULL DEFAULT 'M')," . "PLUG_MODULE varchar(10) NOT NULL DEFAULT 'wireless')," . "PLUG_NUM_MODULE int(11) NOT NULL DEFAULT '0')," . "PLUG_MODULE_OPTIONS varchar(20) NOT NULL DEFAULT '')," . "PLUG_MODULE_OUTPUT int(11) NOT NULL DEFAULT '1')," . "PLUG_START_OFFSET int(11) NOT NULL DEFAULT '0');";
// Create table
try {
$sth = $db->prepare($sql);
$sth->execute();
} catch (\PDOException $e) {
$ret = $e->getMessage();
print_r($ret);
}
$sql = "INSERT INTO plugs (id, PLUG_ID, PLUG_NAME, PLUG_TYPE, PLUG_TOLERANCE, PLUG_POWER, PLUG_POWER_MAX, PLUG_REGUL, PLUG_REGUL_SENSOR, PLUG_SENSO, PLUG_SENSS, PLUG_REGUL_VALUE, PLUG_SECOND_TOLERANCE,PLUG_COMPUTE_METHOD,PLUG_MODULE) VALUES\n(1,'', 'Prise1', 'other', 1.0, 100, '3500', 'False', '1', 'T', '+', 35.0,0.0,'M','wireless'),\n(2,'', 'Prise2', 'other', 1.0, 100, '1000', 'False', '1', 'T', '+', 35.0,0.0,'M','wireless'),\n(3,'', 'Prise3', 'other', 1.0, 100, '1000', 'False', '1', 'T', '+', 35.0,0.0,'M','wireless'),\n(4,'', 'Prise4', 'other', 1.0, 100, '1000', 'False', '1', 'T', '+', 35.0,0.0,'M','wireless'),\n(5,'', 'Prise5', 'other', 1.0, 100, '1000', 'False', '1', 'T', '+', 35.0,0.0,'M','wireless'),\n(6,'', 'Prise6', 'other', 1.0, 100, '1000', 'False', '1', 'T', '+', 35.0,0.0,'M','wireless'),\n(7,'', 'Prise7', 'other', 1.0, 100, '1000', 'False', '1', 'T', '+', 35.0,0.0,'M','wireless'),\n(8,'', 'Prise8', 'other', 1.0, 100, '1000', 'False', '1', 'T', '+', 35.0,0.0,'M','wireless'),\n(9,'', 'Prise9', 'other', 1.0, 100, '1000', 'False', '1', 'T', '+', 35.0,0.0,'M','wireless'),\n(10,'', 'Prise10', 'other', 1.0, 100, '1000', 'False', '1', 'T', '+', 35.0,0.0,'M','wireless'),\n(11,'', 'Prise11', 'other', 1.0, 100, '1000', 'False', '1', 'T', '+', 35.0,0.0,'M','wireless'),\n(12,'', 'Prise12', 'other', 1.0, 100, '1000', 'False', '1', 'T', '+', 35.0,0.0,'M','wireless'),\n(13,'', 'Prise13', 'other', 1.0, 100, '1000', 'False', '1', 'T', '+', 35.0,0.0,'M','wireless'),\n(14,'', 'Prise14', 'other', 1.0, 100, '1000', 'False', '1', 'T', '+', 35.0,0.0,'M','wireless'),\n(15,'', 'Prise15', 'other', 1.0, 100, '1000', 'False', '1', 'T', '+', 35.0,0.0,'M','wireless'),\n(16,'', 'Prise16', 'other', 1.0, 100, '1000', 'False', '1', 'T', '+', 35.0,0.0,'M','wireless'),\n(17,'', 'Prise16', 'other', 1.0, 100, '1000', 'False', '1', 'T', '+', 35.0,0.0,'M','wireless'),\n(18,'', 'Prise16', 'other', 1.0, 100, '1000', 'False', '1', 'T', '+', 35.0,0.0,'M','wireless'),\n(19,'', 'Prise16', 'other', 1.0, 100, '1000', 'False', '1', 'T', '+', 35.0,0.0,'M','wireless'),\n(20,'', 'Prise16', 'other', 1.0, 100, '1000', 'False', '1', 'T', '+', 35.0,0.0,'M','wireless'),\n(21,'', 'Prise16', 'other', 1.0, 100, '1000', 'False', '1', 'T', '+', 35.0,0.0,'M','wireless'),\n(22,'', 'Prise16', 'other', 1.0, 100, '1000', 'False', '1', 'T', '+', 35.0,0.0,'M','wireless'),\n(23,'', 'Prise16', 'other', 1.0, 100, '1000', 'False', '1', 'T', '+', 35.0,0.0,'M','wireless'),\n(24,'', 'Prise16', 'other', 1.0, 100, '1000', 'False', '1', 'T', '+', 35.0,0.0,'M','wireless'),\n(25,'', 'Prise16', 'other', 1.0, 100, '1000', 'False', '1', 'T', '+', 35.0,0.0,'M','wireless'),\n(26,'', 'Prise16', 'other', 1.0, 100, '1000', 'False', '1', 'T', '+', 35.0,0.0,'M','wireless'),\n(27,'', 'Prise16', 'other', 1.0, 100, '1000', 'False', '1', 'T', '+', 35.0,0.0,'M','wireless'),\n(28,'', 'Prise16', 'other', 1.0, 100, '1000', 'False', '1', 'T', '+', 35.0,0.0,'M','wireless'),\n(29,'', 'Prise16', 'other', 1.0, 100, '1000', 'False', '1', 'T', '+', 35.0,0.0,'M','wireless'),\n(30,'', 'Prise16', 'other', 1.0, 100, '1000', 'False', '1', 'T', '+', 35.0,0.0,'M','wireless'),\n(31,'', 'Prise16', 'other', 1.0, 100, '1000', 'False', '1', 'T', '+', 35.0,0.0,'M','wireless'),\n(32,'', 'Prise16', 'other', 1.0, 100, '1000', 'False', '1', 'T', '+', 35.0,0.0,'M','wireless'),\n(33,'', 'Prise16', 'other', 1.0, 100, '1000', 'False', '1', 'T', '+', 35.0,0.0,'M','wireless'),\n(34,'', 'Prise16', 'other', 1.0, 100, '1000', 'False', '1', 'T', '+', 35.0,0.0,'M','wireless'),\n(35,'', 'Prise16', 'other', 1.0, 100, '1000', 'False', '1', 'T', '+', 35.0,0.0,'M','wireless');";
// Insert row:
try {
$sth = $db->prepare($sql);
$sth->execute();
} catch (\PDOException $e) {
$ret = $e->getMessage();
print_r($ret);
}
} else {
// Check column
check_and_update_column_db("plugs", $plugs_index_col);
}
$db = null;
}
function check_db()
{
// Define columns of the calendar table
$calendar_col = array();
$calendar_col["Id"] = array('Field' => "Id", "Type" => "int(11)", 'carac' => "NOT NULL AUTO_INCREMENT");
$calendar_col["Title"] = array('Field' => "Title", "Type" => "VARCHAR(1000)", "default_value" => "NULL");
$calendar_col["Description"] = array('Field' => "Description", "Type" => "VARCHAR(500)", "default_value" => "NULL");
$calendar_col["StartTime"] = array('Field' => "StartTime", "Type" => "DATETIME", "default_value" => "NULL");
$calendar_col["EndTime"] = array('Field' => "EndTime", "Type" => "DATETIME", "default_value" => "NULL");
$calendar_col["External"] = array('Field' => "External", "Type" => "SMALLINT(6)", "default_value" => 0, 'carac' => "NOT NULL");
$calendar_col["Color"] = array('Field' => "Color", "Type" => "VARCHAR(7)", "default_value" => "#4A40A4", 'carac' => "NOT NULL");
$calendar_col["Icon"] = array('Field' => "Icon", "Type" => "VARCHAR(30)");
$calendar_col["Important"] = array('Field' => "Important", "Type" => "int(1)", 'carac' => "NOT NULL", "default_value" => 0);
$calendar_col["program_index"] = array('Field' => "program_index", "Type" => "VARCHAR(30)", "default_value" => "NULL");
// Check if table program_index exists
$sql = "SHOW TABLES FROM bulcky LIKE 'calendar';";
$db = \db_priv_pdo_start("root");
try {
$sth = $db->prepare($sql);
$sth->execute();
$res = $sth->fetchAll(\PDO::FETCH_ASSOC);
} catch (\PDOException $e) {
$ret = $e->getMessage();
}
// If table exists, return
if ($res == null) {
// Build MySQL command to create table
$sql = "CREATE TABLE calendar (" . "Id int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY," . "Title varchar(1000) DEFAULT NULL," . "Description varchar(500) DEFAULT NULL," . "StartTime datetime DEFAULT NULL," . "EndTime datetime DEFAULT NULL," . "External SMALLINT(6) NOT NULL DEFAULT '0'," . "Color varchar(7) NOT NULL DEFAULT '#4A40A4'," . "Icon VARCHAR(30) NULL," . "Important INT(1) NOT NULL DEFAULT '0'," . "program_index VARCHAR(30) DEFAULT NULL," . " KEY Id (Id));";
// Create table
try {
$sth = $db->prepare($sql);
$sth->execute();
} catch (\PDOException $e) {
$ret = $e->getMessage();
print_r($ret);
}
} else {
// Check column
check_and_update_column_db("calendar", $calendar_col);
}
$db = null;
}
function check_db()
{
// Define columns of the irrigation zone table
$zone_col = array();
$zone_col["id"] = array('Field' => "id", 'Type' => "int(11)", 'carac' => "NOT NULL AUTO_INCREMENT");
$zone_col["name"] = array('Field' => "name", 'Type' => "varchar(20)", "default_value" => 'nom', 'carac' => "NOT NULL");
// Check if table configuration exists
$sql = "SHOW TABLES FROM bulcky LIKE 'trigger_index';";
$db = \db_priv_pdo_start("root");
try {
$sth = $db->prepare($sql);
$sth->execute();
$res = $sth->fetchAll(\PDO::FETCH_ASSOC);
} catch (\PDOException $e) {
$ret = $e->getMessage();
}
// If table exists, return
if ($res == null) {
// Buil MySQL command to create table
$sql = "CREATE TABLE trigger_index (" . "id int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY," . "name varchar(20) NOT NULL DEFAULT '1');";
// Create table
try {
$sth = $db->prepare($sql);
$sth->execute();
} catch (\PDOException $e) {
$ret = $e->getMessage();
print_r($ret);
}
} else {
// Check column
check_and_update_column_db("trigger_index", $zone_col);
}
$db = null;
// Define columns of the irrigation zone table
$zone_col = array();
$zone_col["id"] = array('Field' => "id", 'Type' => "int(11)", 'carac' => "NOT NULL AUTO_INCREMENT");
$zone_col["idTrigger"] = array('Field' => "idTrigger", 'Type' => "int(11)", "default_value" => '1', 'carac' => "NOT NULL");
$zone_col["state"] = array('Field' => "state", 'Type' => "int(11)", "default_value" => '1', 'carac' => "NOT NULL");
$zone_col["action"] = array('Field' => "action", 'Type' => "int(11)", "default_value" => '1', 'carac' => "NOT NULL");
$zone_col["type"] = array('Field' => "type", 'Type' => "varchar(20)", "default_value" => 'plug', 'carac' => "NOT NULL");
$zone_col["value"] = array('Field' => "value", 'Type' => "varchar(20)", "default_value" => '1 on', 'carac' => "NOT NULL");
// Check if table configuration exists
$sql = "SHOW TABLES FROM bulcky LIKE 'trigger_action';";
$db = \db_priv_pdo_start("root");
try {
$sth = $db->prepare($sql);
$sth->execute();
$res = $sth->fetchAll(\PDO::FETCH_ASSOC);
} catch (\PDOException $e) {
$ret = $e->getMessage();
}
// If table exists, return
if ($res == null) {
// Buil MySQL command to create table
$sql = "CREATE TABLE trigger_action (" . "id int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY," . "state int(11) NOT NULL DEFAULT '1'," . "idTrigger int(11) NOT NULL DEFAULT '1'," . "action int(11) NOT NULL DEFAULT '1'," . "type varchar(20) NOT NULL DEFAULT '1'," . "value varchar(20) NOT NULL DEFAULT '1');";
// Create table
try {
$sth = $db->prepare($sql);
$sth->execute();
} catch (\PDOException $e) {
$ret = $e->getMessage();
print_r($ret);
}
} else {
// Check column
check_and_update_column_db("trigger_action", $zone_col);
}
$db = null;
// Define columns of the irrigation zone table
$zone_col = array();
$zone_col["id"] = array('Field' => "id", 'Type' => "int(11)", 'carac' => "NOT NULL AUTO_INCREMENT");
$zone_col["idTrigger"] = array('Field' => "idTrigger", 'Type' => "int(11)", "default_value" => '1', 'carac' => "NOT NULL");
$zone_col["state"] = array('Field' => "state", 'Type' => "int(11)", "default_value" => '1', 'carac' => "NOT NULL");
$zone_col["action"] = array('Field' => "action", 'Type' => "int(11)", "default_value" => '1', 'carac' => "NOT NULL");
$zone_col["type"] = array('Field' => "type", 'Type' => "varchar(20)", "default_value" => 'plug', 'carac' => "NOT NULL");
$zone_col["sensor"] = array('Field' => "sensor", 'Type' => "varchar(20)", "default_value" => 'plug', 'carac' => "NOT NULL");
$zone_col["value"] = array('Field' => "value", 'Type' => "varchar(20)", "default_value" => '1 on', 'carac' => "NOT NULL");
// Check if table configuration exists
$sql = "SHOW TABLES FROM bulcky LIKE 'trigger_condition';";
$db = \db_priv_pdo_start("root");
try {
$sth = $db->prepare($sql);
$sth->execute();
$res = $sth->fetchAll(\PDO::FETCH_ASSOC);
} catch (\PDOException $e) {
$ret = $e->getMessage();
}
// If table exists, return
if ($res == null) {
// Buil MySQL command to create table
$sql = "CREATE TABLE trigger_condition (" . "id int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY," . "idTrigger int(11) NOT NULL DEFAULT '1'," . "state int(11) NOT NULL DEFAULT '1'," . "action int(11) NOT NULL DEFAULT '1'," . "type varchar(20) NOT NULL DEFAULT '1'," . "sensor varchar(20) NOT NULL DEFAULT '1'," . "value varchar(20) NOT NULL DEFAULT '1');";
// Create table
try {
$sth = $db->prepare($sql);
$sth->execute();
} catch (\PDOException $e) {
$ret = $e->getMessage();
print_r($ret);
}
} else {
// Check column
check_and_update_column_db("trigger_condition", $zone_col);
}
$db = null;
}
function check_db()
{
// Define columns of the irrigation zone table
$zone_col = array();
$zone_col["id"] = array('Field' => "id", 'Type' => "int(11)", 'carac' => "NOT NULL AUTO_INCREMENT");
$zone_col["motherPlatef"] = array('Field' => "motherPlatef", 'Type' => "int(11)", "default_value" => 0, 'carac' => "NOT NULL");
$zone_col["zoneId"] = array('Field' => "zoneId", 'Type' => "int(11)", "default_value" => 1, 'carac' => "NOT NULL");
$zone_col["name"] = array('Field' => "name", 'Type' => "VARCHAR(20)", "default_value" => "other", 'carac' => "NOT NULL");
$zone_col["prise"] = array('Field' => "prise", 'Type' => "int(11)", "default_value" => 0, 'carac' => "NOT NULL");
$zone_col["tempsOn"] = array('Field' => "tempsOn", 'Type' => "int(11)", "default_value" => 0, 'carac' => "NOT NULL");
$zone_col["tempsOff"] = array('Field' => "tempsOff", 'Type' => "int(11)", "default_value" => 0, 'carac' => "NOT NULL");
$zone_col["active"] = array('Field' => "active", 'Type' => "VARCHAR(5)", "default_value" => "on", 'carac' => "NOT NULL");
$zone_col["coef"] = array('Field' => "coef", 'Type' => "decimal(6,2)", "default_value" => 1.0, 'carac' => "NOT NULL");
$zone_col["tempsOnNuit"] = array('Field' => "tempsOnNuit", 'Type' => "int(11)", "default_value" => 0, 'carac' => "NOT NULL");
$zone_col["tempsOffNuit"] = array('Field' => "tempsOffNuit", 'Type' => "int(11)", "default_value" => 0, 'carac' => "NOT NULL");
$zone_col["tempsOnApresMidi"] = array('Field' => "tempsOnApresMidi", 'Type' => "int(11)", "default_value" => 0, 'carac' => "NOT NULL");
$zone_col["tempsOffApresMidi"] = array('Field' => "tempsOffApresMidi", 'Type' => "int(11)", "default_value" => 0, 'carac' => "NOT NULL");
// Check if table configuration exists
$sql = "SHOW TABLES FROM bulcky LIKE 'irrigation_zone';";
$db = \db_priv_pdo_start("root");
try {
$sth = $db->prepare($sql);
$sth->execute();
$res = $sth->fetchAll(\PDO::FETCH_ASSOC);
} catch (\PDOException $e) {
$ret = $e->getMessage();
}
// If table exists, return
if ($res == null) {
// Buil MySQL command to create table
$sql = "CREATE TABLE irrigation_zone (" . "id int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY," . "motherPlatef int(11) NOT NULL DEFAULT '1'," . "zoneId int(11) NOT NULL DEFAULT '1'," . "name varchar(20) NOT NULL DEFAULT 'other'," . "prise int(11) NOT NULL DEFAULT '0'," . "tempsOn int(11) NOT NULL DEFAULT '0'," . "tempsOff int(11) NOT NULL DEFAULT '0'," . "active varchar(5) NOT NULL DEFAULT 'true'," . "coef decimal(6,2) NOT NULL DEFAULT '1.0'," . "tempsOnNuit int(11) NOT NULL DEFAULT '0'," . "tempsOffNuit int(11) NOT NULL DEFAULT '0'," . "tempsOnApresMidi int(11) NOT NULL DEFAULT '0'," . "tempsOffApresMidi int(11) NOT NULL DEFAULT '0' );";
// Create table
try {
$sth = $db->prepare($sql);
$sth->execute();
} catch (\PDOException $e) {
$ret = $e->getMessage();
print_r($ret);
}
} else {
// Check column
check_and_update_column_db("irrigation_zone", $zone_col);
}
$db = null;
// Create table for plateforme
// Define columns of the irrigation zone table
$plateforme_col = array();
$plateforme_col["id"] = array('Field' => "id", 'Type' => "int(11)", 'carac' => "NOT NULL AUTO_INCREMENT");
$plateforme_col["idPlateforme"] = array('Field' => "idPlateforme", 'Type' => "int(11)", "default_value" => 1, 'carac' => "NOT NULL");
$plateforme_col["name"] = array('Field' => "name", 'Type' => "VARCHAR(20)", "default_value" => "other", 'carac' => "NOT NULL");
$plateforme_col["ip"] = array('Field' => "ip", 'Type' => "VARCHAR(16)", "default_value" => "1", 'carac' => "NOT NULL");
$plateforme_col["pompeName"] = array('Field' => "pompeName", 'Type' => "VARCHAR(20)", "default_value" => "pompe", 'carac' => "NOT NULL");
$plateforme_col["pompePrise"] = array('Field' => "pompePrise", 'Type' => "int(11)", "default_value" => 1, 'carac' => "NOT NULL");
$plateforme_col["active"] = array('Field' => "active", 'Type' => "VARCHAR(5)", "default_value" => "true", 'carac' => "NOT NULL");
$plateforme_col["limitDesamorcagePompe"] = array('Field' => "limitDesamorcagePompe", 'Type' => "VARCHAR(5)", "default_value" => "true", 'carac' => "NOT NULL");
$plateforme_col["tempsPerco"] = array('Field' => "tempsPerco", 'Type' => "int(11)", "default_value" => 0, 'carac' => "NOT NULL");
$plateforme_col["tempsMaxRemp"] = array('Field' => "tempsMaxRemp", 'Type' => "int(11)", "default_value" => 300, 'carac' => "NOT NULL");
$plateforme_col["tempsMaxRempApresMidi"] = array('Field' => "tempsMaxRempApresMidi", 'Type' => "int(11)", "default_value" => 300, 'carac' => "NOT NULL");
$plateforme_col["tempsMaxRempNuit"] = array('Field' => "tempsMaxRempNuit", 'Type' => "int(11)", "default_value" => 300, 'carac' => "NOT NULL");
$plateforme_col["priseDansLT"] = array('Field' => "priseDansLT", 'Type' => "int(11)", "default_value" => 0, 'carac' => "NOT NULL");
$plateforme_col["tempsPercoNuit"] = array('Field' => "tempsPercoNuit", 'Type' => "int(11)", "default_value" => 0, 'carac' => "NOT NULL");
$plateforme_col["tempsPercoApresMidi"] = array('Field' => "tempsPercoApresMidi", 'Type' => "int(11)", "default_value" => 0, 'carac' => "NOT NULL");
$plateforme_col["priseEau"] = array('Field' => "priseEau", 'Type' => "int(11)", "default_value" => 0, 'carac' => "NOT NULL");
$plateforme_col["activeAutoRemplissage"] = array('Field' => "activeAutoRemplissage", 'Type' => "VARCHAR(5)", "default_value" => "false", 'carac' => "NOT NULL");
$plateforme_col["autoRemplissageDirect"] = array('Field' => "autoRemplissageDirect", 'Type' => "VARCHAR(5)", "default_value" => "true", 'carac' => "NOT NULL");
$plateforme_col["priseRegulation"] = array('Field' => "priseRegulation", 'Type' => "int(11)", "default_value" => 0, 'carac' => "NOT NULL");
$plateforme_col["priseRemplissage"] = array('Field' => "priseRemplissage", 'Type' => "int(11)", "default_value" => 0, 'carac' => "NOT NULL");
$plateforme_col["tempsAutoRemplissage"] = array('Field' => "tempsAutoRemplissage", 'Type' => "int(11)", "default_value" => 30, 'carac' => "NOT NULL");
// Check if table configuration exists
$sql = "SHOW TABLES FROM bulcky LIKE 'irrigation_plateforme';";
$db = \db_priv_pdo_start("root");
try {
$sth = $db->prepare($sql);
$sth->execute();
$res = $sth->fetchAll(\PDO::FETCH_ASSOC);
} catch (\PDOException $e) {
$ret = $e->getMessage();
}
// If table exists, return
if ($res == null) {
// Buil MySQL command to create table
$sql = "CREATE TABLE irrigation_plateforme (" . "id int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY," . "idPlateforme int(11) NOT NULL DEFAULT '1'," . "name varchar(20) NOT NULL DEFAULT 'other'," . "ip VARCHAR(16) NOT NULL DEFAULT '1'," . "pompeName varchar(20) NOT NULL DEFAULT 'pompe'," . "pompePrise int(11) NOT NULL DEFAULT '1'," . "active varchar(5) NOT NULL DEFAULT 'true'," . "limitDesamorcagePompe varchar(5) NOT NULL DEFAULT 'true'," . "tempsPerco int(11) NOT NULL DEFAULT '0'," . "tempsMaxRemp int(11) NOT NULL DEFAULT '100'," . "tempsMaxRempApresMidi int(11) NOT NULL DEFAULT '100'," . "tempsMaxRempNuit int(11) NOT NULL DEFAULT '100'," . "priseDansLT int(11) NOT NULL DEFAULT '0'," . "tempsPercoNuit int(11) NOT NULL DEFAULT '0'," . "tempsPercoApresMidi int(11) NOT NULL DEFAULT '0'," . "priseEau int(11) NOT NULL DEFAULT '0'," . "activeAutoRemplissage varchar(5) NOT NULL DEFAULT 'false'," . "autoRemplissageDirect varchar(5) NOT NULL DEFAULT 'true'," . "priseRegulation int(11) NOT NULL DEFAULT '0'," . "priseRemplissage int(11) NOT NULL DEFAULT '0'," . "tempsAutoRemplissage int(11) NOT NULL DEFAULT '30' );";
// Create table
try {
$sth = $db->prepare($sql);
$sth->execute();
} catch (\PDOException $e) {
$ret = $e->getMessage();
print_r($ret);
}
} else {
// Check column
check_and_update_column_db("irrigation_plateforme", $plateforme_col);
}
$db = null;
// Create table for localtechnique
$lt_col = array();
$lt_col["id"] = array('Field' => "id", 'Type' => "int(11)", 'carac' => "NOT NULL AUTO_INCREMENT");
$lt_col["name"] = array('Field' => "name", 'Type' => "VARCHAR(20)", "default_value" => "local_technique", 'carac' => "NOT NULL");
$lt_col["ip"] = array('Field' => "ip", 'Type' => "VARCHAR(16)", "default_value" => "1", 'carac' => "NOT NULL");
$lt_col["pompeName"] = array('Field' => "pompeName", 'Type' => "VARCHAR(20)", "default_value" => 'pompe', 'carac' => "NOT NULL");
$lt_col["pompePrise"] = array('Field' => "pompePrise", 'Type' => "int(11)", "default_value" => 0, 'carac' => "NOT NULL");
$lt_col["irriActive"] = array('Field' => "irriActive", 'Type' => "VARCHAR(5)", "default_value" => "on", 'carac' => "NOT NULL");
$lt_col["timeMatinStarter"] = array('Field' => "timeMatinStarter", 'Type' => "int(11)", "default_value" => 0, 'carac' => "NOT NULL");
$lt_col["timeApresStarter"] = array('Field' => "timeApresStarter", 'Type' => "int(11)", "default_value" => 0, 'carac' => "NOT NULL");
$lt_col["timeNuitStarter"] = array('Field' => "timeNuitStarter", 'Type' => "int(11)", "default_value" => 0, 'carac' => "NOT NULL");
// Check if table configuration exists
$sql = "SHOW TABLES FROM bulcky LIKE 'irrigation_lt';";
$db = \db_priv_pdo_start("root");
try {
$sth = $db->prepare($sql);
$sth->execute();
$res = $sth->fetchAll(\PDO::FETCH_ASSOC);
} catch (\PDOException $e) {
$ret = $e->getMessage();
}
// If table exists, return
if ($res == null) {
// Buil MySQL command to create table
$sql = "CREATE TABLE irrigation_lt (" . "id int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY," . "name varchar(20) NOT NULL DEFAULT 'local_technique'," . "ip VARCHAR(16) NOT NULL DEFAULT '1'," . "pompeName varchar(20) NOT NULL DEFAULT 'pompe'," . "pompePrise int(11) NOT NULL DEFAULT '1'," . "irriActive varchar(5) NOT NULL DEFAULT 'true'," . "timeMatinStarter int(11) NOT NULL DEFAULT '0'," . "timeApresStarter int(11) NOT NULL DEFAULT '0'," . "timeNuitStarter int(11) NOT NULL DEFAULT '0');";
// Create table
try {
$sth = $db->prepare($sql);
$sth->execute();
} catch (\PDOException $e) {
$ret = $e->getMessage();
print_r($ret);
}
} else {
// Check column
check_and_update_column_db("irrigation_lt", $lt_col);
}
$db = null;
// Create table for engrais
$engrais_col = array();
$engrais_col["id"] = array('Field' => "id", 'Type' => "int(11)", 'carac' => "NOT NULL AUTO_INCREMENT");
$engrais_col["name"] = array('Field' => "name", 'Type' => "VARCHAR(10)", "default_value" => "engrais", 'carac' => "NOT NULL");
$engrais_col["prise"] = array('Field' => "prise", 'Type' => "int(11)", "default_value" => 0, 'carac' => "NOT NULL");
$engrais_col["active"] = array('Field' => "active", 'Type' => "VARCHAR(5)", "default_value" => "on", 'carac' => "NOT NULL");
$engrais_col["engraisId"] = array('Field' => "engraisId", 'Type' => "int(11)", "default_value" => 1, 'carac' => "NOT NULL");
$engrais_col["useMatinStarter"] = array('Field' => "useMatinStarter", 'Type' => "VARCHAR(5)", "default_value" => 'false', 'carac' => "NOT NULL");
$engrais_col["useMatinNormal"] = array('Field' => "useMatinNormal", 'Type' => "VARCHAR(5)", "default_value" => 'false', 'carac' => "NOT NULL");
$engrais_col["useApresStarter"] = array('Field' => "useApresStarter", 'Type' => "VARCHAR(5)", "default_value" => 'false', 'carac' => "NOT NULL");
$engrais_col["useApresNormal"] = array('Field' => "useApresNormal", 'Type' => "VARCHAR(5)", "default_value" => 'false', 'carac' => "NOT NULL");
$engrais_col["useNuitStarter"] = array('Field' => "useNuitStarter", 'Type' => "VARCHAR(5)", "default_value" => 'false', 'carac' => "NOT NULL");
$engrais_col["useNuitNormal"] = array('Field' => "useNuitNormal", 'Type' => "VARCHAR(5)", "default_value" => 'false', 'carac' => "NOT NULL");
// Check if table configuration exists
$sql = "SHOW TABLES FROM bulcky LIKE 'irrigation_engrais';";
$db = \db_priv_pdo_start("root");
try {
$sth = $db->prepare($sql);
$sth->execute();
$res = $sth->fetchAll(\PDO::FETCH_ASSOC);
} catch (\PDOException $e) {
$ret = $e->getMessage();
}
// If table exists, return
if ($res == null) {
// Buil MySQL command to create table
$sql = "CREATE TABLE irrigation_engrais (" . "id int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY," . "name varchar(20) NOT NULL DEFAULT 'engrais'," . "prise int(11) NOT NULL DEFAULT '1'," . "active varchar(5) NOT NULL DEFAULT 'true'," . "engraisId int(11) NOT NULL DEFAULT '1'," . "useMatinStarter varchar(5) NOT NULL DEFAULT 'false'," . "useMatinNormal varchar(5) NOT NULL DEFAULT 'false'," . "useApresStarter varchar(5) NOT NULL DEFAULT 'false'," . "useApresNormal varchar(5) NOT NULL DEFAULT 'false'," . "useNuitStarter varchar(5) NOT NULL DEFAULT 'false'," . "useNuitNormal varchar(5) NOT NULL DEFAULT 'false')";
// Create table
try {
$sth = $db->prepare($sql);
$sth->execute();
} catch (\PDOException $e) {
$ret = $e->getMessage();
print_r($ret);
}
} else {
// Check column
check_and_update_column_db("irrigation_engrais", $engrais_col);
}
$db = null;
}
function check_db()
{
// Define columns of the calendar table
$conf_index_col = array();
$conf_index_col["id"] = array('Field' => "id", 'Type' => "int(11)", 'carac' => "NOT NULL AUTO_INCREMENT");
$conf_index_col["COLOR_HUMIDITY_GRAPH"] = array('Field' => "COLOR_HUMIDITY_GRAPH", 'Type' => "varchar(30)", 'default_value' => "blue", 'carac' => "NOT NULL");
$conf_index_col["COLOR_TEMPERATURE_GRAPH"] = array('Field' => "COLOR_TEMPERATURE_GRAPH", 'Type' => "varchar(30)", 'default_value' => "red", 'carac' => "NOT NULL");
$conf_index_col["COLOR_WATER_GRAPH"] = array('Field' => "COLOR_WATER_GRAPH", 'Type' => "varchar(30)", 'default_value' => "orange", 'carac' => "NOT NULL");
$conf_index_col["COLOR_LEVEL_GRAPH"] = array('Field' => "COLOR_LEVEL_GRAPH", 'Type' => "varchar(30)", 'default_value' => "pink", 'carac' => "NOT NULL");
$conf_index_col["COLOR_PH_GRAPH"] = array('Field' => "COLOR_PH_GRAPH", 'Type' => "varchar(30)", 'default_value' => "brown", 'carac' => "NOT NULL");
$conf_index_col["COLOR_EC_GRAPH"] = array('Field' => "COLOR_EC_GRAPH", 'Type' => "varchar(30)", 'default_value' => "yellow", 'carac' => "NOT NULL");
$conf_index_col["COLOR_OD_GRAPH"] = array('Field' => "COLOR_OD_GRAPH", 'Type' => "varchar(30)", 'default_value' => "red", 'carac' => "NOT NULL");
$conf_index_col["COLOR_ORP_GRAPH"] = array('Field' => "COLOR_ORP_GRAPH", 'Type' => "varchar(30)", 'default_value' => "blue", 'carac' => "NOT NULL");
$conf_index_col["COLOR_CO2_GRAPH"] = array('Field' => "COLOR_CO2_GRAPH", 'Type' => "varchar(30)", 'default_value' => "blue", 'carac' => "NOT NULL");
$conf_index_col["COLOR_PRESSURE_GRAPH"] = array('Field' => "COLOR_PRESSURE_GRAPH", 'Type' => "varchar(30)", 'default_value' => "blue", 'carac' => "NOT NULL");
$conf_index_col["NB_PLUGS"] = array('Field' => "NB_PLUGS", 'Type' => "int(11)", 'default_value' => 3, 'carac' => "NOT NULL");
$conf_index_col["COST_PRICE"] = array('Field' => "COST_PRICE", 'Type' => "decimal(6,4)", 'default_value' => 0.1249, 'carac' => "NOT NULL");
$conf_index_col["COST_PRICE_HP"] = array('Field' => "COST_PRICE_HP", 'Type' => "decimal(6,4)", 'default_value' => 0.1353, 'carac' => "NOT NULL");
$conf_index_col["COST_PRICE_HC"] = array('Field' => "COST_PRICE_HC", 'Type' => "decimal(6,4)", 'default_value' => 0.0926, 'carac' => "NOT NULL");
$conf_index_col["START_TIME_HC"] = array('Field' => "START_TIME_HC", 'Type' => "varchar(5)", 'default_value' => "22:30", 'carac' => "NOT NULL");
$conf_index_col["STOP_TIME_HC"] = array('Field' => "STOP_TIME_HC", 'Type' => "varchar(5)", 'default_value' => "06:30", 'carac' => "NOT NULL");
$conf_index_col["COST_TYPE"] = array('Field' => "COST_TYPE", 'Type' => "varchar(20)", 'default_value' => "standard", 'carac' => "NOT NULL");
$conf_index_col["ADVANCED_REGUL_OPTIONS"] = array('Field' => "ADVANCED_REGUL_OPTIONS", 'Type' => "varchar(5)", 'default_value' => "False", 'carac' => "NOT NULL");
$conf_index_col["REMOVE_1000_CHANGE_LIMIT"] = array('Field' => "REMOVE_1000_CHANGE_LIMIT", 'Type' => "varchar(5)", 'default_value' => "False", 'carac' => "NOT NULL");
$conf_index_col["REMOVE_5_MINUTE_LIMIT"] = array('Field' => "REMOVE_5_MINUTE_LIMIT", 'Type' => "varchar(5)", 'default_value' => "False", 'carac' => "NOT NULL");
$conf_index_col["DEFAULT_LANG"] = array('Field' => "DEFAULT_LANG", 'Type' => "varchar(5)", 'default_value' => "fr_FR", 'carac' => "NOT NULL");
$conf_index_col["ENABLE_LED"] = array('Field' => "ENABLE_LED", 'Type' => "varchar(4)", 'default_value' => "0001", 'carac' => "NOT NULL");
$conf_index_col["EMAIL_ADRESS"] = array('Field' => "EMAIL_ADRESS", 'Type' => "varchar(40)", 'default_value' => "*****@*****.**", 'carac' => "NOT NULL");
$conf_index_col["EMAIL_PASSWORD"] = array('Field' => "EMAIL_PASSWORD", 'Type' => "varchar(40)", 'default_value' => "motdepasse", 'carac' => "NOT NULL");
$conf_index_col["EMAIL_PROVIDER"] = array('Field' => "EMAIL_PROVIDER", 'Type' => "varchar(40)", 'default_value' => "other", 'carac' => "NOT NULL");
$conf_index_col["EMAIL_SMTP"] = array('Field' => "EMAIL_SMTP", 'Type' => "varchar(40)", 'default_value' => "smtp.gmail.com", 'carac' => "NOT NULL");
$conf_index_col["EMAIL_PORT"] = array('Field' => "EMAIL_PORT", 'Type' => "int(11)", 'default_value' => 587, 'carac' => "NOT NULL");
$conf_index_col["EMAIL_USE_SSL"] = array('Field' => "EMAIL_USE_SSL", 'Type' => "varchar(5)", 'default_value' => 'true', 'carac' => "NOT NULL");
// Check if table configuration exists
$sql = "SHOW TABLES FROM bulcky LIKE 'configuration';";
$db = \db_priv_pdo_start("root");
try {
$sth = $db->prepare($sql);
$sth->execute();
$res = $sth->fetchAll(\PDO::FETCH_ASSOC);
} catch (\PDOException $e) {
$ret = $e->getMessage();
}
// If table exists, return
if ($res == null) {
// Buil MySQL command to create table
$sql = "CREATE TABLE `configuration` (" . "id int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY," . "COLOR_HUMIDITY_GRAPH varchar(30) NOT NULL DEFAULT 'blue'," . "COLOR_TEMPERATURE_GRAPH varchar(30) NOT NULL DEFAULT 'red'," . "COLOR_WATER_GRAPH varchar(30) NOT NULL DEFAULT 'orange'," . "COLOR_LEVEL_GRAPH varchar(30) NOT NULL DEFAULT 'pink'," . "COLOR_PH_GRAPH varchar(30) NOT NULL DEFAULT 'brown'," . "COLOR_EC_GRAPH varchar(30) NOT NULL DEFAULT 'yellow'," . "COLOR_OD_GRAPH varchar(30) NOT NULL DEFAULT 'red'," . "COLOR_ORP_GRAPH varchar(30) NOT NULL DEFAULT 'blue'," . "COLOR_CO2_GRAPH varchar(30) NOT NULL DEFAULT 'blue'," . "COLOR_PRESSURE_GRAPH varchar(30) NOT NULL DEFAULT 'blue'," . "NB_PLUGS int(11) NOT NULL DEFAULT '3'," . "COST_PRICE decimal(6,4) NOT NULL DEFAULT '0.1249'," . "COST_PRICE_HP decimal(6,4) NOT NULL DEFAULT '0.1353'," . "COST_PRICE_HC decimal(6,4) NOT NULL DEFAULT '0.0926'," . "START_TIME_HC varchar(5) NOT NULL DEFAULT '22:30'," . "STOP_TIME_HC varchar(5) NOT NULL DEFAULT '06:30'," . "COST_TYPE varchar(20) NOT NULL DEFAULT 'standard'," . "ADVANCED_REGUL_OPTIONS VARCHAR(5) NOT NULL DEFAULT 'False'," . "REMOVE_1000_CHANGE_LIMIT VARCHAR(5) NOT NULL DEFAULT 'False'," . "REMOVE_5_MINUTE_LIMIT VARCHAR(5) NOT NULL DEFAULT 'False'," . "DEFAULT_LANG VARCHAR(5) NOT NULL DEFAULT 'fr_FR'," . "ENABLE_LED varchar(4) NOT NULL DEFAULT '0001'," . "EMAIL_ADRESS varchar(40) NOT NULL DEFAULT '*****@*****.**'," . "EMAIL_PASSWORD varchar(40) NOT NULL DEFAULT 'motdepasse'," . "EMAIL_PROVIDER varchar(40) NOT NULL DEFAULT 'other'," . "EMAIL_SMTP varchar(40) NOT NULL DEFAULT 'smtp.gmail.com'," . "EMAIL_PORT int(11) NOT NULL DEFAULT '587'," . "EMAIL_USE_SSL varchar(5) NOT NULL DEFAULT 'true');";
// Create table
try {
$sth = $db->prepare($sql);
$sth->execute();
} catch (\PDOException $e) {
$ret = $e->getMessage();
print_r($ret);
}
$sql = "INSERT INTO configuration (id, COLOR_HUMIDITY_GRAPH, COLOR_TEMPERATURE_GRAPH, COLOR_WATER_GRAPH, COLOR_LEVEL_GRAPH, COLOR_PH_GRAPH, COLOR_EC_GRAPH, COLOR_OD_GRAPH, COLOR_ORP_GRAPH,NB_PLUGS, COST_PRICE, COST_PRICE_HP, COST_PRICE_HC, START_TIME_HC, STOP_TIME_HC, COST_TYPE, ADVANCED_REGUL_OPTIONS,ENABLE_LED) VALUES (1, 'blue', 'red', 'orange', 'pink', 'brown', 'yellow', 'red', 'blue', 3, 0.1225, 0.1353, 0.0926, '22:30', '06:30', 'standard', 'False', '0001');";
// Insert row:
try {
$sth = $db->prepare($sql);
$sth->execute();
} catch (PDOException $e) {
$ret = $e->getMessage();
print_r($ret);
}
} else {
check_and_update_column_db("configuration", $conf_index_col);
}
$db = null;
}
function check_db()
{
// Define columns of the sensor table
$sensors_index_col = array();
$sensors_index_col["id"] = array('Field' => "id", 'Type' => "int(11)", 'carac' => 'NOT NULL AUTO_INCREMENT');
$sensors_index_col["sensorIndex"] = array('Field' => "sensorIndex", 'Type' => "varchar(2)", 'default_value' => "NA", 'carac' => "NOT NULL");
$sensors_index_col["type"] = array('Field' => "type", 'Type' => "varchar(2)", 'default_value' => 0, 'carac' => "NOT NULL");
$sensors_index_col["name"] = array('Field' => "name", 'Type' => "varchar(20)", 'default_value' => "capteur", 'carac' => "NOT NULL");
$sensors_index_col["source"] = array('Field' => "source", 'Type' => "varchar(10)", 'default_value' => "rj12", 'carac' => "NOT NULL");
$sensors_index_col["input"] = array('Field' => "input", 'Type' => "varchar(2)", 'default_value' => "NA", 'carac' => "NOT NULL");
$sensors_index_col["value"] = array('Field' => "value", 'Type' => "varchar(2)", 'default_value' => "NA", 'carac' => "NOT NULL");
$sensors_index_col["input2"] = array('Field' => "input2", 'Type' => "varchar(2)", 'default_value' => "NA", 'carac' => "NOT NULL");
$sensors_index_col["value2"] = array('Field' => "value2", 'Type' => "varchar(2)", 'default_value' => "NA", 'carac' => "NOT NULL");
$sensors_index_col["statusOK"] = array('Field' => "statusOK", 'Type' => "int(11)", 'default_value' => 1, 'carac' => "NOT NULL");
$sensors_index_col["statusOK2"] = array('Field' => "statusOK2", 'Type' => "int(11)", 'default_value' => 1, 'carac' => "NOT NULL");
// Check if table configuration exists
$sql = "SHOW TABLES FROM bulcky LIKE 'sensors';";
$db = \db_priv_pdo_start("root");
try {
$sth = $db->prepare($sql);
$sth->execute();
$res = $sth->fetchAll(\PDO::FETCH_ASSOC);
} catch (\PDOException $e) {
$ret = $e->getMessage();
}
// If table exists, return
if ($res == null) {
// Buil MySQL command to create table
$sql = "CREATE TABLE sensors (" . "id int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY, " . "sensorIndex varchar(2) NOT NULL DEFAULT 'NA', " . "type varchar(2) NOT NULL DEFAULT '0', " . "name varchar(20) NOT NULL DEFAULT 'capteur'" . "input varchar(2) NOT NULL DEFAULT 'NA', " . "value varchar(2) NOT NULL DEFAULT 'NA'" . "input2 varchar(2) NOT NULL DEFAULT 'NA'" . "value2 varchar(2) NOT NULL DEFAULT 'NA'" . "statusOK int(11) NOT NULL DEFAULT 1" . "statusOK2 int(11) NOT NULL DEFAULT 1" . ");";
// Create table
try {
$sth = $db->prepare($sql);
$sth->execute();
} catch (\PDOException $e) {
$ret = $e->getMessage();
print_r($ret);
}
$sql = "INSERT INTO sensors (id, type) VALUES (1, '2'), (2, '2'), (3, '2'), (4, '2'), (5, '0'),(6, '0'), (7, '0'), (8, '0'), (9, '0'), (10, '0'), (11, '0'), (12, '0'), (13, '0'), (14, '0'), (15, '0'), (16, '0'), (17, '0'), (18, '0'), (19, '0'), (20, '0'), (21, '0'), (22, '0'), (23, '0'), (24, '0'), (25, '0'), (26, '0'), (27, '0'), (28, '0'), (29, '0'), (30, '0'), (31, '0'), (32, '0');";
// Insert row:
try {
$sth = $db->prepare($sql);
$sth->execute();
} catch (\PDOException $e) {
$ret = $e->getMessage();
print_r($ret);
}
} else {
// Check column
check_and_update_column_db("sensors", $sensors_index_col);
//Check value:
//For version > 2.0.02:
$sql = "ALTER TABLE sensors ADD PRIMARY KEY (id);";
try {
$db->exec("{$sql}");
} catch (PDOException $e) {
$ret = $e->getMessage();
}
// Check if every sensor has not an incorrect value :
// Incorrect value : 1 4 5
check_sensors_def();
}
$db = null;
// Define columns of the direct read table
$direct_read_index_col = array();
$direct_read_index_col["id"] = array('Field' => "id", 'Type' => "int(11)", 'carac' => 'NOT NULL AUTO_INCREMENT');
$direct_read_index_col["sensorIndex"] = array('Field' => "sensorIndex", 'Type' => "varchar(2)", 'default_value' => "NA", 'carac' => "NOT NULL");
// Check if table configuration exists
$sql = "SHOW TABLES FROM bulcky LIKE 'sensors_directRead';";
$db = \db_priv_pdo_start("root");
try {
$sth = $db->prepare($sql);
$sth->execute();
$res = $sth->fetchAll(\PDO::FETCH_ASSOC);
} catch (\PDOException $e) {
$ret = $e->getMessage();
}
// If table exists, return
if ($res == null) {
// Buil MySQL command to create table
$sql = "CREATE TABLE sensors_directRead (" . "id int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY, " . "sensorIndex varchar(2) NOT NULL DEFAULT 'NA', " . "input varchar(2) NOT NULL DEFAULT 'NA', " . "value varchar(2) NOT NULL DEFAULT 'NA'" . "input2 varchar(2) NOT NULL DEFAULT 'NA'" . "value2 varchar(2) NOT NULL DEFAULT 'NA'" . "type varchar(20) NOT NULL DEFAULT 'NA'" . "statusOK int(11) NOT NULL DEFAULT 1" . "statusOK2 int(11) NOT NULL DEFAULT 1" . ");";
// Create table
try {
$sth = $db->prepare($sql);
$sth->execute();
} catch (\PDOException $e) {
$ret = $e->getMessage();
print_r($ret);
}
} else {
// Check column
check_and_update_column_db("sensors_directRead", $direct_read_index_col);
}
$db = null;
}
function check_db()
{
// Define columns of the synoptic table
$synoptic_col = array();
$synoptic_col["id"] = array('Field' => "id", 'Type' => "int(11)", 'carac' => "NOT NULL AUTO_INCREMENT");
$synoptic_col["element"] = array('Field' => "element", 'Type' => "VARCHAR(10)", "default_value" => "other", 'carac' => "NOT NULL");
$synoptic_col["scale"] = array('Field' => "scale", 'Type' => "int(11)", "default_value" => 100, 'carac' => "NOT NULL");
$synoptic_col["x"] = array('Field' => "x", 'Type' => "int(11)", "default_value" => 0, 'carac' => "NOT NULL");
$synoptic_col["y"] = array('Field' => "y", 'Type' => "int(11)", "default_value" => 0, 'carac' => "NOT NULL");
$synoptic_col["z"] = array('Field' => "z", 'Type' => "int(11)", "default_value" => 100, 'carac' => "NOT NULL");
$synoptic_col["indexElem"] = array('Field' => "indexElem", 'Type' => "int(11)", "default_value" => 0, 'carac' => "NOT NULL");
$synoptic_col["rotation"] = array('Field' => "rotation", 'Type' => "int(11)", "default_value" => 0, 'carac' => "NOT NULL");
$synoptic_col["image"] = array('Field' => "image", 'Type' => "VARCHAR(50)", "default_value" => "", 'carac' => "NOT NULL");
// Check if table configuration exists
$sql = "SHOW TABLES FROM bulcky LIKE 'synoptic';";
$db = \db_priv_pdo_start("root");
try {
$sth = $db->prepare($sql);
$sth->execute();
$res = $sth->fetchAll(\PDO::FETCH_ASSOC);
} catch (\PDOException $e) {
$ret = $e->getMessage();
}
// If table exists, return
if ($res == null) {
// Buil MySQL command to create table
$sql = "CREATE TABLE synoptic (" . "id int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY," . "element varchar(10) NOT NULL DEFAULT 'other'," . "scale int(11) NOT NULL DEFAULT '100'," . "x int(11) NOT NULL DEFAULT '0'," . "y int(11) NOT NULL DEFAULT '0'," . "z int(11) NOT NULL DEFAULT '100'," . "indexElem int(11) NOT NULL DEFAULT '0'," . "rotation int(11) NOT NULL DEFAULT '0'," . "image varchar(50) NOT NULL DEFAULT '' );";
// Create table
try {
$sth = $db->prepare($sql);
$sth->execute();
} catch (\PDOException $e) {
$ret = $e->getMessage();
print_r($ret);
}
} else {
// Check column
check_and_update_column_db("synoptic", $synoptic_col);
}
// Database for supervision
// Define columns of the synoptic table
$supervision_col = array();
$supervision_col["id"] = array('Field' => "id", 'Type' => "int(11)", 'carac' => "NOT NULL AUTO_INCREMENT");
$supervision_col["checkPing_en"] = array('Field' => "checkPing_en", 'Type' => "VARCHAR(3)", "default_value" => "off", 'carac' => "NOT NULL");
$supervision_col["checkPing_action"] = array('Field' => "checkPing_action", 'Type' => "VARCHAR(8)", "default_value" => "sendMail", 'carac' => "NOT NULL");
$supervision_col["checkPing_adress"] = array('Field' => "checkPing_adress", 'Type' => "VARCHAR(100)", "default_value" => "8.8.8.8", 'carac' => "NOT NULL");
$supervision_col["dailyReport_en"] = array('Field' => "dailyReport_en", 'Type' => "VARCHAR(3)", "default_value" => "off", 'carac' => "NOT NULL");
$supervision_col["monthlyReport_en"] = array('Field' => "monthlyReport_en", 'Type' => "VARCHAR(3)", "default_value" => "off", 'carac' => "NOT NULL");
// Check if table configuration exists
$sql = "SHOW TABLES FROM bulcky LIKE 'supervision';";
try {
$sth = $db->prepare($sql);
$sth->execute();
$res = $sth->fetchAll(\PDO::FETCH_ASSOC);
} catch (\PDOException $e) {
$ret = $e->getMessage();
}
// If table exists, return
if ($res == null) {
// Buil MySQL command to create table
$sql = "CREATE TABLE supervision (" . "id int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY," . "checkPing_en varchar(3) NOT NULL DEFAULT 'off'," . "checkPing_action varchar(8) NOT NULL DEFAULT 'sendMail'," . "checkPing_adress varchar(100) NOT NULL DEFAULT '8.8.8.8'," . "dailyReport_en varchar(3) NOT NULL DEFAULT 'off'," . "monthlyReport_en varchar(3) NOT NULL DEFAULT 'off');";
// Create table
try {
$sth = $db->prepare($sql);
$sth->execute();
} catch (\PDOException $e) {
$ret = $e->getMessage();
print_r($ret);
}
$sql = "INSERT INTO supervision (id, checkPing_en, checkPing_action, checkPing_adress, dailyReport_en, monthlyReport_en)" . "VALUES (1, 'off', 'sendMail', '8.8.8.8', 'off', 'off');";
// Insert row:
try {
$sth = $db->prepare($sql);
$sth->execute();
} catch (PDOException $e) {
$ret = $e->getMessage();
print_r($ret);
}
} else {
// Check column
check_and_update_column_db("supervision", $supervision_col);
}
$db = null;
}
function check_db()
{
// Define columns of the program_index table
$program_index_col = array();
$program_index_col["id"] = array('Field' => "id", 'Type' => "int(11)", 'carac' => "NOT NULL AUTO_INCREMENT");
$program_index_col["name"] = array('Field' => "name", 'Type' => "VARCHAR(100)");
$program_index_col["version"] = array('Field' => "version", 'Type' => "VARCHAR(100)");
$program_index_col["program_idx"] = array('Field' => "program_idx", 'Type' => "int(11)");
$program_index_col["creation"] = array('Field' => "creation", 'Type' => "DATETIME");
$program_index_col["modification"] = array('Field' => "modification", 'Type' => "DATETIME");
$program_index_col["plugv_filename"] = array('Field' => "plugv_filename", 'Type' => "VARCHAR(10)");
$program_index_col["comments"] = array('Field' => "comments", 'Type' => "VARCHAR(500)");
// Check if table program_index exists
$sql = "SHOW TABLES FROM bulcky LIKE 'program_index';";
$db = \db_priv_pdo_start("root");
try {
$sth = $db->prepare($sql);
$sth->execute();
$res = $sth->fetchAll(\PDO::FETCH_ASSOC);
} catch (\PDOException $e) {
$ret = $e->getMessage();
}
// If table exists, return
if ($res == null) {
// Build MySQL command to create table
$sql = "CREATE TABLE program_index " . "(id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, " . "name VARCHAR(100), version VARCHAR(100), " . "program_idx INT, creation DATETIME, " . "modification DATETIME, plugv_filename VARCHAR(10), " . "comments VARCHAR(500));";
// Create table
try {
$sth = $db->prepare($sql);
$sth->execute();
} catch (\PDOException $e) {
$ret = $e->getMessage();
print_r($ret);
}
// Add default line
add_row_program_idx(__('CURRENT_PROG_NAME'), '1.0', '1', '00', __('CURRENT_PROG_COMMENT'));
} else {
// Check column
check_and_update_column_db("program_index", $program_index_col);
}
$db = null;
// Define columns of the programs table
$program_col = array();
$program_col["plug_id"] = array('Field' => "plug_id", 'Type' => "int(11)", 'carac' => "NOT NULL");
$program_col["time_start"] = array('Field' => "time_start", 'Type' => "VARCHAR(6)", 'carac' => "NOT NULL");
$program_col["time_stop"] = array('Field' => "time_stop", 'Type' => "VARCHAR(6)", 'carac' => "NOT NULL");
$program_col["value"] = array('Field' => "value", 'Type' => "decimal(5,1)", 'carac' => "NOT NULL");
$program_col["number"] = array('Field' => "number", 'Type' => "int(11)", 'default_value' => 1, 'carac' => "NOT NULL");
$program_col["date_start"] = array('Field' => "date_start", 'Type' => "varchar(10)", 'default_value' => '0000-00-00', 'carac' => "NOT NULL");
$program_col["date_end"] = array('Field' => "date_end", 'Type' => "VARCHAR(10)", 'default_value' => '0000-00-00', 'carac' => "NOT NULL");
$program_col["type"] = array('Field' => "type", 'Type' => "int(11)", 'default_value' => '0', 'carac' => "NOT NULL");
// Check if table programs exists
$sql = "SHOW TABLES FROM bulcky LIKE 'programs';";
$db = \db_priv_pdo_start("root");
try {
$sth = $db->prepare($sql);
$sth->execute();
$res = $sth->fetchAll(\PDO::FETCH_ASSOC);
} catch (\PDOException $e) {
$ret = $e->getMessage();
}
// If table exists, return
if ($res == null) {
// Build MySQL command to create table
$sql = "CREATE TABLE programs (" . "plug_id int(11) NOT NULL," . "time_start varchar(6) NOT NULL," . "time_stop varchar(6) NOT NULL," . "value decimal(5,1) NOT NULL," . "number int(11) NOT NULL DEFAULT '1'," . "date_start varchar(10) NOT NULL DEFAULT '0000-00-00'," . "date_end varchar(10) NOT NULL DEFAULT '0000-00-00'," . "type int(11) NOT NULL DEFAULT '0');";
// Create table
try {
$sth = $db->prepare($sql);
$sth->execute();
} catch (\PDOException $e) {
$ret = $e->getMessage();
print_r($ret);
}
} else {
// Check column
check_and_update_column_db("programs", $program_col);
}
$db = null;
}
