entity relationship - One-to-one relations that only go one way in Laravel -

-

is possible/right have a relation between tables only goes 1 way? have invoices table need reference in other tables likes commission_payments , membership_payments invoices table not need commission_payment_id or membership_payment_id. in other words, there different types of transactions can happen , may have invoice attached, invoice not need reference these transaction tables.

invoices           commission_payments      membership_payments ---------------    ---------------------    --------------------- -id                -id                      -id ...                -invoice_id              -invoice_id                    ...                      ...

i have created eloquent models each table. added hasone relation invoices on other 2 models.

class commissionpayment extends model{     public function invoice(){         return $this->hasone('app\models\invoice');     } }

i tried accessing comission payment's attached invoice this:

$com = commissionpayment::first(); $com->invoice->id;

i error:

sqlstate[42s22]: column not found: 1054 unknown column  'invoices.commission_payment_id' in 'where clause' (sql: select * `invoices`  `invoices`.`commission_payment_id` = 15 , `invoices`.`commission_payment_id` not null limit 1)

why looking commission_payment_id field in invoices table? expect query sort of this:

select * `invoices` `id` = 23  /* id fetched `invoice_id` field in `commission_payments` table */

do have add column each table reference invoice_id? @ moment it's 2 grow. also, when invoice generated commission payment, won't need membership payment field don't think should go there.

a one-to-one relationship setup using either hasone or belongsto relationship. hasone side of relationship assumes foreign key stored on other table. belongsto side of relationship has foreign key.

therefore, since foreign key invoices stored on commission_payments , membership_payments tables, models said belong invoices table.

change relationship hasone belongsto , should go:

class commissionpayment extends model{     public function invoice() {         return $this->belongsto('app\models\invoice');     } }

Comments

Post a Comment

Popular posts from this blog

Django REST Framework perform_create: You cannot call `.save()` after accessing `serializer.data` -

-
i have following viewset: class artistprofileviewset(viewsets.modelviewset): queryset = artistprofile.objects.all() serializer_class = artistprofileserializer def perform_create(self, serializer): if serializer.is_valid(): serializer.save() with following serializers: class simpleartisttrackserializer(serializers.hyperlinkedmodelserializer): class meta: model = artisttrack fields = (...my fields...) class artistprofileserializer(serializers.hyperlinkedmodelserializer): owners = userserializer(many=true, required=false) tracks = simpleartisttrackserializer(many=true, required=false) class meta: model = artistprofile fields = (...my fields...) i getting following error: assertionerror: cannot call `.save()` after accessing `serializer.data`.if need access data before committing database inspect 'serializer.validated_data' instead. i don't see editing serializer.data object. th...
Read more

Why does Go error when trying to marshal this JSON? -

-
i'm trying rather simple example of trying decode json file structs using golang. however, when attempting error that json: cannot unmarshal object go value of type []main.track which don't understand. here's code in question, , json can found here . package main import ( "encoding/json" "fmt" "net/http" "os" ) // tracks group of track types type tracks struct { tracks []track } // track represents singular track type track struct { name string url string artist artist } // artist represents single artist type artist struct { name string mbid string url string } func main() { url := "http://ws.audioscrobbler.com/2.0/?method=geo.gettoptracks&api_key=c1572082105bd40d247836b5c1819623&format=json&country=netherlands" response, err := http.get(url) if err != nil { fmt.printf("%s\n", err) os.exit(1) } de...
Read more