[issue40617] sqlite3: expose sqlite3_create_window_function

Change by Erlend E. Aasland : -- resolution: -> duplicate stage: -> resolved status: open -> closed superseder: -> Add create_window_function() to sqlite3.Connection ___ Python tracker

[issue40617] sqlite3: expose sqlite3_create_window_function

Erlend Egeberg Aasland added the comment: Duplicate of bpo-34916 -- ___ Python tracker ___ ___ Python-bugs-list mailing list Unsubs

[issue40617] sqlite3: expose sqlite3_create_window_function

Erlend Egeberg Aasland added the comment: Another possibility (instead of adding `sqlite3.create_window_function`) is to add a "windowed" parameter to `sqlite3.create_aggregate()`: `sqlite3.create_aggregate(name, narg, aggregate, windowed=True` Maybe that's a little bit cleaner regarding the

[issue40617] sqlite3: expose sqlite3_create_window_function

Erlend Egeberg Aasland added the comment: Please see attached patch, @iljau. -- keywords: +patch Added file: https://bugs.python.org/file49190/0001-Add-support-for-sqlite3-aggregate-window-functions.patch ___ Python tracker

[issue40617] sqlite3: expose sqlite3_create_window_function

Change by Erlend Egeberg Aasland : -- nosy: +berker.peksag ___ Python tracker ___ ___ Python-bugs-list mailing list Unsubscribe: ht

[issue40617] sqlite3: expose sqlite3_create_window_function

Erlend Egeberg Aasland added the comment: On a second thought and with regards to error reporting, it _would_ make sense to expose this as a function instead of embedding it into sqlite3.create_aggregate. -- ___ Python tracker

[issue40617] sqlite3: expose sqlite3_create_window_function

Erlend Egeberg Aasland added the comment: This is a good idea, but I think the Python interface should stay the same. >From the user perspective, you'd only need to implement the 'value' and >'inverse' callbacks to transform your aggregate class into an aggregate window >class. >From the CP

[issue40617] sqlite3: expose sqlite3_create_window_function

New submission from Ilja Umov : Expose sqlite3_create_window_function as sqlite3.create_window_function. There already exists sqlite3.create_aggregate, which uses sqlite3_create_function_v2 and is conceptually similar. Window functions are available in sqlite starting from 2018-09-15 (3.25.0)