forked from CarGuo/gsy_github_app_flutter
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathsql_provider.dart
More file actions
55 lines (40 loc) · 1 KB
/
sql_provider.dart
File metadata and controls
55 lines (40 loc) · 1 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
import 'dart:async';
import 'dart:convert';
/**
* 数据库表
* Created by guoshuyu
* Date: 2018-08-03
*/
import 'package:gsy_github_app_flutter/common/ab/sql_manager.dart';
import 'package:meta/meta.dart';
import 'package:sqflite/sqflite.dart';
///基类
abstract class BaseDbProvider {
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 SqlManager.isTableExits(name);
if (!isTableExits) {
Database db = await SqlManager.getCurrentDatabase();
return await db.execute(createSql);
}
}
@mustCallSuper
open() async {
if (!isTableExits) {
await prepare(tableName(), tableSqlString());
}
return await SqlManager.getCurrentDatabase();
}
}