setup_db.py
790 Bytes
# -*- coding: utf-8 -*-
from server.database import Base, engine
from server.database.models import Host
from server.database import db_adapter
def setup_db():
"""Initialize db tables
make sure database and user correctly created in mysql
in case upgrade the table structure, the origin table need be dropped firstly
"""
Base.metadata.create_all(bind=engine)
# init REQUIRED db data.
db_adapter.add_object_kwargs(Host,
id='1',
hostname='test1',
public_ip='10.0.2.15',
private_ip='127.0.0.1',
mem='32G',
cores=16
)
setup_db()