android中数据库 用mysql的多,如何从Android Room中的多个数据库中选择（如何附加数据库）...

As you know we can select from multiple databases using attach command like this:

String path = DBHelper.getDatabasePath(context);

String sql = "ATTACH DATABASE '" + path + "/" + dbname.toString()

+ ".db' AS \"" + dbname.toString() + "\";";

db.execSQL(sql);

Then by using Cursor, we can do select from them.

By using Android Room, How can I do this? Is there any attachment or similar command to do this?

解决方案

Can use this code for attach another database

@Database(entities = {Book.class, User.class}, version = 1)

public abstract class LoanDatabase extends RoomDatabase {

public abstract UserDao userDao();

public abstract BookDao bookDao();

private static LoanDatabase INSTANCE;

public static LoanDatabase getInstance(Context context,final String attachDatabaseName) {

if (INSTANCE == null) {{

INSTANCE = Room.databaseBuilder(context,

LoanDatabase.class, "LoanDatabase").addCallback(new Callback() {

@Override

public void onOpen(@NonNull SupportSQLiteDatabase db) {

attach(attachDatabaseName,"/data/data/com.test.roomwithdagger/databases/");

super.onOpen(db);

}

})

.build();

}}

return INSTANCE;

}

private static void attach(final String databaseName, final String databasePath) {

String sql = "ATTACH DATABASE '" + databasePath + databaseName

+ "' AS \"" + databaseName + "\";";

INSTANCE. mDatabase.execSQL(sql);

}

}

public void attachDatabase(String databaseName,String databasePath){

String sql = "ATTACH DATABASE '" + databasePath + "/" + databaseName

+ ".db' AS \"" + databaseName + "\";";

INSTANCE.mDatabase.execSQL(sql);

}

}

In Dao interface use @SkipQueryVerification for skip query verification like this.

@Dao

public interface BookDao {

...

@SkipQueryVerification

@Query("SELECT * FROM main.Book b INNER JOIN LoanDatabase1.Loan l on b.Id=l.BookId where b.Id=:bookId")

Book getBookAndLoan(int bookId);

...

}

Use :

LoanDatabase db = LoanDatabase.getInstance(this,"LoanDatabase1")

Book book= db.bookDao().getBookAndLoan(1)