Re: Text-mode apps (Was :Who are the "spacists"?)

2017-03-26 Thread eryk sun
On Sun, Mar 26, 2017 at 6:57 PM, Chris Angelico wrote: > > In actual UCS-2, surrogates are entirely disallowed; in UTF-16, they *must* be > correctly paired. Strictly-speaking UCS-2 disallows codes that aren't defined by the standard, but the kernel couldn't be that

Re: Escaping confusion with Python 3 + MySQL

2017-03-26 Thread Steve D'Aprano
On Mon, 27 Mar 2017 07:13 am, Νίκος Βέργος wrote: > OMG!!! It actually worked! > > Can't believe that 3 days in a row i have tried everything concerning > string manipulation and mysql escaping nd the error was the UPDATE > itself You tried everything except what we told you, over and over

Re: Escaping confusion with Python 3 + MySQL

2017-03-26 Thread breamoreboy
On Sunday, March 26, 2017 at 8:33:49 PM UTC+1, Νίκος Βέργος wrote: > Τη Κυριακή, 26 Μαρτίου 2017 - 10:23:27 μ.μ. UTC+3, ο χρήστης > bream...@gmail.com έγραψε: > > On Sunday, March 26, 2017 at 4:11:54 PM UTC+1, Νίκος Βέργος wrote: > > > Τη Κυριακή, 26 Μαρτίου 2017 - 5:49:00 μ.μ. UTC+3, ο χρήστης

[issue29912] Overlapping tests between list_tests and seq_tests

2017-03-26 Thread Jim Fasarakis-Hilliard
New submission from Jim Fasarakis-Hilliard: Seems the CommonTests class defined in list_tests duplicates the testing performed by seq_tests.CommonTests in the following functions: test_index, test_count Additionally, a part of test_imul from list_tests.CommonTests can be moved to

[issue29911] Uninstall command line in Windows registry does not uninstall

2017-03-26 Thread Steve Dower
Steve Dower added the comment: I'll take a look at having separate commands set, but the component responsible is external and this may be an issue for them. Also, for future reference, continuing to point out that you would have preferred an MSI does not help you get faster assistance, and

Re: Text-mode apps (Was :Who are the "spacists"?)

