No info on installing reporting stored procedure

[dimonic]

I tried copying the reporting subdirectory into the installed tracsubtickets directory in dist-packages, but the stored procedure cannot be found by the example code.

Where does one need to install the stored procedure so it can be used?

[rjollos]

You'll have to manually create the reports from the /report page:
https://trac.edgewall.org/wiki/TracReports#CreatingCustomReports

[dimonic]

I figured that. I just couldn't get the stored procedure/function to work/installed, and I couldn't figure out how to write it in plain SQL.

…

On Thu, 11 Jun 2020 at 18:52, Ryan J Ollos ***@***.***> wrote: You'll have to manually create the reports from the /report page: https://trac.edgewall.org/wiki/TracReports#CreatingCustomReports — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#31 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AANSGOT6YTOHK5VE33CYBXDRWFNZJANCNFSM4NZVHTTA> .

-- Dominic Amann M 416-270-4587

[rjollos]

It looks like they might be written for PostgreSQL. Are you using SQLite?

[dimonic]

I took the trouble of switching to PostgreSQL to use them, but I don't know where to install the stored functions.

…

On Thu., Jun. 11, 2020, 11:11 p.m. Ryan J Ollos, ***@***.***> wrote: It looks like they might be written for PostgreSQL. Are you using SQLite? — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#31 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AANSGOTOAXALVNV7SYTD5H3RWGMGVANCNFSM4NZVHTTA> .

[rjollos]

Oh, I see. I'm not sure how to load a stored procedure on PostgreSQL. Probably need to consult the official PostgreSQL documentation.

[dimonic]

Yes, and how do I integrate that into trac? Once I figure out the postgresql part, then I need to find out the pg API representation of that, and then the trac template/layout stuff - as in where do I put a part that I want executed once against the database.

[rjollos]

I will try to find time to look into that and get back to you.

[dimonic]

Any help at all would be very much appreciated.

…

On Fri, 26 Jun 2020 at 20:24, Ryan J Ollos ***@***.***> wrote: I will try to find time to look into that and get back to you. — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#31 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AANSGOW3L3INQHMO2PEVQELRYU35DANCNFSM4NZVHTTA> .

-- Dominic Amann M 416-270-4587

[rjollos]

It looks to me like you need to run the scripts using psql: https://superuser.com/a/701823.

Then, you will be able to use the stored procedures in Trac reports.