You may have to join across multiple tables. For instance, the 'reviews_review_comments' table has two columns, 'review_id' and 'comment_id', which are foreign keys into the 'reviews_review' table and 'reviews_comments' table respectively. The 'reviews_review' table has a 'review_request_id' column which is a foreign key into the 'reviews_review_request' table (and should also match the IDs you see in the web UI).
-David On Fri, Sep 5, 2014 at 12:26 AM, Rama krishna <[email protected]> wrote: > Hi David, > Thanks for the reply, I am able to connect to data base. > > Have another query as below; > *Kindly provide the command to query following fields; "Review Request > ID", "Comment ID" and "Comment text" through "mysql" query* > > we refered "reviews_comment " and "reviews_review_comments" tables but we > are not able to read above fields since there is no common field between > these 2 tables. > Need your inputs for same. > > > On Thursday, September 4, 2014 8:45:16 AM UTC+5:30, David Trowbridge wrote: > >> The correct database location and credentials are listed in that. You may >> want to change the database password and SECRET_KEY now that you've >> divulged them to the world. >> >> -David >> >> On Sep 3, 2014, at 4:36 AM, Rama krishna <[email protected]> wrote: >> >> Hi David, >> below is my settings_local.py file but still I am not able to connect to >> proper database: >> >> # Site-specific configuration settings for Review Board >> # Definitions of these settings can be found at >> # http://docs.djangoproject.com/en/dev/ref/settings/ >> # Database configuration >> DATABASES = { >> 'default': { >> 'ENGINE': 'django.db.backends.mysql', >> 'NAME': 'bitnami_reviewboard', >> 'USER': 'bitnami', >> 'PASSWORD': 'eadf57801d', >> 'HOST': '/opt/reviewboard-2.0.1-0/mysql/tmp/mysql.sock', >> 'PORT': '', >> }, >> } >> # Unique secret key. Don't share this with anybody. >> SECRET_KEY = '5+bopex32rr%0%!#5^=(s))fb9a89k!s3e(f*(14ms+...@' >> # Cache backend settings. >> CACHES = { >> 'default': { >> 'BACKEND': 'django.core.cache.backends.memcached.MemcachedCache', >> 'LOCATION': 'localhost:11212', >> }, >> } >> # Extra site information. >> SITE_ID = 1 >> SITE_ROOT = '/reviewboard/' >> FORCE_SCRIPT_NAME = '' >> DEBUG = False >> ALLOWED_HOSTS = ['*'] >> >> >> On Wednesday, September 3, 2014 12:25:52 PM UTC+5:30, David Trowbridge >> wrote: >> >>> Look at your settings_local.py file to see how your database is >>> configured. >>> >>> -David >>> >>> >>> On Tue, Sep 2, 2014 at 10:26 PM, Rama krishna <[email protected]> wrote: >>> >>>> Hi David, >>>> How to check correct data base server? >>>> >>>> >>>> On Monday, September 1, 2014 5:18:11 PM UTC+5:30, Rama krishna wrote: >>>> >>>>> Hi All, >>>>> I have successfully installed review board and I am using it now. Is >>>>> there any plugin for extracting review comments from Review Board tool to >>>>> xl file? >>>>> >>>>> *Setup environment Details:* >>>>> >>>>> *BitNami Review Board* >>>>> <https://www.google.co.in/url?sa=t&rct=j&q=&esrc=s&source=web&cd=6&cad=rja&uact=8&ved=0CDQQFjAF&url=http%3A%2F%2Fwiki.bitnami.com%2FApplications%2FBitNami_Review_Board&ei=SUqVU9mGN4ONuASe6oDQDQ&usg=AFQjCNG5tGnCDuE3iRN9pZ2Ug-dOszdy5w&sig2=4-xRP4zlD4F6Nd4AC0-5Sg&bvm=bv.68445247,d.c2E> >>>>> Installed >>>>> location: /opt/reviewboard-2.0.1-0 >>>>> Mysql port : 3307 http port: 8081 Memcached Port: 11212 >>>>> >>>> -- >>>> Get the Review Board Power Pack at http://www.reviewboard.org/ >>>> powerpack/ >>>> --- >>>> Sign up for Review Board hosting at RBCommons: https://rbcommons.com/ >>>> --- >>>> Happy user? Let us know at http://www.reviewboard.org/users/ >>>> --- >>>> You received this message because you are subscribed to the Google >>>> Groups "reviewboard" group. >>>> To unsubscribe from this group and stop receiving emails from it, send >>>> an email to [email protected]. >>>> For more options, visit https://groups.google.com/d/optout. >>>> >>> >>> -- >> Get the Review Board Power Pack at http://www.reviewboard.org/powerpack/ >> --- >> Sign up for Review Board hosting at RBCommons: https://rbcommons.com/ >> --- >> Happy user? Let us know at http://www.reviewboard.org/users/ >> --- >> You received this message because you are subscribed to the Google Groups >> "reviewboard" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]. >> For more options, visit https://groups.google.com/d/optout. >> >> -- > Get the Review Board Power Pack at http://www.reviewboard.org/powerpack/ > --- > Sign up for Review Board hosting at RBCommons: https://rbcommons.com/ > --- > Happy user? Let us know at http://www.reviewboard.org/users/ > --- > You received this message because you are subscribed to the Google Groups > "reviewboard" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- Get the Review Board Power Pack at http://www.reviewboard.org/powerpack/ --- Sign up for Review Board hosting at RBCommons: https://rbcommons.com/ --- Happy user? Let us know at http://www.reviewboard.org/users/ --- You received this message because you are subscribed to the Google Groups "reviewboard" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
