def editName(self, fromName, toName):
data = {}
if fromName == toName:
data["error"] = u"Name entry is the same as existing name"
data["success"] = False
return data
db = DBHandler(app.config["DBFILE"])
c = db.getCursor()
if db.exists("zones", "name", toName):
data["error"] = u"Duplicate name entry in db"
data["success"] = False
return data
if not db.exists("zones", "name", fromName):
data["error"] = u"No old name entry in db"
data["success"] = False
return data
try:
c.execute(
"""
UPDATE zones
SET old_value = name, name = ?,
updated = 1, update_type = 'MODIFIED NAME'
WHERE name LIKE ?
""", [toName, fromName])
db.commit()
data["success"] = True
data["message"] = u"Entry %s updated from %s" % (toName, fromName)
except Exception, e:
errormsg = u"Unsuccessful database update transaction:" + str(e)
log.exception(errormsg, self.__class__.__name__)
data["success"] = False
data["error"] = errormsg
def editName(self, fromName, toName):
data = {}
if fromName == toName:
data["error"] = u"Name entry is the same as existing name"
data["success"] = False
return data
db = DBHandler(app.config["DBFILE"])
c = db.getCursor()
if db.exists("zones", "name", toName):
data["error"] = u"Duplicate name entry in db"
data["success"] = False
return data
if not db.exists("zones", "name", fromName):
data["error"] = u"No old name entry in db"
data["success"] = False
return data
try:
c.execute("""
UPDATE zones
SET old_value = name, name = ?,
updated = 1, update_type = 'MODIFIED NAME'
WHERE name LIKE ?
""",[toName, fromName])
db.commit()
data["success"] = True
data["message"] = u"Entry %s updated from %s"%(toName, fromName)
except Exception, e:
errormsg = u"Unsuccessful database update transaction:" + str(e)
log.exception(errormsg, self.__class__.__name__)
data["success"] = False
data["error"] = errormsg
def add(self, name, host):
data = {}
# Check if name exists
db = DBHandler(app.config["DBFILE"])
c = db.getCursor()
if db.exists("zones", "name", name):
data["error"] = u"Duplicate name entry in db"
data["success"] = False
else:
try:
c.execute("""
INSERT INTO zones(name,host,updated,update_type)
VALUES(?,?,1,'CREATE')
""",[name,host])
db.commit()
data["success"] = True
data["message"] = u"Entry %s inserted"%(name)
except Exception, e:
errormsg = u"Unsuccessful database insert transaction:" + str(e)
log.exception(errormsg, self.__class__.__name__)
data["success"] = False
data["error"] = errormsg
def add(self, name, host):
data = {}
# Check if name exists
db = DBHandler(app.config["DBFILE"])
c = db.getCursor()
if db.exists("zones", "name", name):
data["error"] = u"Duplicate name entry in db"
data["success"] = False
else:
try:
c.execute(
"""
INSERT INTO zones(name,host,updated,update_type)
VALUES(?,?,1,'CREATE')
""", [name, host])
db.commit()
data["success"] = True
data["message"] = u"Entry %s inserted" % (name)
except Exception, e:
errormsg = u"Unsuccessful database insert transaction:" + str(
e)
log.exception(errormsg, self.__class__.__name__)
data["success"] = False
data["error"] = errormsg
