Package com.alibaba.cobar.client.entities

Examples of com.alibaba.cobar.client.entities.Follower


        verifyEntityNonExistenceOnSpecificDataSource(confirmSQL, jt2m);
        verifyEntityNonExistenceOnSpecificDataSource(confirmSQL, jt2s);
    }

    public void testDeleteWithExpectedResultSizeOnCobarSqlMapClientTemplate() {
        Follower f = new Follower("fname");
         getSqlMapClientTemplate().insert("com.alibaba.cobar.client.entities.Follower.create", f);

        String confirmSQL = "select name from followers where name='fname'";
        verifyEntityNonExistenceOnSpecificDataSource(confirmSQL, jt1m);
        verifyEntityNonExistenceOnSpecificDataSource(confirmSQL, jt1s);
View Full Code Here


        String[] names = { "Aaron", "Amily", "Aragon", "Darren", "Darwin" };
        batchInsertMultipleFollowersAsFixture(names);

        // 2. assertion.
        for (String name : names) {
            Follower follower = (Follower) getSqlMapClientTemplate().queryForObject(
                    "com.alibaba.cobar.client.entities.Follower.finaByName", name);
            assertNotNull(follower);
        }
    }
View Full Code Here

        String[] names = { "Aaron", "Amily", "Aragon", "Darren", "Darwin" };
        batchInsertMultipleFollowersAsFixture(names);

        String nameSuffix = "Wang";
        for (String name : names) {
            Follower follower = (Follower) getSqlMapClientTemplate().queryForObject(
                    "com.alibaba.cobar.client.entities.Follower.finaByName", name);
            assertNotNull(follower);
            follower.setName(follower.getName() + nameSuffix);
            getSqlMapClientTemplate().update("com.alibaba.cobar.client.entities.Follower.update",
                    follower);

            Long id = follower.getId();

            follower = null;
            follower = (Follower) getSqlMapClientTemplate().queryForObject(
                    "com.alibaba.cobar.client.entities.Follower.finaByName", name);
            assertNull(follower);

            follower = (Follower) getSqlMapClientTemplate().queryForObject(
                    "com.alibaba.cobar.client.entities.Follower.load", id);
            assertNotNull(follower);
            assertEquals(name + nameSuffix, follower.getName());
        }

    }
