Examples with TableMeta com.alibaba.otter.canal.parse.inbound.TableMeta used on opensource projects

Example 1 with TableMeta

use of com.alibaba.otter.canal.parse.inbound.TableMeta in project canal by alibaba.

the class MemoryTableMeta_DDL_Test method test2.

@Test
public void test2() throws Throwable {
    MemoryTableMeta memoryTableMeta = new MemoryTableMeta();
    URL url = Thread.currentThread().getContextClassLoader().getResource("dummy.txt");
    File dummyFile = new File(url.getFile());
    File create = new File(dummyFile.getParent() + "/ddl", "ddl_test2.sql");
    String sql = StringUtils.join(IOUtils.readLines(new FileInputStream(create)), "\n");
    memoryTableMeta.apply(null, "test", sql, null);
    TableMeta meta = memoryTableMeta.find("yushitai_test", "card_record");
    System.out.println(meta);
    Assert.assertEquals(meta.getFieldMetaByName("id").isKey(), true);
    Assert.assertEquals(meta.getFieldMetaByName("name").isUnique(), true);
}

Example 2 with TableMeta

use of com.alibaba.otter.canal.parse.inbound.TableMeta in project canal by alibaba.

the class MemoryTableMeta_DDL_Test method test3.

@Test
public void test3() throws Throwable {
    MemoryTableMeta memoryTableMeta = new MemoryTableMeta();
    URL url = Thread.currentThread().getContextClassLoader().getResource("dummy.txt");
    File dummyFile = new File(url.getFile());
    File create = new File(dummyFile.getParent() + "/ddl", "ddl_test3.sql");
    String sql = StringUtils.join(IOUtils.readLines(new FileInputStream(create)), "\n");
    memoryTableMeta.apply(null, "test", sql, null);
    TableMeta meta = memoryTableMeta.find("test", "quniya4");
    System.out.println(meta);
    Assert.assertTrue(meta.getFields().get(0).getColumnName().equalsIgnoreCase("id"));
}

Example 3 with TableMeta

use of com.alibaba.otter.canal.parse.inbound.TableMeta in project canal by alibaba.

the class MemoryTableMetaTest method testSimple.

@Test
public void testSimple() throws Throwable {
    MemoryTableMeta memoryTableMeta = new MemoryTableMeta();
    URL url = Thread.currentThread().getContextClassLoader().getResource("dummy.txt");
    File dummyFile = new File(url.getFile());
    File create = new File(dummyFile.getParent() + "/ddl", "create.sql");
    String sql = StringUtils.join(IOUtils.readLines(new FileInputStream(create)), "\n");
    memoryTableMeta.apply(null, "test", sql, null);
    TableMeta meta = memoryTableMeta.find("test", "test");
    System.out.println(meta);
    Assert.assertTrue(meta.getFieldMetaByName("ID").isKey());
}

Example 4 with TableMeta

use of com.alibaba.otter.canal.parse.inbound.TableMeta in project canal by alibaba.

the class TableMetaCache method parseTableMeta.

public static List<FieldMeta> parseTableMeta(String schema, String table, ResultSetPacket packet) {
    if (packet.getFieldValues().size() > 1) {
        String createDDL = packet.getFieldValues().get(1);
        MemoryTableMeta memoryTableMeta = new MemoryTableMeta();
        memoryTableMeta.apply(DatabaseTableMeta.INIT_POSITION, schema, createDDL, null);
        TableMeta tableMeta = memoryTableMeta.find(schema, table);
        return tableMeta.getFields();
    } else {
        return new ArrayList<>();
    }
}

Example 5 with TableMeta

use of com.alibaba.otter.canal.parse.inbound.TableMeta in project canal by alibaba.

the class TableMetaCache method getTableMetaByDB.

private synchronized TableMeta getTableMetaByDB(String fullname) throws IOException {
    try {
        ResultSetPacket packet = connection.query("show create table " + fullname);
        String[] names = StringUtils.split(fullname, "`.`");
        String schema = names[0];
        String table = names[1].substring(0, names[1].length());
        return new TableMeta(schema, table, parseTableMeta(schema, table, packet));
    } catch (Throwable e) {
        // fallback to desc table
        ResultSetPacket packet = connection.query("desc " + fullname);
        String[] names = StringUtils.split(fullname, "`.`");
        String schema = names[0];
        String table = names[1].substring(0, names[1].length());
        return new TableMeta(schema, table, parseTableMetaByDesc(packet));
    }
}