Models stepping on each other?

Hi all!

I hate to revive dead threads, but I felt that creating another one would be too much, since this one’s problem is apparently still in question, and it only has two pages, so….

I have come across the same problem as the author. And, from what I’ve read here, CI’s creators think it is useless to call another model’s methods from within a model, and thus have designed it in a way to make it difficult to do so. However, it says in the manual that the architectural goals of CodeIgniter are “flexibility”, “loose coupling” and “singularity”. Well, how can you achieve those, if the components of the system cannot use one another..? What flexibility and reuseability are we talking about then..? I think it is perfectly rational to invoke objects from other objects. I think that “loose coupling” does not mean “insane incapsulation”. One object is not supposed to perform all work in my opinion. And I totally agree that it is definately not OOP to do as CI intends. Moreover, there is nothing deviating from the MVC approach. Magento, one of the best (but, unfortunately, one of the most poorly documented) packages, does this all the time; it is essential to do this in Magento. This is not an attempt to advertise the eCommerce solution…

So I’d really like to know how to invoke a model’s method from within another model. I have done as it says in the Manual (used the get_instance method), and it kinda works, but not as expected. You see, the problem is that CI stores the invoked models somehow inside, but from within one model it is impossible to know whether another model, or another model with the same name, has been instanciated before, and this leads to a disaster when addressing these models. Especially this goes crazy when specifying a second parameter while loading, like so:

This is very frustrating. Please, if someone knows how to do this properly, tell me, as I really need this kind of functionality.

Thanks.

Hello,

