MysqlCommonTrait::query()

Completed

Push — master ( a30b0b...f1bafc )

by Sébastien

created 2016-01-02 10:51 UTC

↳ Parent: MysqlCommonTrait

Size

Total Lines

Duplication

Lines	0
Ratio	0 %

Metric	Value
dl	0
loc	1
ccs	0
cts	0
cp	0
nc	1

<?php

namespace Soluble\DbWrapper\Adapter\Mysql;

use Soluble\DbWrapper\Exception;

trait MysqlCommonTrait
{
    
    /**
     * Execute query and return query as an ArrayObject
     *
     * @throws \Soluble\DbWrapper\Exception\InvalidArgumentException
     * @param string $query
     * @return \Soluble\DbWrapper\Result\Resultset
     */    
    abstract public function query($query);

    /**
     * Return current schema/database name
     * 
     * @throws \Soluble\DbWrapper\Exception\RuntimeException
     * @return string|false
     */
    public function getCurrentSchema()
    {
        $query = 'SELECT DATABASE() as current_schema';
        try {
            $results = $this->query($query);
            if (count($results) == 0 || $results[0]['current_schema'] === null) {
                return false;
            }
        } catch (\Exception $e) {
            throw new Exception\RuntimeException($e->getMessage());
        }
        return $results[0]['current_schema'];
    }
}


1		<?php
2
3		namespace Soluble\DbWrapper\Adapter\Mysql;
4
5		use Soluble\DbWrapper\Exception;
6
7		trait MysqlCommonTrait
8		{
9
10		/**
11		* Execute query and return query as an ArrayObject
12		*
13		* @throws \Soluble\DbWrapper\Exception\InvalidArgumentException
14		* @param string $query
15		* @return \Soluble\DbWrapper\Result\Resultset
16		*/
17		abstract public function query($query);
18
19		/**
20		* Return current schema/database name
21		*
22		* @throws \Soluble\DbWrapper\Exception\RuntimeException
23		* @return string\|false
24		*/
25	2	public function getCurrentSchema()
26		{
27	2	$query = 'SELECT DATABASE() as current_schema';
28		try {
29	2	$results = $this->query($query);
30	2	if (count($results) == 0 \|\| $results[0]['current_schema'] === null) {
31	2	return false;
32		}
33	2	} catch (\Exception $e) {
34		throw new Exception\RuntimeException($e->getMessage());
35		}
36	2	return $results[0]['current_schema'];
37		}
38		}
39

belgattitude / soluble-dbwrapper

Push — master ( a30b0b...f1bafc )

MysqlCommonTrait::query()

Size

Duplication

Duplication Side-by-Side

Filter issues like