Idiorm (MySQL) - Raw query - SHOW TABLES LIKE

Question

I use Idiorm as ORM for MySQL with PHP.

I need to check if a table is created or not.

In SQL

This works in phpMyAdmin

SHOW TABLES LIKE 'ro_globals'

What I tried in Idiorm

ORM::raw_query("SHOW TABLES LIKE 'ro_globals'")->count()

Call to undefined method admin::count()

Is it possible to make this work with Idiorm? If so, how?

Their own example for raw_query: $people = ORM::for_table('person')->raw_query('SELECT p.* FROM person p JOIN role r ON p.role_id = r.id WHERE r.name = :role', array('role' => 'janitor'))->find_many(); It seems like it's only to be used with the for_table. — Jens Törnell
– Jens Törnell, Commented Dec 18, 2012 at 12:32
Maybe I got something in my eyes, but find_many is another method than count, right? Check, which type of object you are getting back from raw_query: var_dump( get_class( ORM::raw_query( '…' ) ) ); to know which methods it provides. Just trying out random method names wouldn't lead to success. Also SELECT queries do return data in a different format than SHOW queries. — feeela
– feeela, Commented Dec 18, 2012 at 12:40
@JensTörnell You are right raw_query() is not to be used in this way, but with for_table. Recently there was some code added to the develop branch of Idiorm to support this style with a method called raw_execute(). — Treffynnon
– Treffynnon, Commented Jan 16, 2013 at 11:44

score 2 · Accepted Answer · 2015-08-08 07:37:27Z

2

The correct anwser is:

ORM::forTable()->rawQuery('SHOW TABLES')->findMany()->count();

or with underscore:

ORM::for_table()->raw_query('SHOW TABLES')->find_many()->count();

Prefixed tables:

ORM::for_table()->raw_query('SHOW TABLES LIKE ' . $prefix . '%')->find_many()->count();

answered Oct 28, 2014 at 19:28

user924017

Sign up to request clarification or add additional context in comments.

Comments

Jens Törnell · Accepted Answer · 2012-12-20 14:36:45Z

0

I got the answer in a comment by Saharsh. It's not a Idiorm problem, it could be solved with SQL.

Result

CREATE TABLE IF NOT EXISTS

answered Dec 20, 2012 at 14:36

Jens Törnell

25k46 gold badges132 silver badges223 bronze badges