Example #1
0
    def save(self, commit=True):
        group = super(GroupForm, self).save(commit=True)

        if commit:
            group.save()

            # Create and save the group profile
            group_profile = GroupProfile()
            group_profile.group = group

            # Need to add validation for the password fields
            if len(self.cleaned_data['group_password1']) > 0:
                group_profile.set_password(
                    self.cleaned_data['group_password1'])

            group_profile.save()

            # Now we need to actually create folders
            private_folder = Folder()
            private_folder.name = '%s Private' % group.name
            private_folder.notes = 'This folder is private to the %s group' % group.name
            private_folder.save()

            # Give users in this group read and write access to it
            private_folder.setPermissions(group, Actions.WRITE)
            private_folder.save()

            # Now we need to create the public folder for this group
            public_folder = Folder()
            public_folder.name = '%s Public' % group.name
            public_folder.notes = 'This folder is publically viewable and writable memebers of the %s group' % group.name
            public_folder.save()

            # Give any user the ability to read this folder
            anyuser = Group.objects.get(name="anyuser")
            public_folder.setPermissions(anyuser, Actions.READ)

            # Give this group read and write access
            public_folder.setPermissions(group, Actions.WRITE)
            public_folder.save()

            return (group, group_profile, public_folder, private_folder)

        return group
Example #2
0
    def save(self, commit=True):
        group = super(GroupForm, self).save(commit=True)

        if commit:
            group.save()

            # Create and save the group profile
            group_profile = GroupProfile()
            group_profile.group = group

            # Need to add validation for the password fields
            if len(self.cleaned_data['group_password1']) > 0:
                group_profile.set_password(self.cleaned_data['group_password1'])

            group_profile.save()

            # Now we need to actually create folders
            private_folder = Folder()
            private_folder.name = '%s Private' % group.name
            private_folder.notes = 'This folder is private to the %s group' % group.name
            private_folder.save()

            # Give users in this group read and write access to it
            private_folder.setPermissions(group, Actions.WRITE)
            private_folder.save()

            # Now we need to create the public folder for this group
            public_folder = Folder()
            public_folder.name = '%s Public' % group.name
            public_folder.notes = 'This folder is publically viewable and writable memebers of the %s group' % group.name
            public_folder.save()

            # Give any user the ability to read this folder
            anyuser = Group.objects.get(name="anyuser")
            public_folder.setPermissions(anyuser, Actions.READ)

            # Give this group read and write access
            public_folder.setPermissions(group, Actions.WRITE)
            public_folder.save()

            return (group, group_profile, public_folder, private_folder)

        return group
