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&quo
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&qu
Read more

javascript - Chrome Extension: Interacting with iframe embedded within popup -

-
i writing chrome extension needs interact urls user not have open. therefore using hidden iframes embedded within popup, , attempting click button within iframe. however, receiving same origin policy error. know possible extension interact iframes of different domain via content scripts when iframe on tab user has open, not sure if possible use content scripts interact iframes directly in popup. here code: manifest.json "content_scripts": [ { "js": [ "bin/jquery.min.js", "interaction.js" ], "all_frames": true, "run_at": "document_start", "matches": [ "http://*/*", "https://*/*" ] }], "permissions": [ "activetab", "tabs", "http://*/", "https://*/" ], interaction.js $(document).ready(function() { $('div#iframes').append("<iframe id='shop' src=
Read more