README.md

OmlManager v1.0, Object Manipulation Language

This is an ORM DataBase Manager. Which is easier to learn and better for using

About ORM. http://en.wikipedia.org/wiki/Object-relational_mapping

===========

1. Config databases =========== libs/OmlManager/Config/databases.ini

	[default]
	driver = pdo_mysql;
	host = localhost;
	db_name = '';
	user = 'root';
	password = '';
	port = '';

	[db_test]
	driver = pdo_mysql;
	host = localhost;
	db_name = test;
	user = root;
	password = ;
	port = '';

=== 2. Generate Database entities (Console command)

libs/OmlManager/Console/

	//Example
	//[DB_CONF_NAME] = db_test
	//[TABLE_NAME] = users

	//generate all database entities
	php generate.php [DB_CONF_NAME]

	//generate only one entity
	php generate.php [DB_CONF_NAME] [TABLE_NAME]

=== 3. Type of Using OmlORManager

	//DDL
	OmlORManager::ddl()->package(new \TestPackage\Test())->*.*

	//Run transaction
	OmlORManager::ddl()->package(new \TestPackage\Test())->beginTransaction();
    OmlORManager::ddl()->package(new \TestPackage\Test())->commitTransaction();
    OmlORManager::ddl()->package(new \TestPackage\Test())->rollbackTransaction();

	//DML Query (Object Manipulation Language)
	OmlORManager::dml()->*.* [->select()->model($modelObject)->, ->insert()->model($modelObject)->,
								->update()->model($modelObject)->, ->delete()->model($modelObject)]

	$exp = new \OmlManager\ORM\Query\Expression\Expression();
    	$exp->field('u.id')->equal(11)->andExp()->field('u.name')->like('%Vasea');

    OmlORManager::dml()->select('u.*')->model(new \TestPackage\Models\Users(), 'u')
    	->join('u.id = p.user_id')->model(new \TestPackage\Store\Privs(), 'p')
    	->expression($exp)
    	->limit(0, 10)
    	->fetchAll();

    //Native Query
	$query = 'SELECT * FROM users WHERE name = :name AND age > :age';

	OmlORManager::dml()
		->nativeQuery($query, array(':name' => 'Thom', 'age' => 12), new \TestPackage\Models\Users())
		->fetchAll();

	OmlORManager::dml()
		->nativeQuery($query, array(':name' => 'Thom', 'age' => 12), new \TestPackage\Models\Users())
		->fetchOne();

	OmlORManager::dml()
		->nativeQuery($query, array(':name' => 'Thom', 'age' => 12))
		->fetchAssoc();

    //OML
	OmlORManager::oml()->model()->*.*
	OmlORManager::oml()->*.*
	OmlORManager::oml()->model($object)->fetchAll($fieldName, $value, $operator, $limit = array(0, 30));
	OmlORManager::oml()->model($object)->delete();
	OmlORManager::oml()->model($object)->deleteBy(new \OmlManager\ORM\Query\Expression\Expression());

	//Run Transaction
	\TestPackage\Models\Users::oml()->beginTransaction();
	\TestPackage\Models\Users::oml()->commitTransaction();
	\TestPackage\Models\Users::oml()->rollbackTransaction();

	//Fetch objects
	$users = OmlORManager::oml()->model(new \TestPackage\Models\Users())->fetch();
	var_dump($users);


	$users = \TestPackage\Models\Users::oml()->fetch(array(0, 30));
	var_dump($users);

	$user = \TestPackage\Models\Users::oml()->fetchByPk(11);
	var_dump($user);

	$user = \TestPackage\Models\Users::oml()->fetchOne('age', 26, '<=');
	var_dump($user);

	$users = \TestPackage\Models\Users::oml()->fetchAll('age', array(26, 10, 16, 18), 'in');
	var_dump($users);

	$exp = new \OmlManager\ORM\Query\Expression\Expression();
	$exp->field('name')->like('Enry%');

	$user = \TestPackage\Models\Users::oml()->fetchOneBy($exp);
	var_dump($user);

	$users = \TestPackage\Models\Users::oml()->fetchAllBy($exp);
	var_dump($users);