<?php
/* vim: set expandtab sw=4 ts=4 sts=4: */
/**
* Holds the TableProperty class
*
* @package PhpMyAdmin-Export
* @subpackage CodeGen
*/
if (! defined('PHPMYADMIN')) {
exit;
}

/**
* TableProperty class
*
* @package PhpMyAdmin-Export
* @subpackage CodeGen
*/
class TableProperty
{
/**
* Name
*
* @var string
*/
public $name;

/**
* Type
*
* @var string
*/
public $type;

/**
* Wheter the key is nullable or not
*
* @var bool
*/
public $nullable;

/**
* The key
*
* @var int
*/
public $key;

/**
* Default value
*
* @var mixed
*/
public $defaultValue;

/**
* Extension
*
* @var string
*/
public $ext;

/**
* Constructor
*
* @param array $row table row
*
* @return void
*/
function __construct($row)
{
$this->name = trim($row[0]);
$this->type = trim($row[1]);
$this->nullable = trim($row[2]);
$this->key = trim($row[3]);
$this->defaultValue = trim($row[4]);
$this->ext = trim($row[5]);
}

/**
* Gets the pure type
*
* @return string type
*/
function getPureType()
{
$pos = strpos($this->type, "(");
if ($pos > 0) {
return substr($this->type, 0, $pos);
}
return $this->type;
}

/**
* Tells whether the key is null or not
*
* @return bool true if the key is not null, false otherwise
*/
function isNotNull()
{
return $this->nullable == "NO" ? "true" : "false";
}

/**
* Tells whether the key is unique or not
*
* @return bool true if the key is unique, false otherwise
*/
function isUnique()
{
return $this->key == "PRI" || $this->key == "UNI" ? "true" : "false";
}

/**
* Gets the .NET primitive type
*
* @return string type
*/
function getDotNetPrimitiveType()
{
if (strpos($this->type, "int") === 0) {
return "int";
}
if (strpos($this->type, "long") === 0) {
return "long";
}
if (strpos($this->type, "char") === 0) {
return "string";
}
if (strpos($this->type, "varchar") === 0) {
return "string";
}
if (strpos($this->type, "text") === 0) {
return "string";
}
if (strpos($this->type, "longtext") === 0) {
return "string";
}
if (strpos($this->type, "tinyint") === 0) {
return "bool";
}
if (strpos($this->type, "datetime") === 0) {
return "DateTime";
}
return "unknown";
}

/**
* Gets the .NET object type
*
* @return string type
*/
function getDotNetObjectType()
{
if (strpos($this->type, "int") === 0) {
return "Int32";
}
if (strpos($this->type, "long") === 0) {
return "Long";
}
if (strpos($this->type, "char") === 0) {
return "String";
}
if (strpos($this->type, "varchar") === 0) {
return "String";
}
if (strpos($this->type, "text") === 0) {
return "String";
}
if (strpos($this->type, "longtext") === 0) {
return "String";
}
if (strpos($this->type, "tinyint") === 0) {
return "Boolean";
}
if (strpos($this->type, "datetime") === 0) {
return "DateTime";
}
return "Unknown";
}

/**
* Gets the index name
*
* @return string containing the name of the index
*/
function getIndexName()
{
if (strlen($this->key) > 0) {
return "index=\""
. htmlspecialchars($this->name, ENT_COMPAT, 'UTF-8')
. "\"";
}
return "";
}

/**
* Tells whether the key is primary or not
*
* @return bool true if the key is primary, false otherwise
*/
function isPK()
{
return $this->key=="PRI";
}

/**
* Formats a string for C#
*
* @param string $text string to be formatted
*
* @return string formatted text
*/
function formatCs($text)
{
$text = str_replace(
"#name#",
ExportCodegen::cgMakeIdentifier($this->name, false),
$text
);
return $this->format($text);
}

/**
* Formats a string for XML
*
* @param string $text string to be formatted
*
* @return string formatted text
*/
function formatXml($text)
{
$text = str_replace(
"#name#",
htmlspecialchars($this->name, ENT_COMPAT, 'UTF-8'),
$text
);
$text = str_replace(
"#indexName#",
$this->getIndexName(),
$text
);
return $this->format($text);
}

/**
* Formats a string
*
* @param string $text string to be formatted
*
* @return string formatted text
*/
function format($text)
{
$text = str_replace(
"#ucfirstName#",
ExportCodegen::cgMakeIdentifier($this->name),
$text
);
$text = str_replace(
"#dotNetPrimitiveType#",
$this->getDotNetPrimitiveType(),
$text
);
$text = str_replace(
"#dotNetObjectType#",
$this->getDotNetObjectType(),
$text
);
$text = str_replace(
"#type#",
$this->getPureType(),
$text
);
$text = str_replace(
"#notNull#",
$this->isNotNull(),
$text
);
$text = str_replace(
"#unique#",
$this->isUnique(),
$text
);
return $text;
}
}
?>