Repository navigation
Expand file tree
/
Copy pathDemoDb.dart
More file actions
172 lines (142 loc) · 4.09 KB
/
Copy pathDemoDb.dart
File metadata and controls
172 lines (142 loc) · 4.09 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
import 'dart:async';
import 'dart:convert';
import 'package:gsy_github_app_flutter/common/model/User.dart';
import 'package:meta/meta.dart';
import 'package:sqflite/sqflite.dart';
/**
* Created by guoshuyu
* Date: 2018-08-06
*/
///数据库管理
class DemoSqlManager {
static final _VERSION = 1;
static final _NAME = "demo_github_app_flutter.db";
static Database _database;
///初始化
static init() async {
// open the database
var databasesPath = await getDatabasesPath();
String path = databasesPath + _NAME;
_database = await openDatabase(path, version: _VERSION, onCreate: (Database db, int version) async {
// When creating the db, create the table
//await db.execute("CREATE TABLE Test (id INTEGER PRIMARY KEY, name TEXT, value INTEGER, num REAL)");
});
}
/**
* 表是否存在
*/
static isTableExits(String tableName) async {
await getCurrentDatabase();
var res = await _database.rawQuery("select * from Sqlite_master where type = 'table' and name = '$tableName'");
return res != null && res.length > 0;
}
///获取当前数据库对象
static Future<Database> getCurrentDatabase() async {
if (_database == null) {
await init();
}
return _database;
}
///关闭
static close() {
if (_database != null) {
_database.close();
_database = null;
}
}
}
///数据库数据提供的抽象基类
abstract class DemoBaseDbProvider {
bool isTableExits = false;
tableSqlString();
tableName();
tableBaseString(String name, String columnId) {
return '''
create table $name (
$columnId integer primary key autoincrement,
''';
}
Future<Database> getDataBase() async {
return await open();
}
@mustCallSuper
prepare(name, String createSql) async {
isTableExits = await DemoSqlManager.isTableExits(name);
if (!isTableExits) {
Database db = await DemoSqlManager.getCurrentDatabase();
return await db.execute(createSql);
}
}
@mustCallSuper
open() async {
if (!isTableExits) {
await prepare(tableName(), tableSqlString());
}
return await DemoSqlManager.getCurrentDatabase();
}
}
/**
* 用户表
*/
class DemoUserInfoDbProvider extends DemoBaseDbProvider {
final String name = 'UserInfo';
final String columnId = "_id";
final String columnUserName = "userName";
final String columnData = "data";
int id;
String userName;
String data;
DemoUserInfoDbProvider();
Map<String, dynamic> toMap(String userName, String data) {
Map<String, dynamic> map = {columnUserName: userName, columnData: data};
if (id != null) {
map[columnId] = id;
}
return map;
}
DemoUserInfoDbProvider.fromMap(Map map) {
id = map[columnId];
userName = map[columnUserName];
data = map[columnData];
}
@override
tableSqlString() {
return tableBaseString(name, columnId) +
'''
$columnUserName text not null,
$columnData text not null)
''';
}
@override
tableName() {
return name;
}
Future _getUserProvider(Database db, String userName) async {
List<Map<String, dynamic>> maps =
await db.query(name, columns: [columnId, columnUserName, columnData], where: "$columnUserName = ?", whereArgs: [userName]);
if (maps.length > 0) {
DemoUserInfoDbProvider provider = DemoUserInfoDbProvider.fromMap(maps.first);
return provider;
}
return null;
}
///插入到数据库
Future insert(String userName, String eventMapString) async {
Database db = await getDataBase();
var userProvider = await _getUserProvider(db, userName);
if (userProvider != null) {
var result = await db.delete(name, where: "$columnUserName = ?", whereArgs: [userName]);
print(result);
}
return await db.insert(name, toMap(userName, eventMapString));
}
///获取事件数据
Future<User> getUserInfo(String userName) async {
Database db = await getDataBase();
var userProvider = await _getUserProvider(db, userName);
if (userProvider != null) {
return User.fromJson(json.decode(userProvider.data));
}
return null;
}
}