@Kljofa

Hello,

What do you mean when you say multiple joins?  Do you mean one parent entity with many child entities, or a parent entity with a child entity, which in turn is the parent of another and so on.  For the first type of relationship the documentation gives good examples. First you need to set up the relationships so that gasorm knows how tables relate to each other:

http://gasorm-doc.taufanaditya.com/relationship.html

Once you have done that, you can use the with() function.  Here is an example from:

http://gasorm-doc.taufanaditya.com/quickstart.html

There is an entity called user, and the relationships between the (has many)kid, (has one)wife and (has many)job entities have been created so that the command below creates the joins and retrieves the corresponding records for all users.

If there is a chain of parent/child entities, the above command could be used to get the initial parent/child relationship, then the command below can be used to fetch only the child entity details of further entities.

Depending on the source of your download you may have to watch your capitalization as the link below discusses, as I vaguelly remember I had the problem with capitalization too first time round:

http://ellislab.com/forums/viewthread/213348/P120/#1010854

@snowfall,

Its looks like the ORM class seeing your primary key as invalid collumn name, in the constructor.

Just to verify, ensure that ‘sample_context_refid’ is exists on below script output :

@toopay

Result is:

The code nearly works, it is using the correct foreign key except it has the table name attached.  This is the malformed SQL:

This is what it *should* be when correct:

@snowfall.

I can’t replicate this behaviour, since custom foreign key actually already well-covered within recent unit-test suite.

I suspect, the ORM class going down to this line while investigating your entity meta-data.

Here is a crude example of my problem.

I have 3 tables

TABLE 1
id
year

TABLE 2
id
table1_id

TABLE 3
id
table2_id

I want to grab all results from table 3 that matches year from table 1.

I tried doing something like this:

but i only get one join and that’s the last one i entered. Relationships are properly set.

@toopay

Found the problem.  In the child relation, if capital letters are used for Model and Class, it fails.  So this causes the problem:

But if lower case letters are used, it passes.  This solves the problem:

Raised before, http://ellislab.com/forums/viewthread/213348/P120/#1010854 but I, was using the code from Github, so thought it would be fine. D’oh.  Thanks for looking, sorry to disturb ^^

@Kijofa

If everything has been setup correctly, you should only need :

You do not need to set up a manual JOIN.

Tried that but didn’t work. This is what i have setup in my models.

TABLE 1 model:

TABLE 2 model:

TABLE 3 model:

With this relationship i tried calling the code you mentioned but got error that the method doesn’t exists in the object.

@Kijofa

With your current setup, this should do the job :

Actually, it is easier to set up :

so that you could use the previous code i mention.

Hi.

I have a pivot table set up. I want to fetch data from a table connected to the pivot table using the result extension but i want to check if the id is valid against the pivot table.

After upgrading from GORM 2.0.0 to 2.1.1 the following code no longer works for me:

It used to do a subquery:

But now instead it does

and every other $user->userdata() will return bool False.

I.e. it only queries the userdata table for the last row matched in the user table.

I can still loop through the list of users and print their IDs and check by hand that they match the ones in the database, so that should not be a problem.

What am I doing wrong here?

I have three tables. Jobs, Categories and Location. I want to find jobs with a sertain category id and location id. Jobs has many categories and categories has many jobs. Therefore i need to use a pivot table. I checked out laravels ORM and in there you used:

Are there any ways to do something similar with GAS?

Patch v.2.1.2

Changes :
1. Fixes several known issues on relationship entities.
2. Minor refactor on Core class.
3. Additional files on test-suite to cover core files.

How to update :
If you previously download the zipped files, just re-download and replace the old one. If you already installed via Spark, update using this command from your comman line :

I added a section on README about test-suite, so make sure to read that section before tweeting me any issues regarding this open-source library.

Hello! How can I get a result, as I’m make a query:
SELECT * from USER WHERE user_email = ‘Arugin’ AND user_password=“123”

I’m trying to write something like this:

$data = User::where(“user_email =”,$user_email)->first()->where(“user_password =”,$user_password)->first();

but it’s ignore the first “where”.

What I’m missed?

Thank you.

Hi toopay,

I have some problems using relationships into GAS.
I basically have two tables:

chef_secteur {id[int], nom_cs[var_char], email_cs[int]}
1 | John Doe | 1
2 | Ana Alba | 3

users {id[int], identity[varchar], pass[varchar], email[varchar]}
1 | jd | xxx | jdoe at tt.co
2 | ue| xxx | ultra at tt.co
3 | aa | xxx | aalba at tt.co

So the `chef_secteur`.`email_cs ` belongs to the `users`.`email`

These are my GAS models : http://codepad.org/kQynbVeo
I get a server NetworkError: 500 Internal Server Error hangout when I add fields in relationships array. If I comment them, GAS 2.1.2 works fine, I’m using it as result()->find_by_field() and I’m happy with it.

Thanks, Radu