generate-object.php

<?php

use Pico\DynamicObject\DynamicObject;
use Pico\Util\StringUtil;

require_once __DIR__ . "/inc/app.php";

$picoTableName = "";

if($argc > 1)
{
    $picoTableName = trim($argv[1]);
}
else
{
    if(isset($_GET['tablename']))
    {
        $picoTableName = trim($_GET['tablename']);
    }
}

if(empty($picoTableName))
{
    exit();
}

$className = ucfirst(StringUtil::camelize($picoTableName));
$namespace = "Pico\\Data\\Entity";

$fileName = $namespace."/".$className;
$path = __DIR__ . "/inc.lib/classes/".$fileName.".php";
$path = str_replace("\\", "/", $path);

$sql = "SHOW COLUMNS FROM $picoTableName";

$obj = new DynamicObject();

$typeMap = array(
    "double" => "double",
    "float" => "double",
    "bigint" => "integer",
    "smallint" => "integer",
    "tinyint(1)" => "bool",
    "tinyint" => "integer",
    "int" => "integer",
    "varchar" => "string",
    "char" => "string",
    "tinytext" => "string",
    "mediumtext" => "string",
    "longtext" => "string",
    "text" => "string",
    "enum" => "string",
    "boolean" => "bool",
    "bool" => "bool",
    "timestamp" => "string",
    "datetime" => "string",
    "date" => "string",
    "time" => "string"
);

/**
 * Create property
 *
 * @param array $typeMap
 * @param string $columnName
 * @param string $columnType
 * @param string $columnKey
 * @param string $columnNull
 * @param string $columnDefault
 * @param string $columnExtra
 * @return string
 */
function createProperty($typeMap, $columnName, $columnType, $columnKey, $columnNull, $columnDefault, $columnExtra)
{
    $propertyName = StringUtil::camelize($columnName);
    $docs = array();
    $docStart = "\t/**";
    $docEnd = "\t */";

    $docs[] = $docStart;
    $docs[] = "\t * ".getPropertyName($columnName);

    if(!empty($columnKey) && stripos($columnKey, "PRI") === 0)
    {
        $docs[] = "\t * @Id";
        if(stripos("auto_increment", $columnExtra) === false)
        {
            $docs[] = "\t * @GeneratedValue(strategy=GenerationType.UUID)";
        }
    }

    if(stripos("auto_increment", $columnExtra) !== false)
    {
        $docs[] = "\t * @GeneratedValue(strategy=GenerationType.IDENTITY)";
    }
    
    if(strcasecmp($columnNull, 'No') == 0)
    {
        $docs[] = "\t * @NotNull";
    }

    $attrs = array();
    $attrs[] = "name=\"$columnName\"";
    $attrs[] = "type=\"$columnType\"";
    $length = getDataLength($columnType);
    if($length > 0)
    {
        $attrs[] = "length=$length";
    }

    if(!empty($columnDefault))
    {
        $attrs[] = "default_value=\"".$columnDefault."\"";
    }
    if(!empty($columnNull))
    {
        $val = stripos($columnNull, "YES") === 0 ? "true" : "false";
        $attrs[] = "nullable=$val";
    }

    if($columnName == "time_create" || $columnName == "admin_create" || $columnName == "ip_create")
    {
        $attrs[] = "updatable=false";
    }

    if(!empty($columnExtra))
    {
        $attrs[] = "extra=\"".$columnExtra."\"";
    }

    $docs[] = "\t * @Column(".implode(", ", $attrs).")";
    if(!empty($columnDefault))
    {
        $docs[] = "\t * @DefaultColumn(value=\"".$columnDefault."\")";        
    }

    $type = getDataType($typeMap, $columnType);

    $docs[] = "\t * @var $type";
    $docs[] = $docEnd;
    $prop = "\tprotected \$$propertyName;";
    return implode("\r\n", $docs)."\r\n".$prop."\r\n";
}

function getPropertyName($name)
{
    $arr = explode("_", $name);
    foreach($arr as $k => $v)
    {
        $arr[$k] = ucfirst($v);
        $arr[$k] = str_replace("Id","ID", $arr[$k]);
    }
    return implode(" ", $arr);
}

/**
 * Get data type
 *
 * @param array $typeMap
 * @param string $columnType
 * @return string
 */
function getDataType($typeMap, $columnType)
{
    $type = "";
    foreach($typeMap as $key=>$val)
    {
        if(stripos($columnType, $key) === 0)
        {
            $type = $val;
            break;
        }
    }
    if(empty($type))
    {
        $type = "string";
    }
    return $type;
}

/**
 * Get column length
 *
 * @param string $str
 * @return integer
 */
function getDataLength($str)
{
    $str2 = preg_replace('~\D~', '', $str);
    if(empty($str2))
    {
        $str2 = "0";
    }
    $length = $str2 * 1;
    
    if(stripos($str, "datetime") !== false || stripos($str, "timestamp") !== false)
    {
        $length += 20;
        if($length == 20)
        {
            $length = 19;
        }
    }
    return $length;
}
$rows = $database->fetchAll($sql);

$attrs = [];
foreach($rows as $row)
{
    $columnName = $row['Field'];
    $columnType = $row['Type'];
    $columnKey = $row['Key'];
    $columnNull = $row['Null'];
    $columnDefault = $row['Default'];
    $columnExtra = $row['Extra'];

    $prop = createProperty($typeMap, $columnName, $columnType, $columnKey, $columnNull, $columnDefault, $columnExtra);
    $attrs[] = $prop;
}



$uses = array();
$uses[] = "use Pico\DynamicObject\DynamicObject;";

$classStr = '<?php

namespace '.$namespace.';

'.implode("\r\n", $uses).'

/**
 * @Entity
 * @JSON(property-naming-strategy=SNAKE_CASE)
 * @Table(name="'.$picoTableName.'")
 */
class '.$className.' extends DynamicObject
{
'.implode("\r\n", $attrs).'
}';
$written = file_put_contents($path, $classStr);
echo "PATH = $path<br>\r\n";
echo "WRITTEN = $written<br>\r\n";
echo "SELESAI<br>\r\n";