Login

oracle 10g fulltext search & patch nclob field limitations

Author:
ageldama
Posted:
April 5, 2008
Language:
Python
Version:
.96
Tags:
text search oracle database contains db-api backend 10g patch full full-text-search
Score:
0 (after 0 ratings)

save as some module, import then, call 'patch()' in somewhere suchs urls.py...

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
def fulltext_search_sql(self, field_name):
    return ("CONTAINS(%s, %%s) > 0" % field_name)

def field_cast_sql(self, db_type):
    return "%s"


def patch():
    """call me, call me"""
    from django.db.backends.oracle.base import DatabaseOperations
    DatabaseOperations.fulltext_search_sql = fulltext_search_sql
    DatabaseOperations.field_cast_sql = field_cast_sql

More like this

  1. Automatically setup raw_id_fields ForeignKey & OneToOneField by agusmakmun 6 months, 2 weeks ago
  2. Crispy Form by sourabhsinha396 7 months, 1 week ago
  3. ReadOnlySelect by mkoistinen 7 months, 3 weeks ago
  4. Verify events sent to your webhook endpoints by santos22 8 months, 3 weeks ago
  5. Django Language Middleware by agusmakmun 9 months ago

Comments

ikelly (on April 7, 2008):

Note that this breaks the "History" links in the admin app, resulting in an ORA-00932 error when you try to click on them.

#

ageldama (on May 7, 2008):

thanks, I'll fix it.

#

Please login first before commenting.