psycopg2 vs sys.stdin.read() -

-

मेरे पास नीचे की तरह छोटा कोड है: 

  #! / Usr / bin / python आयात Psycopg2, sys कोशिश: conn = psycopg2.connect ("dbname = 'smdr' user = 'bino'"); को छोड़कर: प्रिंट "मैं डेटाबेस से कनेक्ट करने में असमर्थ हूँ" cur = conn.cursor () v_num = '1' cur.execute ("SELECT * from genctr WHERE कोड =% (num) s", dict (num = v_num) ) पंक्तियों में पंक्ति के लिए \ n "ctrnum = 0: प्रिंट पंक्ति [0] +", "+ पंक्ति [1]
P> जब मैं इसे चलाता हूं, मुझे 

  bino @ erp: ~ / mydoc / openerp / smdr $ ./genctr.py मुझे डेटाबेस दिखाएं: 1, बहामा 1, बारबाडोस 1, कनाडा 1, केमन द्वीप 1, संयुक्त राज्य अमेरिका 1, वर्जिन आइलैंड्स अमेरिका

मैं "v_num = '1'" "v_num = sys.stdin.read ()" के साथ बदलने की कोशिश करता हूं 

  #! / Usr / bin / python आयात psycopg2, sys कोशिश: conn = psycopg2.connect ("dbname = 'smdr' user = 'bino'"); को छोड़कर: प्रिंट "मैं डेटाबेस से कनेक्ट करने में असमर्थ हूँ" cur = conn.cursor () #v_num = '1' v_num = sys.stdin.read () cur.execute ("SELECT * from genctr WHERE कोड =% (num) ) S ", dict (num = v_num) पंक्तियां = cur.fetchall () प्रिंट" \ n मुझे डेटाबेस दिखाएं: \ n "ctrnum = 0 पंक्तियों में पंक्ति के लिए: प्रिंट पंक्ति [0] +", "+ पंक्ति [1 ]

लेकिन जब मैं इसे चलाता हूं, तो मुझे यह केवल मिला: 

  bino @ erp: ~ / mydoc / openerp / smdr $ echo 1 | ./  
 ईमानदारी से  
 -बिनो       P>  
 
 
  प्रतिध्वन 1  आपके प्रोग्राम को "1 \ n" दे रहा है (वह है, "1" बाद में एक नई पंक्ति के साथ)।  sys.stdin.read ()  उस सटीक स्ट्रिंग को वापस करने जा रहा है, और फिर psycopg2 एसक्यूएल स्टेटमेंट को  SELECT * को जेनरेटर WHERE code = '1 \ n' । नतीजे कोई मिलान परिणाम न होने वाला है, इसलिए लूप के अंदर के कोड को कभी भी निष्पादित नहीं किया जाएगा, यही वजह है कि आपको कोई अतिरिक्त आउटपुट दिखाई नहीं देता है।  
 या तो  echo-n 1  को स्ट्रिंग से किसी भी अग्रणी और अनुक्रमित सफेद स्थान को हटाने के लिए, न्यूलाइन या  sys.stdin.read ()। Strip ()  दबाएं। यदि  कोड  फ़ील्ड एक पूर्णांक है, तो यह एक अच्छा विचार हो सकता है कि  sys.stdin.read ()  का परिणाम एक int पर भी, जैसा भी हो: < / P> 
  int (sys.stdin.read ()। Strip ())

Comments

Post a Comment

Popular posts from this blog

iphone - How do I make a UIPickerView in a UIActionSheet -

-
Just want to know how I will create UIPickerView in a UIActionSheet with a simple array. Well, I really know how to put it in an action sheet but I like my way because it is more for my app, thanks, but I I also want to know how to put options in UIPKviewView, I just have an array with colors already on top of that part: red, green, blue, yellow, black, etc. in this, but I want to know how it In the preview d L'be if I am using the already Instifrem:? Please help anyone. I know that this is a stupid question, but I'm cheating my head on my $$$$$$ MacBook. Instead you want to do this, create your UIPickerView interface builder and have it in your view controller Connect to the outlet. Add it as a subview of your main view and set its frame coordinates so that it is offset right below the edge, x = 0, y = 480 Then, when you want to display a picker, animate it like something with the screen: [UIView startup permissions: zero reference: zero]; [Color picture setfr...
Read more

excel - Populate list via a bi-Condition -

-
I'm interested in implementing something but I'm not sure it would be possible and would like to take it on. This is my scenario: I will have two verification cells, which will be shown as a list, from which I will select. This is my condition that I want to remember and remember my list from a database. I have a list of agents, which has been thrown at B13: B23 and the next two, I have columns of data that assume that my data base looks like this bcdx | Y Z Agent 1 1 | 1 | 0 Agent 2 0 | 1 | 0 Agent 3 0 | 1 | 1 agent 4 1 | 0 | 0 ... I want to populate a list named agent from column B, when I verify cell 1: x and verification cell 2: 1 I choose from. It should only show an agent in column X with column: agent1 agent4 or 0 ... I read somewhere Array formula but I do not know if this is convenient and I have unfortunately not any background in the macro :( But I know C ++ is quite easy with some conditional statement like this. Advance Thanks, This...
Read more