Breaking News: Grepper is joining You.com. Read the official announcement!

python model to translate big data using google translator API

sumer5020 answered on June 28, 2022 Popularity 1/10 Helpfulness 8/10

answer python model to translate big data using google translator API

python model to translate big data using google translator API

Comment

from mysql.connector import connect, Error #NO 1: import mysql connector
from deep_translator import GoogleTranslator #NO 2: import GoogleTranslator API

#darabase connection
msg_en = None; query = None; stp= True; counter=0;
try:
    with connect(host="localhost",user="root",port="3306",password="", #NO 3: create connection to mysql
    ) as connection:
        with connection.cursor() as cursor: #NO 4: create cursor to get and set data
            while stp:
                #cursor = connection.cursor()
                query="select * from gathering_db.msg_translate where isnull(msg_translate.msg_en) limit 1000;" #NO 5: quiry
                cursor.execute(query) #NO 6: exicute the quiry
                result = cursor.fetchall() #NO 7: get the data
                stp = bool(result)
                if stp == True: #NO 8: chick is empty
                    for row in result:
                        msg_en = row[1];
                        msg_en = msg_en.replace('"', '').replace('\'', '').replace('`', '')
                        try:
                            msg_en = GoogleTranslator(source='auto', target='en').translate(msg_en) #NO 9: translate data
                        except:
                            #fill in translate
                            msg_en = "-"
                        # if success try
                        query = """ UPDATE gathering_db.msg_translate SET msg_en = "%s" WHERE id = %s; """ % (
                            msg_en,
                            row[0],
                            )
                        cursor.execute(query)
                        connection.commit() #NO 9: commit DB changes
                counter+=1
                print(counter)
except Error as e:
    print(e)

Popularity 1/10 Helpfulness 8/10 Language python

Source: Grepper

Tags: api python translate using

Link to this answer
Share Copy Link

Contributed on Jun 28 2022

sumer5020

0 Answers Avg Quality 2/10

python model to translate big data using google translator API

Contents

More Related Answers

python model to translate big data using google translator API

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.