首页 \ 问答 \ 从Android应用程序调试SQLite数据库(Debugging SQLite Database from Android App)

从Android应用程序调试SQLite数据库(Debugging SQLite Database from Android App)

我正在编写一个带有SQLite数据库的Android应用程序。 该数据库由App创建,并存储在设备的默认目录中:

shell@android: ls /data/data/com.package.example/databases # 
MyDb.db
MyDb.db-journal

在开发过程中,我想测试一下,如果行正确插入/更新,那么我需要查看数据库。 有一个很好的工具叫做SQLite数据库浏览器 (适用于Win,Mac和Linux)。

有了这个工具,我可以打开数据库,浏览,插入和更新行,等等......问题是,我首先需要将数据库从设备复制到本地机器:

# On Android Shell
# (Cannot pull directly from /data/-directory)
cp /data/data/com.package.example/databases/MyDb.db /sdcard/


# On developing machine
adb pull /sdcard/MyDb.db

比我在我的机器上的数据库,我终于可以打开它。

我的问题是:有没有更好/更快捷的方法? 我可以以某种方式直接访问设备上的数据库吗?


I am writing an Android Application with a SQLite Database in the background. This Database gets created by the App, and is stored on the default directory on the device:

shell@android: ls /data/data/com.package.example/databases # 
MyDb.db
MyDb.db-journal

During development I want to test, if the rows are inserted / updated correctly, so I need to take a look on the database. There is a pretty nice tool called SQLite Database Browser (Available for Win, Mac and Linux).

With this tool I can open the database, browse, insert and update the rows and so on... The problem is, that I first need to copy the database from the device to my local machine:

# On Android Shell
# (Cannot pull directly from /data/-directory)
cp /data/data/com.package.example/databases/MyDb.db /sdcard/


# On developing machine
adb pull /sdcard/MyDb.db

Than I have the database on my machine and I can finally open it.

My Question is: Is there a better / quicker way of doing it? Can I somehow directly access the database on the device?


原文:https://stackoverflow.com/questions/31377969
更新时间:2023-09-25 07:09

最满意答案

你的例子有点简单。 你的实际问题可能是很多问题,但我会对最有可能发生的事情进行抨击。

如果目标是修改div的内容,那么答案就是根本不使用道具。 这正是你的国家所针对的!

var Banner = React.createClass({
    render: function() {
        return <div>this.state.word</div>
    },
    getInitialState: function(){
        return {word: this.props.word};
    }

    changeWord: function(word){
        this.setState({word: word});
    }
});

编辑:

如果您尝试从嵌入页面中其他位置的vanilla js修改组件:

我认为在这种情况下你最好的选择是利用一些(如果不是全部)Flux设计模式: https//facebook.github.io/flux/docs/overview.html#content

如果不是整个Flux范例,你至少可以利用Flux处理'Stores'的方式,它实际上只是Node.js EventEmmiters: https ://nodejs.org/api/events.html

var BannerStore = new EventEmmitter();

var Banner = React.createClass({
    render: function() {
        return <div>this.state.word</div>
    },
    getInitialState: function(){
        return {word: this.props.word};
    },
    changeWord: function(){
        this.setState({word: BannerStore.word});
    },

    componentDidMount: function(){
        BannerStore.on('banner_change', this.changeWord);
    },

    componentWillUnmount: function(){
        BannerStore.removeListener('banner_change', this.changeWord);
    }
});

function changeText(component, text){
    if(component === 'banner'){
        BannerStore.word = text;
        BannerStore.emit('banner_change');
    }
}
changeText(banner, 'Goodbye') 

从长远来看,使用全通量范式将更加清洁,但是可以合理地输入SO。


Your example is a bit to simplistic. Your actual problem could be a number of things, but I'll take a stab at what seems most likely.

If the goal is to have the content of your div be modified, then the answer is not to use props at all. That's exactly what your state is for!

var Banner = React.createClass({
    render: function() {
        return <div>this.state.word</div>
    },
    getInitialState: function(){
        return {word: this.props.word};
    }

    changeWord: function(word){
        this.setState({word: word});
    }
});

EDIT:

If you're trying to modify the component from vanilla js embedded elsewhere in the page:

