Examples with Filter com.orm.androrm.Filter used on opensource projects

Example 1 with Filter

use of com.orm.androrm.Filter in project androrm by androrm.

the class FilterTest method testIs.

public void testIs() {
    Filter f = new Filter();
    f.is("product__name", "foo");
    List<Rule> filters = f.getRules();
    Rule filter = filters.get(0);
    Statement s = filter.getStatement();
    Set<String> keys = s.getKeys();
    assertEquals("product__name", filter.getKey());
    assertTrue(keys.contains("name"));
    assertEquals("name = 'foo'", s.toString());
    Product p = new Product();
    p.setName("test product");
    p.save(getContext());
    f = new Filter();
    f.is("supplier__product", p);
    filters = f.getRules();
    filter = filters.get(0);
    s = filter.getStatement();
    keys = s.getKeys();
    assertEquals("supplier__product", filter.getKey());
    assertTrue(keys.contains("product"));
    assertEquals("product = '" + p.getId() + "'", s.toString());
}

Example 2 with Filter

use of com.orm.androrm.Filter in project androrm by androrm.

the class FilterTest method testContains.

public void testContains() {
    Filter set = new Filter();
    set.contains("supplier__name", "foo");
    List<Rule> filters = set.getRules();
    Rule filter = filters.get(0);
    Statement s = filter.getStatement();
    Set<String> keys = s.getKeys();
    assertEquals("supplier__name", filter.getKey());
    assertTrue(keys.contains("name"));
    assertTrue(s instanceof LikeStatement);
    assertEquals("name LIKE '%foo%'", s.toString());
}

Example 3 with Filter

use of com.orm.androrm.Filter in project androrm by androrm.

the class FilterTest method testIn.

public void testIn() {
    Filter set = new Filter();
    List<Integer> values = new ArrayList<Integer>();
    values.add(3);
    values.add(5);
    set.in("product__id", values);
    List<Rule> filters = set.getRules();
    Rule filter = filters.get(0);
    Statement s = filter.getStatement();
    Set<String> keys = s.getKeys();
    assertEquals("product__id", filter.getKey());
    assertTrue(keys.contains("id"));
    assertTrue(s instanceof InStatement);
    assertEquals("id IN ('3','5')", s.toString());
    List<Product> products = new ArrayList<Product>();
    Product p1 = new Product();
    p1.setName("test 1");
    p1.save(getContext());
    Product p2 = new Product();
    p2.setName("test 2");
    p2.save(getContext());
    products.add(p1);
    products.add(p2);
    set = new Filter();
    set.in("supplier__product", products);
    filters = set.getRules();
    filter = filters.get(0);
    s = filter.getStatement();
    keys = s.getKeys();
    assertEquals("supplier__product", filter.getKey());
    assertTrue(keys.contains("product"));
    assertTrue(s instanceof InStatement);
    assertEquals("product IN ('" + p1.getId() + "','" + p2.getId() + "')", s.toString());
}

Example 4 with Filter

use of com.orm.androrm.Filter in project androrm by androrm.

the class RenameModelMigrationTest method testRenameRelation.

public void testRenameRelation() {
    Migrator<NewModelWithRelation> migrator = new Migrator<NewModelWithRelation>(NewModelWithRelation.class);
    assertTrue(mHelper.hasRelationTable(ModelWithRelation.class));
    assertTrue(mHelper.tableExists("emptymodel_modelwithrelation"));
    ModelWithRelation model1 = new ModelWithRelation();
    model1.save(getContext());
    EmptyModel empty = new EmptyModel();
    empty.save(getContext());
    model1.addRelation(empty);
    model1.save(getContext());
    assertEquals(1, model1.getRelations(getContext()).count());
    assertEquals(0, NewModelWithRelation.objects(getContext()).count());
    migrator.renameModel("ModelWithRelation", NewModelWithRelation.class);
    migrator.migrate(getContext());
    NewModelWithRelation one = NewModelWithRelation.objects(getContext()).get(1);
    assertEquals(1, one.getRelations(getContext()).count());
    assertTrue(mHelper.hasRelationTable(NewModelWithRelation.class));
    assertFalse(mHelper.hasRelationTable(ModelWithRelation.class));
    assertFalse(mHelper.tableExists("emptymodel_modelwithrelation"));
    Filter filter = new Filter();
    filter.is("mModel", "newmodelwithrelation").is("mAction", "rename_relation").is("mValue", "emptymodel_modelwithrelation");
    assertEquals(1, Migration.objects(getContext()).filter(filter).count());
}

Example 5 with Filter

use of com.orm.androrm.Filter in project androrm by androrm.

the class FilterTest method testInFilterString.

public void testInFilterString() {
    Person tom = new Person();
    tom.setName("tom");
    tom.save(getContext());
    Person peter = new Person();
    peter.setName("peter");
    peter.save(getContext());
    Person susan = new Person();
    susan.setName("susan");
    susan.save(getContext());
    List<String> names = new ArrayList<String>();
    names.add("tom");
    names.add("peter");
    Filter filter = new Filter();
    filter.in("mName", names);
    QuerySet<Person> people = Person.objects(getContext()).filter(filter);
    assertEquals(2, people.count());
}