Django 1.11 - Use search with unaccent extensionWhat is a “slug” in Django?How do I do a not equal in Django queryset filtering?Does Django scale?What's the difference between django OneToOneField and ForeignKey?Need a minimal Django file upload exampledifferentiate null=True, blank=True in djangoHow to update User object without creating new one?How to create a user with just First name, Last name and emai. And not with the usernameDjango Invitation app link to other modelsdjango full text search: how to do with accent text
Why does there seem to be an extreme lack of public trashcans in Taiwan?
Changing the PK column of a data extension without completely recreating it
Can an open source licence be revoked if it violates employer's IP?
What does BREAD stand for while drafting?
What publication claimed that Michael Jackson died in a nuclear holocaust?
What did the 8086 (and 8088) do upon encountering an illegal instruction?
How can I find out about the game world without meta-influencing it?
I am caught when I was about to steal some candies
How do I properly use a function under a class?
Can I attach a DC blower to intake manifold of my 150CC Yamaha FZS FI engine?
Someone who is granted access to information but not expected to read it
What's the relation between у.е. to USD?
Is it good practice to create tables dynamically?
Why is it bad to use your whole foot in rock climbing
Which are the methodologies for interpreting Vedas?
Print "N NE E SE S SW W NW"
David slept with Bathsheba because she was pure?? What does that mean?
How (un)safe is it to ride barefoot?
How to import .txt file with missing data?
Can I use 220 V outlets on a 15 ampere breaker and wire it up as 110 V?
Nth term of Van Eck Sequence
Can you open the door or die? v2
The best in flight meal option for those suffering from reflux
Is it advisable to add a location heads-up when a scene changes in a novel?
Django 1.11 - Use search with unaccent extension
What is a “slug” in Django?How do I do a not equal in Django queryset filtering?Does Django scale?What's the difference between django OneToOneField and ForeignKey?Need a minimal Django file upload exampledifferentiate null=True, blank=True in djangoHow to update User object without creating new one?How to create a user with just First name, Last name and emai. And not with the usernameDjango Invitation app link to other modelsdjango full text search: how to do with accent text
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;
Problem
We need to use Django search with the unaccent extension. So far I installed the extension with a migration and added 'django.contrib.postgres' to installed apps. After I wrote some code to query the databe. I don't know why but I keep getting this error and I can't find any information about what it means.
Error
text search configuration "unaccent" does not exist at character 701
Migration
from django.db import migrations
class Migration(migrations.Migration):
dependencies = [
('team', '0006_team_team_image'),
]
operations = [
UnaccentExtension()
]
Code
from django.contrib.postgres.search import SearchVector, SearchQuery
sv = SearchVector('first_name', 'last_name', 'email')
parsed_body = json.loads(request.body.decode('utf-8'))
query = parsed_body['query']
users = User.objects.annotate(search = sv).filter(search = SearchQuery(query, config = 'unaccent'))
response =
'users': ['full_name': u.get_full_name(), 'email': u.email, 'pk': u.pk for u in users]
django django-models
add a comment |
Problem
We need to use Django search with the unaccent extension. So far I installed the extension with a migration and added 'django.contrib.postgres' to installed apps. After I wrote some code to query the databe. I don't know why but I keep getting this error and I can't find any information about what it means.
Error
text search configuration "unaccent" does not exist at character 701
Migration
from django.db import migrations
class Migration(migrations.Migration):
dependencies = [
('team', '0006_team_team_image'),
]
operations = [
UnaccentExtension()
]
Code
from django.contrib.postgres.search import SearchVector, SearchQuery
sv = SearchVector('first_name', 'last_name', 'email')
parsed_body = json.loads(request.body.decode('utf-8'))
query = parsed_body['query']
users = User.objects.annotate(search = sv).filter(search = SearchQuery(query, config = 'unaccent'))
response =
'users': ['full_name': u.get_full_name(), 'email': u.email, 'pk': u.pk for u in users]
django django-models
add a comment |
Problem
We need to use Django search with the unaccent extension. So far I installed the extension with a migration and added 'django.contrib.postgres' to installed apps. After I wrote some code to query the databe. I don't know why but I keep getting this error and I can't find any information about what it means.
Error
text search configuration "unaccent" does not exist at character 701
Migration
from django.db import migrations
class Migration(migrations.Migration):
dependencies = [
('team', '0006_team_team_image'),
]
operations = [
UnaccentExtension()
]
Code
from django.contrib.postgres.search import SearchVector, SearchQuery
sv = SearchVector('first_name', 'last_name', 'email')
parsed_body = json.loads(request.body.decode('utf-8'))
query = parsed_body['query']
users = User.objects.annotate(search = sv).filter(search = SearchQuery(query, config = 'unaccent'))
response =
'users': ['full_name': u.get_full_name(), 'email': u.email, 'pk': u.pk for u in users]
django django-models
Problem
We need to use Django search with the unaccent extension. So far I installed the extension with a migration and added 'django.contrib.postgres' to installed apps. After I wrote some code to query the databe. I don't know why but I keep getting this error and I can't find any information about what it means.
Error
text search configuration "unaccent" does not exist at character 701
Migration
from django.db import migrations
class Migration(migrations.Migration):
dependencies = [
('team', '0006_team_team_image'),
]
operations = [
UnaccentExtension()
]
Code
from django.contrib.postgres.search import SearchVector, SearchQuery
sv = SearchVector('first_name', 'last_name', 'email')
parsed_body = json.loads(request.body.decode('utf-8'))
query = parsed_body['query']
users = User.objects.annotate(search = sv).filter(search = SearchQuery(query, config = 'unaccent'))
response =
'users': ['full_name': u.get_full_name(), 'email': u.email, 'pk': u.pk for u in users]
django django-models
django django-models
asked Mar 25 at 0:19
Tiago MartinsTiago Martins
286
286
add a comment |
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
);
);
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%2f55329861%2fdjango-1-11-use-search-with-unaccent-extension%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
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.
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%2f55329861%2fdjango-1-11-use-search-with-unaccent-extension%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