def run(args, dbparams): try: amount = float(args["amount"]) except ValueError: amount = 0.0 from au_user import getUserId, haveProductRight import MySQLdb db = MySQLdb.connect(host=dbparams["host"], db=dbparams["db"], user=dbparams["user"], passwd=dbparams["passwd"]) db.autocommit(False) c = db.cursor() user = getUserId(c, args["user"], args["password"]) if user == -1: data = {"pass": "******"} c.close() return data if haveProductRight(c, user, int(args["id"])): c.execute("SELECT id FROM unitname WHERE name=%s", (args["unit"],)) res = c.fetchone() unid = res[0] c.execute("SELECT id FROM unit WHERE unid=%s AND prid=%s", (unid, int(args["prid"]))) res = c.fetchone() uid = res[0] c.execute("SELECT id FROM unitname WHERE name=%s", (args["oldunit"],)) res = c.fetchone() unid = res[0] c.execute("SELECT id FROM unit WHERE unid=%s AND prid=%s", (unid, int(args["prid"]))) res = c.fetchone() old_uid = res[0] c.execute( "UPDATE complex SET uid=%s, amount=%s WHERE prid=%s AND uid=%s", (uid, amount, int(args["id"]), old_uid) ) data = {"pass": "******"} from au_calcBAR import calcBAR, updateComplex elem = calcBAR(c, int(args["id"])) updateComplex(c, int(args["id"])) db.commit() data["balt"] = elem[0] data["angl"] = elem[1] data["rieb"] = elem[2] data["total"] = elem[3] else: data = {"pass": "******"} c.close() return data
def run(args, dbparams): from au_user import getUserId, haveProductRight import MySQLdb db=MySQLdb.connect(host=dbparams["host"], db=dbparams["db"], user=dbparams["user"], passwd=dbparams["passwd"]) db.autocommit(False) c=db.cursor() user = getUserId(c, args['user'], args['password']) data = {} if user == -1: data['pass'] = '******' c.close() return data if haveProductRight(c, user, int(args['id'])) and noCircularDep(c, int(args['id']), int(args['prid'])): c.execute("SELECT count(*) FROM unit u, complex c " "WHERE c.prid = %s AND c.uid = u.id AND u.prid = %s", (int(args['id']), int(args['prid']))) count = c.fetchone()[0]; if count == 0: data['pass'] = '******' data['list'] = [] c.execute("SELECT un.name, u.id FROM unit u, unitname un WHERE u.prid = %s AND u.unid = un.id", (int(args['prid']),)) units = c.fetchall() for u in units: data['list'].append({'name': u[0]}) c.execute("INSERT INTO complex(prid, uid, amount) VALUES (%s, %s, %s)", (int(args['id']), units[0][1], '0.0')) from au_calcBAR import calcBAR, updateComplex elem = calcBAR(c, int(args['id'])) updateComplex(c, int(args['id'])) db.commit() data['balt'] = elem[0] data['angl'] = elem[1] data['rieb'] = elem[2] data['total'] = elem[3] else: data['pass'] = '******' else: data['pass'] = '******' c.close() return data
def run(args, dbparams): from au_user import getUserId, haveProductRight import MySQLdb db=MySQLdb.connect(host=dbparams["host"], db=dbparams["db"], user=dbparams["user"], passwd=dbparams["passwd"]) db.autocommit(False) c=db.cursor() user = getUserId(c, args['user'], args['password']) if user == -1: data = {'pass': '******'} c.close() return data if haveProductRight(c, user, int(args['id'])): c.execute("SELECT id FROM unitname WHERE name=%s", (args['unit'],)) res = c.fetchone() unid = res[0] c.execute("SELECT id FROM unit WHERE unid=%s AND prid=%s", (unid, int(args['prid']))) res = c.fetchone() uid = res[0] c.execute("DELETE FROM complex WHERE prid=%s AND uid=%s", (int(args['id']), uid)) data = {'pass': '******'} from au_calcBAR import calcBAR, updateComplex elem = calcBAR(c, int(args['id'])) updateComplex(c, int(args['id'])) db.commit() data['balt'] = elem[0] data['angl'] = elem[1] data['rieb'] = elem[2] data['total'] = elem[3] else: data = {'pass': '******'} c.close() return data
def run(args, dbparams): try: balt = float(args['balt']) except ValueError: balt = 0.0 try: rieb = float(args['rieb']) except ValueError: rieb = 0.0 try: angl = float(args['angl']) except ValueError: angl = 0.0 import MySQLdb from au_user import getUserId, haveProductRight, isProductOwner db=MySQLdb.connect(host=dbparams["host"], db=dbparams["db"], user=dbparams["user"], passwd=dbparams["passwd"]) db.autocommit(False) c=db.cursor() user = getUserId(c, args['user'], args['password']) if user == -1: data = {'pass': '******'} c.close() return data if haveProductRight(c, user, int(args['id'])): complex = 0 if args['complex'] == 'true': complex = 1 secret = 0 if args['secret'] == 'true': secret = 1 c.execute("UPDATE product SET name=%s, balt=%s, rieb=%s, angl=%s, complex=%s, descr=%s, " "secret=%s, linkdescr=%s, link=%s " "WHERE id=%s", (args['name'], balt, rieb, angl, complex, args['descr'], secret, args['linkdescr'], args['link'], int(args['id']))) from au_calcBAR import updateComplex updateComplex(c, int(args['id'])) else: data = {'pass': '******'} c.close() return data if isProductOwner(c, user, int(args['id'])): mod_servant = 0 if args['mod_servant'] == 'true': mod_servant = 1 mod_others = 0 if args['mod_others'] == 'true': mod_others = 1 c.execute("UPDATE product SET mod_servant=%s, mod_others=%s WHERE id=%s", (mod_servant, mod_others, int(args['id']))) db.commit() data = {'pass': '******'} c.close() return data