def alta(self, params):
code = self.validate(params)
if code == 0:
if "iccid" not in params or len(params["iccid"]) != 19:
code = 200
elif "cveplan" not in params or params["cveplan"] == "":
code = 600
elif "cvetpoinst" not in params or params["cvetpoinst"] == "":
code = 600
else:
db = Database(dbhost=Utils.get_secret("pg_host"), dbuser=Utils.get_secret("soapdbuser"),
dbpass=Utils.get_secret("soapdbpass"))
rows = db.find_iccid(params["iccid"])
if len(rows) > 0:
code = 501
else:
id = db.insert_telcel_trans(params)
if int(id) > 0:
rec = db.select_telcel(id)
code = db.insert_telcel_hist(rec)
else:
code = 401
return code
