Define a registered Postgres server
| 277 | |
| 278 | |
| 279 | class Server(db.Model, UserScopedMixin): |
| 280 | """Define a registered Postgres server""" |
| 281 | __tablename__ = 'server' |
| 282 | id = db.Column(db.Integer, primary_key=True) |
| 283 | user_id = db.Column( |
| 284 | db.Integer, |
| 285 | db.ForeignKey(USER_ID), |
| 286 | nullable=False |
| 287 | ) |
| 288 | servergroup_id = db.Column( |
| 289 | db.Integer, |
| 290 | db.ForeignKey('servergroup.id'), |
| 291 | nullable=False |
| 292 | ) |
| 293 | servergroup = db.relationship( |
| 294 | 'ServerGroup', |
| 295 | back_populates='servers', |
| 296 | lazy='joined' |
| 297 | ) |
| 298 | name = db.Column(db.String(128), nullable=False) |
| 299 | host = db.Column(db.String(128), nullable=True) |
| 300 | port = db.Column( |
| 301 | db.Integer(), |
| 302 | db.CheckConstraint('port >= 1 AND port <= 65534'), |
| 303 | nullable=False) |
| 304 | maintenance_db = db.Column(db.String(64), nullable=True) |
| 305 | username = db.Column(db.String(64), nullable=False) |
| 306 | password = db.Column(PgAdminDbBinaryString()) |
| 307 | save_password = db.Column( |
| 308 | db.Integer(), |
| 309 | db.CheckConstraint('save_password >= 0 AND save_password <= 1'), |
| 310 | nullable=False |
| 311 | ) |
| 312 | role = db.Column(db.String(64), nullable=True) |
| 313 | comment = db.Column(db.String(1024), nullable=True) |
| 314 | discovery_id = db.Column(db.String(128), nullable=True) |
| 315 | db_res = db.Column(db.Text(), nullable=True) |
| 316 | db_res_type = db.Column(db.String(32), default='databases') |
| 317 | passexec_cmd = db.Column(db.Text(), nullable=True) |
| 318 | passexec_expiration = db.Column(db.Integer(), nullable=True) |
| 319 | bgcolor = db.Column(db.String(10), nullable=True) |
| 320 | fgcolor = db.Column(db.String(10), nullable=True) |
| 321 | service = db.Column(db.Text(), nullable=True) |
| 322 | use_ssh_tunnel = db.Column( |
| 323 | db.Integer(), |
| 324 | db.CheckConstraint('use_ssh_tunnel >= 0 AND use_ssh_tunnel <= 1'), |
| 325 | nullable=False |
| 326 | ) |
| 327 | tunnel_host = db.Column(db.String(128), nullable=True) |
| 328 | tunnel_port = db.Column( |
| 329 | db.Integer(), |
| 330 | db.CheckConstraint('port <= 65534'), |
| 331 | nullable=True, default=22) |
| 332 | tunnel_username = db.Column(db.String(64), nullable=True) |
| 333 | tunnel_authentication = db.Column( |
| 334 | db.Integer(), |
| 335 | db.CheckConstraint('tunnel_authentication >= 0 AND ' |
| 336 | 'tunnel_authentication <= 1'), |
no test coverage detected