I found problematic using ORM with pivot tables (of course I've read documentation).
In my database I need a table, that keeps track on assignments between SUBCATEGORIES and PROPERTIES (subcategory may have many properties, properties may belong to many subcategories).

So,

tablenames:

properties
subcategories
properties_subcategories

models:

class Property_Model extends ORM { //filename: models/property.php
protected $has_and_belongs_to_many = array('properties_subcategories');
...

class Subcategory_Model extends ORM { //filename: models/subcategory.php
protected $has_and_belongs_to_many = array('properties_subcategories');
...

class Property_Subcategory_Model extends ORM { //filename: models/property_subcategory.php
protected $has_and_belongs_to_many = array('subcategories', 'properties');
...

-----------
Kohana says:
"There was an SQL error: Table 'shop.property_subcategories' doesn't exist - SHOW COLUMNS FROM `property_subcategories`"

I have no idea why it tries to access 'shop.property_subcategories' table instead of 'shop.properties_subcategories'

If you see (or just know) my mistake, please respond.
I'll be grateful.

P.S. Sorry for the format of code samples, hope this is legible.

Hi!

I use CI for some time now but I'm still a bit confused about models. So far I wasn't using models at all, if I had to obtain some data from DB I simply used AR directly in controllers, in more complex situations - I wrote libraries. This worked well and I didn't have any problems (even in big applications/sites), however I feel like I'm approaching MVC the wrong way cause everyone uses models but for me it just brings more complexity to application than it's worth. Or am I missing something? Could you explain me why models are useful? Why create additional methods for simple tasks that aren't used often anyway when I can simply use AR and adjust everything as I want rather than write many sophisticated methods?

Thanks,
Peter

I've got absolutely no idea what this means:

Fatal error: Uncaught exception 'Doctrine_Connection_Mysql_Exception' with message 'SQLSTATE[HY000]: General error: 1452 Cannot add or update a child row: a foreign key constraint fails (`ci_doctrine`.`bank`, CONSTRAINT `bank_category_id_category_id` FOREIGN KEY (`category_id`) REFERENCES `category` (`id`))' in C:\xampplite\htdocs\ci_doctrine\system\application\plugins\doctrine\lib\Doctrine\Connection.php:1082 Stack trace: #0 C:\xampplite\htdocs\ci_doctrine\system\application\plugins\doctrine\lib\Doctrine\Connection\Statement.php(269): Doctrine_Connection->rethrowException(Object(PDOException), Object(Doctrine_Connection_Statement)) #1 C:\xampplite\htdocs\ci_doctrine\system\application\plugins\doctrine\lib\Doctrine\Connection.php(1042): Doctrine_Connection_Statement->execute(Array) #2 C:\xampplite\htdocs\ci_doctrine\system\application\plugins\doctrine\lib\Doctrine\Connection.php(687): Doctrine_Connection->exec('INSERT INTO ban…', Array) #3 C:\xampplite\htdocs\ci_doctrine\system\application\plugins\doctrine\lib\Doctrine\ in C:\xampplite\htdocs\ci_doctrine\system\application\plugins\doctrine\lib\Doctrine\Connection.php on line 1082

It happens when i'm trying to submit data from form. I think it's about models but i guess i made it right:

And category:

Maybe relation is made wrong, i dunno…

Code: Select all



Alunos

Mmartins

1.0

































cm:content







d:text







d:text







d:text







d:datetime







d:text









d:text







d:int







d:text











d:text







d:boolean

false







d:datetime







d:text







d:text







d:text
















false
true


cm:content
false
false





false
true


cm:content
false
true


















Code: Select all










alfresco/extension/alunos.xml






Code: Select all






display-label-id="content_type"
component-generator="MimeTypeSelectorGenerator" />

display-label-id="size"
converter="org.alfresco.faces.ByteSizeConverter"
show-in-edit-mode="false" />






































This is my first post to the CI community. I've been a PHP dev for 10 years and just recently a cakephp dev for 5 weeks and I'm really starting to hate it (which is why I'm posting on the CI side of the force).

After reading through a few of the examples, I noticed how CI's model structure is different from cakes. From the top example on…

http://codeigniter.com/user_guide/general/models.html

It looks like your using a decorator pattern to wrap Blogmodel around the db object, why? In cake there is no decorator pattern, the actual model is the thing you manipulate the db with…

But with code CI, a core object does all the object manipulation while a simple wrapper object around it just passes the calls to it…

class Blogmodel extends Model {
function insert_entry(){
$this->title = $_POST['title']; // please read the below note
$this->content = $_POST['content'];
$this->date = time();
$this->db->insert('entries', $this);
}
}

why go through the trouble in wrapping one object around another and call it a model? Technically, Blogmodel isn't the model, $this->db is the model because it (by definition), is an object that represents the underlying data. You could easily extends the db class to something else (otherdb for example) and add the insert_entry method to it.

As far a relationships between other models go…

Cake does it by sticking an array in a var called $hasMany (see my first example code) So if I wanted to access the projects model from the orgs model, I could just type $orgs->projects->find('all'). In theory, you would think the projects model would retrieve projects that are only associated to that particular org but it doesn't. It just blindly fetches ALL the projects in the projects table. This is the main reason why I'm totally fed up with cakephp. If I can't cleanly do db table relations then I can't use the framework.

As for CI I couldn't find any built in examples that shows how one could associate one model to another. The closest thing I found datamapper and rdm and dmz. I can't use datamapper because it uses 5th normal form and all my databases (as well as most others) are in 3rd. from the examples with rdm, it doesn't use a config array or a simple to the point one line command to fetch assoc. dmz seems like my best bet but it looks like I would have to do custom code for each model as far as doing the relations between them.

My ultimate goal and the main reason that would make me a CI fan and drop cake is if I can simple traverse related objects in some easy way kind of like this…

Keep in mind that was a very ruff scetch I whipped up but you get my point. Keep in mind I don't know that much about code igniter yet, I've only been reading the examples from the website for the past hour or so.

Code: Select all


Error Please correct the errors below then click OK.

* A system error happened during the operation: 00180002 Failed to parse model


Code: Select all

Please correct the errors below then click OK.

* A system error happened during the operation: 00180003 Failed to parse model