Re: Does CakePHP 2.5 support the HSTORE and ARRAY data types from PostgreSQL?

2014-07-22 Thread José Lorenzo
Long answer is: CakePHP 3.0 could support it without much pain. You will need to implement the corresponding Type classes to convert from and to Array. As for the syntax, you can use any expression when building the queries On Wednesday, July 23, 2014 8:43:01 AM UTC+2, José Lorenzo wrote: > > N

Re: Does CakePHP 2.5 support the HSTORE and ARRAY data types from PostgreSQL?

2014-07-22 Thread José Lorenzo
Nope :P On Wednesday, July 23, 2014 5:30:25 AM UTC+2, David Suna wrote: > > We are looking into what framework to use for a new project. One of the > requirements of the project is to use PostgreSQL and take advantage of the > Postgres specific data types like HSTORE. Is that something that Cake

Re: 3.x - Fixtures, import records ?

2014-07-22 Thread José Lorenzo
Yeah, just use the passed connection instance and do execute(...) On Tuesday, July 22, 2014 8:31:06 PM UTC+2, Thomas von Hassel wrote: > > Do you just exec() out to the mysql client or how would you do this in the > most “correct” way ? > > /thomas > > > On 22 Jul 2014, at 09:53, José Lorenzo wr

Re: 3.0: defaultConnectionName doesn't create correct connection