def migrate(opts):
    # back up the database before migrating
    if not opts.nodump:
        db = settings.DATABASES['default']
        dbName = db['NAME']
        timeText = datetime.datetime.now().strftime('%Y_%m_%d_%H%M%S')
        dumpFile = '%s_%s_migrate.sql' % (timeText, dbName)
        cmd = ('mysqldump --user="******" --password="******" %s > %s' %
               (db['USER'], db['PASSWORD'], dbName, dumpFile))
        dosys(cmd, stopOnError=True)

    cursor = connection.cursor()

    # drop tables with no data
    noDataTables = ('geocamCore_assignment', 'geocamCore_permission',
                    'geocamCore_unit', 'geocamCore_change',
                    'geocamCore_operation')
    for table in noDataTables:
        cursor.execute('DROP TABLE `%s`' % table)
    transaction.commit()

    # create tables
    dosys('%s/manage.py syncdb --noinput' % settings.CHECKOUT_DIR)

    # change UserProfile column definitions
    cursor.execute(
        'ALTER TABLE `geocamCore_userprofile` CHANGE COLUMN `homeTitle` `homeJobTitle` varchar(64) NOT NULL'
    )
    # syncdb will do the following for us since ManyToManyFields are
    # stored in separate tables:
    #   drop: userPermissions, assignments
    #   add: operations
    transaction.commit()

    # change Track column definitions
    cursor.execute(
        'ALTER TABLE `geocamTrack_track` CHANGE COLUMN `name` `name` varchar(80) NOT NULL'
    )
    newColumns = ('`author_id` integer', '`sensor_id` integer',
                  '`isAerial` bool NOT NULL', '`notes` longtext NOT NULL',
                  '`tags` varchar(255) NOT NULL',
                  '`icon` varchar(16) NOT NULL',
                  '`status` varchar(1) NOT NULL', '`processed` bool NOT NULL',
                  '`version` integer UNSIGNED NOT NULL',
                  '`purgeTime` datetime',
                  '`workflowStatus` integer UNSIGNED NOT NULL',
                  '`mtime` datetime', '`minTime` datetime NOT NULL',
                  '`maxTime` datetime NOT NULL', '`minLat` double precision',
                  '`minLon` double precision', '`maxLat` double precision',
                  '`maxLon` double precision')
    for col in newColumns:
        cursor.execute('ALTER TABLE `geocamTrack_track` ADD COLUMN %s' % col)
    transaction.commit()

    # for each old folder, make a Folder, Group, and Context
    cursor.execute('SELECT `id`, `name`, `timeZone` FROM `geocamCore_folder`')
    newFolderLookup = {}
    for oldFolderId, name, timeZone in cursor.fetchall():
        g = Group(name=name)
        g.save()
        transaction.commit()

        rootFolder = Folder.objects.get(id=1)
        f = Folder(name=name, parent=rootFolder)
        f.save()
        transaction.commit()

        f.setPermissions(g, Actions.ALL)
        transaction.commit()

        c = Context(name=name, uploadFolder=f, timeZone=timeZone)
        c.save()
        transaction.commit()

        gp = g.groupprofile
        gp.context = c
        gp.save()
        transaction.commit()

        newFolderLookup[oldFolderId] = f

    # syncdb should create these tables (according to sqlall) but
    # doesn't for some reason
    cursor.execute("""
    CREATE TABLE `geocamLens_photo_folders` (
        `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
        `photo_id` integer NOT NULL,
        `folder_id` integer NOT NULL,
        UNIQUE (`photo_id`, `folder_id`)
    )
    """)
    transaction.commit()

    cursor.execute("""
    CREATE TABLE `geocamTrack_track_folders` (
        `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
        `track_id` integer NOT NULL,
        `folder_id` integer NOT NULL,
        UNIQUE (`track_id`, `folder_id`)
    )
    """)
    transaction.commit()

    # fill in new 'folders' field
    folderTables = ('geocamLens_photo', )
    for table in folderTables:
        modelName = table.split('_')[1]
        cursor.execute('SELECT `id`, `folder_id` FROM `%s`' % table)
        for objId, oldFolderId in cursor.fetchall():
            newFolderId = newFolderLookup[oldFolderId].id
            cursor.execute(
                'INSERT INTO `%s_folders` (`%s_id`, `folder_id`) VALUES (%d, %d)'
                % (table, modelName, objId, newFolderId))
        transaction.commit()

    # drop old 'folder' field
    for table in folderTables:
        cursor.execute('ALTER TABLE `%s` DROP COLUMN `folder_id`' % table)
        transaction.commit()

    # drop remaining obsolete tables
    cursor.execute('DROP TABLE `geocamCore_folder`')
    transaction.commit()
