class Vlans(db.Model):
__tablename__ = 'vlans'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(50), unique=True)
vlanid = db.Column(db.String(50), unique=True)
switch1_24_ports = db.relationship('Switch1_24_port',
backref='sw124vlansbackref',
lazy='dynamic')
switch2_24_ports = db.relationship('Switch2_24_port',
backref='sw224vlansbackref',
lazy='dynamic')
switch1_48_ports = db.relationship('Switch1_48_port',
backref='sw148vlansbackref',
lazy='dynamic')
switch2_48_ports = db.relationship('Switch1_48_port',
backref='sw248vlansbackref',
lazy='dynamic')
subnets = db.relationship('Subnets',
backref='subnetsvlansbackref',
lazy='dynamic')
def __init__(self, name=None, vlanid=None):
self.name = name
self.vlanid = vlanid
def __repr__(self):
return '<Vlans %r>' % (self.name)
class Vstorage(db.Model):
__tablename__ = 'vstorage'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(50), unique=True)
def __init__(self, name=None):
self.name = name
def __repr__(self):
return '<Vstorage %r>' % (self.name)
class Nas(db.Model):
__tablename__ = 'nas'
id = db.Column(db.Integer, primary_key=True)
hostname = db.Column(db.String(50), unique=True)
ipaddress = db.Column(db.String(50), unique=True)
subnet = db.Column(db.String(50))
gateway = db.Column(db.String(50))
port = db.Column(db.String(50))
provider = db.Column(db.String(50))
username = db.Column(db.String(50))
password = db.Column(db.String(50))
def __init__(self,
hostname=None,
ipaddress=None,
subnet=None,
gateway=None,
port=None,
provider=None,
username=None,
password=None):
self.hostname = hostname
self.ipaddress = ipaddress
self.subnet = subnet
self.gateway = gateway
self.port = port
self.provider = provider
self.username = username
self.password = password
def __repr__(self):
return '<Nas %r>' % (self.hostname)
class Templates(db.Model):
__tablename__ = 'templates'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(50), unique=True)
path = db.Column(db.String(50))
def __init__(self, name=None, path=None):
self.name = name
self.path = path
def __repr__(self):
return '<Templates %r>' % (self.name)
class Racks(db.Model):
__tablename__ = 'racks'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(50), unique=True)
location = db.Column(db.String(20))
def __init__(self, name=None, location=None):
self.name = name
self.location = location
def __repr__(self):
return '<Racks %r>' % (self.name)
class System_phy_profiles(db.Model):
__tablename__ = 'system_phy_profiles'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(15), unique=True)
mac = db.Column(db.String(10))
def __init__(self, name=None, mac=None):
self.name = name
self.mac = mac
def __repr__(self):
return str('%s') % (self.mac)
class Sharedsan(db.Model):
__tablename__ = 'sharedsan'
id = db.Column(db.Integer, primary_key=True)
lunname = db.Column(db.String(50), unique=True)
lunsize = db.Column(db.String(50))
def __init__(self, lunname=None, lunsize=None):
self.lunname = lunname
self.lunsize = lunsize
def __repr__(self):
return '<Sharedsan %r>' % (self.lunname)
class Role(db.Model, RoleMixin):
id = db.Column(db.Integer(), primary_key=True)
name = db.Column(db.String(80), unique=True)
description = db.Column(db.String(255))
def __init__(self, name=None, description=None):
self.name = name
self.description = description
def __repr__(self):
# return '<Role %r>' % (self.name)
return str('%s').replace('[', '').replace(']', '') % (self.name)
class VirtualMachines(db.Model):
__tablename__ = 'virtualmachines'
id = db.Column(db.Integer, primary_key=True)
hostname = db.Column(db.String(50), unique=True)
ipaddress = db.Column(db.String(50), unique=True)
subnet = db.Column(db.String(50))
gateway = db.Column(db.String(50))
portgroup = db.Column(db.String(50))
username = db.Column(db.String(50))
password = db.Column(db.String(50))
def __init__(self,
hostname=None,
ipaddress=None,
subnet=None,
gateway=None,
portgroup=None,
username=None,
password=None):
self.hostname = hostname
self.ipaddress = ipaddress
self.subnet = subnet
self.gateway = gateway
self.portgroup = portgroup
self.username = username
self.password = password
def __repr__(self):
return '%s' % (self.hostname)
class Switches(db.Model):
__tablename__ = 'switches'
id = db.Column(db.Integer, primary_key=True)
hostname = db.Column(db.String(50), unique=True)
ipaddress = db.Column(db.String(50), unique=True)
subnet = db.Column(db.String(50))
gateway = db.Column(db.String(50))
mgmtvlan = db.Column(db.String(50))
portnr = db.Column(db.String(2))
porttype = db.Column(db.String(15))
customer_sw = db.relationship('Customer_sw',
backref='customerswbackref',
lazy='dynamic')
def __init__(self,
hostname=None,
ipaddress=None,
subnet=None,
gateway=None,
mgmtvlan=None,
portnr=None,
porttype=None):
self.hostname = hostname
self.ipaddress = ipaddress
self.subnet = subnet
self.gateway = gateway
self.mgmtvlan = mgmtvlan
self.portnr = portnr
self.porttype = porttype
def __repr__(self):
return '<Switches %r>' % (self.hostname)
class Firewall2_interfaces(db.Model):
__tablename__ = 'firewall2_interfaces'
id = db.Column(db.Integer, primary_key=True)
vlan = db.Column(db.String(20))
name = db.Column(db.String(20))
seclvl = db.Column(db.String(10))
subnet = db.Column(db.String(10))
enabled = db.Column(db.Boolean())
mode = db.Column(db.String(10))
group = db.Column(db.String(10))
# group = db.Column(db.Integer, db.ForeignKey('port_channels.id'))
def __init__(self,
vlan=None,
name=None,
seclvl=None,
subnet=None,
enabled=None,
mode=None,
group=None):
self.vlan = vlan
self.name = name
self.seclvl = seclvl
self.subnet = subnet
self.enabled = enabled
self.mode = mode
self.group = group
def __repr__(self):
return '%r' % (self.id)
class Subnets(db.Model):
__tablename__ = 'subnets'
id = db.Column(db.Integer, primary_key=True)
# name = db.Column(db.String(50), unique=True)
name = db.Column(db.Integer, db.ForeignKey('vlans.id'))
network = db.Column(db.String(50), unique=True)
mask = db.Column(db.String(50))
def __init__(self, name=None, network=None, mask=None):
self.name = name
self.network = network
self.mask = mask
def __repr__(self):
return '<Subnets %r>' % (self.name)
class System_vm_profiles(db.Model):
__tablename__ = 'system_vm_profiles'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(15), unique=True)
mac = db.Column(db.String(10))
# salt_mac = db.Column(db.Integer, db.ForeignKey('saltstack_pxe_nodes.id'))
salt_id = db.relationship('Saltstack_pxe_nodes',
backref='saltvmbackref',
lazy='dynamic')
# def __init__(self, name=None, mac=None):
def __init__(self, name=None, mac=None):
self.name = name
self.mac = mac
def __repr__(self):
return str('%s') % (self.name)
class Isos(db.Model):
__tablename__ = 'isos'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(50), unique=True)
filepath = db.Column(db.String(100), unique=True)
filename = db.Column(db.String(80), unique=True)
cobbler_status = db.Column(db.String(80))
cobbler_name = db.Column(db.String(80))
import_eventid = db.Column(db.String(80))
def __init__(self,
name=None,
filename=None,
filepath=None,
cobbler_status=None,
cobbler_name=None,
import_eventid=None):
self.name = name
self.filename = filename
self.filepath = filepath
self.cobbler_status = cobbler_status
self.cobbler_name = cobbler_name
self.import_eventid = import_eventid
def __repr__(self):
return '<Isos %r>' % (self.name)
class Vsswitch(db.Model):
__tablename__ = 'vsswitch'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(50), unique=True)
ipaddress = db.Column(db.String(50), unique=True)
subnet = db.Column(db.String(50))
gateway = db.Column(db.String(50))
nic1 = db.Column(db.String(50), unique=True)
nic2 = db.Column(db.String(50), unique=True)
def __init__(self,
name=None,
ipaddress=None,
subnet=None,
gateway=None,
nic1=None,
nic2=None):
self.name = name
self.ipaddress = ipaddress
self.subnet = subnet
self.gateway = gateway
self.nic1 = nic1
self.nic2 = nic2
def __repr__(self):
return '<Vdsswitch %r>' % (self.name)
class Firewalls(db.Model):
__tablename__ = 'firewalls'
id = db.Column(db.Integer, primary_key=True)
hostname = db.Column(db.String(50), unique=True)
ipaddress = db.Column(db.String(50), unique=True)
subnet = db.Column(db.String(50))
gateway = db.Column(db.String(50))
mgmtnetwork = db.Column(db.String(50), unique=True)
mgmtsubnet = db.Column(db.String(50))
def __init__(self,
hostname=None,
ipaddress=None,
subnet=None,
gateway=None,
mgmtnetwork=None,
mgmtsubnet=None):
self.hostname = hostname
self.ipaddress = ipaddress
self.subnet = subnet
self.gateway = gateway
self.mgmtnetwork = mgmtnetwork
self.mgmtsubnet = mgmtsubnet
def __repr__(self):
return '<Firewalls %r>' % (self.hostname)
class Port_channels_fw1(db.Model):
__tablename__ = 'port_channels_fw1'
id = db.Column(db.Integer, primary_key=True)
vlan = db.Column(db.String(20))
name = db.Column(db.String(20))
seclvl = db.Column(db.String(10))
subnet = db.Column(db.String(10))
enabled = db.Column(db.Boolean())
mode = db.Column(db.String(10))
# group = db.Column(db.String(10))
interfaces = db.relationship('Firewall1_interfaces',
backref='interfaces',
lazy='dynamic')
def __init__(self,
vlan=None,
name=None,
seclvl=None,
subnet=None,
enabled=None,
mode=None,
group=None):
self.vlan = vlan
self.name = name
self.seclvl = seclvl
self.subnet = subnet
self.enabled = enabled
self.mode = mode
self.group = group
def __repr__(self):
return '%r' % (self.id)
class Vcenter(db.Model):
__tablename__ = 'vcenter'
id = db.Column(db.Integer, primary_key=True)
hostname = db.Column(db.String(50), unique=True)
ipaddress = db.Column(db.String(50), unique=True)
subnet = db.Column(db.String(50), unique=True)
gateway = db.Column(db.String(50), unique=True)
username = db.Column(db.String(50), unique=True)
password = db.Column(db.String(50), unique=True)
def __init__(self,
hostname=None,
ipaddress=None,
subnet=None,
gateway=None,
username=None,
password=None):
self.hostname = hostname
self.ipaddress = ipaddress
self.subnet = subnet
self.gateway = gateway
self.username = username
self.password = password
def __repr__(self):
return '<Vcenter %r>' % (self.hostname)
class Vdsswitch(db.Model):
__tablename__ = 'vdsswitch'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(50), unique=True)
nic1 = db.Column(db.String(50))
nic2 = db.Column(db.String(50))
datacenter = db.Column(db.String(50))
portgroup = db.Column(db.String(50), unique=True)
portgroupvlan = db.Column(db.String(50), unique=True)
def __init__(self,
name=None,
nic1=None,
nic2=None,
datacenter=None,
portgroup=None,
portgroupvlan=None):
self.name = name
self.nic1 = nic1
self.nic2 = nic2
self.datacenter = datacenter
self.portgroup = portgroup
self.portgroupvlan = portgroupvlan
def __repr__(self):
return '<Vdsswitch %r>' % (self.name)
class Switch2_48_port(db.Model):
__tablename__ = 'switch2_48_port'
id = db.Column(db.Integer, primary_key=True)
devicename = db.Column(db.String(50))
deviceport = db.Column(db.String(20))
portmode = db.Column(db.String(10))
portvlan = db.Column(db.String(10))
portpxeboot = db.Column(db.Boolean())
vlan_id = db.Column(db.Integer, db.ForeignKey('vlans.id'))
def __init__(self,
devicename=None,
deviceport=None,
portmode=None,
portvlan=None,
portpxeboot=None):
self.devicename = devicename
self.deviceport = deviceport
self.portmode = portmode
self.portvlan = portvlan
self.portpxeboot = portpxeboot
def __repr__(self):
return '<port %r>' % (self.id)
class Customer_sw(db.Model):
__tablename__ = 'customer_sw'
id = db.Column(db.Integer, primary_key=True)
selfname = db.Column(db.String(15))
baseconfig = db.Column(db.String(10))
portconfig = db.Column(db.String(10))
singleport = db.Column(db.String(10))
switch_id = db.Column(db.Integer, db.ForeignKey('switches.id'))
def __init__(self,
selfname=None,
baseconfig=None,
portconfig=None,
singleport=None):
self.selfname = selfname
self.baseconfig = baseconfig
self.portconfig = portconfig
self.singleport = singleport
def __repr__(self):
return '<Customer_sw %r>' % (self.selfname)
class Saltstack_pxe_nodes(db.Model):
__tablename__ = 'saltstack_pxe_nodes'
id = db.Column(db.Integer, primary_key=True)
pxeipaddr = db.Column(db.String(15), unique=True)
pxeint = db.Column(db.String(10))
pxemac = db.Column(db.String(20))
pxeinstalled = db.Column(db.Boolean())
# vm_mac = db.relationship('System_vm_profiles', backref='systemvmbackref', lazy='dynamic')
system_id = db.Column(db.Integer, db.ForeignKey('system_vm_profiles.id'))
def __init__(self,
pxeipaddr=None,
pxeint=None,
pxemac=None,
pxeinstalled=None):
self.pxeipaddr = pxeipaddr
self.pxeint = pxeint
self.pxemac = pxemac
self.pxeinstalled = pxeinstalled
def __repr__(self):
return str('%s') % (self.pxeipaddr)
from iomate.iomate_app import db, UserMixin, RoleMixin
## Flask-Security
roles_users = db.Table(
'roles_users', db.Column('user_id', db.Integer(),
db.ForeignKey('user.id')),
db.Column('role_id', db.Integer(), db.ForeignKey('role.id')))
class Role(db.Model, RoleMixin):
id = db.Column(db.Integer(), primary_key=True)
name = db.Column(db.String(80), unique=True)
description = db.Column(db.String(255))
def __init__(self, name=None, description=None):
self.name = name
self.description = description
def __repr__(self):
# return '<Role %r>' % (self.name)
return str('%s').replace('[', '').replace(']', '') % (self.name)
class User(db.Model, UserMixin):
id = db.Column(db.Integer, primary_key=True)
email = db.Column(db.String(255), unique=True)
username = db.Column(db.String(255))
password = db.Column(db.String(255))
last_login_at = db.Column(db.DateTime())
current_login_at = db.Column(db.DateTime())
last_login_ip = db.Column(db.String(100))
class User(db.Model, UserMixin):
id = db.Column(db.Integer, primary_key=True)
email = db.Column(db.String(255), unique=True)
username = db.Column(db.String(255))
password = db.Column(db.String(255))
last_login_at = db.Column(db.DateTime())
current_login_at = db.Column(db.DateTime())
last_login_ip = db.Column(db.String(100))
current_login_ip = db.Column(db.String(100))
login_count = db.Column(db.Integer)
active = db.Column(db.Boolean())
confirmed_at = db.Column(db.DateTime())
profile_pic = db.Column(db.String(100))
roles = db.relationship('Role',
secondary=roles_users,
backref=db.backref('users', lazy='dynamic'))
def __init__(self,
email=None,
username=None,
password=None,
last_login_at=None,
current_login_at=None,
last_login_ip=None,
current_login_ip=None,
login_count=None,
active=None,
confirmed_at=None,
profile_pic=None,
roles=None):
self.email = email
self.username = username
self.password = password
self.last_login_at = last_login_at
self.current_login_at = current_login_at
self.last_login_ip = last_login_ip
self.current_login_ip = current_login_ip
self.login_count = login_count
self.active = active
self.confirmed_at = confirmed_at
self.profile_pic = profile_pic
self.roles = roles
def is_authenticated(self):
return True
def is_active(self):
return True
def is_anonymous(self):
return False
def get_id(self):
return unicode(self.id)
def set_password():
pass
def check_password():
pass
def __repr__(self):
return '<User %r>' % (self.username)
