Example #1
0
    def test_sync_created_column(self):
        """Test: src table has columns not in dest table (ignore Column COMMENT)"""
        saved = self.dest.columns['staff_id']
        pos = self.dest.columns.index('staff_id')
        del self.dest.columns['staff_id']

        for i, (p,r) in enumerate(syncdb.sync_created_columns(self.src.columns, self.dest.columns, sync_comments=False)):
            self.assertEqual(p, "ADD COLUMN `staff_id` TINYINT(3) UNSIGNED NOT NULL AFTER `return_date`")
            self.assertEqual(r, "DROP COLUMN `staff_id`")

        self.assertEqual(i, 0)
Example #2
0
    def test_sync_created_column_with_comments(self):
        """Test: src table has columns not in dest table (include Column COMMENT)"""
        saved = self.dest.columns['staff_id']
        pos = self.dest.columns.index('staff_id')
        del self.dest.columns['staff_id']

        self.src.columns['staff_id'].comment = "hello world"

        for i, (p,r) in enumerate(syncdb.sync_created_columns(self.src.columns, self.dest.columns, sync_comments=True)):
            self.assertEqual(p, "ADD COLUMN `staff_id` TINYINT(3) UNSIGNED NOT NULL COMMENT 'hello world' AFTER `return_date`")
            self.assertEqual(r, "DROP COLUMN `staff_id`")

        self.assertEqual(i, 0)
Example #3
0
    def test_sync_created_column(self):
        """Test: src table has columns not in dest table (ignore Column COMMENT)"""
        saved = self.dest.columns['staff_id']
        pos = self.dest.columns.index('staff_id')
        del self.dest.columns['staff_id']

        for i, (p, r) in enumerate(
                syncdb.sync_created_columns(self.src.columns,
                                            self.dest.columns,
                                            sync_comments=False)):
            self.assertEqual(
                p,
                "ADD COLUMN `staff_id` TINYINT(3) UNSIGNED NOT NULL AFTER `return_date`"
            )
            self.assertEqual(r, "DROP COLUMN `staff_id`")

        self.assertEqual(i, 0)
Example #4
0
    def test_sync_created_column_with_comments(self):
        """Test: src table has columns not in dest table (include Column COMMENT)"""
        saved = self.dest.columns['staff_id']
        pos = self.dest.columns.index('staff_id')
        del self.dest.columns['staff_id']

        self.src.columns['staff_id'].comment = "hello world"

        for i, (p, r) in enumerate(
                syncdb.sync_created_columns(self.src.columns,
                                            self.dest.columns,
                                            sync_comments=True)):
            self.assertEqual(
                p,
                "ADD COLUMN `staff_id` TINYINT(3) UNSIGNED NOT NULL COMMENT 'hello world' AFTER `return_date`"
            )
            self.assertEqual(r, "DROP COLUMN `staff_id`")

        self.assertEqual(i, 0)