def get(self):
query = ''' select * from product '''
cursorobj = _execute(query)
self.render("index.html", products=cursorobj.fetchall())
from random import choice
from models.db import _execute
context = zmq.Context()
socket = context.socket(zmq.PUB)
socket.bind("tcp://127.0.0.1:5000")
context1 = zmq.Context()
consumer_receiver = context.socket(zmq.PULL)
consumer_receiver.connect("tcp://127.0.0.1:5557")
while True:
parsed = consumer_receiver.recv_json()["product"]
query = ''' INSERT INTO product (name, description, price) VALUES('%s','%s',%s)''' % (parsed["productname"], parsed["productdescription"], parsed["productprice"])
cursorobj = _execute(query)
productId = cursorobj.lastrowid
query = ''' SELECT * from product where id=%s''' % (productId)
cursorobj = _execute(query)
row = cursorobj.fetchone()
product = {}
product["id"] = row[0]
product["name"] = row[1]
product["description"] = row[2]
product["price"] = row[3]
print "-> %r",product
socket.send_json( product )
time.sleep(.1)
context = zmq.Context()
socket = context.socket(zmq.PUB)
socket.bind("tcp://127.0.0.1:5000")
context1 = zmq.Context()
consumer_receiver = context.socket(zmq.PULL)
consumer_receiver.connect("tcp://127.0.0.1:5557")
while True:
parsed = consumer_receiver.recv_json()["product"]
query = ''' INSERT INTO product (name, description, price) VALUES('%s','%s',%s)''' % (
parsed["productname"], parsed["productdescription"],
parsed["productprice"])
cursorobj = _execute(query)
productId = cursorobj.lastrowid
query = ''' SELECT * from product where id=%s''' % (productId)
cursorobj = _execute(query)
row = cursorobj.fetchone()
product = {}
product["id"] = row[0]
product["name"] = row[1]
product["description"] = row[2]
product["price"] = row[3]
print "-> %r", product
socket.send_json(product)
time.sleep(.1)
def get(self):
query = ''' select * from product '''
cursorobj = _execute(query)
self.render("index.html", products=cursorobj.fetchall())
