edisonliao / dbdemo Goto Github PK

android {
 
    greendao {
        //指定数据库schema版本号，迁移等操作会用到
        schemaVersion 1
        //DaoSession、DaoMaster以及所有实体类的dao生成的目录
        //daoPackage 包名
        daoPackage 'com.example.liaoshouwang.dbdemo.greendaodb'
        //工程路径
        targetGenDir 'src/main/java'
    }
}

//默认每次升级会把数据库中的数据清除
/** WARNING: Drops all table on Upgrade! Use only during development. */
    public static class DevOpenHelper extends OpenHelper {
        public DevOpenHelper(Context context, String name) {
            super(context, name);
        }

        public DevOpenHelper(Context context, String name, CursorFactory factory) {
            super(context, name, factory);
        }

        @Override
        public void onUpgrade(Database db, int oldVersion, int newVersion) {
            Log.i("greenDAO", "Upgrading schema from version " + oldVersion + " to " + newVersion + " by dropping all tables");
            dropAllTables(db, true);
            onCreate(db);
        }
    }

Room.databaseBuilder(getApplicationContext(), MyDb.class, "database-name")
        .addMigrations(MIGRATION_1_2, MIGRATION_2_3).build();

//1，2是对应的旧、新的数据库版本
static final Migration MIGRATION_1_2 = new Migration(1, 2) {
    @Override
    public void migrate(SupportSQLiteDatabase database) {
        database.execSQL("CREATE TABLE `Fruit` (`id` INTEGER, "
                + "`name` TEXT, PRIMARY KEY(`id`))");
    }
};

static final Migration MIGRATION_2_3 = new Migration(2, 3) {
    @Override
    public void migrate(SupportSQLiteDatabase database) {
        database.execSQL("ALTER TABLE Book "
                + " ADD COLUMN pub_year INTEGER");
    }
};

/** A raw-style query where you can pass any WHERE clause and arguments. */
    public List<T> queryRaw(String where, String... selectionArg) {
        Cursor cursor = db.rawQuery(statements.getSelectAll() + where, selectionArg);
        return loadAllAndCloseCursor(cursor);
    }

    /**
     * Creates a repeatable {@link Query} object based on the given raw SQL where you can pass any WHERE clause and
     * arguments.
     */
    public Query<T> queryRawCreate(String where, Object... selectionArg) {
        List<Object> argList = Arrays.asList(selectionArg);
        return queryRawCreateListArgs(where, argList);
    }

SELECT T."_id",T."NAME",T."AGE" FROM "GREEN_USER" T 

@Dao
interface RoomUserDao {

    @Query("SELECT * FROM ROOM_USER")
    fun getRoomUsers(): List<RoomUser>

    @Insert
    fun insertAll(users:List<RoomUser>)

    @Query("DELETE FROM ROOM_USER")
    fun deleteAll()


}

@Dao
interface MyAppReportDataDao {

    //本周每天的点击次数，intervalDay栗子：-7 day 指定的日期往前回滚7天，
    //datetime('now','start of day',:intervalDay)，当前日期往前回滚intervalDay天
    @Query("SELECT count(*) as times ,time_date as date " +
            "FROM ( SELECT * FROM MY_APP_REPORT_DATA WHERE time_date>=datetime('now','start of day',:intervalDay) " +
            "AND time_date<=datetime('now','localtime')) WHERE time_date>=datetime(time_date,'start of day','+0 day') " +
            "AND time_date<datetime(time_date,'start of day','+1 day') group by date(time_date)")
    fun getLineDataByWeek(intervalDay:String):LiveData<List<ReportLineData>>

liteOrm.query(new QueryBuilder<Book>(Book.class)
        .columns(new String[]{"id", "author", Book.COL_INDEX})
        .distinct(true)
        .whereGreaterThan("id", 0)
        .whereAppendAnd()
        .whereLessThan("id", 10000)
        .limit(6, 9)
        .appendOrderAscBy(Book.COL_INDEX));