Comments (3)
I in general asked for this, one reason that this is beneficial is that we can not combine AND
and OR
clauses together when we need to run a reletivey complex query
example :
table chatRoom {
roomKey string
updatedTime int
isPined bool
archived bool
}
select * from chatroom where isPined = 1
union
select * from chatroom where archived = 0 AND updatedTime > 123
union
order by updatedTime desc
this is just an sample to illustrate my point for combing multiple where clause with diffrent OR and AND.
we can have this direct query in sqlite, but with orma we can not do this:
select * from chatroom where isPined = 1 OR ( archived = 0 AND updatedTime > 123 ) order by updatedTime desc
the current api that allows just one OR
s or AND
s is clean and i like it, but adding union support makes instead of running multiple query to database and then in java combine the result, we will just run one query.
from android-orma.
You can use rawQuery
, see https://github.com/gfx/Android-Orma#raw-queries
from android-orma.
Sounds great.
BTW what you expect the result type and value for UNION? Do you have an example models?
from android-orma.
Related Issues (20)
- ConcurrentModificationException in data-set changed events HOT 2
- Support to Android Architecture Components Paging Library
- how to run "vacuum" on the database? HOT 1
- how to run "analyze" on the database?
- ManualStepMigration is ignored at the first time (i.e. when DB version is 0) HOT 2
- Build Failed. when constructor has non column property at Kotlin. HOT 2
- Migration to Circle CI 2.0 HOT 1
- Use Robolectric 4.0 instead of Robolectric-Instrumentation HOT 1
- Best practice to search the values in direct associations HOT 3
- AndroidX support HOT 2
- deleter().execute() fails when using Direct Associations
- A link to expired methodscount.com domain is in README HOT 1
- FOREIGN KEY constraint failed
- Orma incompatible with Room?
- How to set Locale when create database?
- Request For New Maintainers
- Into the Sunset on May 1st: Bintray, JCenter, GoCenter, and ChartCenter HOT 3
- Could you please release next version for sqlcipher update? HOT 1
- Migrate from JCenter() to the mavenCentral() HOT 13
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from android-orma.