python - SQLAlchemy .all() only returning first result on multi-join -

-

howdie do,

so i'm joing 5 tables using following query:

order = db.session.query(trailer, trip, trippallet, waveorder, package)\     .join(trip, trailer.trailer_id == trip.trailer_id)\     .join(trippallet, trip.trip_id == trippallet.trip_id)\     .join(waveorder, trippallet.pallet_id == waveorder.pallet_id)\     .join(package, waveorder.order_id == package.order_id)\     .filter(trailer.trailer_id == '555555').all()

now, 5 tables follows:

**trailer table** trailer_id       555555  **trip table** trip_id         trailer_id       523462462       555555  **trip pallet table** trip_id         pallet_id        523462462       1052 523462462       1054  **wave order table** pallet_id       order_id 1052            123456 1052            123457 1054            324567 1054            797453  **package table** order_id        tracking 123456            abckdf 123457            dvniuo 324567            dnklin 797453            adfnln

so give overview, trailer contains trip. trip contains pallets , each pallet contains waves grouping of packages.

the query i'm using above return packages on 1 pallet, it's not returning pallets.

when run query, via loop, result:

counter = 0 trailer, trip, trippallet, wave_order, package in order:     counter += 1     print "%d trailer id %d , contains trip id %d pallet id %d , has following order %d " \           "has following tracking number %s" % \           (counter, trailer.trailer_id, trip.trip_id, trippallet.pallet_id, wave_order.order_id, package.tracking_no)    1 trailer id 555555 , contains trip id 523462462 pallet id 1052 , has following order 123456 has following tracking number abckdf 2 trailer id 555555 , contains trip id 523462462 pallet id 1052 , has following order 123457 has following tracking number dvniuo

as can see, it's getting first pallet_id trip pallet table 1052. should getting pallet_id 1054 , returning packages on table.

does know how make return second pallet_id trip pallet table , it's corresponding packages?

howdie do,

the issue wasn't join statement. join statement 100% correct. in fact, database.

the dba had removed key data needed complete join statement.


Comments

Post a Comment

Popular posts from this blog

Android : Making Listview full screen -

-
<linearlayout xmlns:android="http://schemas.android.com/apk/res/android" xmlns:tools="http://schemas.android.com/tools" android:layout_width="match_parent" android:layout_height="match_parent" android:orientation="vertical" tools:context=".mainactivity"> <edittext android:layout_margintop="5dp" android:layout_width="match_parent" android:layout_height="50dp" android:background="@drawable/location_edittext" android:id="@+id/locationeditext" android:textsize="15sp" android:textcolor="#999" android:paddingleft="15dp" /> <com.example.ravi_gupta.slider.viewpagercustomduration android:layout_width="wrap_content" android:layout_height="0dp" android:id="@+id/viewpager" android:scrollbarstyle="outsideoverlay" android:layout_weight="0.5...
Read more

javascript - Parse JSON from the body of the POST -

-
i'm using cameratag.com record video on website. service can send json response server can save data database. don't know how proceed here: the documentation states please note json repsonse passed in body of post , not form parameters. here example of how parse response in ruby: data = json.parse(request.raw_post) video_uuid = data["uuid"] but don't know how data on javascript. i'm not experienced in js please bare me :) post sample: { "uuid": "00012710-4b65-0131-ffe6-22000a499ea4", "camera_uuid": "98373a20-79ee-0130-3e42-1231390fcc11", "created_at": "2013-12-20t05:25:02.000z", "percent_complete": 100, "short_code": "kktb4q", "metadata": { }, "state": "published", "recorded_from": "http://singwho.com", "publish_type": null, "formats": [ { "name...
Read more

javascript - How to Hide Date Menu from Datepicker in yii2 -

-
basically in datetimepicker widget date choose first time, how can hide date option widget , filter according time. tried not working want hide remove button [ 'attribute'=>'time', 'label'=>'time', 'format'=>'raw', 'value'=>function($data){ return date('h:i:s',strtotime($data->time)); }, 'filter'=> datetimepicker::widget([ 'model' => $searchmodel, 'attribute' => 'time', 'clientoptions' => [ 'autoclose' => true, 'format' => 'hh:ii', 'showon' =...
Read more