Пример #1
0
def getprice(request):
    print "this is ajax getprice!!"
    print "this is request:: '%s' " % request
    if request.GET.has_key('flavorid'):
        flavor_id = request.GET['flavorid']
        result = {}
        sql = "select price from instance_types where flavorid = '%s' and deleted = '0'" % flavor_id
        info = Mysql.selectData(sql)
        result['price'] = info[0]['price']
        return HttpResponse(json.dumps(result), content_type = "application/json")
    else:
        print "not get request!"
Пример #2
0
def getprice(request):
    print "this is ajax getprice!!"
    print "this is request:: '%s' " % request
    if request.GET.has_key('flavorid'):
        flavor_id = request.GET['flavorid']
        result = {}
        sql = "select price from instance_types where flavorid = '%s' and deleted = '0'" % flavor_id
        info = Mysql.selectData(sql)
        result['price'] = info[0]['price']
        return HttpResponse(json.dumps(result),
                            content_type="application/json")
    else:
        print "not get request!"
def update_price(id, price):
    sql = "update instance_types set price = '%s' where flavorid = '%s'" % (
        price, id)
    Mysql.updateData(sql)
def update_price(id, price):
	sql = "update instance_types set price = '%s' where flavorid = '%s'" % (price, id)
	Mysql.updateData(sql)
Пример #5
0
def get_one_flavor(id):
	sql = "select * from instance_types where id = '%s'" % id
	flavor = Mysql.selectData(sql)
	return flavor
Пример #6
0
def get_instance_type():
	sql = "select * from instance_types where deleted = 0"
	flavorss = Mysql.selectData(sql)
	return flavorss