#!/usr/bin/python

# -*- coding: utf-8 -*-

import sys
import string
from MySQLdb import connections

def Connect(db,host):
    db=connections.Connection(db=db, host=host)
    return db.cursor()

def Select(curs): 
    row=curs.execute("SELECT * from device;")
    rw=curs.fetchone()
    for i in range(row):
	print "model: %s\t cost: %s" % (rw[1],rw[2])
	rw=curs.fetchone()

def Insert(curs,list):
    row=curs.execute("INSERT INTO device VALUES(0,'%s','%s')" % (list[0],list[1]))
    	
curs=Connect('test','localhost')
Select(curs)
print "Enter <name price>: ",
list=string.split(sys.stdin.readline())
Insert(curs,list)
Select(curs)