How to do a search in peewee python?

Question

Python

Hello, I want to fetch data from sqlite3 database by partial text in any case in peewee ORM. How to do it?

Answer 1

Probably - read the documentation

Answer 2

your Wishlist is called not "by partial text in any case", but full-text search https://docs.peewee-orm.com/en/latest/peewee/sqlit...

Answer 3

You need to enable the sqlite extension. I didn't use peewee myself, but here's what I found - SQLite Extensions(peewee)
sqlean - a huge list of extensions for sqlite. You can download both sources and so/dll/dylib. Specifically, you need a plugin called unicode .
Specifically, how to connect it to peewee - did not look. If you use the sqlite3 standard library, then like this:

import sqlite3

connection = sqlite3.connect(":memory:")
connection.enable_load_extension(True)
connection.load_extension("./unicode.dll")