AttributeError: 'function' object has no attribute 'execute'
0
It's a django project,the views.py is
from django.shortcuts import render
from django.db import connection
def get_cursor():
return connection.cursor
def index(request):
cursor = get_cursor()
cursor.execute("select id,name,author from book")
books = cursor.fetchall()
return render(request, 'index.html')
Few minutes, it's work, but now error, and it can not get data from mysql,I don't know if is my system fault.
python mysql django
asked Nov 19 '18 at 14:38
P.ChengP.Cheng
12
add a comment |
0
It's a django project,the views.py is
from django.shortcuts import render
from django.db import connection
def get_cursor():
return connection.cursor
def index(request):
cursor = get_cursor()
cursor.execute("select id,name,author from book")
books = cursor.fetchall()
return render(request, 'index.html')
Few minutes, it's work, but now error, and it can not get data from mysql,I don't know if is my system fault.
python mysql django
asked Nov 19 '18 at 14:38
P.ChengP.Cheng
12
3
Apart from the error inget_cursor()- you didn't call theconnection.cursormethod - why are you doing this at all? Why aren't you using the Django model layer, especially for such a simple query?
– Daniel Roseman
Nov 19 '18 at 14:40
What error are you getting?
– ritlew
Nov 19 '18 at 14:41
@DanielRoseman I'm learning for django, this step didn't use Model. In the function of index, I used 'cursor = get_cursor()', was it not call the 'connection.cursor'?
– P.Cheng
Nov 19 '18 at 14:53
2
But that is not the way to learn Django. The way to do that is to follow the tutorial, which starts with defining models. And no, you need to call it inside the function:return connection.cursor().
– Daniel Roseman
Nov 19 '18 at 14:56
@Daniel I change it ,but there is a new error:'django.db.utils.OperationalError: (2026, 'SSL connection error: SSL_CTX_set_tmp_dh failed')'
– P.Cheng
Nov 20 '18 at 1:55
add a comment |
0
0
0
It's a django project,the views.py is
from django.shortcuts import render
from django.db import connection
def get_cursor():
return connection.cursor
def index(request):
cursor = get_cursor()
cursor.execute("select id,name,author from book")
books = cursor.fetchall()
return render(request, 'index.html')
Few minutes, it's work, but now error, and it can not get data from mysql,I don't know if is my system fault.
python mysql django
asked Nov 19 '18 at 14:38
P.ChengP.Cheng
12
It's a django project,the views.py is
from django.shortcuts import render
from django.db import connection
def get_cursor():
return connection.cursor
def index(request):
cursor = get_cursor()
cursor.execute("select id,name,author from book")
books = cursor.fetchall()
return render(request, 'index.html')
Few minutes, it's work, but now error, and it can not get data from mysql,I don't know if is my system fault.
python mysql django
python mysql django
asked Nov 19 '18 at 14:38
P.ChengP.Cheng
12
asked Nov 19 '18 at 14:38
P.ChengP.Cheng
12
asked Nov 19 '18 at 14:38
P.ChengP.Cheng
12
asked Nov 19 '18 at 14:38
P.ChengP.Cheng
12
asked Nov 19 '18 at 14:38
P.ChengP.Cheng
12
12
3
Apart from the error inget_cursor()- you didn't call theconnection.cursormethod - why are you doing this at all? Why aren't you using the Django model layer, especially for such a simple query?
– Daniel Roseman
Nov 19 '18 at 14:40
What error are you getting?
– ritlew
Nov 19 '18 at 14:41
@DanielRoseman I'm learning for django, this step didn't use Model. In the function of index, I used 'cursor = get_cursor()', was it not call the 'connection.cursor'?
– P.Cheng
Nov 19 '18 at 14:53
2
But that is not the way to learn Django. The way to do that is to follow the tutorial, which starts with defining models. And no, you need to call it inside the function:return connection.cursor().
– Daniel Roseman
Nov 19 '18 at 14:56
@Daniel I change it ,but there is a new error:'django.db.utils.OperationalError: (2026, 'SSL connection error: SSL_CTX_set_tmp_dh failed')'
– P.Cheng
Nov 20 '18 at 1:55
add a comment |
3
Apart from the error inget_cursor()- you didn't call theconnection.cursormethod - why are you doing this at all? Why aren't you using the Django model layer, especially for such a simple query?
– Daniel Roseman
Nov 19 '18 at 14:40
What error are you getting?
– ritlew
Nov 19 '18 at 14:41
@DanielRoseman I'm learning for django, this step didn't use Model. In the function of index, I used 'cursor = get_cursor()', was it not call the 'connection.cursor'?
– P.Cheng
Nov 19 '18 at 14:53
2
But that is not the way to learn Django. The way to do that is to follow the tutorial, which starts with defining models. And no, you need to call it inside the function:return connection.cursor().
– Daniel Roseman
Nov 19 '18 at 14:56
@Daniel I change it ,but there is a new error:'django.db.utils.OperationalError: (2026, 'SSL connection error: SSL_CTX_set_tmp_dh failed')'
– P.Cheng
Nov 20 '18 at 1:55
3
3
Apart from the error in
get_cursor() - you didn't call the connection.cursor method - why are you doing this at all? Why aren't you using the Django model layer, especially for such a simple query?– Daniel Roseman
Nov 19 '18 at 14:40
Apart from the error in
get_cursor() - you didn't call the connection.cursor method - why are you doing this at all? Why aren't you using the Django model layer, especially for such a simple query?– Daniel Roseman
Nov 19 '18 at 14:40
What error are you getting?
– ritlew
Nov 19 '18 at 14:41
What error are you getting?
– ritlew
Nov 19 '18 at 14:41
@DanielRoseman I'm learning for django, this step didn't use Model. In the function of index, I used 'cursor = get_cursor()', was it not call the 'connection.cursor'?
– P.Cheng
Nov 19 '18 at 14:53
@DanielRoseman I'm learning for django, this step didn't use Model. In the function of index, I used 'cursor = get_cursor()', was it not call the 'connection.cursor'?
– P.Cheng
Nov 19 '18 at 14:53
2
2
But that is not the way to learn Django. The way to do that is to follow the tutorial, which starts with defining models. And no, you need to call it inside the function:
return connection.cursor().– Daniel Roseman
Nov 19 '18 at 14:56
But that is not the way to learn Django. The way to do that is to follow the tutorial, which starts with defining models. And no, you need to call it inside the function:
return connection.cursor().– Daniel Roseman
Nov 19 '18 at 14:56
@Daniel I change it ,but there is a new error:'django.db.utils.OperationalError: (2026, 'SSL connection error: SSL_CTX_set_tmp_dh failed')'
– P.Cheng
Nov 20 '18 at 1:55
@Daniel I change it ,but there is a new error:'django.db.utils.OperationalError: (2026, 'SSL connection error: SSL_CTX_set_tmp_dh failed')'
– P.Cheng
Nov 20 '18 at 1:55
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53376926%2fattributeerror-function-object-has-no-attribute-execute%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53376926%2fattributeerror-function-object-has-no-attribute-execute%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
3
Apart from the error in
get_cursor()- you didn't call theconnection.cursormethod - why are you doing this at all? Why aren't you using the Django model layer, especially for such a simple query?– Daniel Roseman
Nov 19 '18 at 14:40
What error are you getting?
– ritlew
Nov 19 '18 at 14:41
@DanielRoseman I'm learning for django, this step didn't use Model. In the function of index, I used 'cursor = get_cursor()', was it not call the 'connection.cursor'?
– P.Cheng
Nov 19 '18 at 14:53
2
But that is not the way to learn Django. The way to do that is to follow the tutorial, which starts with defining models. And no, you need to call it inside the function:
return connection.cursor().– Daniel Roseman
Nov 19 '18 at 14:56
@Daniel I change it ,but there is a new error:'django.db.utils.OperationalError: (2026, 'SSL connection error: SSL_CTX_set_tmp_dh failed')'
– P.Cheng
Nov 20 '18 at 1:55