问题描述
例如如何在sqflite中存储复杂类型:餐桌上的人(身份证,姓名,电子邮件,汽车列表);汽车在哪里是具有ID和类型的实体?有什么解决方案,例如如何存储它(例如Blob或在新表中并将其链接到人员表)?
how to store complex type in sqflite for example :the table person(id,name,email,List cars);where the car is an entity that have an id and a type ?is there any solution like how to store it (like a Blob or in a new table and link it to the person table ) ?
推荐答案
您不能在一个简单的表中.我了解您的意思,例如,您想存储以下内容:
You can´t in a simple table. I understand your point, you want to store, for example, something like this:
citizen = {
"name":"",
"id":"",
"childrens":{
children1:{
"name":"",
"id":"",
}
children2:{
"name":"",
"id":"",
}
}
}
这是因为sqflite是使用设备sqlite的工具,并且该数据库在apache软件下工作.这意味着Sqflite会存储数据,而sql DB会存储数据,而您不能在sql表中存储对象.
This is because sqflite is a tool to use the device sqlite and this DB works under apache software. That means, Sqflite stores data as well sql DB stores data and you can't store objects in a sql table.
您应根据需要为每个复杂数据创建其他表.像这样的东西(作为伪代码):
You should create other table for each complex data as you need. Something like this (as pseudocode):
'CREATE TABLE Citizen ('
' id INTEGER PRIMARY KEY,'
' name TEXT,'
' children1Id INTEGER,'
' children2Id INTEGER,'
'); '
'CREATE TABLE Children ('
' id INTEGER PRIMARY KEY,'
' name TEXT'
')'
我希望这会对您有所帮助.
I hope this will help you.
这篇关于将复杂类型存储在Fluf sqflite中的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!