Day 19 - GreenDAO

1
include ':app', ':DaoGenerator'

1
project(':DaoGenerator') {
2
    apply plugin: 'application'
3
    apply plugin: 'java'
4

5
    mainClassName = "com.devahoy.learn30androidlibraries.daogenerator.MyDaoGenerator"
6
    outputDir = "../app/src/main/java-gen"
7

8
    dependencies {
9
        compile fileTree(dir: 'libs', include: ['*.jar'])
10
        compile('de.greenrobot:DaoGenerator:1.3.0')
11
    }
12

13
    task createDocs {
14
        def docs = file(outputDir)
15
        docs.mkdirs()
16
    }
17

18
    run {
19
        args outputDir
20
    }
21
}

1
package com.devahoy.learn30androidlibraries.daogenerator;
2

3
import java.io.File;
4

5
import de.greenrobot.daogenerator.DaoGenerator;
6
import de.greenrobot.daogenerator.Entity;
7
import de.greenrobot.daogenerator.Schema;
8

9
public class MyDaoGenerator {
10

11
    public static void main(String[] args) throws Exception {
12
        Schema schema = new Schema(1, "com.devahoy.learn30androidlibraries");
13
        Entity player = schema.addEntity("Player");
14

15
        player.addIdProperty();
16
        player.addStringProperty("name");
17
        player.addStringProperty("club");
18

19
        new DaoGenerator().generateAll(schema, args[0]);
20
    }
21
}

1
android {
2
    sourceSets {
3
        main {
4
            java {
5
                srcDir 'src/main/java'
6
                // for greenDAO
7
                srcDir 'src/main/java-gen'
8
            }
9
        }
10
    }
11
}
12
dependencies {
13
    compile 'de.greenrobot:greendao:1.3.7'
14
}

1
package com.devahoy.learn30androidlibraries.day19;
2

3
import android.app.Application;
4
import android.database.sqlite.SQLiteDatabase;
5

6
import com.devahoy.learn30androidlibraries.DaoMaster;
7
import com.devahoy.learn30androidlibraries.DaoSession;
8

9
public class GreenDaoApplication extends Application {
10

11
    DaoSession mDaoSession;
12

13
    @Override
14
    public void onCreate() {
15
        super.onCreate();
16
        setupDatabase();
17
    }
18

19
    private void setupDatabase() {
20
        DaoMaster.DevOpenHelper helper =
21
                new DaoMaster.DevOpenHelper(this, "MyGreenDao.db", null);
22
        SQLiteDatabase db = helper.getWritableDatabase();
23
        DaoMaster daoMaster = new DaoMaster(db);
24
        mDaoSession = daoMaster.newSession();
25
    }
26

27
    public DaoSession getDaoSession() {
28
        return mDaoSession;
29
    }
30
}

1
<manifest xmlns:android="http://schemas.android.com/apk/res/android"
2
    package="com.devahoy.learn30androidlibraries" >
3
    <application
4
        ...
5
        android:name=".day19.GreenDaoApplication">
6
        <activity>
7
            ...
8
        </activity>
9
    </application>
10

11
</manifest>

1
package com.devahoy.learn30androidlibraries.day19;
2

3
import android.app.ListActivity;
4
import android.os.Bundle;
5
import android.widget.ArrayAdapter;
6

7
import com.devahoy.learn30androidlibraries.DaoSession;
8
import com.devahoy.learn30androidlibraries.Player;
9
import com.devahoy.learn30androidlibraries.PlayerDao;
10

11
import java.util.ArrayList;
12
import java.util.List;
13

14
public class GreenDAOActivity extends ListActivity {
15

16
    ArrayList<String> mDataset = new ArrayList<String>();
17

18
    @Override
19
    protected void onCreate(Bundle savedInstanceState) {
20
        super.onCreate(savedInstanceState);
21

22
        ArrayAdapter<String> adapter = new ArrayAdapter<String>(this,
23
                android.R.layout.simple_list_item_1, mDataset);
24
        setListAdapter(adapter);
25
    }
26
}

1
Player player = new Player(1L, "my name", "my club");
2
PlayerDAO.insert(player);

1
PlayerDAO.loadAll();
2
PlayerDao.load(key); // query แบบระบุ id

1
oldPlayer;
2
PlayerDAO.update(oldPlayer);

1
PlayerDAO.delete(player);
2
PlayerDAO.deleteByKey(id);
3
PlayerDAO.deleteAll();

1
package com.devahoy.learn30androidlibraries.day19;
2

3
import android.app.ListActivity;
4
import android.os.Bundle;
5
import android.widget.ArrayAdapter;
6

7
import com.devahoy.learn30androidlibraries.DaoSession;
8
import com.devahoy.learn30androidlibraries.Player;
9
import com.devahoy.learn30androidlibraries.PlayerDao;
10

11
import java.util.ArrayList;
12
import java.util.List;
13

14
public class GreenDAOActivity extends ListActivity {
15

16
    GreenDaoApplication mApplication;
17
    DaoSession mDaoSession;
18
    PlayerDao mPlayerDao;
19
    ArrayList<String> mDataset = new ArrayList<String>();
20

21
    @Override
22
    protected void onCreate(Bundle savedInstanceState) {
23
        super.onCreate(savedInstanceState);
24

25
        mApplication = (GreenDaoApplication) getApplication();
26
        mDaoSession = mApplication.getDaoSession();
27

28
        initSampleData();
29

30
        ArrayAdapter<String> adapter = new ArrayAdapter<String>(this,
31
                android.R.layout.simple_list_item_1, mDataset);
32
        setListAdapter(adapter);
33
    }
34

35
    void initSampleData() {
36
        mPlayerDao = mDaoSession.getPlayerDao();
37

38
        mPlayerDao.deleteAll();
39

40
        Player messi = new Player(1L, "Leonel Messi", "FC Barcelona");
41
        Player ronaldo = new Player(2L, "Cristiano Ronaldo", "Real Madrid");
42
        Player gerrard = new Player(3L, "Steven Gerrard", "Liverpool");
43
        Player persie = new Player(4L, "Robin Van Persie", "Man Utd");
44
        Player teerasil = new Player(5L, "Teerasil Dangda", "UD Almeria");
45

46
        mPlayerDao.insert(messi);
47
        mPlayerDao.insert(ronaldo);
48
        mPlayerDao.insert(gerrard);
49
        mPlayerDao.insert(persie);
50
        mPlayerDao.insert(teerasil);
51

52
        mDataset = new ArrayList<String>();
53

54
        List<Player> players = mPlayerDao.loadAll();
55
        for (Player player : players) {
56
            mDataset.add("Name : " + player.getName() + "\nClub : " + player.getClub());
57
        }
58
    }
59
}