How can I see relationships?

[mevdschee]

How can I see relationships?

[mevdschee]

Can you try to call http://localhost/api.php/Person,Class?transform=1 and see what happens?

[mevdschee]

Also, defining a foreign key constraint is required for the feature to work. Something you can do with SQL with the following command (for MySQL innoDB):

ALTER TABLE Person ADD FOREIGN KEY (classId) REFERENCES Class (id) ON DELETE RESTRICT ON UPDATE RESTRICT

See also: https://github.com/mevdschee/php-crud-api/blob/master/tests/blog.mysql#L27

[boldijar]

http://localhost/api/index.php/person?transform=1 will give me

{
person: [
{
id: "1",
name: "Alex",
classId: "2"
},
{
id: "2",
name: "Dan",
classId: "2"
},
{
id: "3",
name: "Ion",
classId: "1"
},
{
id: "4",
name: "Boldij",
classId: "2"
}
]
}

And if transform is 0
http://localhost/api/index.php/person?transform=0

{
person: {
columns: [
"id",
"name",
"classId"
],
records: [
[
"1",
"Alex",
"2"
],
[
"2",
"Dan",
"2"
],
[
"3",
"Ion",
"1"
],
[
"4",
"Boldij",
"2"
]
]
}
}

I made the relation with phpmyadmin.

[mevdschee]

Good, now try: http://localhost/api/index.php/person,class?transform=1

[boldijar]

Thank you! Works

[mevdschee]

Great, enjoy the software! Feedback is always welcome.

[boldijar]

Also, if I go to
http://localhost/api/index.php/person,class?transform=1
As you said

I get a list of

person: [
{
id: "1",
name: "Alex",
classId: "2",
class: [
{
id: "2",
name: "Sport"
}
]
}

Why a person has a list of classes?
It is not a many to many relationship, a person only has one classId field.
Am I wrong?

[mevdschee]

Why a person has a list of classes?

This way the relationship is represented the same way for belongsTo, hasMany and HABTM relationships. One may argue whether or not this is an advantage.

[boldijar]

So there is no way to only have a class object instead of a list of classes there?

[mevdschee]

At the moment you cannot, as the transformation does not know which field contains the primary key. On the other hand you probably do and you can easily add "[0]" to the class to get the object, right?

[boldijar]

Yes, i can.