function serProductAndCategoriesSerialization($fileName) { $f = gzopen($fileName, "w"); $xmlTables = new XmlNode(); $xmlTables->LoadInnerXmlFromFile(DATABASE_STRUCTURE_XML_PATH); $array = $xmlTables->SelectNodes("DataBaseStructure/tables/table"); foreach ($array as $xmlTable) { $attrubtes = $xmlTable->GetXmlNodeAttributes(); if (isset($attrubtes["PRODUCTANDCATEGORYSYNC"])) { if (strtoupper($attrubtes["PRODUCTANDCATEGORYSYNC"]) == "TRUE") { $res = _tableSerialization($xmlTable); gzputs($f, $res . "\n"); } } } gzclose($f); }
function GetColumnDataType($columnName, $tableName, $fileName) { $xmlTables = new XmlNode(); $xmlTables->LoadInnerXmlFromFile($fileName); $array = $xmlTables->SelectNodes("DataBaseStructure/tables/table"); foreach ($array as $xmlTable) { $attr = $xmlTable->GetXmlNodeAttributes(); $tableName = $attr["NAME"]; if (trim($tableName) == trim($tableName)) { $arrayColumn = $xmlTable->SelectNodes("table/column"); foreach ($arrayColumn as $xmlColumn) { if (trim($xmlColumn->GetXmlNodeData()) == trim($columnName)) { $attributes = $xmlColumn->GetXmlNodeAttributes(); return strtoupper($attributes["TYPE"]); } } } } return false; }