Hi David, Thanks for the reply, I am new to SQL query . Can you please provide sql for below request.
On Saturday, September 6, 2014 5:24:20 AM UTC+5:30, David Trowbridge wrote: > 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] > <javascript:>> 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] <javascript:>. >> 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.
