andela-iadeniyi / Potato-ORM

     *

     * @return string

     */

    protected static function buildClause($tableName, $data)

    {

        $counter = 0;

        $updateQuery = "";

        $arraySize = count($data);

        foreach ($data as $key => $value)

        {

            $counter++;

            $columnName = self::checkColumn($tableName, self::sanitize($key));

            $updateQuery .= $columnName ." = '".self::sanitize($value)."'";

            if ($arraySize > $counter)

            {

                $updateQuery .= ", ";

            }

        }

        return $updateQuery;

    }

    /**

     * Get the fields to be fillables defined in the model

        return $where;

    }

    public static function whereLikeClause($tableName, $data, $condition)

    {

        $where = "";

        $counter = 0;

        $arraySize = count($data);

        foreach ( $data as $key => $value )

        {

            $counter++;

            $columnName = self::checkColumn($tableName, self::sanitize($key));

            $where .= $columnName ." LIKE '%".self::sanitize($value)."%'";

            if ( $arraySize > $counter )

            {

                $where .= " " . $condition . " ";

            }

        }

        return $where;

    }

    /**

     * selectQuery