ByJG Micro Orm with Snake Case

README.md

A fully functional example for issue: byjg/php-micro-orm#9

composer.json

{
    "name": "jg/snake_case",
    "require": {
        "byjg/micro-orm": "^4.0"
    },
    "autoload": {
        "psr-4": {
            "ByJG\\Sample\\MicroOrm\\SnakeCase\\": "./"
        }
    }
}

example.php

<?php

require "vendor/autoload.php";

// Creating the mapping
$mapper = new \ByJG\MicroOrm\Mapper(
    \ByJG\Sample\MicroOrm\SnakeCase\MyTable::class,
    'my_table',
    'field_id'
);

$mapper->addFieldMap("fieldid", "field_id");
$mapper->addFieldMap("fieldvalue", "field_value");

$dataset = \ByJG\AnyDataset\Db\Factory::getDbRelationalInstance('sqlite://' . __DIR__ . '/snake_case.db');

$repository = new \ByJG\MicroOrm\Repository($dataset, $mapper);

$repository->save(new \ByJG\Sample\MicroOrm\SnakeCase\MyTable("teste"));

var_dump($repository->get(1));

MyTable.php

<?php

class MyTable
{
    protected $field_id;
    protected $field_value;

    /**
     * MyTable constructor.
     * @param $field_value
     */
    public function __construct($field_value = "")
    {
        $this->field_value = $field_value;
    }


    /**
     * @return mixed
     */
    public function getFieldId()
    {
        return $this->field_id;
    }

    /**
     * @param mixed $field_id
     */
    public function setFieldId($field_id)
    {
        $this->field_id = $field_id;
    }

    /**
     * @return mixed
     */
    public function getFieldValue()
    {
        return $this->field_value;
    }

    /**
     * @param mixed $field_value
     */
    public function setFieldValue($field_value)
    {
        $this->field_value = $field_value;
    }
}

snake_case.sql

create table my_table (
    field_id integer primary key autoincrement not null,
    field_value varchar(20) null
);