how save output from python to database?

Question

I wrote a simple script for translation in urbandictionary:

import urllib.request
import bs4

def translate():
    search=''
    while(search!='!'):
        search=input("Enter a word(! for exit): ")
        if search=='!':
            continue
        search2=search.replace(' ','+')
        urb_url='http://www.urbandictionary.com/define.php?term='+str(search2)
        urban=urllib.request.urlopen(urb_url).read().decode('utf-8')
        soup_urb = bs4.BeautifulSoup(urban)
        try:
            q2=soup_urb.find('div', class_="meaning").text
            print("{0}: {1}".format(search,q2))
        except AttributeError as e:
            print("The word not found\n")

now I want to save result for every word that searched to use and don't search again in the future. what is your suggestion? sqlite, save in simple text or other solutions.

itzMEonTV · Accepted Answer · 2015-03-25 15:42:17Z

5

You can use sqlite3 or whatever any database. Try this

import sqlite3

conn = sqlite3.connect('test.db')
try:
    conn.execute('''CREATE TABLE urbandictionary
           (SEARCH_WORD TEXT NOT NULL,
           SEARCH_STRING TEXT NOT NULL)''')
    print "Table created successfully";
except:
    pass

conn.close()

Then in your print statement line, put

conn = sqlite3.connect('test.db')
conn.execute("INSERT INTO urbandictionary (SEARCH_WORD, SEARCH_STRING) \
      VALUES (?,?)", [search, q2])
conn.commit()
conn.close()

To view the results,

conn = sqlite3.connect('test.db')
cur = conn.execute('select * from urbandictionary')
res = [dict(search_word=row[0], search_string=row[1]) for row in cur.fetchall()]
conn.close()

>>>res #gives you output

answered Mar 25, 2015 at 15:42

itzMEonTV

20.4k4 gold badges44 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Sara Santana Over a year ago

thanks for your code. but what if i want to see a word is in database or not? and show that word from database

itzMEonTV Over a year ago

conn.execute("select * from urbandictionary where SEARCH_WORD like '%"+"searchword"+"%'")

Vladimir T. · Accepted Answer · 2015-03-25 15:43:34Z

2

SQLite is a good way to do it if you plan to add functionalities to your application or if the amount of data can grow big: you will be able to add tables to your database and/or process usefull SQL requests.

However it adds complexity to your architecture: use of a database, use of SQL requests.

You could as well use a dictionary with keys being 'search' and values being 'q2' and store it with the pickle module (Python object serialization). That way you can keep it quite simple if your purpose is only to store and get translations back.

answered Mar 25, 2015 at 15:43

Vladimir T.

1994 bronze badges

Collectives™ on Stack Overflow

how save output from python to database?

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related