Jalle19 / tvheadend-status-manager

     *

     * @return ChildChannel A model object, or null if the key is not found

     */

    protected function findPkSimple($key, ConnectionInterface $con)

    {

        $sql = 'SELECT id, instance_name, name FROM channel WHERE id = :p0';

        try {

            $stmt = $con->prepare($sql);

            $stmt->bindValue(':p0', $key, PDO::PARAM_INT);

            $stmt->execute();

        } catch (Exception $e) {

            Propel::log($e->getMessage(), Propel::LOG_ERR);

            throw new PropelException(sprintf('Unable to execute SELECT statement [%s]', $sql), 0, $e);

        }

        $obj = null;

        if ($row = $stmt->fetch(\PDO::FETCH_NUM)) {

            /** @var ChildChannel $obj */

            $obj = new ChildChannel();

            $obj->hydrate($row);

            ChannelTableMap::addInstanceToPool($obj, null === $key || is_scalar($key) || is_callable([$key, '__toString']) ? (string) $key : $key);

        }

        $stmt->closeCursor();

        return $obj;

    }

    /**

     * Find object by primary key.

     *

     * @return ChildConnection A model object, or null if the key is not found

     */

    protected function findPkSimple($key, ConnectionInterface $con)

    {

        $sql = 'SELECT id, instance_name, user_id, peer, started, type FROM connection WHERE id = :p0';

        try {

            $stmt = $con->prepare($sql);

            $stmt->bindValue(':p0', $key, PDO::PARAM_INT);

            $stmt->execute();

        } catch (Exception $e) {

            Propel::log($e->getMessage(), Propel::LOG_ERR);

            throw new PropelException(sprintf('Unable to execute SELECT statement [%s]', $sql), 0, $e);

        }

        $obj = null;

        if ($row = $stmt->fetch(\PDO::FETCH_NUM)) {

            /** @var ChildConnection $obj */

            $obj = new ChildConnection();

            $obj->hydrate($row);

            ConnectionTableMap::addInstanceToPool($obj, null === $key || is_scalar($key) || is_callable([$key, '__toString']) ? (string) $key : $key);

        }

        $stmt->closeCursor();

        return $obj;

    }

    /**

     * Find object by primary key.

     *

     * @return ChildInstance A model object, or null if the key is not found

     */

    protected function findPkSimple($key, ConnectionInterface $con)

    {

        $sql = 'SELECT name FROM instance WHERE name = :p0';

        try {

            $stmt = $con->prepare($sql);

            $stmt->bindValue(':p0', $key, PDO::PARAM_STR);

            $stmt->execute();

        } catch (Exception $e) {

            Propel::log($e->getMessage(), Propel::LOG_ERR);

            throw new PropelException(sprintf('Unable to execute SELECT statement [%s]', $sql), 0, $e);

        }

        $obj = null;

        if ($row = $stmt->fetch(\PDO::FETCH_NUM)) {

            /** @var ChildInstance $obj */

            $obj = new ChildInstance();

            $obj->hydrate($row);

            InstanceTableMap::addInstanceToPool($obj, null === $key || is_scalar($key) || is_callable([$key, '__toString']) ? (string) $key : $key);

        }

        $stmt->closeCursor();

        return $obj;

    }

    /**

     * Find object by primary key.

     *

     * @return ChildSubscription A model object, or null if the key is not found

     */

    protected function findPkSimple($key, ConnectionInterface $con)

    {

        $sql = 'SELECT id, instance_name, user_id, channel_id, subscription_id, started, stopped, title, service FROM subscription WHERE id = :p0';

        try {

            $stmt = $con->prepare($sql);

            $stmt->bindValue(':p0', $key, PDO::PARAM_INT);

            $stmt->execute();

        } catch (Exception $e) {

            Propel::log($e->getMessage(), Propel::LOG_ERR);

            throw new PropelException(sprintf('Unable to execute SELECT statement [%s]', $sql), 0, $e);

        }

        $obj = null;

        if ($row = $stmt->fetch(\PDO::FETCH_NUM)) {

            /** @var ChildSubscription $obj */

            $obj = new ChildSubscription();

            $obj->hydrate($row);

            SubscriptionTableMap::addInstanceToPool($obj, null === $key || is_scalar($key) || is_callable([$key, '__toString']) ? (string) $key : $key);

        }

        $stmt->closeCursor();

        return $obj;

    }

    /**

     * Find object by primary key.

     *

     * @return ChildUser A model object, or null if the key is not found

     */

    protected function findPkSimple($key, ConnectionInterface $con)

    {

        $sql = 'SELECT id, instance_name, name FROM user WHERE id = :p0';

        try {

            $stmt = $con->prepare($sql);

            $stmt->bindValue(':p0', $key, PDO::PARAM_INT);

            $stmt->execute();

        } catch (Exception $e) {

            Propel::log($e->getMessage(), Propel::LOG_ERR);

            throw new PropelException(sprintf('Unable to execute SELECT statement [%s]', $sql), 0, $e);

        }

        $obj = null;

        if ($row = $stmt->fetch(\PDO::FETCH_NUM)) {

            /** @var ChildUser $obj */

            $obj = new ChildUser();

            $obj->hydrate($row);

            UserTableMap::addInstanceToPool($obj, null === $key || is_scalar($key) || is_callable([$key, '__toString']) ? (string) $key : $key);

        }

        $stmt->closeCursor();

        return $obj;

    }

    /**

     * Find object by primary key.