_seq_example.py

'''
Created on 2014-10-20


@author: XSD


# sequence #
NOTE:Encoding=UTF-8


'''


print("练习 training")
print("hello", "ptyon" + "!")
print(type(str(1)) == type(str(1.0)))




#元组(tuple):不可变的数据序列
print(' ########## 元组 ######### ')
item = ("中国", "南京", "A")
print("jangsu %s %s %-2s" % item + "item0 > " + item[0])
print("tuple len:%2s" % len(item))


singleTuple = ('one',)#单个元素加','
print("singleTuple:%2s" % singleTuple)
print("singleTuple:%2s" % singleTuple[0])
print("singleTuple:%2s" % singleTuple[0][2])#分片(slicing)
print("slicing:", item[1:4])#分片(slicing)


seq = [];
seq.extend(item);
print("copy:", seq)#copy序列每个元素
print("pop:", seq.pop(1))#弹出元素




m = ('a', 'b', 'c')
n = (1, 2, 3)
z = (m, n, "z")#嵌套
print("z[0]: %s %s %s" % z[0])
print("z[1]: %d %d %s" % z[1])
print("z[2]: %s" % z[2])
print("z[0][1]: %s" % z[0][1])
print("z[1][2]: %d" % z[1][2])




#列表(list):可变的数据序列
print(' ########## 列表 ######### ')
jiangsu = ["nanjing", "suzhou", "yangzhou", "huaian"]
print("list[0] > %s" % jiangsu[0])
print("list.len > %s" % len(jiangsu))
jiangsu[1] = '苏州'
print("list[1] > %s" % jiangsu[1])#modify


jiangsu.append("xuzhou")
print("list.len2 > %s" % len(jiangsu))
extra = ["e1", "e2", ]
jiangsu.extend(extra)
print("list.len3 > %s" % len(jiangsu))




#字典(dictionary):类似于列表和元组,可以用名称索引
print(' ########## 字典 ######### ')
dic = {}
dic["fir"] = 'first'
dic[0] = 'second'
dic['thd'] = 'third'
print("dic: %s" % dic)


dic2 = {'x' : 'a', 'x' : '1', 'y' : '1'}
print("dic2: %s" % dic2)
print("dic2[x]: %s" % dic2['x'])
dic2['y'] = 'o'
print("dic2['y']: %s" % dic2['y'])


keys = dic.keys()#key
values = dic.values()
print(list(values))#print value
print(list(keys)) #print key
print(len(keys))




#集合(assemblage):
print(' ########## 集合 ######### ')
ass = ['a', 'b', 'c', 'a']
print(set(ass))#去重复
请帮我看看这个sql语句是否正确,并改正:select a.ebeln, a.ebelp, a.art, a.kdauf, a.zbw, a.size1, a.txz01, a.menge, b.quantity, (a.menge - b.quantity) as OWE_MATERIAL, ( select sum(THIS_PLAN_QTY) as HAVE_PLAN , a.ebeln , a.ebelp , a.kdauf from SCM_OUTSOURCE_PRODUCTION_PLAN_LIST c , SCM_PROCESS_PURCHASE_ORDER_D a group by c.order_no , c.order_seq , c.sales_order , a.ebeln , a.ebelp , a.kdauf having c.order_no = a.ebeln And c.order_seq = a.ebelp And c.sales_order = a.kdauf ) , ( select a.menge - t.HAVE_PLAN as OWN_PLAY from (select sum(THIS_PLAN_QTY) as HAVE_PLAN , c.order_no , c.order_seq , c.sales_order from SCM_OUTSOURCE_PRODUCTION_PLAN_LIST c , SCM_PROCESS_PURCHASE_ORDER_D a group by c.order_no , c.order_seq , c.sales_order , a.ebeln , a.ebelp , a.kdauf having c.order_no = a.ebeln And c.order_seq = a.ebelp And c.sales_order = a.kdauf ) t , SCM_PROCESS_PURCHASE_ORDER_D a where a.ebeln = t.order_no and a.ebelp = t.order_seq and a.menge = t.sales_order ) , d.scan_qty, (d.quantity - d.scan_qty) as OWN_PRODUCE, e.scan_qty, (e.quantity - e.scan_qty) as OWE_SHIP from SCM_PROCESS_PURCHASE_ORDER_D a left join MMS_INOUT_BILL_M b On a.ebeln = b.purchase_order_number And a.ebelp = b.purchase_order_seq And a.kdauf = b.sales_order left join SCM_OUTSOURCE_PRODUCTION_PLAN_LIST c on a.ebeln = c.order_no And a.ebelp = c.order_seq And a.kdauf = c.sales_order left join SCM_PROCESS_OUTPUT d on a.ebeln = d.order_no And a.ebelp = d.order_seq And a.kdauf = d.sales_order left join SCM_OUTSOURCE_SHIP e on a.ebeln = e.qr_code and a.ebelp = e.order_no and a.kdauf = e.order_seq where a.art = 'IE7181' Order by a.ebeln desc, a.ebelp;
05-24
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值