I think your best bet in this case would be to leverage some (if not all) of the Flux design pattern: https://facebook.github.io/flux/docs/overview.html#content

If not the entire Flux paradigm, you could at the very least make use of the way Flux handles 'Stores', which are essentially just Node.js EventEmmiters: https://nodejs.org/api/events.html

var BannerStore = new EventEmmitter();

var Banner = React.createClass({
    render: function() {
        return <div>this.state.word</div>
    },
    getInitialState: function(){
        return {word: this.props.word};
    },
    changeWord: function(){
        this.setState({word: BannerStore.word});
    },

    componentDidMount: function(){
        BannerStore.on('banner_change', this.changeWord);
    },

    componentWillUnmount: function(){
        BannerStore.removeListener('banner_change', this.changeWord);
    }
});

function changeText(component, text){
    if(component === 'banner'){
        BannerStore.word = text;
        BannerStore.emit('banner_change');
    }
}
changeText(banner, 'Goodbye') 

Using full flux paradigm will be cleaner in the long run, but is more than can be reasonably typed into SO.

相关问答

更多

相关文章

更多

最新问答

更多
  • 您如何使用git diff文件,并将其应用于同一存储库的副本的本地分支?(How do you take a git diff file, and apply it to a local branch that is a copy of the same repository?)
  • 将长浮点值剪切为2个小数点并复制到字符数组(Cut Long Float Value to 2 decimal points and copy to Character Array)
  • OctoberCMS侧边栏不呈现(OctoberCMS Sidebar not rendering)
  • 页面加载后对象是否有资格进行垃圾回收?(Are objects eligible for garbage collection after the page loads?)
  • codeigniter中的语言不能按预期工作(language in codeigniter doesn' t work as expected)
  • 在计算机拍照在哪里进入
  • 使用cin.get()从c ++中的输入流中丢弃不需要的字符(Using cin.get() to discard unwanted characters from the input stream in c++)
  • No for循环将在for循环中运行。(No for loop will run inside for loop. Testing for primes)
  • 单页应用程序:页面重新加载(Single Page Application: page reload)
  • 在循环中选择具有相似模式的列名称(Selecting Column Name With Similar Pattern in a Loop)
  • System.StackOverflow错误(System.StackOverflow error)
  • KnockoutJS未在嵌套模板上应用beforeRemove和afterAdd(KnockoutJS not applying beforeRemove and afterAdd on nested templates)
  • 散列包括方法和/或嵌套属性(Hash include methods and/or nested attributes)
  • android - 如何避免使用Samsung RFS文件系统延迟/冻结?(android - how to avoid lag/freezes with Samsung RFS filesystem?)
  • TensorFlow:基于索引列表创建新张量(TensorFlow: Create a new tensor based on list of indices)
  • 企业安全培训的各项内容
  • 错误:RPC失败;(error: RPC failed; curl transfer closed with outstanding read data remaining)
  • C#类名中允许哪些字符?(What characters are allowed in C# class name?)
  • NumPy:将int64值存储在np.array中并使用dtype float64并将其转换回整数是否安全?(NumPy: Is it safe to store an int64 value in an np.array with dtype float64 and later convert it back to integer?)
  • 注销后如何隐藏导航portlet?(How to hide navigation portlet after logout?)
  • 将多个行和可变行移动到列(moving multiple and variable rows to columns)
  • 提交表单时忽略基础href,而不使用Javascript(ignore base href when submitting form, without using Javascript)
  • 对setOnInfoWindowClickListener的意图(Intent on setOnInfoWindowClickListener)
  • Angular $资源不会改变方法(Angular $resource doesn't change method)
  • 在Angular 5中不是一个函数(is not a function in Angular 5)
  • 如何配置Composite C1以将.m和桌面作为同一站点提供服务(How to configure Composite C1 to serve .m and desktop as the same site)
  • 不适用:悬停在悬停时:在元素之前[复制](Don't apply :hover when hovering on :before element [duplicate])
  • 常见的python rpc和cli接口(Common python rpc and cli interface)
  • Mysql DB单个字段匹配多个其他字段(Mysql DB single field matching to multiple other fields)
  • 产品页面上的Magento Up出售对齐问题(Magento Up sell alignment issue on the products page)