2017-03-26 Thread Tim Chase
On 2017-03-27 02:37, Chris Angelico wrote: > > In DOS, (I don't remember if in all versions or only some) > > one could do all this and this opens very rich possibilities for > > approximating of objects with tiles. The only limitations > > that one uses 255 tiles, but even this enables to build >

[issue29888] The link referring to "Python download page" is broken

2017-03-26 Thread Kinebuchi Tomohiko
Kinebuchi Tomohiko added the comment: @ned.deily Thank you for the commend. I updated the 2.7 PR. -- ___ Python tracker ___

Re: Escaping confusion with Python 3 + MySQL

2017-03-26 Thread Chris Angelico
On Mon, Mar 27, 2017 at 1:39 PM, Νίκος Βέργος wrote: >> MariaDB / MySQL shows part of your SQL from where they failed to parse. >> In your case, your MariaDB can't parse from '(' >> LIKE clause is not problem for this issue? > > Yes indeed it is. > I was just so sure that

[issue29911] Uninstall command line in Windows registry does not uninstall

2017-03-26 Thread Christian Ullrich
Christian Ullrich added the comment: Thank you. As for the pointing out: It worked for Cato, didn't it? He may not have lived to see it, but his perseverance in the face of rejection eventually brought about the years-long bloody war he had dreamed about. (Any historical inaccuracies in the

[issue29911] Uninstall command line in Windows registry does not uninstall

2017-03-26 Thread Zachary Ware
Changes by Zachary Ware : -- nosy: -zach.ware ___ Python tracker ___ ___

Re: Escaping confusion with Python 3 + MySQL

2017-03-26 Thread Νίκος Βέργος
Τη Δευτέρα, 27 Μαρτίου 2017 - 5:43:01 π.μ. UTC+3, ο χρήστης Chris Angelico έγραψε: > On Mon, Mar 27, 2017 at 1:39 PM, Νίκος Βέργος wrote: > >> MariaDB / MySQL shows part of your SQL from where they failed to parse. > >> In your case, your MariaDB can't parse from '(' > >>

[issue29888] The link referring to "Python download page" is broken

2017-03-26 Thread Ned Deily
Ned Deily added the comment: New changeset 6f95b37f290e0225aed5f8f7733ad0730601201b by Ned Deily (cocoatomo) in branch '2.7': bpo-29888: Fix the link referring to "Python download page" (GH-823) https://github.com/python/cpython/commit/6f95b37f290e0225aed5f8f7733ad0730601201b --

Escaping confusion with Python 3 + MySQL

2017-03-26 Thread Νίκος Βέργος
print('''UPDATE visitors SET (pagesID, host, ref, location, useros, browser, visits) VALUES (%s, %s, %s, %s, %s, %s, %s) WHERE host LIKE "%s"''', (pID, domain, ref, location, useros, browser, lastvisit, domain) ) prints out: UPDATE visitors SET (pagesID, host, ref, location, useros, browser,

[issue29909] types.coroutine monkey patches original function

2017-03-26 Thread Eric Hopper
New submission from Eric Hopper: The types.coroutine decorator for Python 3.6 (and I suspect for Python 3.6.1 as well) simply monkey patches the function it's passed and then returns it. This results in behavior that I found somewhat surprising. def bar(): yield 5 foo =

Re: Python question

2017-03-26 Thread Cameron Simpson
On 26Mar2017 20:55, Steve D'Aprano wrote: On Sun, 26 Mar 2017 01:55 pm, c...@zip.com.au wrote: 1: He BCCed the list, not us individually. Look at the headers. BCCed addresses aren't visible in the headers. That's why they're BLIND CC. Of course, but the received

[issue27827] pathlib is_reserved fails for some reserved paths on Windows

2017-03-26 Thread Eryk Sun
Eryk Sun added the comment: For COM[n] and LPT[n], only ASCII 1-9 and superscript 1-3 (U+00b9, U+00b2, and U+00b3) are handled as decimal digits. For example: >>> print(*(ascii(chr(c)) for c in range(1, 65536) ... if _getfullpathname('COM%s' % chr(c))[0] == '\\'), sep=', ')

[issue29888] The link referring to "Python download page" is broken

2017-03-26 Thread Kinebuchi Tomohiko
Kinebuchi Tomohiko added the comment: I just created two pull requests. + PR for 2.7 -> https://github.com/python/cpython/pull/823 + PR for 3.5 or newer -> https://github.com/python/cpython/pull/824 -- ___ Python tracker

Re: Escaping confusion with Python 3 + MySQL

2017-03-26 Thread Ian Kelly
On Sun, Mar 26, 2017 at 8:24 AM, Νίκος Βέργος wrote: > Τη Κυριακή, 26 Μαρτίου 2017 - 5:19:27 μ.μ. UTC+3, ο χρήστης Ian έγραψε: > >> You need to change the placeholders back. The poster who told you to >> replace them was misinformed. > > okey altered them back to > >

Re: Text-mode apps (Was :Who are the "spacists"?)

2017-03-26 Thread Chris Angelico
On Mon, Mar 27, 2017 at 2:37 AM, Chris Angelico wrote: > Just use Unicode. Everything else, these days, is a subset of Unicode > anyway. (Caveat: There are a few counter-examples to my statement, but I very much doubt that someone who's talking about PC OEM graphics is going to

Re: Text-mode apps (Was :Who are the "spacists"?)

2017-03-26 Thread Mikhail V
On 26 March 2017 at 21:53, Chris Angelico wrote: > On Mon, Mar 27, 2017 at 6:25 AM, Mikhail V wrote: >> On 26 March 2017 at 20:10, Steve D'Aprano wrote: >>> On Mon, 27 Mar 2017 03:57 am, Mikhail V wrote: >>> >>> [...] >>

[issue29908] Inconsistent crashing with an access violation

2017-03-26 Thread Steve Dower
Steve Dower added the comment: Have you confirmed this occurring with 3.5? PyCharm has a very invasive debugger that is almost certainly responsible, but there's a significant difference between the 3.5 and 3.6 implementations that is probably relevant. --

[issue29162] pyshell.py: name 'sys' is not defined

2017-03-26 Thread Terry J. Reedy
Terry J. Reedy added the comment: Reopening because I missed file=sys.__stderr__ in the print() above sys.exit ;-(. Reported by JelleZijlstra in PR. I wonder if there is any way to force an import to fail when testing. I could at least partly test by moving the code for import failure and

Re: Escaping confusion with Python 3 + MySQL

2017-03-26 Thread Νίκος Βέργος
Τη Δευτέρα, 27 Μαρτίου 2017 - 2:27:31 π.μ. UTC+3, ο χρήστης INADA Naoki έγραψε: > > i dont have to update table set column1 = this value, column2=that value and > > so on > > Why do you think so? Did you really read the manual? > > mysql> create table test_update (a int primary key, b int, c

Re: Escaping confusion with Python 3 + MySQL

2017-03-26 Thread Chris Angelico
On Mon, Mar 27, 2017 at 1:52 PM, Νίκος Βέργος wrote: > Its NOT that i have not read it exactly, but for some strange reason i was > under the belief that the way i had syntactically typed the UPDATE query was > correctly and more consistent and similar to thr INSERT query

[issue29888] The link referring to "Python download page" is broken

2017-03-26 Thread Ned Deily
Changes by Ned Deily : -- resolution: -> fixed stage: commit review -> resolved status: open -> closed ___ Python tracker ___

Re: Escaping confusion with Python 3 + MySQL

2017-03-26 Thread breamoreboy
On Sunday, March 26, 2017 at 4:11:54 PM UTC+1, Νίκος Βέργος wrote: > Τη Κυριακή, 26 Μαρτίου 2017 - 5:49:00 μ.μ. UTC+3, ο χρήστης Ian έγραψε: > > > The database wrapper won't do substitution into the middle of a string > > like that. Either concatenate the literal %'s on in the SQL statement > >

[issue29162] pyshell.py: name 'sys' is not defined

2017-03-26 Thread Jelle Zijlstra
Changes by Jelle Zijlstra : -- pull_requests: +735 ___ Python tracker ___ ___

[issue29162] pyshell.py: name 'sys' is not defined

2017-03-26 Thread Mariatta Wijaya
Changes by Mariatta Wijaya : -- pull_requests: +736 ___ Python tracker ___ ___

RE: [Python-ideas] Proposal: Query language extension to Python (PythonQL)

2017-03-26 Thread Gerald Britton
(Forgot the subject) > >* On 25 Mar 2017, at 15:51, Gerald Britton >> wrote: > *> >* On 25 March 2017 at 11:24, Pavel Velikhov >> wrote: > *>* > No, the current solution is temporary

[issue29910] Ctrl-D eats a character on IDLE

2017-03-26 Thread Terry J. Reedy
Terry J. Reedy added the comment: Checking, I see that the default ^D binding to DEL is documented in IDLE Help, section 2, Editing and Navigation, along with other Text defaults. (I need to determine if the list is complete. Is it the same on all systems?) I question whether IDLE should

[issue29909] types.coroutine monkey patches original function

2017-03-26 Thread Eric Hopper
Eric Hopper added the comment: Here's an update to types.coroutine that fixes the problem for me. -- Added file: http://bugs.python.org/file46756/types.coroutine.py ___ Python tracker

[issue19824] string.Template: Rewrite docs to emphasize i18n use case

2017-03-26 Thread R. David Murray
R. David Murray added the comment: Let's retitle this, then. -- nosy: +r.david.murray title: string.Template: Add PHP-style variable expansion example -> string.Template: Rewrite docs to emphasize i18n use case ___ Python tracker

[issue20774] collections.deque should ship with a stdlib json serializer

2017-03-26 Thread Lisa Roach
Lisa Roach added the comment: I made PR 830 for this issue, it seems to be a nice feature to have in my opinion. Let me know if I should add some unit tests :) -- nosy: +lisroach pull_requests: +734 ___ Python tracker

Re: Escaping confusion with Python 3 + MySQL

2017-03-26 Thread Νίκος Βέργος
Τη Δευτέρα, 27 Μαρτίου 2017 - 6:00:34 π.μ. UTC+3, ο χρήστης Chris Angelico έγραψε: > On Mon, Mar 27, 2017 at 1:52 PM, Νίκος Βέργος wrote: > > Its NOT that i have not read it exactly, but for some strange reason i was > > under the belief that the way i had syntactically

[issue20552] Use specific asserts in bytes tests

2017-03-26 Thread Terry J. Reedy
Terry J. Reedy added the comment: Raymond, Am I correct in thinking that your comment is not specific to bytes but applies to all patches like this? If so, I think I agree because any future changes that break tests will almost certain happen in 3.7+, so that the extra work of backporting

[issue20774] collections.deque should ship with a stdlib json serializer

2017-03-26 Thread Raymond Hettinger
Raymond Hettinger added the comment: Thanks Lisa. -- ___ Python tracker ___ ___ Python-bugs-list mailing list

Re: Escaping confusion with Python 3 + MySQL

2017-03-26 Thread Νίκος Βέργος
Τη Κυριακή, 26 Μαρτίου 2017 - 11:59:21 μ.μ. UTC+3, ο χρήστης Larry Hudson έγραψε: > On 03/26/2017 01:21 AM, Νίκος Βέργος wrote: > > print('''UPDATE visitors SET (pagesID, host, ref, location, useros, > > browser, visits) VALUES (%s, %s, %s, %s, %s, %s, %s) WHERE host LIKE > > "%s"''', (pID,

Re: Escaping confusion with Python 3 + MySQL

2017-03-26 Thread INADA Naoki
> i dont have to update table set column1 = this value, column2=that value and > so on Why do you think so? Did you really read the manual? mysql> create table test_update (a int primary key, b int, c int); Query OK, 0 rows affected (0.02 sec) mysql> insert into test_update values (1, 2, 3);

[issue11989] deprecate shutil.copy2

2017-03-26 Thread Serhiy Storchaka
Changes by Serhiy Storchaka : -- status: open -> pending ___ Python tracker ___

Re: Escaping confusion with Python 3 + MySQL

2017-03-26 Thread Frank Millman
"Νίκος Βέργος" wrote in message news:8c5f0443-c61b-4059-8d6f-576152d59...@googlegroups.com... cur.execute('''UPDATE visitors SET (pagesID, host, ref, location, useros, browser, visits) VALUES (%s, %s, %s, %s, %s, %s, %s) WHERE host LIKE %s''', (pID, domain, ref, location, useros, browser,

Re: Escaping confusion with Python 3 + MySQL

2017-03-26 Thread Ian Kelly
On Sun, Mar 26, 2017 at 8:07 AM, Νίκος Βέργος wrote: > Τη Κυριακή, 26 Μαρτίου 2017 - 5:04:27 μ.μ. UTC+3, ο χρήστης INADA Naoki This > error came from MySQL. If there are no logs in error_log, it's >> your configuration issue. >> >> See

Text-mode apps (Was :Who are the "spacists"?)

2017-03-26 Thread Mikhail V
On 26 March 2017 at 16:28, Wildman via Python-list wrote: > On Sun, 26 Mar 2017 15:18:06 +0200, Mikhail V wrote: > >> On 26 March 2017 at 06:16, Wildman via Python-list >> wrote: >>> On Tue, 21 Mar 2017 15:15:14 +0100, Mikhail V wrote: >>> And

Re: Text-mode apps (Was :Who are the "spacists"?)

2017-03-26 Thread Chris Angelico
On Mon, Mar 27, 2017 at 2:17 AM, Mikhail V wrote: >>> Why? IIRC I can do good pseudographics on linux only with extended >>> unicode character sets, so yes it is possible, is that what you mean? >> >> No. The same ASCII character set that was available in DOS is >>

Re: Installation issue with Python 3.6.1 for 64 bit Windows

2017-03-26 Thread Sibylle Koczian
Am 26.03.2017 um 06:01 schrieb arjun.janah: Hello, I am using an HP PC, brought in 2009, which currently has on it Windows 7 Ultimate, Service Pack 1. Did you do all Windows updates? System type is 64-bit operating system. I went to https://www.python.org/downloads/windows/ and chose the

[issue29909] types.coroutine monkey patches original function

2017-03-26 Thread Yury Selivanov
Yury Selivanov added the comment: Yeah, we can fix this. However, I don't want to push the fix to 3.6, too much code uses this function now. So it's going to be 3.7 only. -- assignee: -> yselivanov versions: +Python 3.7 -Python 3.6 ___ Python

Re: Installation issue with Python 3.6.1 for 64 bit Windows

2017-03-26 Thread eryk sun
On Sun, Mar 26, 2017 at 4:01 AM, arjun.janah wrote: > > I ran the file and it appeared to install properly. But when I tried to run > Python from > the Windows All Programs menu tab, I got the following message, in a small > window by the window with a black screen: >

Re: Escaping confusion with Python 3 + MySQL

2017-03-26 Thread Νίκος Βέργος
Any ideas on how to make progress on that? After all its just an UPDATE with a WHERE clause?! Do you also think is DBI related issue? -- https://mail.python.org/mailman/listinfo/python-list

Re: Escaping confusion with Python 3 + MySQL

2017-03-26 Thread Νίκος Βέργος
I do not see why my UPDATE fails. cur.execute('''UPDATE visitors SET (pagesID, host, ref, location, useros, browser, visits) VALUES (%s, %s, %s, %s, %s, %s, %s)''') works i dont have to update table set column1 = this value, column2=that value and so on It's just when the LIKE clause jumps in

[issue29888] The link referring to "Python download page" is broken

2017-03-26 Thread Ned Deily
Ned Deily added the comment: New changeset f8beb9831acd5cf80b9c56aea5864e16118c5400 by Ned Deily (cocoatomo) in branch 'master': bpo-29888: Fix the link referring to the "Python download page" (GH-824) https://github.com/python/cpython/commit/f8beb9831acd5cf80b9c56aea5864e16118c5400

Re: Text-mode apps (Was :Who are the "spacists"?)

2017-03-26 Thread Steve D'Aprano
On Mon, 27 Mar 2017 02:37 am, Chris Angelico wrote: > On Mon, Mar 27, 2017 at 2:17 AM, Mikhail V wrote: Why? IIRC I can do good pseudographics on linux only with extended unicode character sets, so yes it is possible, is that what you mean? >>> >>> No. The same

[issue29888] The link referring to "Python download page" is broken

2017-03-26 Thread Ned Deily
Changes by Ned Deily : -- pull_requests: +733 ___ Python tracker ___ ___ Python-bugs-list

[issue12414] getsizeof() on code objects is wrong

2017-03-26 Thread Serhiy Storchaka
Serhiy Storchaka added the comment: See gettotalsizeof.py attached to issue19048. It contains two functions that calculates the total size of the object with subobjects recursively. The problem is that virtually all objects are linked, two functions use slightly different criteria for

Re: Text-mode apps (Was :Who are the "spacists"?)

2017-03-26 Thread Chris Angelico
On Mon, Mar 27, 2017 at 5:10 AM, Steve D'Aprano wrote: >> And for own standalone app, I would not use any TTF or >> anything vector-based font, since why? > > Right, because your users will *love* to see their native language displayed > in a crappy bitmapped font with

Re: Text-mode apps (Was :Who are the "spacists"?)

2017-03-26 Thread eryk sun
On Sun, Mar 26, 2017 at 5:58 PM, Chris Angelico wrote: >> The Windows console can render any character in the BMP, but it >> requires configuring font linking for fallback fonts. It's Windows, so >> of course the supported UTF format is UTF-16. The console's UTF-8 >> support

Re: Escaping confusion with Python 3 + MySQL

2017-03-26 Thread Νίκος Βέργος
Τη Κυριακή, 26 Μαρτίου 2017 - 8:58:55 μ.μ. UTC+3, ο χρήστης alister έγραψε: > On Sun, 26 Mar 2017 07:43:51 -0700, Νίκος Βέργος wrote: > > > Τη Κυριακή, 26 Μαρτίου 2017 - 5:38:57 μ.μ. UTC+3, ο χρήστης alister > > έγραψε: > >> On Sun, 26 Mar 2017 07:24:49 -0700, Νίκος Βέργος wrote: > >> > >> > Τη

Re: Escaping confusion with Python 3 + MySQL

2017-03-26 Thread INADA Naoki
Read my mail again. > This error came from MySQL. If there are no logs in error_log, it's > your configuration issue. > See https://dev.mysql.com/doc/refman/5.7/en/update.html for Update > statement syntax. -- https://mail.python.org/mailman/listinfo/python-list

[issue29888] The link referring to "Python download page" is broken

2017-03-26 Thread Ned Deily
Ned Deily added the comment: New changeset 8ce3085bf167b702989a9db466078b5676e825e3 by Ned Deily in branch '3.5': bpo-29888: Fix the link referring to the "Python download page" (GH-824) (GH-827) https://github.com/python/cpython/commit/8ce3085bf167b702989a9db466078b5676e825e3 --

[issue29888] The link referring to "Python download page" is broken

2017-03-26 Thread Ned Deily
Ned Deily added the comment: New changeset ceff32fb833e7be42508ffa73344e2e56865e54b by Ned Deily in branch '3.6': bpo-29888: Fix the link referring to the "Python download page" (GH-824) (GH-826) https://github.com/python/cpython/commit/ceff32fb833e7be42508ffa73344e2e56865e54b --

Re: Escaping confusion with Python 3 + MySQL

2017-03-26 Thread alister
On Sun, 26 Mar 2017 07:43:51 -0700, Νίκος Βέργος wrote: > Τη Κυριακή, 26 Μαρτίου 2017 - 5:38:57 μ.μ. UTC+3, ο χρήστης alister > έγραψε: >> On Sun, 26 Mar 2017 07:24:49 -0700, Νίκος Βέργος wrote: >> >> > Τη Κυριακή, 26 Μαρτίου 2017 - 5:19:27 μ.μ. UTC+3, ο χρήστης Ian >> > έγραψε: >> > >> >> You

Re: Text-mode apps (Was :Who are the "spacists"?)

2017-03-26 Thread Steve D'Aprano
On Mon, 27 Mar 2017 03:57 am, Mikhail V wrote: [...] >>> And more important: can one use binary (bitmap) fonts in default modern >>> linux console? If yes, can one patch them with custom tiles at >>> the application start? >> >> If you really need something completely custom, it's not text any >>

Re: Escaping confusion with Python 3 + MySQL

2017-03-26 Thread Chris Angelico
On Mon, Mar 27, 2017 at 5:52 AM, Νίκος Βέργος wrote: > Τη Κυριακή, 26 Μαρτίου 2017 - 9:32:13 μ.μ. UTC+3, ο χρήστης Chris Angelico > έγραψε: >> On Mon, Mar 27, 2017 at 4:54 AM, Νίκος Βέργος wrote: >> > Τη Κυριακή, 26 Μαρτίου 2017 - 8:06:07 μ.μ. UTC+3, ο

Re: Text-mode apps (Was :Who are the "spacists"?)

2017-03-26 Thread Mikhail V
On 26 March 2017 at 20:10, Steve D'Aprano wrote: > On Mon, 27 Mar 2017 03:57 am, Mikhail V wrote: > > [...] And more important: can one use binary (bitmap) fonts in default modern linux console? If yes, can one patch them with custom tiles at the

Re: Escaping confusion with Python 3 + MySQL

2017-03-26 Thread Νίκος Βέργος
Τη Κυριακή, 26 Μαρτίου 2017 - 10:56:07 μ.μ. UTC+3, ο χρήστης Chris Angelico έγραψε: > On Mon, Mar 27, 2017 at 6:33 AM, Νίκος Βέργος wrote: > > Since i'm incopetent as you suggest i'am show us your level of skills and > > expertise and provide a solution, otherwise you are

Re: Escaping confusion with Python 3 + MySQL

2017-03-26 Thread Νίκος Βέργος
Currently to avoid any misinformations my code looks as follows: domain = '.'.join( host.split('.')[-2:] ) domain_query = '%%%s' % domain cur.execute('''UPDATE visitors SET (pagesID, host, ref, location, useros, browser, visits) VALUES (%s, %s, %s, %s, %s, %s, %s) WHERE host LIKE %s''', (pID,

[issue29888] The link referring to "Python download page" is broken

2017-03-26 Thread Ned Deily
Changes by Ned Deily : -- pull_requests: +732 ___ Python tracker ___ ___ Python-bugs-list

Re: Text-mode apps (Was :Who are the "spacists"?)

2017-03-26 Thread eryk sun
On Sun, Mar 26, 2017 at 3:37 PM, Chris Angelico wrote: > > Just use Unicode. Everything else, these days, is a subset of Unicode > anyway. Unless you're stuck on the default Windows shell/terminal, you > should be able to use UTF-8 everywhere and have the entire Unicode > range

Re: Text-mode apps (Was :Who are the "spacists"?)

2017-03-26 Thread Chris Angelico
On Mon, Mar 27, 2017 at 4:38 AM, eryk sun wrote: > On Sun, Mar 26, 2017 at 3:37 PM, Chris Angelico wrote: >> >> Just use Unicode. Everything else, these days, is a subset of Unicode >> anyway. Unless you're stuck on the default Windows shell/terminal, you >>

Re: Escaping confusion with Python 3 + MySQL

2017-03-26 Thread Larry Hudson via Python-list
On 03/26/2017 01:21 AM, Νίκος Βέργος wrote: print('''UPDATE visitors SET (pagesID, host, ref, location, useros, browser, visits) VALUES (%s, %s, %s, %s, %s, %s, %s) WHERE host LIKE "%s"''', (pID, domain, ref, location, useros, browser, lastvisit, domain) ) prints out: UPDATE visitors SET

Re: Text-mode apps (Was :Who are the "spacists"?)

2017-03-26 Thread Mikhail V
On 26 March 2017 at 17:37, Chris Angelico wrote: > On Mon, Mar 27, 2017 at 2:17 AM, Mikhail V wrote: Why? IIRC I can do good pseudographics on linux only with extended unicode character sets, so yes it is possible, is that what you mean? >>> >>>

[issue29910] Ctrl-D eats a character on IDLE

2017-03-26 Thread Serhiy Storchaka
New submission from Serhiy Storchaka: Ctrl-D is binded to commenting out a block in IDLE. But additionally it deletes the first character of the line after the block. The default binding of Ctrl-D in Text widget is deleting a character under cursor. IDLE first comment out selected block, and

Re: Text-mode apps (Was :Who are the "spacists"?)

2017-03-26 Thread eryk sun
On Sun, Mar 26, 2017 at 5:29 PM, Chris Angelico wrote: > Rounded corners? > > ╭─┬─╮ > ├─┼─┤ > ╰─┴─╯ This prints fine in the Windows console with Consolas as the font, but the older Courier New and Lucida Console fonts lack glyphs for the rounded corners. --

Re: Text-mode apps (Was :Who are the "spacists"?)

2017-03-26 Thread Chris Angelico
On Mon, Mar 27, 2017 at 4:43 AM, Steve D'Aprano wrote: > On Mon, 27 Mar 2017 02:37 am, Chris Angelico wrote: > >> Just use Unicode. Everything else, these days, is a subset of Unicode >> anyway. Unless you're stuck on the default Windows shell/terminal, you >> should

Re: Escaping confusion with Python 3 + MySQL

2017-03-26 Thread Chris Angelico
On Mon, Mar 27, 2017 at 4:54 AM, Νίκος Βέργος wrote: > Τη Κυριακή, 26 Μαρτίου 2017 - 8:06:07 μ.μ. UTC+3, ο χρήστης INADA Naoki > έγραψε: >> Read my mail again. >> >> > This error came from MySQL. If there are no logs in error_log, it's >> > your configuration issue. >> >> >

Re: Text-mode apps (Was :Who are the "spacists"?)

2017-03-26 Thread eryk sun
On Sun, Mar 26, 2017 at 5:49 PM, eryk sun wrote: > On Sun, Mar 26, 2017 at 5:29 PM, Chris Angelico wrote: >> Rounded corners? >> >> ╭─┬─╮ >> ├─┼─┤ >> ╰─┴─╯ > > This prints fine in the Windows console with Consolas as the font, but > the older Courier New and

Re: Escaping confusion with Python 3 + MySQL

2017-03-26 Thread breamoreboy
On Sunday, March 26, 2017 at 3:11:50 PM UTC+1, Ian wrote: > On Sun, Mar 26, 2017 at 7:39 AM, MeV wrote: > > On Sunday, March 26, 2017 at 6:34:30 AM UTC-7, Νίκος Βέργος wrote: > >> with import cgitb; cgitb.enable() > >> > >> ProgrammingError(1064, "You have an error in your SQL syntax; check the >

Re: Escaping confusion with Python 3 + MySQL

2017-03-26 Thread Νίκος Βέργος
Τη Κυριακή, 26 Μαρτίου 2017 - 10:23:27 μ.μ. UTC+3, ο χρήστης bream...@gmail.com έγραψε: > On Sunday, March 26, 2017 at 4:11:54 PM UTC+1, Νίκος Βέργος wrote: > > Τη Κυριακή, 26 Μαρτίου 2017 - 5:49:00 μ.μ. UTC+3, ο χρήστης Ian έγραψε: > > > > > The database wrapper won't do substitution into the

Re: Installation issue with Python 3.6.1 for 64 bit Windows

2017-03-26 Thread Arjun Janah
Thank you, Eryk Sun. On Mar 26, 2017 12:40 PM, "eryk sun" wrote: > On Sun, Mar 26, 2017 at 4:01 AM, arjun.janah > wrote: > > > > I ran the file and it appeared to install properly. But when I tried to > run Python from > > the Windows All Programs menu

Re: Escaping confusion with Python 3 + MySQL

2017-03-26 Thread Νίκος Βέργος
Τη Κυριακή, 26 Μαρτίου 2017 - 8:06:07 μ.μ. UTC+3, ο χρήστης INADA Naoki έγραψε: > Read my mail again. > > > This error came from MySQL. If there are no logs in error_log, it's > > your configuration issue. > > > See https://dev.mysql.com/doc/refman/5.7/en/update.html for Update > > statement

[issue29888] The link referring to "Python download page" is broken

2017-03-26 Thread Ned Deily
Ned Deily added the comment: Thanks for the pull requests! I've merged to master, 3.6, and 3.5 and I left a comment for the 2.7 PR. By the way, next time you make a PR, please feel free to add your name to Misc/ACKS. -- stage: -> commit review versions: +Python 3.7

[issue29911] Uninstall command line in Windows registry does not uninstall

2017-03-26 Thread Christian Ullrich
New submission from Christian Ullrich: The Windows installation package registers a command line for uninstalling the package. Running this command line does not uninstall the package. The command line ends with "/modify". For uninstallation, it should be "/passive /uninstall". Windows

[issue29908] Inconsistent crashing with an access violation

2017-03-26 Thread Cameron Mckain
Cameron Mckain added the comment: C:\Users\cmcka\PycharmProjects\test>wevtutil qe application /rd:true /c:1 /format:text /q:"*[System[Provider[@Name='Application Error']]][EventData[Data='python.exe'][Data='ucrtbase.dll']]" Event[0]: Log Name: Application Source: Application Error Date:

Re: Escaping confusion with Python 3 + MySQL

2017-03-26 Thread Νίκος Βέργος
Τη Κυριακή, 26 Μαρτίου 2017 - 9:32:13 μ.μ. UTC+3, ο χρήστης Chris Angelico έγραψε: > On Mon, Mar 27, 2017 at 4:54 AM, Νίκος Βέργος wrote: > > Τη Κυριακή, 26 Μαρτίου 2017 - 8:06:07 μ.μ. UTC+3, ο χρήστης INADA Naoki > > έγραψε: > >> Read my mail again. > >> > >> > This error

Re: Text-mode apps (Was :Who are the "spacists"?)

2017-03-26 Thread Chris Angelico
On Mon, Mar 27, 2017 at 5:37 AM, eryk sun wrote: > On Sun, Mar 26, 2017 at 5:58 PM, Chris Angelico wrote: >>> The Windows console can render any character in the BMP, but it >>> requires configuring font linking for fallback fonts. It's Windows, so >>> of

Re: Escaping confusion with Python 3 + MySQL

2017-03-26 Thread Νίκος Βέργος
Τη Κυριακή, 26 Μαρτίου 2017 - 10:04:31 μ.μ. UTC+3, ο χρήστης Chris Angelico έγραψε: > On Mon, Mar 27, 2017 at 5:52 AM, Νίκος Βέργος wrote: > > Τη Κυριακή, 26 Μαρτίου 2017 - 9:32:13 μ.μ. UTC+3, ο χρήστης Chris Angelico > > έγραψε: > >> On Mon, Mar 27, 2017 at 4:54 AM, Νίκος

[issue19824] string.Template: Add PHP-style variable expansion example

2017-03-26 Thread Serhiy Storchaka
Serhiy Storchaka added the comment: Formatting with locals() and globals() should be used with careful. This is not the most idiomatic way of formatting. I think that the post in specialised blog would be better place for describing it than Python stdlib documentation. Peoples coming from PHP

Re: Text-mode apps (Was :Who are the "spacists"?)

2017-03-26 Thread Chris Angelico
On Mon, Mar 27, 2017 at 6:25 AM, Mikhail V wrote: > On 26 March 2017 at 20:10, Steve D'Aprano wrote: >> On Mon, 27 Mar 2017 03:57 am, Mikhail V wrote: >> >> [...] > And more important: can one use binary (bitmap) fonts in default modern >

Re: Escaping confusion with Python 3 + MySQL

2017-03-26 Thread Joel Goldstick
On Sun, Mar 26, 2017 at 11:48 AM, Νίκος Βέργος wrote: > Τη Κυριακή, 26 Μαρτίου 2017 - 6:39:01 μ.μ. UTC+3, ο χρήστης Steve D'Aprano > έγραψε: >> On Mon, 27 Mar 2017 02:11 am, Νίκος Βέργος wrote: >> >> > I just tried: >> > >> > domain = '.'.join( host.split('.')[-2:] ) >> >

Re: Text-mode apps (Was :Who are the "spacists"?)

2017-03-26 Thread Chris Angelico
On Mon, Mar 27, 2017 at 3:57 AM, Mikhail V wrote: > On 26 March 2017 at 17:37, Chris Angelico wrote: >> On Mon, Mar 27, 2017 at 2:17 AM, Mikhail V wrote: > Why? IIRC I can do good pseudographics on linux only with extended >

[issue29910] Ctrl-D eats a character on IDLE

2017-03-26 Thread Serhiy Storchaka
Changes by Serhiy Storchaka : -- pull_requests: +731 ___ Python tracker ___ ___

Re: Escaping confusion with Python 3 + MySQL

2017-03-26 Thread Chris Angelico
On Mon, Mar 27, 2017 at 6:33 AM, Νίκος Βέργος wrote: > Since i'm incopetent as you suggest i'am show us your level of skills and > expertise and provide a solution, otherwise you are also what you claim of me. It's not his problem. An expert does not have to provide

Re: Escaping confusion with Python 3 + MySQL

2017-03-26 Thread Νίκος Βέργος
Τη Κυριακή, 26 Μαρτίου 2017 - 11:05:34 μ.μ. UTC+3, ο χρήστης Νίκος Βέργος έγραψε: > Τη Κυριακή, 26 Μαρτίου 2017 - 10:56:07 μ.μ. UTC+3, ο χρήστης Chris Angelico > έγραψε: > > On Mon, Mar 27, 2017 at 6:33 AM, Νίκος Βέργος wrote: > > > Since i'm incopetent as you suggest i'am

[issue19824] string.Template: Add PHP-style variable expansion example

2017-03-26 Thread Barry A. Warsaw
Barry A. Warsaw added the comment: We should really restructure string.Template documentation to emphasize i18n. That's always been its prime use case, and f-strings don't change that (because f-strings are not really appropriate for translations). Before f-strings, string.Template had

[issue29907] Unicode encoding failure

2017-03-26 Thread STINNER Victor
STINNER Victor added the comment: For Python 2, there is https://pypi.python.org/pypi/win_unicode_console -- ___ Python tracker ___

[issue1697943] msgfmt cannot cope with BOM

2017-03-26 Thread Christoph Zwerschke
Christoph Zwerschke added the comment: > Corresponding GNU gettext issue [1] was closed as "Not a Bug". Though I think the rationale given there pointing to RFC3629 section 6 is wrong, since that section explicitly refers to Internet protocols, but PO files are not an Internet protocol.

Re: why and how to run forever and debug when error in for proc in psutil.process_iter()?

2017-03-26 Thread Ho Yeung Lee
On Sunday, March 26, 2017 at 7:32:12 PM UTC+8, Ho Yeung Lee wrote: > On Sunday, March 26, 2017 at 10:33:51 AM UTC+8, Deborah Swanson wrote: > > Someone here can probably help you, but they'll need your Python > > version, operating system, and full traceback. They get tired of saying > > so. > >

Re: Escaping confusion with Python 3 + MySQL

2017-03-26 Thread Νίκος Βέργος
i have tried that 2 days ago. Problem is that you maintained space before and after '%s' which wont work within like How would you type it without space as in "%%s%" ? Στις Κυρ, 26 Μαρ 2017 στις 5:32 μ.μ., ο/η INADA Naoki < songofaca...@gmail.com> έγραψε: > > I MEAN HOW TO DIFFERENTIATE '%S'

Re: Escaping confusion with Python 3 + MySQL

2017-03-26 Thread Νίκος Βέργος
Τη Κυριακή, 26 Μαρτίου 2017 - 5:49:00 μ.μ. UTC+3, ο χρήστης Ian έγραψε: > The database wrapper won't do substitution into the middle of a string > like that. Either concatenate the literal %'s on in the SQL statement > or add them to the string before you pass it in, i.e. '%' + domain + > '%' or

Re: Escaping confusion with Python 3 + MySQL

2017-03-26 Thread Νίκος Βέργος
Τη Κυριακή, 26 Μαρτίου 2017 - 6:39:01 μ.μ. UTC+3, ο χρήστης Steve D'Aprano έγραψε: > On Mon, 27 Mar 2017 02:11 am, Νίκος Βέργος wrote: > > > I just tried: > > > > domain = '.'.join( host.split('.')[-2:] ) > > domain = '%' + domain + '%' > > > > cur.execute('''UPDATE visitors SET (pagesID,

[issue29908] Inconsistent crashing with an access violation

2017-03-26 Thread Eryk Sun
Eryk Sun added the comment: The offset in ucrtbase.dll where it's crashing may hint at the culprit. The following command should print the full event log for the most recent crash: wevtutil qe application /rd:true /c:1 /format:text /q:"*[System[Provider[@Name='Application

[issue21301] pathlib missing Path.expandvars(env=os.environ)

2017-03-26 Thread Alain Mellan
Alain Mellan added the comment: Yes, you can close it. — alain. On Mar 25, 2017, at 23:51 , Serhiy Storchaka wrote: http://bugs.python.org/issue21301 -- ___ Python tracker

  1   2   >