View Full Code Here

    }

    protected void batchInsertMultipleFollowersAsFixture(String[] names) {
        List<Follower> followers = new ArrayList<Follower>();
        for (String name : names) {
            followers.add(new Follower(name));
        }

        BatchInsertTask task = new BatchInsertTask(followers);
        getSqlMapClientTemplate().insert("com.alibaba.cobar.client.entities.Follower.batchInsert",
                task);
View Full Code Here

                "META-INF/spring/sqlaction-sharding-router-appctx.xml" });
    }
   
    public void testInsertOnCobarSqlMapClientTemplateWithFollowerA() {
        String name = "Aranda";
        Follower follower = new Follower(name);
        getSqlMapClientTemplate().insert("com.alibaba.cobar.client.entities.Follower.create",
                follower);

        String confirmSQL = "select name from followers where name='" + name + "'";
        verifyEntityExistenceOnSpecificDataSource(confirmSQL, jt1m);
View Full Code Here

        verifyEntityNonExistenceOnSpecificDataSource(confirmSQL, jt2s);
    }

    public void testInsertOnCobarSqlMapClientTemplateWithFollowerD() {
        String name = "Darl";
        Follower follower = new Follower(name);
        getSqlMapClientTemplate().insert("com.alibaba.cobar.client.entities.Follower.create",
                follower);

        String confirmSQL = "select name from followers where name='" + name + "'";
        verifyEntityNonExistenceOnSpecificDataSource(confirmSQL, jt1m);
View Full Code Here

        verifyEntityNonExistenceOnSpecificDataSource(confirmSQL, jt2s);
    }

    public void testInsertOnCobarSqlMapClientTemplateWithFollowerNonAorD() {
        String name = "Sara";
        Follower follower = new Follower(name);
        getSqlMapClientTemplate().insert("com.alibaba.cobar.client.entities.Follower.create",
                follower);

        String confirmSQL = "select name from followers where name='" + name + "'";
        verifyEntityExistenceOnSpecificDataSource(confirmSQL, jt1m);
View Full Code Here

    public void testQueryForObjectOnCobarSqlMapClientTemplate() {
        batchInsertMultipleFollowersAsFixture(names);

        for (String name : names) {
            Follower follower = (Follower) getSqlMapClientTemplate().queryForObject(
                    "com.alibaba.cobar.client.entities.Follower.finaByName", name);
            if (name.startsWith("A")) {
                assertNotNull(follower);
            }
            if (name.startsWith("D")) {
                assertNull(follower);
            }
        }

        String name = "Jesus";
        int count = jt2m.update("insert into followers(name) values(?)", new Object[] { name });
        if (count == 1) {
            Follower f = (Follower) getSqlMapClientTemplate().queryForObject(
                    "com.alibaba.cobar.client.entities.Follower.finaByName", name);
            assertNull(f);
        }

        Follower follower = new Follower(name);
        Object pk = getSqlMapClientTemplate().insert(
                "com.alibaba.cobar.client.entities.Follower.create", follower);
        if (pk != null) {
            Follower f = (Follower) getSqlMapClientTemplate().queryForObject(
                    "com.alibaba.cobar.client.entities.Follower.finaByName", name);
            assertNotNull(f);
            assertEquals(name, f.getName());
        } else {
            logger.warn("failed to create fixture Follower object.");
        }
    }
View Full Code Here

        batchInsertMultipleFollowersAsFixture(names);
       
        List<Follower> followersToUpdate = new ArrayList<Follower>();
        for(String name:names)
        {
            Follower follower = (Follower)getSqlMapClientTemplate().queryForObject("com.alibaba.cobar.client.entities.Follower.finaByName", name);
            if(follower != null)
            {
                followersToUpdate.add(follower);
            }
            else
            {
                follower = (Follower)jt2m.queryForObject("select * from followers where name=?", new Object[]{name}, new RowMapper(){
                    public Object mapRow(ResultSet rs, int rowNum) throws SQLException {
                        Follower f = new Follower();
                        f.setId(rs.getLong(1));
                        f.setName(rs.getString(2));
                        return f;
                    }});
                followersToUpdate.add(follower);
            }
        }
        assertEquals(5, followersToUpdate.size());
       
        for(Follower follower:followersToUpdate)
        {
            follower.setName(follower.getName().toUpperCase());
            int affectedRows = getSqlMapClientTemplate().update("com.alibaba.cobar.client.entities.Follower.update", follower);
            if(follower.getName().startsWith("A"))
            {
                assertEquals(1, affectedRows);
                Follower f = (Follower)getSqlMapClientTemplate().queryForObject("com.alibaba.cobar.client.entities.Follower.load",follower.getId());
                assertEquals(follower.getName(), f.getName());
            }
            else
            {
                assertEquals(0, affectedRows);
            }
View Full Code Here

                "META-INF/spring/sqlaction-router-appctx.xml" });
    }

    public void testInsertOnCobarSqlMapClientWithSqlActionOnlyRules() {
        String name = "Darren";
        Follower follower = new Follower(name);
        getSqlMapClientTemplate().insert("com.alibaba.cobar.client.entities.Follower.create",
                follower);
        // since no rule for this insert, it will be inserted into default data source, that's, partition1
        String confirmSQL = "select name from followers where name='" + name + "'";
        verifyEntityExistenceOnSpecificDataSource(confirmSQL, jt1m);
        verifyEntityNonExistenceOnSpecificDataSource(confirmSQL, jt1s);
        verifyEntityNonExistenceOnSpecificDataSource(confirmSQL, jt2m);
        verifyEntityNonExistenceOnSpecificDataSource(confirmSQL, jt2s);
        // this sql action is routed to partition2, so can't find any matched record.
        Follower followerToFind = (Follower) getSqlMapClientTemplate().queryForObject(
                "com.alibaba.cobar.client.entities.Follower.finaByName", name);
        assertNull(followerToFind);
        // sql action below will be against all of the partitions , so we will get back what we want here
        @SuppressWarnings("unchecked")
        List<Follower> followers = (List<Follower>) getSqlMapClientTemplate().queryForList(
View Full Code Here

TOP

Related Classes of com.alibaba.cobar.client.entities.Follower

Copyright © 2018 www.massapicom. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.