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

Is there an open source WebSockets (JavaScript) XMPP library? -

-
Has anyone written the open source XMPP library that uses the websacet and is being run by a browser? We do not yet have a standard XMPP that can enforce the server, Must be adequately faced before it may be necessary The first step is to eliminate WebSAT standardization. It seems that it can be in an IETF Haib working group, which has not been approved by the IESG so far in the writing time (see) a few weeks ago (Hiroshima), a hybrid bird-of-a-feather in IETF ( BOF), which went very well. WebSketches have a constant reference, and it seems to be systematically organized, one will make XMPP binding for webmasters, possibly with a bar for every webset frame. Edit: Jack Moffitt has written an IETF can be used with the first pass on a protocol. Warning . It is still likely to change fast enough, only apply it if you are ready to wrap it completely later. Warning
Read more

java - Is there an object like a "Set" that can contain only unique string values, but also contain a count on the number of occurrences of the string value? -

-
There is an object like "set" in Java that can contain only unique string values, but it also includes a count Is the number of string value in number? This idea is simple. A data set, ALA ... ABBCCC I will set the text of each line set- I want to add to the object every time a non-unique text is added to the set, I also want to show a numeric value associated with the set to show how often it was added. So if I run it on the above data then set output will be something like this: A: 1B: 2C: 3 Any ideas? Maps & lt; String, integer & gt; add public null (strings) {if (map.containsKey (s)) {map.put (s, map.get (s) + 1); } And {map.put (S, 1); }}
Read more

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