CakePHP LJ Community

 Hi there.

My model uses multiply tables, not single one. Those tables have unique CHAR strings as primary key, so their contents don't intersect.

I need my model to search through all of these tables. But cake's FIND method doesn't allow to specify table to search in. And also doesn't allow to use mysql's UNITE constructions.
So, I should use such an monster construction like

__________________________________________
$this->setSource($table1);
$r=$this->find(....);
if (! $r)
{
$this->setSource($table2);
$r=$this->find(....);
}
if (! $r)
{
$this->setSource($table3);
$r=$this->find(....);
}
& etc
__________________________________________

It seems to me to be at least extreamly slow. All this job can be mady with only one MySQL query like:

__________________________________________
SELECT <..> FROM `<table1>` WHERE <..> ORDER <..> <...>
UNITE
SELECT <..> FROM `<table2>` WHERE <..> ORDER <..> <...>
UNITE
SELECT <..> FROM `<table3>` WHERE <..> ORDER <..> <...>
& etc
__________________________________________

Do you have idea, how to do it? It seems to me, that the only way is copypasting cake's "find" method and changing it my situation.
Maybee there is another way?

Update
Solution found.

I'm planning to use tags at my site instead of tree of content. Also there's an opportunity to create a tree from tags (if there's more then 1 tag assigned to an element).

But how can I set up rights for an elements? Yes, I can set it for every element, but what's for a groups of elements, such as sections and subsections in ordinary tree content categorising system?

Does anyone have some thoughts on automatic installing of cakePHP applications?

For example, if the table is missing the check_and_install action is performed to check the table presence and structure and create or fix them.

As you know, there's an URL parser in cake. But we have to write all URLs by hands in "flash" messages, "redirects", views etc.

Does anyone have any suggestions how to automatize this task? This means that it should be really simple way to change site routing.

I'm a little late in catching it, but the dev team released 2 new versions of CakePHP on Christmas day:

Version 1.1.12.4205 is a bugfix release with no major changes

Also released is a development version of Cake 1.2, which I'm excited to start playing with. You can read more about it here in this Bakery article.

Happy holidays, and happy baking.

I have model A and model B. Can I use model B inside the model A class?

I hit another little bug in the developerWorks tutorial; there's a problem in Part 2, Section 8: Putting your ACLs to work

( continued... )

I've been running through the developerWorks articles on Cake, and hit a little bug during the ACL steps; I was getting 2 errors, one regarding array_shift() requiring an array parameter, and the other stating "class 'Configure' not found"

The first issue was my fault; I recently installed PHP5 and Apache2.2, and my php directory is now c:\php5, but c:\php was still in my Windows PATH list, so when I was running php from my command line, it was calling c:\php\php.exe (which was my old php4.x install) and for whatever reason the line "$serverArgs = env('argv');" in acl.php was returning nothing; I took out c:\php from my path, and the warning disappeared. Probably nothing anyone else will hit, but as a heads up, if you ever experience bizarre CLI behavior, and you have multiple PHP installs either specify the full pull for php.exe, or check on your PATH variable.

The second issue has already been addressed by the Cake team (https://trac.cakephp.org/changeset/4078) but the code has not been merged into the trunk yet, so even if you have the latest nightly build, you get the error 'class Configure not found'; changing the uses() call on line 93 to include 'configure' fixes this issue.

EDIT: The acl fix above still does not allow "initdb" to be run for me; if you're having a problem with running initdb, you can just run the sql file app/config/sql/db_acl.sql on your database by hand. The ACL "create" command seems to be running just fine.

Part 3 of IBM's developerWorks series on Cake has been published:

Cook up Web sites fast with CakePHP, Part 3: Use Sanitize for your protection
CakePHP is a stable production-ready, rapid-development aid for building Web sites in PHP. This "Cook up Web sites fast with CakePHP" series shows you how to build an online product catalog using CakePHP. Part 1 focuses on getting CakePHP up and running, and Part 2 demonstrates how to use scaffolding and Bake. In this article, you will learn how to use CakePHP's Sanitize and Security components to help secure your user-submitted data. You will also learn how to handle invalid requests.

http://www-128.ibm.com/developerworks/opensource/library/os-php-cake3/

Links to part 1 and 2 can be found below, and in Part 3