lessql 0.0.1-alpha lessql: ^0.0.1-alpha copied to clipboard
A flutter plugin for sqlite.
LesSQL #
LesSQL is a flutter plugin for sqlite.
Getting started #
1.Import LesSQL #
import 'package:lessql/lessql.dart';
2.Init databse #
Define DB
class FooDB extends LesDB{
@override
String getName() {
return 'foo_db';
}
@override
int getVersion() {
return 1;
}
}
Define table
class FooTable1 extends LesTable{
@override
List<String> getColumnNames() {
return ['c1','c2','c3','c4'];
}
@override
List<String> getColumnTypes() {
return [Contract.TYPE_NUMBER,Contract.TYPE_NUMBER,Contract.TYPE_NUMBER,Contract.TYPE_NUMBER,];
}
@override
String getTableName() {
return 'table1';
}
@override
List<int> getPrimaryColumnIndexes() {
return [1];
}
@override
String getAutoIncrementID(){
return "id";
}
}
Init database
LesSQL.initLesDB(new FooDB(), [new FooTable1(),new FooTable2()]);
Insert
LesTable and LesEntity must correspond one-to-one
class FooEntity1 extends LesEntity{
String c1;
int c2;
int c3;
int c4;
FooEntity1(this.c1,this.c2,this.c3,this.c4);
@override
List getValues() {
return [c1,c2,c3,c4];
}
}
Random random = new Random();
FooEntity1 entity1 = new FooEntity1(random.nextInt(10000).toString(),
random.nextInt(10000),
random.nextInt(10000),
random.nextInt(10000));
LesSQL.insert(new FooTable1(), entity1.getValues()).then(_updateDes);
License #
Copyright 2017 Qinglian.Zhang
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
You may obtain a copy of the License at
http://www.apache.org/licenses/LICENSE-2.0
Unless required by applicable law or agreed to in writing, software
distributed under the License is distributed on an "AS IS" BASIS,
WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
See the License for the specific language governing permissions and
limitations under the License.