|
1 | | -<!--- Provide a general summary of the issue in the Title above --> |
2 | | - |
3 | | -<!--- |
4 | | -IMPORTANT NOTE: |
5 | 1 | This project is maintained one busy person having frail wife and infant daughter. |
6 | 2 | My time and energy is very limited resource. I'm not teacher or free tech support. |
7 | 3 | Don't ask a question here. Don't file an issue until you believe it's a not problem of your code. |
8 | 4 | Search friendly volunteer who can teach you or review your code on ML or Q&A site. |
9 | 5 |
|
10 | 6 | See also: https://medium.com/@methane/why-you-must-not-ask-questions-on-github-issues-51d741d83fde |
11 | | ----> |
12 | | - |
13 | | - |
14 | | -## Expected Behavior |
15 | | -<!--- If you're describing a bug, tell us what should happen --> |
16 | | -<!--- If you're suggesting a change/improvement, tell us how it should work --> |
17 | | - |
18 | | -## Current Behavior |
19 | | -<!--- If describing a bug, tell us what happens instead of the expected behavior --> |
20 | | -<!--- If suggesting a change/improvement, explain the difference from current behavior --> |
21 | | - |
22 | | -## Possible Solution |
23 | | -<!--- Not obligatory, but suggest a fix/reason for the bug, --> |
24 | | -<!--- or ideas how to implement the addition or change --> |
25 | | - |
26 | | -## Executable script to reproduce (for bugs) |
27 | | - |
28 | | -<!--- Overwrite following code and schema ---> |
29 | | - |
30 | | -code: |
31 | | -```python |
32 | | -import pymysql.cursors |
33 | | - |
34 | | -# Connect to the database |
35 | | -connection = pymysql.connect(host='localhost', |
36 | | - user='user', |
37 | | - password='passwd', |
38 | | - db='db', |
39 | | - charset='utf8mb4', |
40 | | - cursorclass=pymysql.cursors.DictCursor) |
41 | | - |
42 | | -try: |
43 | | - with connection.cursor() as cursor: |
44 | | - # Create a new record |
45 | | - sql = "INSERT INTO `users` (`email`, `password`) VALUES (%s, %s)" |
46 | | - cursor.execute(sql, ('webmaster@python.org', 'very-secret')) |
47 | | - |
48 | | - # connection is not autocommit by default. So you must commit to save |
49 | | - # your changes. |
50 | | - connection.commit() |
51 | | - |
52 | | - with connection.cursor() as cursor: |
53 | | - # Read a single record |
54 | | - sql = "SELECT `id`, `password` FROM `users` WHERE `email`=%s" |
55 | | - cursor.execute(sql, ('webmaster@python.org',)) |
56 | | - result = cursor.fetchone() |
57 | | - print(result) |
58 | | -finally: |
59 | | - connection.close() |
60 | | -``` |
61 | | - |
62 | | -schema: |
63 | | -```sql |
64 | | -CREATE TABLE `users` ( |
65 | | - `id` int(11) NOT NULL AUTO_INCREMENT, |
66 | | - `email` varchar(255) COLLATE utf8_bin NOT NULL, |
67 | | - `password` varchar(255) COLLATE utf8_bin NOT NULL, |
68 | | - PRIMARY KEY (`id`) |
69 | | -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin |
70 | | -AUTO_INCREMENT=1 ; |
71 | | -``` |
72 | | - |
73 | | -## Tracebacks (for bugs) |
74 | | - |
75 | | -``` |
76 | | -paste here |
77 | | -``` |
78 | 7 |
|
79 | | -## Context |
80 | | -<!--- How has this issue affected you? What are you trying to accomplish? --> |
81 | | -<!--- Providing context helps us come up with a solution that is most useful in the real world --> |
82 | 8 |
|
83 | | -## Your Environment |
84 | | -<!--- Include as many relevant details about the environment you experienced the bug in --> |
| 9 | +If you're sure it's PyMySQL's issue, report complete step to reproduce, from creating database. |
85 | 10 |
|
86 | | -* Operating System and version: |
87 | | -* Python version and build (cygwin, python.org, homebrew, pyenv, Linux distribution's package, PyPy etc...) |
88 | | -* PyMySQL Version used: |
89 | | -* my.cnf if possible. If you don't have it, related system variables like [connection encoding](https://dev.mysql.com/doc/refman/5.6/en/charset-connection.html). |
| 11 | +I don't have time to investigate your issue from incomplete code snipet. |
0 commit comments