# -*- coding: utf-8 -*-
from __future__ import print_function
import mysql, mysql.connector, codecs

'''Database Operation'''
def connect():
    conn = mysql.connector.connect(user = 'root', password = '', unix_socket = "/tmp/mysql.sock", database = 'noname' )
    cursor = conn.cursor()
    cursor = conn.cursor(buffered=True)
    cursor.execute("""SELECT distinct jungle FROM junglebook""")
    conn.commit()
    conn.close()
    from nltk.tokenize import word_tokenize
    file = codecs.open("newfile.txt","wb","UTF-8")
    for i in cursor:
        ram = word_tokenize(''.join(i))   #Tokenize sentences into words
        for j in range(len(ram)):
            file.write(ram[j]+'n')       # Writing to text file
if __name__ == '__main__':
    connect()