def migrate(opts):
    # back up the database before migrating
    if not opts.nodump:
        db = settings.DATABASES['default']
        dbName = db['NAME']
        timeText = datetime.datetime.now().strftime('%Y_%m_%d_%H%M%S')
        dumpFile = '%s_%s_migrate.sql' % (timeText, dbName)
        cmd = ('mysqldump --user="******" --password="******" %s > %s'
               % (db['USER'], db['PASSWORD'], dbName, dumpFile))
        dosys(cmd, stopOnError=True)

    cursor = connection.cursor()

    # drop tables with no data
    noDataTables = ('geocamCore_assignment',
                    'geocamCore_permission',
                    'geocamCore_unit',
                    'geocamCore_change',
                    'geocamCore_operation')
    for table in noDataTables:
        cursor.execute('DROP TABLE `%s`' % table)
    transaction.commit()

    # create tables
    dosys('%s/manage.py syncdb --noinput' % settings.CHECKOUT_DIR)

    # change UserProfile column definitions
    cursor.execute('ALTER TABLE `geocamCore_userprofile` CHANGE COLUMN `homeTitle` `homeJobTitle` varchar(64) NOT NULL')
    # syncdb will do the following for us since ManyToManyFields are
    # stored in separate tables:
    #   drop: userPermissions, assignments
    #   add: operations
    transaction.commit()

    # change Track column definitions
    cursor.execute('ALTER TABLE `geocamTrack_track` CHANGE COLUMN `name` `name` varchar(80) NOT NULL')
    newColumns = ('`author_id` integer',
                  '`sensor_id` integer',
                  '`isAerial` bool NOT NULL',
                  '`notes` longtext NOT NULL',
                  '`tags` varchar(255) NOT NULL',
                  '`icon` varchar(16) NOT NULL',
                  '`status` varchar(1) NOT NULL',
                  '`processed` bool NOT NULL',
                  '`version` integer UNSIGNED NOT NULL',
                  '`purgeTime` datetime',
                  '`workflowStatus` integer UNSIGNED NOT NULL',
                  '`mtime` datetime',
                  '`minTime` datetime NOT NULL',
                  '`maxTime` datetime NOT NULL',
                  '`minLat` double precision',
                  '`minLon` double precision',
                  '`maxLat` double precision',
                  '`maxLon` double precision')
    for col in newColumns:
        cursor.execute('ALTER TABLE `geocamTrack_track` ADD COLUMN %s' % col)
    transaction.commit()

    # for each old folder, make a Folder, Group, and Context
    cursor.execute('SELECT `id`, `name`, `timeZone` FROM `geocamCore_folder`')
    newFolderLookup = {}
    for oldFolderId, name, timeZone in cursor.fetchall():
        g = Group(name=name)
        g.save()
        transaction.commit()

        rootFolder = Folder.objects.get(id=1)
        f = Folder(name=name, parent=rootFolder)
        f.save()
        transaction.commit()

        f.setPermissions(g, Actions.ALL)
        transaction.commit()

        c = Context(name=name,
                    uploadFolder=f,
                    timeZone=timeZone)
        c.save()
        transaction.commit()

        gp = g.groupprofile
        gp.context = c
        gp.save()
        transaction.commit()

        newFolderLookup[oldFolderId] = f

    # syncdb should create these tables (according to sqlall) but
    # doesn't for some reason
    cursor.execute("""
    CREATE TABLE `geocamLens_photo_folders` (
        `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
        `photo_id` integer NOT NULL,
        `folder_id` integer NOT NULL,
        UNIQUE (`photo_id`, `folder_id`)
    )
    """)
    transaction.commit()

    cursor.execute("""
    CREATE TABLE `geocamTrack_track_folders` (
        `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
        `track_id` integer NOT NULL,
        `folder_id` integer NOT NULL,
        UNIQUE (`track_id`, `folder_id`)
    )
    """)
    transaction.commit()

    # fill in new 'folders' field
    folderTables = ('geocamLens_photo',)
    for table in folderTables:
        modelName = table.split('_')[1]
        cursor.execute('SELECT `id`, `folder_id` FROM `%s`' % table)
        for objId, oldFolderId in cursor.fetchall():
            newFolderId = newFolderLookup[oldFolderId].id
            cursor.execute('INSERT INTO `%s_folders` (`%s_id`, `folder_id`) VALUES (%d, %d)'
                           % (table, modelName, objId, newFolderId))
        transaction.commit()

    # drop old 'folder' field
    for table in folderTables:
        cursor.execute('ALTER TABLE `%s` DROP COLUMN `folder_id`' % table)
        transaction.commit()

    # drop remaining obsolete tables
    cursor.execute('DROP TABLE `geocamCore_folder`')
    transaction.commit()