def create_db():
"Create RoseGuarden database"
print "Create database (this will remove old data)"
db.create_all()
User.query.delete()
# add syncmaster-user for synchronisation
print "Add syncmaster user"
syncMasterUser = User('*****@*****.**',
SYNC_MASTER_DEFAULT_PASSWORD, 'Sync', 'Master', 1)
syncMasterUser.syncMaster = 1
db.session.add(syncMasterUser)
# you can add some default user here
print "Add admin user"
defaultUser1 = User('Administrator', 'Admin1234', 'RoseGuarden', 'Admin',
1)
defaultUser1.accessType = 1
db.session.add(defaultUser1)
#db.session.add(Door(id = 0, name = 'front door', address = 'http://192.168.2.137', keyMask = 0x01, local = 0x00 ))
#db.session.add(Door(id = 0, name = 'front door', address = 'http://192.168.2.138', keyMask = 0x01, local = 0x00 ))
#db.session.add(Door(id = 0, name = 'front door', address = 'http://192.168.2.139', keyMask = 0x01, local = 0x00 ))
print "Add local door"
Door.query.delete()
db.session.add(
Door(name=config.NODE_NAME,
displayName='Local',
address='http://localhost',
keyMask=0x03,
local=0x01,
password=config.SYNC_MASTER_DEFAULT_PASSWORD))
print "Add default settings"
Setting.query.delete()
db.session.add(
Setting('NODE_VALID_KEYS_MASK', '3', Setting.SETTINGTYPE_INT))
print "Add log-entry"
Action.query.delete()
db.session.add(
Action(datetime.datetime.utcnow(), config.NODE_NAME,
syncMasterUser.firstName + ' ' + syncMasterUser.lastName,
syncMasterUser.email, 'Remove all data & regenerate database',
'Init systen', 'L1', 1, 'Internal'))
print "Save new database"
db.session.commit()
print "Successfully create new database"
def create_db():
"Create RoseGuarden database"
print "Create database (this will remove old data)"
db.create_all()
User.query.delete()
# add syncmaster-user for synchronisation
print "Add syncmaster user"
syncMasterUser = User('*****@*****.**', SYNC_MASTER_DEFAULT_PASSWORD, 'Sync','Master',1)
syncMasterUser.syncMaster = 1
db.session.add(syncMasterUser)
# you can add some default user here
print "Add admin user"
defaultUser1 = User('Administrator','pleasechangethepassword','RoseGuarden','Admin', 1)
defaultUser1.accessType = 1
db.session.add(defaultUser1)
#db.session.add(Door(id = 0, name = 'front door', address = 'http://192.168.2.137', keyMask = 0x01, local = 0x00 ))
#db.session.add(Door(id = 0, name = 'front door', address = 'http://192.168.2.138', keyMask = 0x01, local = 0x00 ))
#db.session.add(Door(id = 0, name = 'front door', address = 'http://192.168.2.139', keyMask = 0x01, local = 0x00 ))
print "Add local door"
Door.query.delete()
db.session.add(Door(name = config.NODE_NAME, displayName = 'Local', address = 'http://localhost', keyMask = 0x03, local = 0x01, password= config.SYNC_MASTER_DEFAULT_PASSWORD))
print "Add default settings"
Setting.query.delete()
db.session.add(Setting('NODE_VALID_KEYS_MASK', '3', Setting.SETTINGTYPE_INT))
print "Add log-entry"
Action.query.delete()
db.session.add(Action(datetime.datetime.utcnow(), config.NODE_NAME, syncMasterUser.firstName + ' ' + syncMasterUser.lastName, syncMasterUser.email, 'Remove all data & regenerate database', 'Init systen', 'L1', 1, 'Internal'))
print "Save new database"
db.session.commit()
print "Successfully create new database"
__author__ = "drobisch"
from app.server import db, flask_bcrypt
from app.models import User, Log, Door, Setting
import datetime
import base64
db.create_all()
User.query.delete()
syncMasterUser = User("*****@*****.**", "pleasechangethepassword", "Sync", "Master", 1)
syncMasterUser.syncMaster = 1
defaultUser1 = User("*****@*****.**", "konglo2015", "Konglomerat", "Kommando", 0)
defaultUser1.accessType = 1
defaultUser2 = User("*****@*****.**", "1234", "Marcus", "Drobisch", 1, "01754404298", 0x00, 0x03)
defaultUser2.accessType = 1
db.session.add(defaultUser1)
db.session.add(defaultUser2)
# db.session.add(User(id = 0, password = flask_bcrypt.generate_password_hash('1234'), token = base64.encodestring('[email protected]:1234'), tokenExpirationDate= datetime.datetime.utcnow(), firstName = 'Marcus', lastName = 'Drobisch', phone = '0175 4404298', email='*****@*****.**', card_id = '1.1.1.1' , doorLicense = 0x01, deviceLicense = 0x01))
# db.session.add(User(id = 1, password = flask_bcrypt.generate_password_hash('1234'), token = base64.encodestring('[email protected]:1234'), tokenExpirationDate= datetime.datetime.utcnow(), firstName = 'Max', lastName = 'Mustermann', phone = '0175 4404298', email='*****@*****.**', card_id = '2.1.1.1' , doorLicense = 0x00, deviceLicense = 0x00))
Door.query.delete()
# db.session.add(Door(id = 0, name = 'front door', address = 'http://192.168.2.137', keyMask = 0x01, local = 0x00 ))
# db.session.add(Door(id = 0, name = 'front door', address = 'http://192.168.2.138', keyMask = 0x01, local = 0x00 ))
# db.session.add(Door(id = 0, name = 'front door', address = 'http://192.168.2.139', keyMask = 0x01, local = 0x00 ))
db.session.add(Door(name="Local door", address="http://localhost", keyMask=0x03, local=0x01))
db.session.add(Door(name="Outer door", address="http://192.168.0.59", keyMask=0x03, local=0x00))
db.session.add(Door(name="Inner door", address="http://10.43.125.7", keyMask=0x03, local=0x00))
__author__ = 'drobisch'
from app.server import db, flask_bcrypt
from app.models import User, Log, Door, Setting
import datetime
import base64
db.create_all()
User.query.delete()
syncMasterUser = User('*****@*****.**','pleasechangethepassword','Sync','Master',1)
syncMasterUser.syncMaster = 1
defaultUser1 = User('*****@*****.**','konglo2015','Konglomerat','Kommando', 0)
defaultUser1.accessType = 1
defaultUser2 = User('*****@*****.**','1234','Marcus','Drobisch',1,'01754404298',0x00,0x03)
defaultUser2.accessType = 1
db.session.add(defaultUser1)
db.session.add(defaultUser2)
#db.session.add(User(id = 0, password = flask_bcrypt.generate_password_hash('1234'), token = base64.encodestring('[email protected]:1234'), tokenExpirationDate= datetime.datetime.utcnow(), firstName = 'Marcus', lastName = 'Drobisch', phone = '0175 4404298', email='*****@*****.**', card_id = '1.1.1.1' , doorLicense = 0x01, deviceLicense = 0x01))
#db.session.add(User(id = 1, password = flask_bcrypt.generate_password_hash('1234'), token = base64.encodestring('[email protected]:1234'), tokenExpirationDate= datetime.datetime.utcnow(), firstName = 'Max', lastName = 'Mustermann', phone = '0175 4404298', email='*****@*****.**', card_id = '2.1.1.1' , doorLicense = 0x00, deviceLicense = 0x00))
Door.query.delete()
#db.session.add(Door(id = 0, name = 'front door', address = 'http://192.168.2.137', keyMask = 0x01, local = 0x00 ))
#db.session.add(Door(id = 0, name = 'front door', address = 'http://192.168.2.138', keyMask = 0x01, local = 0x00 ))
#db.session.add(Door(id = 0, name = 'front door', address = 'http://192.168.2.139', keyMask = 0x01, local = 0x00 ))
db.session.add(Door(name = 'Local door', address = 'http://localhost', keyMask = 0x03, local = 0x01 ))
db.session.add(Door(name = 'Outer door', address = 'http://192.168.0.59', keyMask = 0x03, local = 0x00 ))
db.session.add(Door(name = 'Inner door', address = 'http://10.43.125.7', keyMask = 0x03, local = 0x00 ))
