search

trac-hacks / trac-subtickets-plugin

A sub-ticket support plugin for trac
4 stars 4 forks source link

No info on installing reporting stored procedure #31

Open dimonic opened 4 years ago

dimonic commented 4 years ago

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 commented 4 years ago

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

dimonic commented 4 years ago

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 notifications@github.com 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 https://github.com/trac-hacks/trac-subtickets-plugin/issues/31#issuecomment-642970091, or unsubscribe https://github.com/notifications/unsubscribe-auth/AANSGOT6YTOHK5VE33CYBXDRWFNZJANCNFSM4NZVHTTA .

--

Dominic Amann

M 416-270-4587

rjollos commented 4 years ago

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

dimonic commented 4 years ago

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, notifications@github.com 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 https://github.com/trac-hacks/trac-subtickets-plugin/issues/31#issuecomment-643040394, or unsubscribe https://github.com/notifications/unsubscribe-auth/AANSGOTOAXALVNV7SYTD5H3RWGMGVANCNFSM4NZVHTTA .

rjollos commented 4 years ago

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

dimonic commented 4 years ago

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 commented 4 years ago

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

dimonic commented 4 years ago

Any help at all would be very much appreciated.

On Fri, 26 Jun 2020 at 20:24, Ryan J Ollos notifications@github.com 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 https://github.com/trac-hacks/trac-subtickets-plugin/issues/31#issuecomment-650461592, or unsubscribe https://github.com/notifications/unsubscribe-auth/AANSGOW3L3INQHMO2PEVQELRYU35DANCNFSM4NZVHTTA .

--

Dominic Amann

M 416-270-4587

rjollos commented 4 years ago

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.