pedro151 / orm-generator

     *

     * @return array

     */

    public function getListColumns ()

    {

        $strSchema = implode ( "', '" , $this->schema );

        return $this->getPDO ()->query (

            "SELECT distinct

	c.table_schema,

	c.table_name,

	c.column_name ,

	c.data_type,

	is_nullable,

	character_maximum_length AS max_length

		FROM

		information_schema.tables AS st

		INNER JOIN  information_schema.columns AS c

		ON st.table_name=c.table_name and st.table_type = 'BASE TABLE'

		and  c.table_schema IN ('$strSchema')

		order by c.table_name asc"

        )->fetchAll ( \PDO::FETCH_ASSOC );

    }

    public function getListConstrant ()

    {

        )->fetchAll ( \PDO::FETCH_ASSOC );

    }

    public function getListConstrant ()

    {

        $strSchema = implode ( "', '" , $this->schema );

        return $this->getPDO ()->query (

            "SELECT distinct

                tc.constraint_type,

                tc.constraint_name,

                tc.table_schema,

                tc.table_name,

                kcu.column_name,

		        ccu.table_schema AS foreign_schema,

                ccu.table_name AS foreign_table,

                ccu.column_name as foreign_column

                  FROM

                information_schema.table_constraints AS tc

                    JOIN information_schema.key_column_usage AS kcu

                      ON tc.constraint_name = kcu.constraint_name

                       AND tc.table_schema IN ('$strSchema')

                       AND tc.constraint_type IN ('FOREIGN KEY','PRIMARY KEY')

                    JOIN information_schema.constraint_column_usage AS ccu

                      ON tc.constraint_name  = ccu.constraint_name

                        AND tc.constraint_schema = ccu.constraint_schema

                    ORDER by tc.table_schema"

        )->fetchAll ( \PDO::FETCH_ASSOC );

    }

    /**