Android Question Direct access sqlite database from device.

[Eme Fibonacci]

sqlitestudio has a plugin that allows you to access SQLite database from device.

(DbAndroid plugin)

The sqlitestudio page says: (adapted)

#AdditionalJar: SQLiteStudioRemote


and add this line in java to code:

SQLiteStudioService.instance().start(this);

and sqlitestudio would be able to access the database directly from the device.

How to run this java in B4A?

SQLiteStudioService.instance().start(this);

Thank you.

 

[Erel]

You need to use JavaObject.InitializeState with the full class name.

 

[b4auser1]

You need to use JavaObject.InitializeState with the full class name.

Do you mean InitializeStatic ?
Something like this:

Dim bo As JavaObject
Dim SQLiteStudioService As JavaObject = bo.InitializeStatic("pl.com.salsoft.sqlitestudioremote.SQLiteStudioService")
Dim instance As JavaObject = SQLiteStudioService.RunMethod("instance")
Dim joActivity As JavaObject = Activity
instance.RunMethod("start", Array As Object(joActivity))

 

[Erel]

Hard to say without seeing the documentation.

Maybe:

Dim context As JavaObject
context.InitializeContext
Dim SQLiteStudioService As JavaObject
SQLiteStudioService .InitializeStatic("pl.com.salsoft.sqlitestudioremote.SQLiteStudioService") _
       .RunMethodJO("instance", null).RunMethod("start", Array (context))

 

[b4auser1]

From the documentation:

The final code should look something like that:

// ...
import pl.com.salsoft.sqlitestudioremote.SQLiteStudioService;
public class MainActivity extends ActionBarActivity {
    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);
        SQLiteStudioService.instance().start(this);
    }
    @Override
    public void onDestroy() {
        SQLiteStudioService.instance().stop();
        super.onDestroy();
    }
    // ...
}

 

[Erel]

The code I posted should work.

 

[Eme Fibonacci]

I did not have sucess in to make it work.

If anyone is interested in using the plugin and make it work with B4A please tell me how.

SQLitestudio - DbAndroid plugin

Thank you.