edruid/basicobject

Yet anoyther object relational mapper

BasicObject

Yet anoyther object relational mapper

Performance hint:

This object relational mapper makes heavy use of information_schema in mysql, per default queries to this schema triggers recalculation of statistics every time it is queried which slows things down a lot. Try turning innodb_stats_on_metadata of to stop mysql doing this.

set global innodb_stats_on_metadata=0;

There are forks of this project solving this with a memcached instance caching the schema information instead.

basicobject's Issues

Add example child classes, with documentation

Null values are returned as empty strings

As described to edruid on the phone

If one table references another table twice, fix joins

Currently it is randomly decided on constraint creation which field is used.

different db-connections for read/write

I'd like to have an option to use different db servers for read/write to be able to scale up easy.

is_protected only protects writes - reading is always allowed

For example, in a user class, I want to keep the password property private (not read-only) because all password validations should be done within the user class.

Also, the is_protected function is not documented.

Create readme file

Why should HTML_ACCESS be a constant?

I don't see the point of creating the lock-in that you cannot change the value of HTML_ACCESS once it has been defined. Using a global variable instead allows for more flexible MVC constructions.

HTML_ACCESS is not mentioned anywhere in the documentations

If one try to use BasicObject as instructed in the example one get HTML_ACCESS errors.

Documentation is not up-to-date

The "documentation", aka comments in the beginning of BasicObject.php, is not up to date.
For example, it states that child classes shoud implement function from_id($id), but it is already implemented in the BasicObject class and I don't see the need to have it in the child classes.
The function from_id is not implemented in the example child classes.

Uset type info from information_schema

information is located at information_schema.COLUMNS.DATA_TYPE

Separate Classes and use PSRs

Separate classes and use PSR to use autoload and composer, its easy to all programmer use your library.

fetch_field() in selection() might fail if bad params are sent - please throw exception instead of fatal error

Line https://github.com/edruid/BasicObject/blob/master/BasicObject.php#L477

This is what I get:
PHP Warning: mysqli_stmt::bind_param(): Number of variables doesn't match number of parameters in prepared s
tatement in /home/slafs/projekt/testing/phpbot/classes/BasicObject.php on line 472
PHP Fatal error: Call to a member function fetch_field() on a non-object in /home/slafs/projekt/testing/phpb
ot/classes/BasicObject.php on line 477

And of course, fatal error means die. I would like to catch this error and ignore it until I have time to figure out what is actually wrong - perhaps a try-catch-throw around that while loop?

Example data.sql is broken

mysql> create database bo_example;
Query OK, 1 row affected (0.00 sec)

mysql> use bo_example;
Database changed
mysql> source data.sql
Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected (0.18 sec)

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ENGINE=InnoDB DEFAULT CHARSET=utf8' at line 7
Query OK, 0 rows affected (0.22 sec)

ERROR 1005 (HY000): Can't create table 'bo_example.group_access' (errno: 150)
ERROR 1005 (HY000): Can't create table 'bo_example.group_members' (errno: 150)
mysql>