从序列中获取变量或映射对象,如url中的元组或字典对象 [英] get variable from sequence or mapping object like tuple or dictionary object in url
问题描述
我的代码:
$ p $ do_nomor = request.args.get('do_nomor','')
bjdt_no_urut = request.args.get('bjdt_no_urut','')
try:
SQL =SELECT
bjdt_id,
do_nomor,
bjqc_tgl_buat,
to_char(do_tgl,'DD / MM / YYYY')
to_char(tgl_rencana_test,'DD / MM / YYYY')as tgl_rencana_test $ b $ from v_bendauji_detil其中
bjdt_tgl_test为空,
为do_nomor =%s
和bjdt_no_urut不在(%s)
ORDER BY bjdt_no_urut ASC限制10;
conn_string =dbname ='api_rc_38'user ='appusr'host ='localhost 'password ='1'port ='8765'
conn = psycopg2.connect(conn_string)
cur = conn.cursor(cursor_factory = psycopg2.extras.RealDictCursor)
data =(do_nomor,bjdt_no_urut,)
cur.execute(SQL,数据)
行= cur.fetchone()
cur.close()
conn.close()
json_data = json.dumps(行)
返回json_data
在GET方法中,如何将变量传递给字典中的url?
就像这个例子:
$ p $ http:// localhost:5000 / bendauji?do_nomor = DOCKET / ICN / 05-2017 / 5175& amp; amp; ; bjdt_no_urut =('5','6','7',)*
您可以使用这种格式的网址 获取 my code : How can I passing variable to url in dictionary with flask on GET method ?
like this example : You can use this format of url And get the value list of 这篇关于从序列中获取变量或映射对象,如url中的元组或字典对象的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋! http:// localhost:5000 / bendauji?do_nomor = DOCKET / ICN / 05-2017 / 5175& bjdt_no_urut = 5& bjdt_no_urut = 6& bjdt_no_urut = 7 $ c
$ b 的值列表bjdt_no_urut
使用 request.args.getlist ('bjdt_no_urut',无)
。 do_nomor = request.args.get('do_nomor', '')
bjdt_no_urut = request.args.get('bjdt_no_urut', '')
try:
SQL = """ SELECT
bjdt_id,
do_nomor,
to_char(do_tgl, 'DD/MM/YYYY' ) as do_tgl,
bjdt_no_urut,
bjqc_nomor,
to_char(bjqc_tgl_buat, 'DD/MM/YYYY' ) as bjqc_tgl_buat,
pelanggan_nama,
pry_nama,
to_char(tgl_rencana_test, 'DD/MM/YYYY' ) as tgl_rencana_test
from v_bendauji_detil where
bjdt_tgl_test is null and
do_nomor = %s
and bjdt_no_urut not in (%s)
ORDER BY bjdt_no_urut ASC limit 10;
"""
conn_string = "dbname='api_rc_38' user='appusr' host='localhost' password='1' port='8765' "
conn = psycopg2.connect(conn_string)
cur = conn.cursor(cursor_factory=psycopg2.extras.RealDictCursor)
data = ( do_nomor, bjdt_no_urut, )
cur.execute(SQL, data)
rows = cur.fetchone()
cur.close()
conn.close()
json_data = json.dumps(rows)
return json_data
http://localhost:5000/bendauji?do_nomor=DOCKET/ICN/05-2017/5175&bjdt_no_urut=('5','6','7',)*
http://localhost:5000/bendauji?do_nomor=DOCKET/ICN/05-2017/5175&bjdt_no_urut=5&bjdt_no_urut=6&bjdt_no_urut=7
bjdt_no_urut
use request.args.getlist('bjdt_no_urut', None)
.