# Get user credentials from consule
def get_user_credentials (self):
    self.username = raw_input("Github username: ")
    self.password = getpass.getpass(prompt='Github password: ')
    self.repository_name = raw_input("Repository name: ")
    self.release_name = raw_input('Release name: ')

# Read details of all releases in a repository
def read_requested_release_detials(self, release, tag_name, sheet, is_release_found):
    is_release_found = True
    release_body = release.body
    lines_in_release_body = (release_body.splitlines(0))
    ReadRelease.read_lines_start_with_dash(self, lines_in_release_body, self.sheet, tag_name)

# Read all releases names of a repository
def read_all_releases_names(self, repository, release_name, sheet):
    is_release_found = False
    for release in repository.get_releases():
        tag_name = (release.tag_name).encode('utf-8')
        name = (release.title).encode('utf-8')
        # Filter releases name with give release name
        if name == release_name:
            is_release_found = True
            ReadRelease.read_requested_release_detials(self, release, tag_name, self.sheet, is_release_found)
        if not is_release_found:
            print "'Release Name' is wrong!, Please try again with correct 'release name'"
    else:
        print "Releases inserted to the Google sheet."

# Insert a line to google sheet file (those issues which are not fixed)
def issue_not_fixed(self, sheet, tag_name, line, row):
    sheet.insert_row([tag_name, tag_name, line[7:].encode('utf-8'), 'NO'], row)

# Insert a line to google sheet file and set fix the Is fixed? column
def issue_fixed(self, sheet, tag_name, line, row):
    sheet.insert_row([tag_name, tag_name, line[7:].encode('utf-8'), 'YES'], row)

# Read all lines in ralease body whihc start with '-'
def read_lines_start_with_dash(self, lines_in_release_body, sheet, tag_name):
    # Counter for updating rows in google sheet file
    row = 2
    for line in lines_in_release_body:
        if (line[:1]).encode('utf-8') == '-':
            if line[1:7].encode('utf-8') == ' [FIX]':
                ReadRelease.issue_fixed(self, sheet, tag_name, line, row)
            elif line[1:7].encode('utf-8') == '------':
                break
            else:
                ReadRelease.issue_not_fixed(self, sheet, tag_name, line, row)
        row += 1

# Set google sheet api credentials and open file on google sheet
def set_google_sheet_credentials(self, sheet):
    scope = ['https://spreadsheets.google.com/feeds','https://www.googleapis.com/auth/drive']
    google_credentials = ServiceAccountCredentials.from_json_keyfile_name('test.json', scope)
    file = gspread.authorize(google_credentials)
    self.sheet = file.open('Copy_of_MOD_Change_Worklog_Tracker.xlsx').sheet1
    # Add headers to the sheet
    self.sheet.update_acell('A1', 'Client Version')
    self.sheet.update_acell('B1', 'Version Reference for Internal Purposes')
    self.sheet.update_acell('C1', 'Proposed Change (Expected Functional Behavior)')
    self.sheet.update_acell('D1', 'Bug Fix?')

# URL Builder method for github repository
def prepare_github_repository_url(self):
    return(str('someuseraccount/'+ self.repository_name))

# Authunticate user in github
def github_authunticate(self, username, password, url):
    github_account = Github(self.username, self.password)
    return (github_account.get_repo(url))

read_release_obj.get_user_credentials()

url = read_release_obj.prepare_github_repository_url()

# Check if username and password exist
if read_release_obj.username and read_release_obj.password:
    try:
        github_repo = read_release_obj.github_authunticate(read_release_obj.username, read_release_obj.password, url)

        read_release_obj.set_google_sheet_credentials(read_release_obj.sheet)

        read_release_obj.read_all_releases_names(github_repo, read_release_obj.release_name, read_release_obj.sheet)

    except BadCredentialsException:
        print ('Bad credentials. Try again!')

else:
    print ('Github credentials are required!')