Sugar ORM 
Insanely easy way to work with Android databases.
Official documentation can be found here - Check some examples below. The example application is provided in the example folder in the source.
Looking for contributors
We need contributors to help maintain this project, ask @satyan for repo permission
Otherwise you can use another ORM, like https://github.com/requery/requery or https://realm.io/
Features
Sugar ORM was built in contrast to other ORM's to have:
- A simple, concise, and clean integration process with minimal configuration.
- Automatic table and column naming through reflection.
- Support for migrations between different schema versions.
Installing
There are four ways to install Sugar:
As a Gradle dependency
This is the preferred way. Simply add:
compile 'com.github.satyan:sugar:1.5'
to your project dependencies and run gradle build or gradle assemble.
As a Maven dependency
Declare the dependency in Maven:
<dependency>
<groupId>com.github.satyan</groupId>
<artifactId>sugar</artifactId>
<version>1.5</version>
</dependency>
As a library project
Download the source code and import it as a library project in Eclipse. The project is available in the folder library. For more information on how to do this, read here.
As a jar
Visit the releases page to download jars directly. You can drop them into your libs folder and configure the Java build path to include the library. See this tutorial for an excellent guide on how to do this.
How to use master version
First, download sugar repository
git clone [email protected]:satyan/sugar.git
include this in your settings.gradle
include ':app' // your module app
include ':sugar'
def getLocalProperty(prop) {
Properties properties = new Properties()
properties.load(new File(rootDir.absolutePath + '/local.properties').newDataInputStream())
return properties.getProperty(prop, '')
}
project(':sugar').projectDir = new File(getLocalProperty('sugar.dir'))
include this in your local.properties
sugar.dir=/path/to/sugar/library
add sugar project to the dependencies of your main project (build.gradle)
dependencies {
compile project(':sugar')
}
You should also comment this line just comment this line (library/build.gradle): https://github.com/satyan/sugar/blob/master/library%2Fbuild.gradle#L2
// apply from: '../maven_push.gradle'
===================
After installing, check out how to set up your first database and models here Outdated. Check examples of 1.4 and master below:
Examples
SugarRecord
public class Book extends SugarRecord {
@Unique
String isbn;
String title;
String edition;
// Default constructor is necessary for SugarRecord
public Book() {
}
public Book(String isbn, String title, String edition) {
this.isbn = isbn;
this.title = title;
this.edition = edition;
}
}
or
@Table
public class Book { ... }
Save Entity
Book book = new Book("isbn123", "Title here", "2nd edition")
book.save();
or
SugarRecord.save(book); // if using the @Table annotation
Load Entity
Book book = Book.findById(Book.class, 1);
Update Entity
Book book = Book.findById(Book.class, 1);
book.title = "updated title here"; // modify the values
book.edition = "3rd edition";
book.save(); // updates the previous entry with new values.
Delete Entity
Book book = Book.findById(Book.class, 1);
book.delete();
or
SugarRecord.delete(book); // if using the @Table annotation
Update Entity based on Unique values
Book book = new Book("isbn123", "Title here", "2nd edition")
book.save();
// Update book with isbn123
Book sameBook = new Book("isbn123", "New Title", "5th edition")
sameBook.update();
book.getId() == sameBook.getId(); // true
or
SugarRecord.update(sameBook); // if using the @Table annotation
Bulk Insert
List<Book> books = new ArrayList<>();
books.add(new Book("isbn123", "Title here", "2nd edition"))
books.add(new Book("isbn456", "Title here 2", "3nd edition"))
books.add(new Book("isbn789", "Title here 3", "4nd edition"))
SugarRecord.saveInTx(books);
When using ProGuard
# Ensures entities remain un-obfuscated so table and columns are named correctly
-keep class com.yourpackage.yourapp.domainclasspackage.** { *; }
Known Issues.
1. Instant Run.
Instant-Run seems to prevent Sugar ORM from finding the "table" classes, therefore it cannot create the DB tables if you run the app for the first time
When running your app for the first time Turn off Instant run once to allow for the DB tables to be created You can enable it after the tables have been created.
To disable Instant-Run in Android Studio:
(Preferences (Mac) or Settings (PC) -> Build, Execution, Deployment -> Instant Run -> Untick "Enable Instant Run..." )
CHANGELOG
Contributing
Please fork this repository and contribute back using pull requests. Features can be requested using issues. All code, comments, and critiques are greatly appreciated.
![no such table in [com.android.tools.build:gradle:2.0.0-beta6]](https://avatars.githubusercontent.com/u/5304798?v=4)
2.2k Jan 7, 2023
1.8k Dec 28, 2022
80 Nov 25, 2022
277 Dec 3, 2022
9 May 9, 2022
4 Jun 14, 2022
11.4k Jan 9, 2023
4.1k Dec 30, 2022
136 Nov 29, 2022
124 Nov 25, 2022
925 Dec 17, 2022
29 Dec 28, 2021
21 Oct 21, 2022
389 Sep 25, 2022
1.5k Dec 30, 2022
71 Nov 11, 2022
276 Jan 5, 2023
5 Sep 14, 2022
2.6k Dec 16, 2022