2014-07-22 Thread José Lorenzo
I would use plugins for organizing them On Wednesday, July 23, 2014 5:33:18 AM UTC+2, Joe Theuerkauf wrote: > > Okay, i fixated on this tonight & i think i got it to work. i put > CaptchasTable back in App/Model/Table, and behold the class loads correctly > (i forgot to adjust the namespace in t

Finding if a event exists for a date

2014-07-22 Thread Jumy Elerossë
Hello everyone. I'm struggling with a problem since a week ago, and this is driving me crazy. I'm doing a website for doing surveys in the forest. This is the schema: 1 place have several points, and for each point, an user can book a day for doing a survey. If that point has booked already a

Booking a date

2014-07-22 Thread Jumy Elerossë
Hello everyone. I'm struggling with this since a week ago and it's driving me crazy. I'm doing a website for doing surveys in a forest. There is many places, and each place has different points. An user can choose one of those points and book a day for a survey, but there can be only one surve

Re: 3.0: defaultConnectionName doesn't create correct connection

2014-07-22 Thread Joe Theuerkauf
Okay, i fixated on this tonight & i think i got it to work. i put CaptchasTable back in App/Model/Table, and behold the class loads correctly (i forgot to adjust the namespace in the previous message). However, before i do a happy dance, i'd like to know if it's *POSSIBLE* to organize my Models

Does CakePHP 2.5 support the HSTORE and ARRAY data types from PostgreSQL?

2014-07-22 Thread David Suna
We are looking into what framework to use for a new project. One of the requirements of the project is to use PostgreSQL and take advantage of the Postgres specific data types like HSTORE. Is that something that CakePHP supports? Thanks. -- Like Us on FaceBook https://www.facebook.com/CakePHP

Re: 3.0: defaultConnectionName doesn't create correct connection

2014-07-22 Thread Joe Theuerkauf
Two addenda: 1. Does it make a difference that i'm loading a different Model that uses the 'default' connection *before* Captchas? i've been omitting it because i didn't think it was relevant. But maybe there's some failure to get the right defaultConnectionName() because both Models are loaded

Re: 3.0: defaultConnectionName doesn't create correct connection

2014-07-22 Thread Joe Theuerkauf
José: Sorry for the delayed response. i've been getting burned out (and burned up with the weather), so i took a day to breathe. i called $this->Captchas->defaultConnectionName() from inside the ContactsController: public function index() { $this->loadModel('Captchas'); // PS: i'm using the

Re: 3.x - Fixtures, import records ?

2014-07-22 Thread Thomas von Hassel
Do you just exec() out to the mysql client or how would you do this in the most "correct" way ? /thomas On 22 Jul 2014, at 09:53, José Lorenzo wrote: > For instance, I have .sql files stored in my project that I load in the > insert() method. -- Like Us on FaceBook https://www.facebook.com

Re: Controller class could not be found

2014-07-22 Thread Rafael Queiroz
Maybe, the first time happened that yesterday, the project is available 4 months ago, no peak was identified in server, some content just created like everyday (12 new images), no changes in version. Do not understand how this problem came to take the site down. On Tue, Jul 22, 2014 at 11:43 AM,

Re: Controller class could not be found

2014-07-22 Thread José Lorenzo
Are you sure the problem is not because you are linking to many broken images in your source? On Tuesday, July 22, 2014 4:34:09 PM UTC+2, Rafael Queiroz wrote: > > Thanks José, but i need catching exception if file not exist. > The problem is dangerous, many the requests connection timed out in

Re: Controller class could not be found

2014-07-22 Thread Rafael Queiroz
Thanks José, but i need catching exception if file not exist. The problem is dangerous, many the requests connection timed out in rackspace. On Tue, Jul 22, 2014 at 4:54 AM, José Lorenzo wrote: > It means that someone is requesting missing images in your app and the > robots.txt file. Creating

Re: Selecting specific data from the database through multiple relations

2014-07-22 Thread David Yell
Managed to solve it with something like this in some cases. /** * Find a list of all the regions and how many hotels are in each region * * @return array */ public function regionWithHotelCount() { return $this->find('all', [ 'link' => [ 'CountriesRegion' => [

Re: Selecting specific data from the database through multiple relations

2014-07-22 Thread David Yell
I have managed to solve some issues, like counting hotels using things similar to the following model method. /** * Find a list of all the regions and how many hotels are in each region * * @return array */ public function regionWithHotelCount() { return $this->find('all', [ 'link' => [

Re: Selecting specific data from the database through multiple relations

2014-07-22 Thread David Yell
I wasn't aware that Linkable took different types of joins. On Tuesday, 22 July 2014 11:50:38 UTC+1, José Lorenzo wrote: > > Not sure why linkable is not working for you. Did you make sure to set > 'type' => 'INNER' in the linkable definition for that model? That will > filter records from the p

Re: Selecting specific data from the database through multiple relations

2014-07-22 Thread José Lorenzo
Not sure why linkable is not working for you. Did you make sure to set 'type' => 'INNER' in the linkable definition for that model? That will filter records from the parent model according to the conditions in the association. On Tuesday, July 22, 2014 10:57:14 AM UTC+2, David Yell wrote: > > *

Re: 3.x - Fixtures, import records ?

2014-07-22 Thread Thomas von Hassel
sure :) On 22 Jul 2014, at 10:33, José Lorenzo wrote: > It was very buggy and slow and what it did could be replaced easier with > specific queries for each driver. My personal plan is to do that in another > plugin like I did for y current Fixturize plugin in 2.x. > Maybe you want to help wit

Selecting specific data from the database through multiple relations

2014-07-22 Thread David Yell
*Synopsis* Trying to select data from multiple related models explicitly is hard in the framework due to it's focus on always providing a left join. Even with Containable and Linkable it's not always possible, without a manual query, to select records where their related record has a condition.

Re: Caching-Strategy for Model-Data in Cake3

2014-07-22 Thread José Lorenzo
I often create plenty small custom finders I can combine. Also I find myself creating very specialized finders which sole responsibility is to combine multiple others. for example in an application of mine I have a findForNewsletter() which composes findActive(), findSubscribed(), findForLocatio

Re: 3.x - Fixtures, import records ?

2014-07-22 Thread José Lorenzo
It was very buggy and slow and what it did could be replaced easier with specific queries for each driver. My personal plan is to do that in another plugin like I did for y current Fixturize plugin in 2.x. Maybe you want to help with that? :) On Tuesday, July 22, 2014 9:58:49 AM UTC+2, Thomas vo

Re: Load Time

2014-07-22 Thread nethues
Hi Sudhir, Use this htaccess code in your main htaccess file. --- Header set Connection keep-alive # compress text, html, javascript, css, xml: AddOutputFilterByType DEFLATE text/plain AddOutputFilterByType DEFLATE text/html AddOutputFilterByType DE

Re: how to display html content without exist view file

2014-07-22 Thread nethues
Use routing rules to create dynamic pages so you do not need to create views for every pages, just create single view and use routing. Thanks Ravi -- View this message in context: http://cakephp.1045679.n5.nabble.com/how-to-display-html-content-without-exist-view-file-tp5718911p5718928.html Se

Re: Load Time

2014-07-22 Thread Ravi Saxena(Nethues)
Hi Sudhir, Use this htaccess code in your main htaccess file. --- Header set Connection keep-alive # compress text, html, javascript, css, xml: AddOutputFilterByType DEFLATE text/plain AddOutputFilterByType DEFLATE text/html AddOutputFilterBy

Re: 3.x - Fixtures, import records ?

2014-07-22 Thread Thomas von Hassel
Yeah, that was i was going to do, i was just wondering why that feature got the axe ? /thomas On 22 Jul 2014, at 09:53, José Lorenzo wrote: > Yes, the feature was removed. You can, though, override the _getRecords() or > insert() method to do whatever you like. For instance, I have .sql files

Re: Controller class could not be found

2014-07-22 Thread José Lorenzo
It means that someone is requesting missing images in your app and the robots.txt file. Creating the missing files will fix the problem On Monday, July 21, 2014 10:00:31 PM UTC+2, Rafael Queiroz wrote: > > Hi, > > I have problem in my application using CakePHP 2.2.5: > > 2014-07-21 16:35:53 Error

Re: 3.x - Fixtures, import records ?

2014-07-22 Thread José Lorenzo
Yes, the feature was removed. You can, though, override the _getRecords() or insert() method to do whatever you like. For instance, I have .sql files stored in my project that I load in the insert() method. On Monday, July 21, 2014 7:49:09 PM UTC+2, Thomas von Hassel wrote: > > Hey > > Is it tr

Caching-Strategy for Model-Data in Cake3

2014-07-22 Thread Sven
Hi all! I am wondering what your opinions are about the best way to tackle caching within Cake 3 within the model-layer. When writing custom finders for your tables you can have 3 approaches: 1. Write small, easy to read, understand-, maintain- and testable finder-methods which you then