Navigation :

Source code

Tip №1: Avoid using generating data model from packages

Click to view static registry initialization via annotations example:

 1@KITTY_DATABASE(
 2        databaseName = "basic_database",
 3        domainPackageNames = {"net.akaish.kittyormdemo.sqlite.basicdb"},
 4        logTag = LOG_TAG,
 5        isLoggingOn = true,
 6        isProductionOn = true,
 7        isPragmaOn = true
 8)
 9@KITTY_DATABASE_REGISTRY(
10        // You can just define set of domain models and extended crud controllers (mappers) would
11        // be added only if those models are annotated with KITTY_EXTENDED_CRUD annotation.
12        // For example, for ComplexRandom.class it would be 
13        // @KITTY_EXTENDED_CRUD(extendedCrudController = ComplexRandomMapper.class)
14        domainModels = {
15                ComplexRandomModel.class,
16                IndexesAndConstraintsModel.class,
17                RandomModel.class
18        },
19        // Or you can provide explicit assignment of model->mapper pairs by defining domainPais
20        domainPairs = {
21                @KITTY_REGISTRY_PAIR(model = ComplexRandomModel.class, mapper = ComplexRandomMapper.class),
22                @KITTY_REGISTRY_PAIR(model = IndexesAndConstraintsModel.class),
23                @KITTY_REGISTRY_PAIR(model = RandomModel.class, mapper = RandomMapper.class)
24        }
25)
26public class BasicDatabase extends KittyDatabase {
27    ...
28}
29

Click to view static registry initialization via overloading getStaticRegistry() method example:

 1@KITTY_DATABASE(
 2        databaseName = "basic_database",
 3        logTag = LOG_TAG,
 4        isLoggingOn = true,
 5        isProductionOn = true,
 6        isPragmaOn = true
 7)
 8public class BasicDatabase extends KittyDatabase {
 9
10    public static final Map<Class<? extends KittyModel>, Class<? extends KittyMapper>> staticRegistry = new HashMap<>();
11
12    static {
13        staticRegistry.put(ComplexRandomModel.class, ComplexRandomMapper.class);
14        staticRegistry.put(IndexesAndConstraintsModel.class, KittyMapper.class);
15        staticRegistry.put(RandomModel.class, RandomMapper.class);
16    }
17
18    public static final String LOG_TAG = "BASIC DB DEMO";
19
20    /**
21     * KittyORM main database class that represents bootstrap and holder for all related with database
22     * components.
23     * <br> See {@link KittyDatabase#KittyDatabase(Context, String)} for more info.
24     *
25     * @param ctx
26     */
27    public BasicDatabase(Context ctx) {
28        super(ctx);
29    }
30
31    @Override
32    protected Map<Class, Class<KittyMapper>> getStaticRegistry() {
33        return (Map) staticRegistry;
34    }
35}
36

Tip №2: Avoid multiply initialization of `KittyDatabase`

Click to view KittyDatabase implementation static initialization at Application implementation example:

 1public class AwesomeApplication extends Application {
 2
 3	private static AwesomeKittyDatabaseImplementation database;
 4
 5	public void onCreate() {
 6		super.onCreate();
 7		AwesomeApplication.database = new AwesomeKittyDatabaseImplementation(getApplicationContext());
 8	}
 9
10	public static AwesomeKittyDatabaseImplementation getAwesomeDB() {
11		return database;
12	}
13}
14

Tip №3: Optimize your data model and statements

Click to view INDEX declaration with KittyORM example:

 1@KITTY_TABLE(tableName = "cai")
 2@INDEX(indexColumns = {"creation_date"}) // Index declaration example №1
 3public class IndexesAndConstraintsModel extends KittyModel {
 4
 5
 6    ...
 7
 8    @KITTY_COLUMN(columnOrder = 5)
 9    @DEFAULT(
10            predefinedLiteralValue = LiteralValues.CURRENT_TIMESTAMP
11    )
12    // Index declaration example №2
13    @ONE_COLUMN_INDEX(unique = true, indexName = "IAC_unique_index_creation_timestamp")
14    @NOT_NULL
15    public Timestamp creationTmstmp;
16
17    ...
18}
19

Click to view bulk insert operation in transaction mode with KittyORM example:

 1void insertIntoDB() {
 2    // Getting mapper instance and filling model collection with random models
 3    RNDRandomModelFactory rndFactory = new RNDRandomModelFactory(Lesson2Tab5Random.this.getContext());
 4    RandomMapper mapper = (RandomMapper) getDatabase().getMapper(RandomModel.class);
 5    List<RandomModel> toInsert = new ArrayList<>();
 6    for(int i = 0; i < 50000; i++)
 7        toInsert.add(rndFactory.newRandomModel());
 8            
 9     // Saving list of 50k models in transaction mode
10     mapper.insertInTransaction(toInsert);
11           
12     // Closing mapper
13     mapper.close();
14}
15

Tip №6: Turn off logging at production

Click to view logging settings example:

 1@KITTY_DATABASE(
 2        isLoggingOn = false, // By default false, bootstrap and error logging
 3        isProductionOn = true, // By default true, when false - query logging
 4        isKittyDexUtilLoggingEnabled = false, // By default false, when true - a lot of logging about classes in app namespace at initialization
 5        databaseName = "mig",
 6        domainPackageNames = {"net.akaish.kittyormdemo.sqlite.migrations.migv4"},
 7        databaseVersion = 4,
 8        logTag = MigrationDBv4.LTAG
 9)
10public class MigrationDBv4 extends KittyDatabase {
11    ...
12}
13

Tip №7: Run expensive operations not in UI thread

Click to view example of KittyORM in AsyncTask: