In [4]:

    

import sqlite3
conn = sqlite3.connect('Test.db')


    

In [5]:

    

c = conn.cursor()

# Create table
c.execute('''CREATE TABLE stocks
             (date text, trans text, symbol text, qty real, price real)''')

# Insert a row of data
c.execute("INSERT INTO stocks VALUES ('2006-01-05','BUY','RHAT',100,35.14)")

# Save (commit) the changes
conn.commit()

# We can also close the connection if we are done with it.
# Just be sure any changes have been committed or they will be lost.
conn.close()


    

In [6]:

    

import sqlite3
conn = sqlite3.connect('example.db')
c = conn.cursor()


    

In [7]:

    

# Never do this -- insecure!
symbol = 'RHAT'
c.execute("SELECT * FROM stocks WHERE symbol = '%s'" % symbol)

# Do this instead
t = ('RHAT',)
c.execute('SELECT * FROM stocks WHERE symbol=?', t)
print c.fetchone()

# Larger example that inserts many records at a time
purchases = [('2006-03-28', 'BUY', 'IBM', 1000, 45.00),
             ('2006-04-05', 'BUY', 'MSFT', 1000, 72.00),
             ('2006-04-06', 'SELL', 'IBM', 500, 53.00),
            ]
c.executemany('INSERT INTO stocks VALUES (?,?,?,?,?)', purchases)


    

    




(u'2006-01-05', u'BUY', u'RHAT', 100.0, 35.14)






    
Out[7]:





<sqlite3.Cursor at 0x4453420>

In [ ]:

    




    

In [8]:

    

>>> for row in c.execute('SELECT * FROM stocks ORDER BY price'):
        print row

(u'2006-01-05', u'BUY', u'RHAT', 100, 35.14)
(u'2006-03-28', u'BUY', u'IBM', 1000, 45.0)
(u'2006-04-06', u'SELL', u'IBM', 500, 53.0)
(u'2006-04-05', u'BUY', u'MSFT', 1000, 72.0)


    

    




(u'2006-01-05', u'BUY', u'RHAT', 100.0, 35.14)
(u'2006-03-28', u'BUY', u'IBM', 1000.0, 45.0)
(u'2006-04-06', u'SELL', u'IBM', 500.0, 53.0)
(u'2006-04-05', u'BUY', u'MSFT', 1000.0, 72.0)






    
Out[8]:





(u'2006-04-05', u'BUY', u'MSFT', 1000, 72.0)

In [12]:

    

print row


    

    




(u'2006-04-05', u'BUY', u'MSFT', 1000.0, 72.0)

In [17]:

    

x = "Naii"
file = open("newfile.txt", "w")
file.write("hello world in the new file")
file.write("and another line")
file.write(x)
file.close()


    

In [18]:

    

file = open('newfile.txt', 'r')

print file.read()


    

    




hello world in the new fileand another lineNaii

In [ ]: