def test_trigger_update(self): df1 = "testes/arq/dfTable1_d1.df" df2 = "testes/arq/dfTable1_d4.df" strcompara = ( 'UPDATE TABLE "aac014" \n' ' TABLE-TRIGGER "Delete" NO-OVERRIDE PROCEDURE "testede.trg" CRC "1920"\n' + ' TABLE-TRIGGER "Replication-Write" DELETE\n' + ' TABLE-TRIGGER "Write" OVERRIDE PROCEDURE "testewr.trg" CRC "?"\n\n' ) diff = executa_diferenca(df1, df2) self.assertEqual(strcompara, executa_diferenca(df1, df2))
def test_tabela_add(self): df1 = "testes/arq/dfTable1_d1.df" df2 = "testes/arq/dfTable1_d2.df" f = open(df1, 'r', encoding="utf-8", errors='ignore') strcompara = f.read() + '\n' self.assertEqual(strcompara, executa_diferenca(df1, df2)) f.close()
def test_field_update(self): df1 = "testes/arq/dfField1_d1.df" df2 = "testes/arq/dfField1_d3.df" strcompara = ('UPDATE FIELD "empresa" of "aac014" \n' + ' INITIAL "0"\n' + ' POSITION 2\n' + ' HELP "Codigo da empresa"\n\n') self.assertEqual(strcompara, executa_diferenca(df1, df2))
def test_index_add(self): df1 = "testes/arq/dfIndex1_d1.df" df2 = "testes/arq/dfField1_d2.df" strcompara = ('ADD INDEX "aac014-1" ON "aac014"\n' + ' UNIQUE\n' + ' PRIMARY\n' + ' INDEX-FIELD "empresa" ASCENDING\n' + ' INDEX-FIELD "cgc-cpf-parceiro" ASCENDING\n' + ' INDEX-FIELD "sequencia" ASCENDING\n\n') self.assertEqual(strcompara, executa_diferenca(df1, df2))
def test_field_update_mandatory(self): df1 = "testes/arq/dfField1_d7.df" df2 = "testes/arq/dfField1_d1.df" strcompara = ('UPDATE FIELD "empresa" of "aac014" \n' + ' INITIAL "1"\n' + ' POSITION 4\n' + ' HELP "Cod empresa"\n' ' MANDATORY\n\n') self.assertEqual(strcompara, executa_diferenca(df1, df2))
def test_field_rename(self): df1 = "testes/arq/dfField1_d1.df" df2 = "testes/arq/dfField1_d4.df" strcompara = ('RENAME FIELD "empresa" OF "aac014" TO "empresa_old"\n' + '\n' + 'ADD FIELD "empresa" OF "aac014" AS integer\n' + ' FORMAT "99"\n' + ' INITIAL "0"\n' + ' LABEL "Empresa........."\n' + ' POSITION 2\n' + ' COLUMN-LABEL "Empresa"\n' + ' HELP "Codigo da empresa"\n' + ' ORDER 10\n\n') self.assertEqual(strcompara, executa_diferenca(df1, df2))
def test_tabela_update(self): df1 = "testes/arq/dfTable1_d3.df" df2 = "testes/arq/dfTable1_d1.df" strcompara = ( 'UPDATE TABLE "aac014" \n' ' DESCRIPTION "Historico das alteracoes" \n' + ' TABLE-TRIGGER "Delete" NO-OVERRIDE PROCEDURE "testede.trg" CRC "1920"\n' + ' TABLE-TRIGGER "Write" DELETE\n\n') self.assertEqual(strcompara, executa_diferenca(df1, df2))
def test_index_umCampoAMais(self): df1 = "testes/arq/dfIndex1_d2.df" df2 = "testes/arq/dfIndex1_d1.df" strcompara = ( 'RENAME INDEX "aac014-1" ON "aac014" TO "aac014-1_old"\n' + '\n' + 'ADD INDEX "aac014-1" ON "aac014"\n' + ' UNIQUE\n' + ' PRIMARY\n' + ' INDEX-FIELD "empresa" ASCENDING\n' + ' INDEX-FIELD "sequencia" ASCENDING\n' + '\n' + 'DROP INDEX "aac014-1_old" ON "aac014"\n\n') self.assertEqual(strcompara, executa_diferenca(df1, df2))
def test_index_sem_schema_area(self): df1 = "testes/arq/dfIndex1_d3.df" df2 = "testes/arq/dfIndex1_d4.df" strcompara = ( 'RENAME INDEX "aac014-1" ON "aac014" TO "aac014-1_old"\n' + '\n' + 'ADD INDEX "aac014-1" ON "aac014"\n' + ' UNIQUE\n' + ' PRIMARY\n' + ' INDEX-FIELD "empresa" ASCENDING\n' + ' INDEX-FIELD "sequencia" ASCENDING\n' + ' INDEX-FIELD "cgc-cpf-parceiro" ASCENDING\n' + '\n' + 'DROP INDEX "aac014-1_old" ON "aac014"\n\n') self.assertEqual(strcompara, executa_diferenca(df1, df2))
def test_alterarExtent(self): df1 = "testes/arq/dfField1_d5.df" df2 = "testes/arq/dfField1_d1.df" f = open(df1, 'r', encoding="utf-8", errors='ignore') strcompara = 'RENAME FIELD "empresa" OF "aac014" TO "empresa_old"\n\n'\ + '''ADD FIELD "empresa" OF "aac014" AS integer FORMAT "99" INITIAL "0" LABEL "Empresa........." POSITION 2 COLUMN-LABEL "Empresa" HELP "Codigo da empresa" EXTENT 10 ORDER 10\n\n''' f.close() self.assertEqual(strcompara, executa_diferenca(df1, df2))
def test_field_drop(self): df1 = "testes/arq/dfField1_d2.df" df2 = "testes/arq/dfField1_d1.df" strcompara = 'DROP FIELD "empresa" ON "aac014"\n\n' self.assertEqual(strcompara, executa_diferenca(df1, df2))
def test_tabela_drop(self): df1 = "testes/arq/dfTable1_d2.df" df2 = "testes/arq/dfTable1_d1.df" strcompara = "DROP TABLE \"aac014\"\n\n" self.assertEqual(strcompara, executa_diferenca(df1, df2))
def test_field_case_insensitive(self): df1 = "testes/arq/dfField1_d5.df" df2 = "testes/arq/dfField1_d6.df" strcompara = '' self.assertEqual(strcompara, executa_diferenca(df1, df2))
def test_index_caseSensitive(self): df1 = "testes/arq/dfIndex1_d4.df" df2 = "testes/arq/dfIndex1_d1.df" self.assertEqual('', executa_diferenca(df1, df2))
def test_index_drop(self): df1 = "testes/arq/dfField1_d2.df" df2 = "testes/arq/dfIndex1_d1.df" strcompara = 'DROP INDEX "aac014-1" ON "aac014"\n\n' self.assertEqual(strcompara, executa_diferenca(df1, df2))
from exec import executa_diferenca print(executa_diferenca("C:\\Users\\Beserra\\Desktop\\dfmain.df", "C:\\Users\\Beserra\\Desktop\\dffiasul.df"))