#!/usr/bin/python
import unittest
import re
from schemasync.utils import REGEX_TABLE_AUTO_INC, REGEX_TABLE_COMMENT
from schemasync.utils import REGEX_MULTI_SPACE, REGEX_DISTANT_SEMICOLIN, REGEX_FILE_COUNTER
class TestTableCommentRegex(unittest.TestCase):
def test_single_column_comment_case_insensitive(self):
"""Test REGEX_TABLE_COMMENT lowercase (comment '*')"""
table = """CREATE TABLE `person` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT, `first_name` varchar(100) NOT NULL comment 'this is your first name',`last_name` varchar(100) NOT NULL,`created` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8"""
(sql, count) = REGEX_TABLE_COMMENT.subn('', table)
self.assertEqual(count, 1)
self.assertEqual(sql, """CREATE TABLE `person` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT, `first_name` varchar(100) NOT NULL ,`last_name` varchar(100) NOT NULL,`created` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8""")
def test_single_column_comment_space_seperator(self):
"""Test REGEX_TABLE_COMMENT space seperator (COMMENT '*')"""
table = """CREATE TABLE `person` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT, `first_name` varchar(100) NOT NULL COMMENT 'this is your first name',`last_name` varchar(100) NOT NULL,`created` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8"""
(sql, count) = REGEX_TABLE_COMMENT.subn('', table)
self.assertEqual(count, 1)
self.assertEqual(sql, """CREATE TABLE `person` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT, `first_name` varchar(100) NOT NULL ,`last_name` varchar(100) NOT NULL,`created` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8""")
def test_single_column_comment_space_seperator_multiple_spaces(self):
"""Test REGEX_TABLE_COMMENT multiple spaces as the seperator (COMMENT '*')"""
table = """CREATE TABLE `person` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT, `first_name` varchar(100) NOT NULL COMMENT 'this is your first name',`last_name` varchar(100) NOT NULL,`created` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8"""
(sql, count) = REGEX_TABLE_COMMENT.subn('', table)
self.assertEqual(count, 1)
self.assertEqual(sql, """CREATE TABLE `person` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT, `first_name` varchar(100) NOT NULL ,`last_name` varchar(100) NOT NULL,`created` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8""")
def test_single_column_comment_equals_seperator(self):
"""Test REGEX_TABLE_COMMENT = seperator (COMMENT='*')"""
table = """CREATE TABLE `person` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT, `first_name` varchar(100) NOT NULL COMMENT='this is your first name',`last_name` varchar(100) NOT NULL,`created` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8"""
(sql, count) = REGEX_TABLE_COMMENT.subn('', table)
self.assertEqual(count, 1)
self.assertEqual(sql, """CREATE TABLE `person` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT, `first_name` varchar(100) NOT NULL ,`last_name` varchar(100) NOT NULL,`created` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8""")
def test_single_column_comment_equals_seperator_with_spaces(self):
"""Test REGEX_TABLE_COMMENT = seperator surrounded by spaces (COMMENT = '*')"""
table = """CREATE TABLE `person` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT, `first_name` varchar(100) NOT NULL COMMENT = 'this is your first name',`last_name` varchar(100) NOT NULL,`created` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8"""
(sql, count) = REGEX_TABLE_COMMENT.subn('', table)
self.assertEqual(count, 1)
self.assertEqual(sql, """CREATE TABLE `person` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT, `first_name` varchar(100) NOT NULL ,`last_name` varchar(100) NOT NULL,`created` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8""")
def test_multiple_mixed_seperated_column_comment(self):
"""Test REGEX_TABLE_COMMENT multiple column comments (COMMENT '*', COMMENT='*')"""
table = """CREATE TABLE `person` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT, `first_name` varchar(100) NOT NULL COMMENT 'this is your first name',`last_name` varchar(100) NOT NULL COMMENT='this is your last name',`created` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8"""
(sql, count) = REGEX_TABLE_COMMENT.subn('', table)
self.assertEqual(count, 2)
self.assertEqual(sql, """CREATE TABLE `person` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT, `first_name` varchar(100) NOT NULL ,`last_name` varchar(100) NOT NULL ,`created` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8""")
def test_table_comment(self):
"""Test REGEX_TABLE_COMMENT Table comment"""
table = """CREATE TABLE `person` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT, `first_name` varchar(100) NOT NULL,`last_name` varchar(100) NOT NULL,`created` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',PRIMARY KEY (`id`)) ENGINE=InnoDB COMMENT 'table comment' DEFAULT CHARSET=utf8"""
(sql, count) = re.subn(REGEX_TABLE_COMMENT, '', table)
self.assertEqual(count, 1)
self.assertEqual(sql, """CREATE TABLE `person` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT, `first_name` varchar(100) NOT NULL,`last_name` varchar(100) NOT NULL,`created` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8""")
def test_multiple_column_comment_with_table_comment(self):
"""Test REGEX_TABLE_COMMENT multiple column comments and the Table comment"""
table = """CREATE TABLE `person` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT, `first_name` varchar(100) NOT NULL COMMENT 'this is your first name',`last_name` varchar(100) NOT NULL COMMENT='this is your last name',`created` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',PRIMARY KEY (`id`)) ENGINE=InnoDB COMMENT 'table comment' DEFAULT CHARSET=utf8"""
(sql, count) = REGEX_TABLE_COMMENT.subn('', table)
self.assertEqual(count, 3)
self.assertEqual(sql, """CREATE TABLE `person` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT, `first_name` varchar(100) NOT NULL ,`last_name` varchar(100) NOT NULL ,`created` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8""")
def test_no_comments(self):
"""Test REGEX_TABLE_COMMENT no comments"""
table = """CREATE TABLE `person` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT, `first_name` varchar(100) NOT NULL,`last_name` varchar(100) NOT NULL,`created` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8"""
(sql, count) = REGEX_TABLE_COMMENT.subn('', table)
self.assertEqual(count, 0)
self.assertEqual(sql, table)
class TestTableAutoIncrementRegex(unittest.TestCase):
def test_auto_inc_regex_space_seperator(self):
"""Test REGEX_TABLE_AUTO_INC table option AUTO_INCREMENT 1"""
table = """CREATE TABLE `person` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT, `first_name` varchar(100) NOT NULL COMMENT 'this is your first name',`last_name` varchar(100) NOT NULL,`created` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',PRIMARY KEY (`id`)) AUTO_INCREMENT 1 ENGINE=InnoDB DEFAULT CHARSET=utf8"""
(sql, count
SchemaSync-修订二版-根据配置文件进行同步.rar （74个子文件） 
SchemaSync 
setup.py 1KB .gitignore 105B CHANGES 785B MANIFEST.in 62B schemasync db.20180530.patch.sql 17KB __init__.py 0B utils.pyc 6KB utils.py 5KB schemasync.py 13KB schemasync.log 18KB syncdb.py 16KB db.20180530.revert.sql 950B example.yml 935B config_yaml.pyc 2KB syncdb.pyc 16KB LICENSE 589B .idea misc.xml 1KB encodings.xml 200B workspace.xml 36KB vcs.xml 173B deployment.xml 349B vagrant.xml 216B scopes scope_settings.xml 143B dictionaries Administrator.xml 94B inspectionProfiles Project_Default.xml 522B profiles_settings.xml 241B SchemaSync.iml 607B .name 10B modules.xml 272B tests __init__.py 0B test_sync_tables.py 8KB test_all.py 2KB test_sync_database.py 969B test_regex.py 18KB test_utils.py 6KB test_sync_columns.py 14KB test_sync_constraints.py 5KB schemaobject procedure.pyc 3KB collections.py 1KB __init__.pyc 512B option.pyc 2KB table.py 10KB index.pyc 7KB __init__.py 330B procedure.py 3KB database.py 6KB connection.pyc 4KB option.py 2KB utils.pyc 6KB connection.py 4KB table.pyc 10KB utils.py 5KB view.py 3KB schema.pyc 2KB collections.pyc 3KB judge.pyc 2KB schemasync.py 14KB config_yaml.py 5KB syncdb.py 16KB trigger.pyc 3KB index.py 7KB judge.py 2KB foreignkey.py 8KB foreignkey.pyc 8KB column.py 8KB view.pyc 3KB config_yaml.pyc 4KB column.pyc 8KB syncdb.pyc 16KB schema.py 2KB trigger.py 3KB database.pyc 7KB README 3KB ez_setup.py 9KB
评论0
最新资源