def database_upgrade():
u"""升级数据库"""
from flask.ext.migrate import upgrade, migrate
migrate()
upgrade()
print u"数据库升级成功"
def action_db_migrate(action=('a', 'start'), debug=False):
"""Migrate database.
This command is responsible for data base migrations.
Actions:
init - initiates migration module use only once.
migrate - creates schema migration.
upgrade - upgrades database using schema migrations.
Options:
- '--debug' use debug configuration
"""
from flask.ext.migrate import upgrade, init, migrate, stamp, downgrade
if debug:
app = make_debug(with_debug_layer=False)
else:
app = make_app()
with app.app_context():
if action == 'init':
init()
elif action == 'migrate':
migrate()
elif action == 'upgrade':
upgrade()
elif action == 'stamp':
stamp()
elif action == 'downgrade':
downgrade()
else:
print('Unknown action')
def action_db_migrate(action=('a', 'start'), debug=False):
"""Migrate database.
This command is responsible for data base migrations.
Actions:
init - initiates migration module use only once.
migrate - creates schema migration.
upgrade - upgrades database using schema migrations.
Options:
- '--debug' use debug configuration
"""
from flask.ext.migrate import upgrade, init, migrate, stamp, downgrade
if debug:
app = make_debug(with_debug_layer=False)
else:
app = make_app()
with app.app_context():
if action == 'init':
init()
elif action == 'migrate':
migrate()
elif action == 'upgrade':
upgrade()
elif action == 'stamp':
stamp()
elif action == 'downgrade':
downgrade()
else:
print('Unknown action')
def deploy():
'''Run deploymnet tsks.'''
from flask.ext.migrate import upgrade, migrate
from flasky import Role, User
migrate()
upgrade()
Role.insert_roles()
User.add_self_follows()
def migrate():
now_str = datetime.datetime.now().strftime('%d-%m-%y-%H:%M')
try:
init_migrations()
except CommandError as e:
# Already initiated .., all good!
pass
migrate(message='silverflask_%s' % now_str)
upgrade()
return 'We\'ve upgraded the ship'
def migrate():
now_str = datetime.datetime.now().strftime('%d-%m-%y-%H:%M')
try:
init_migrations()
except CommandError as e:
# Already initiated .., all good!
pass
migrate(message='silverflask_%s' % now_str)
upgrade()
return 'We\'ve upgraded the ship'
def migrate(ctx, rev_id, version_path, branch_label, splice, head, sql,
message):
app = factory(ctx.obj['CONFIG'])
with app.app_context():
migrate_extension.migrate(
message=message,
sql=sql,
head=head,
splice=splice,
branch_label=branch_label,
version_path=version_path,
rev_id=rev_id)
def deploy():
"""Run deployment tasks"""
from flask.ext.migrate import migrate, upgrade
from app.models import Role, User
# 把数据库迁移到最新修订版本
migrate()
upgrade()
# 创建用户角色
Role.insert_roles()
# 让所有用户都关注自己
User.add_self_follows()
def deploy():
"""Run deployment tasks"""
from flask.ext.migrate import migrate, upgrade
from app.models import Role, User
# 把数据库迁移到最新修订版本
migrate()
upgrade()
# 创建用户角色
Role.insert_roles()
# 让所有用户都关注自己
User.add_self_follows()
def import_csv(path,pkey_colname):
csvname = path.split('/')[-1]
def _make_header_arr(raw_header,data_row):
fields = []
for h_col,d_col in zip(raw_header,data_row):
is_pkey = True if (pkey_colname in h_col) else False
if is_pkey:
print "Found pkey: %s" % h_col
py_type = 'str'
# try:
# float(d_col)
# py_type = 'float'
# except ValueError:
# pass
fields.append({
"name" : h_col,
"py_type" : py_type,
"db_type" : "String",#"Float" if (py_type == float) else "String", || Just String for now
"primary_key" : is_pkey
})
return fields
from app.models.contributor import generate_contrib_model
with open(path, 'rbU') as csvfile:
csvreader = csv.reader(csvfile)
for idx,row in enumerate(csvreader):
if idx == 0:
raw_header = row
elif idx == 1: # header row
header = _make_header_arr(raw_header,row)
Contributor = generate_contrib_model(header)
# trololol
flmigrate.migrate()
flmigrate.upgrade()
print "Generated Contributor Model: %s" % str(Contributor)
if idx != 0:
contrib = Contributor(csvname)
for kv in zip(header,row):
setattr(contrib,kv[0]['name'],eval("%s(\"%s\")" % (kv[0]['py_type'], kv[1])))
db.session.add(contrib)
try:
db.session.commit()
except IntegrityError:
print "Warning: DB Integrity Error"
db.session.rollback()
return
def init_dev():
"""Initialize database, migrate, upgrade, and perform initial inserts."""
from flask.ext.migrate import upgrade, init, migrate
from app.models import GroupRole, Role, User
init()
migrate()
upgrade()
# create user roles
GroupRole.insert_roles()
Role.insert_roles()
u = User(username='******', email='*****@*****.**', confirmed=True)
u.password = '******'
db.session.add(u)
def reset_db_danger():
"""Reset db migration and delete all related files."""
from flask.ext.migrate import init, migrate
# Remove the migration folder if exist
if os.path.exists('migrations'):
shutil.rmtree('migrations')
# Remove the sqlite database files if exist
for fl in glob.glob('*.sqlite'):
os.remove(fl)
# Reset Migration Database
init()
# migrate database to latest revision
migrate(message='init')
def deploy():
"""Run deployment tasks."""
from flask.ext.migrate import upgrade, migrate, init
from app.models import User, Role, Permission
print "Migrating models to database"
init()
migrate()
upgrade()
migrate()
print "Models migrated to database"
print "Migrating meta data to tables"
migrate_meta()
print "Meta tables migrated"
print "Initial migration of our current version of database..."
# migrate_comadre()
migrate_all()
def deploy_dev():
''' deploy in development(using faked data)'''
from flask.ext.migrate import init, migrate, upgrade
from sured.models import Role, User, Post, Comment
#migrade database
init()
migrate()
upgrade()
# create roles
Role.insert_roles()
# fake users
User.generate_fake()
# fake questions
Post.generate_fake()
# fake answers
Comment.generate_fake()
def db_migrate(c, dir=DEFAULT_MIGRATION_DIR):
"""
Generate new autofilled migration.
"""
with app.app_context():
migrate.migrate(directory=dir)
def deploy():
"""Run deployment tasks."""
from flask.ext.migrate import upgrade, migrate
# migrate database to latest revision
migrate()
upgrade()
def database_upgrade():
u"""升级数据库"""
from flask.ext.migrate import upgrade, migrate
migrate()
upgrade()
print u'数据库升级成功'
def db_migrate(c, dir=DEFAULT_MIGRATION_DIR):
with app.app_context():
migrate.migrate(directory=dir)
def deploy():
"""Run deployment tasks."""
from flask.ext.migrate import upgrade, migrate
# migrate database to latest revision
migrate()
upgrade()
