Sorry for the late response I often planned to write a reply but then forgot in my hurry. :-D
I use the database for queries which combine data from Reviewboard and from my other applications I use. I mentioned Polarion already, I use the Review Board tool to review work items which are stored in my Polarion. In the Summary of a review, the work item ID is visible and therefore I can apply a SQL Join on the the review_reviewsrequest table with the work items table and see at a glance, for which work items I have reviews and for which I have not. You may wonder how it can work to make combined queries with an MySQL source (Reviewboard) and a PostgreSQL source (Polarion), for this I use the Microsoft SQL Server Management Studio. There I can indclude the database of the applications I use as Linked Servers and mix SQL Server queries with MySQL and PostgreSQL queries with the OPNEQUERY <https://docs.microsoft.com/en-us/sql/t-sql/functions/openquery-transact-sql> function. You see, in this case the API is not an option. ;-) Best regards Am Dienstag, 16. Januar 2018 00:07:45 UTC+1 schrieb Christian Hammond: > > Hi Christian, > > There's not, I'm afraid. It's not something we've ever needed, and > directly working with the database is not a common thing (and not something > we generally recommend). I'm curious what you're looking to do with the > database? > > For most situations, our recommendation is to either work with the REST > API or the Review Board database models (which are in Python) to perform > the queries you need. We don't guarantee that the database schema will > remain the same each release (we try to keep the Python models compatible, > but the schema is considered an implementation detail) or that it's in a > form that's easy to get to (diff data, for instance, is compressed and > de-duplicated). > > Christian > > On Mon, Jan 15, 2018 at 10:48 AM, Christian Kolb <christi...@reflex.at > <javascript:>> wrote: > >> Hello! >> >> I finally managed to query from the MySQL database of my reviewboard >> installation (yeah! :-D ). >> However for an easier orientation through this table jungle, is there any >> database schema or >> a conceptual ddatabase design available online for the MySQL database of >> a Review Boar installation? >> >> To give you an example that illustrates what I mean, here is the full >> database schema of the Polarion ALM software: >> https://almdemo.polarion.com/polarion/sdk/doc/database/FullDBSchema.pdf >> >> Thanks in advance! >> >> Best regards, Christian >> >> -- >> Supercharge your Review Board with Power Pack: >> https://www.reviewboard.org/powerpack/ >> Want us to host Review Board for you? Check out RBCommons: >> https://rbcommons.com/ >> Happy user? Let us know! https://www.reviewboard.org/users/ >> --- >> You received this message because you are subscribed to the Google Groups >> "Review Board Community" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to reviewboard...@googlegroups.com <javascript:>. >> For more options, visit https://groups.google.com/d/optout. >> > > > > -- > Christian Hammond > President/CEO of Beanbag <https://www.beanbaginc.com/> > Makers of Review Board <https://www.reviewboard.org/> > -- Supercharge your Review Board with Power Pack: https://www.reviewboard.org/powerpack/ Want us to host Review Board for you? Check out RBCommons: https://rbcommons.com/ Happy user? Let us know! https://www.reviewboard.org/users/ --- You received this message because you are subscribed to the Google Groups "Review Board Community" group. To unsubscribe from this group and stop receiving emails from it, send an email to reviewboard+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
