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 ))