def init_db(db): node = models.TrNode() node.id = 1 node.node_name = 'default' node.node_desc = u'测试区域' db.add(node) params = [ ('system_name', u'管理系统名称', u'ToughRADIUS管理控制台'), ('system_ticket_expire_days', u'上网日志保留天数', '90'), ('customer_system_name', u'自助服务系统名称', u'ToughRADIUS自助服务中心'), ('customer_system_url', u"自助服务系统地址", u"http://forum.toughradius.net"), ('is_debug', u'DEBUG模式', u'0'), ('customer_qrcode', u'微信公众号二维码图片(宽度230px)', u'http://img.toughradius.net/toughforum/jamiesun/1421820686.jpg!230'), ('customer_service_phone', u'客户服务电话', u'000000'), ('customer_service_qq', u'客户服务QQ号码', u'000000'), ('rcard_order_url', u'充值卡订购网站地址', u'http://www.tmall.com'), ('expire_notify_days', '到期提醒提前天数', u'7'), ('expire_notify_tpl', '到期提醒邮件模板', u'账号到期通知\n尊敬的会员您好:\n您的账号#account#即将在#expire#到期,请及时续费!'), ('expire_notify_url', u'到期通知url', u'http://your_notify_url?account={account}&expire={expire}&email={email}&mobile={mobile}' ), ('expire_addrpool', u'到期提醒下发地址池', u'expire'), ('expire_session_timeout', u'到期用户下发最大会话时长(秒)', u'120'), ('smtp_server', u'SMTP服务器地址', u'smtp.mailgun.org'), ('smtp_user', u'SMTP用户名', u'*****@*****.**'), ('smtp_pwd', u'SMTP密码', u'service2015'), ('smtp_sender', u'SMTP发送人名称', u'运营中心'), ('acct_interim_intelval', u'Radius记账间隔(秒)', u'120'), ('max_session_timeout', u'Radius最大会话时长(秒)', u'86400'), ('reject_delay', u'拒绝延迟时间(秒)(0-9)', '0') ] for p in params: param = models.TrParam() param.param_name = p[0] param.param_desc = p[1] param.param_value = p[2] db.add(param) opr = models.TrOperator() opr.id = 1 opr.operator_name = u'admin' opr.operator_type = 0 opr.operator_pass = md5('root').hexdigest() opr.operator_desc = 'admin' opr.operator_status = 0 db.add(opr) db.commit() db.close()
def post(self): form = node_forms.node_add_form() if not form.validates(source=self.get_params()): return self.render("base_form.html", form=form) node = models.TrNode() node.node_name = form.d.node_name node.node_desc = form.d.node_desc self.db.add(node) self.add_oplog(u'新增区域信息:%s' % form.d.node_name) self.db.commit() self.redirect("/admin/node",permanent=False)
def init_db(db): node = models.TrNode() node.id = 1 node.node_name = 'default' node.node_desc = u'默认区域' db.add(node) params = [ ('system_name', u'管理系统名称', u'ToughRADIUS管理控制台'), ('system_ticket_expire_days', u'上网日志保留天数', '90'), ('is_debug', u'DEBUG模式', u'0'), ('expire_notify_days', '到期提醒提前天数', u'7'), ('expire_notify_interval', '到期提醒提前间隔(分钟)', u'1440'), ('expire_notify_tpl', '到期提醒邮件模板', u'账号到期通知\n尊敬的会员您好:\n您的账号#account#即将在#expire#到期,请及时续费!'), ('expire_notify_url', u'到期通知url', u'http://your_notify_url?account={account}&expire={expire}&email={email}&mobile={mobile}' ), ('expire_addrpool', u'到期提醒下发地址池', u'expire'), ('expire_session_timeout', u'到期用户下发最大会话时长(秒)', u'120'), ('smtp_server', u'SMTP服务器地址', u'smtp.mailgun.org'), ('smtp_port', u'SMTP服务器端口', u'25'), ('smtp_user', u'SMTP用户名', u'*****@*****.**'), ('smtp_pwd', u'SMTP密码', u'service2015'), ('smtp_sender', u'SMTP发送人名称', u'运营中心'), ('smtp_from', u'SMTP邮件发送地址', u'*****@*****.**'), ('radius_bypass', u'Radius认证密码模式', u'0'), ('radius_acct_interim_intelval', u'Radius记账间隔(秒)', u'120'), ('radius_max_session_timeout', u'Radius最大会话时长(秒)', u'86400'), ('radius_auth_auto_unlock', u'并发自动解锁', '0') ] for p in params: param = models.TrParam() param.param_name = p[0] param.param_desc = p[1] param.param_value = p[2] db.add(param) opr = models.TrOperator() opr.id = 1 opr.operator_name = u'admin' opr.operator_type = 0 opr.operator_pass = md5('root').hexdigest() opr.operator_desc = 'admin' opr.operator_status = 0 db.add(opr) bas = models.TrBas() bas.ip_addr = '127.0.0.1' bas.vendor_id = '0' bas.bas_name = 'local bras' bas.bas_secret = 'secret' bas.coa_port = 3799 bas.time_type = 0 db.add(bas) free_product = models.TrProduct() free_product.id = FREE_FEE_PID free_product.product_name = u"自由资费" free_product.product_policy = FreeFee free_product.product_status = 0 free_product.fee_months = 0 free_product.fee_times = 0 free_product.fee_flows = 0 free_product.bind_mac = 0 free_product.bind_vlan = 0 free_product.concur_number = 0 free_product.fee_price = 0 free_product.fee_period = '' free_product.input_max_limit = 0 free_product.output_max_limit = 0 free_product.create_time = utils.get_currtime() free_product.update_time = utils.get_currtime() db.add(free_product) product = models.TrProduct() product.product_name = u"测试2M包月20元" product.product_policy = 0 product.product_status = 0 product.fee_months = 0 product.fee_times = 0 product.fee_flows = 0 product.bind_mac = 0 product.bind_vlan = 0 product.concur_number = 0 product.fee_price = 2000 product.fee_period = '' product.input_max_limit = 1048576 product.output_max_limit = 1048576 * 2 product.create_time = utils.get_currtime() product.update_time = utils.get_currtime() db.add(product) db.commit() db.close()
def inittest(db): node = models.TrNode() node.id = 100 node.node_name = u'测试区域' node.node_desc = u'测试区域' db.add(node) product1 = models.TrProduct() product1.product_name = u"预付费时长每小时2元" product1.product_policy = 1 product1.product_status = 0 product1.fee_months = 0 product1.fee_times = 0 product1.fee_flows = 0 product1.bind_mac = 0 product1.bind_vlan = 0 product1.concur_number = 1 product1.fee_price = 200 product1.fee_period = '' product1.input_max_limit = 1048576 * 2 product1.output_max_limit = 1048576 * 2 product1.create_time = utils.get_currtime() product1.update_time = utils.get_currtime() db.add(product1) product2 = models.TrProduct() product2.product_name = u"预付费包月30元" product2.product_policy = 0 product2.product_status = 0 product2.fee_months = 0 product2.fee_times = 0 product2.fee_flows = 0 product2.bind_mac = 0 product2.bind_vlan = 0 product2.concur_number = 1 product2.fee_price = 3000 product2.fee_period = '' product2.input_max_limit = 1048576 * 2 product2.output_max_limit = 1048576 * 2 product2.create_time = utils.get_currtime() product2.update_time = utils.get_currtime() db.add(product2) product3 = models.TrProduct() product3.product_name = u"买断包月12个月500元" product3.product_policy = 2 product3.product_status = 0 product3.fee_months = 12 product3.fee_times = 0 product3.fee_flows = 0 product3.bind_mac = 0 product3.bind_vlan = 0 product3.concur_number = 1 product3.fee_price = 50000 product3.fee_period = '' product3.input_max_limit = 1048576 * 2 product3.output_max_limit = 1048576 * 2 product3.create_time = utils.get_currtime() product3.update_time = utils.get_currtime() db.add(product3) product4 = models.TrProduct() product4.product_name = u"买断时长100元50小时" product4.product_policy = 3 product4.product_status = 0 product4.fee_months = 0 product4.fee_times = 50 * 3600 product4.fee_flows = 0 product4.bind_mac = 0 product4.bind_vlan = 0 product4.concur_number = 1 product4.fee_price = 10000 product4.fee_period = '' product4.input_max_limit = 1048576 * 2 product4.output_max_limit = 1048576 * 2 product4.create_time = utils.get_currtime() product4.update_time = utils.get_currtime() db.add(product4) product5 = models.TrProduct() product5.product_name = u"预付费流量每MB0.05元" product5.product_policy = 4 product5.product_status = 0 product5.fee_months = 0 product5.fee_times = 0 product5.fee_flows = 0 product5.bind_mac = 0 product5.bind_vlan = 0 product5.concur_number = 1 product5.fee_price = 5 product5.fee_period = '' product5.input_max_limit = 1048576 * 2 product5.output_max_limit = 1048576 * 2 product5.create_time = utils.get_currtime() product5.update_time = utils.get_currtime() db.add(product5) product6 = models.TrProduct() product6.product_name = u"买断流量5元100MB" product6.product_policy = 5 product6.product_status = 0 product6.fee_months = 0 product6.fee_times = 0 product6.fee_flows = 100 product6.bind_mac = 0 product6.bind_vlan = 0 product6.concur_number = 1 product6.fee_price = 500 product6.fee_period = '' product6.input_max_limit = 1048576 * 2 product6.output_max_limit = 1048576 * 2 product6.create_time = utils.get_currtime() product6.update_time = utils.get_currtime() db.add(product6) db.commit() db.close()
request = self.parse_form_request() except apiutils.SignError, err: return self.render_sign_err(err) except Exception as err: return self.render_parse_err(err) try: if not form.validates(**request): return self.render_verify_err(form.errors) if self.db.query(models.TrNode).filter_by(node_name=form.d.node_name).count() > 0: return self.render_verify_err("node name already exists") except Exception, err: return self.render_verify_err(err) try: node = models.TrNode() node.node_name = form.d.node_name node.node_desc = form.d.node_desc or u'' self.db.add(node) self.add_oplog(u'API添加区域成功:%s' % utils.safeunicode(form.d.node_name)) self.db.commit() return self.render_success(msg=u'区域添加成功:%s' % form.d.node_name) except Exception as err: return self.render_unknow(err)