xc_db_maker

Description:

xc db maker

This package is use to create easily an instance of sqlite db and ready to use. Quick and easy to integrate
Get an xc Database instance #
await Make.xcCreationTables(dbname: "dbname", listTables:listTables );
Database _db = Make.db
copied to clipboard
Exambles #
List<Tables> listTables = <Tables>[
Tables(
name: "client",

columns: '''
fullname TEXT NULL,
city TEXT NULL,
country TEXT NULL,
address TEXT NULL
'''
),
Tables(
name: "user",
columns: '''
login TEXT NULL,
pwd TEXT NULL
'''
),
//....
];
await Make.xcCreationTables(dbname: "dbname", listTables:listTables );

//Create an entity

class Client {
final fullname;
final city;
final country;
final address;

Client({
this.fullname,
this.city ,
this.country,
this.address
});

Map<String, dynamic> toMap() {

return {
'fullname': fullname,
'city': city,
'country': country,
'address': address,
};
}

factory Client.fromJson(Map<String, dynamic> json) {
return Client(
fullname: json['fullname'],
city: json['city'],
country: json['country'],
address: json['address']
);
}
}

//New client
Client newClient = Client(
fullname: "TINA K. Arouna",
city: "Abidjan",
country: "Côte d'ivoire",
address: "Cocody angré - xcodevs corporation"
);

make.db.insert('client',newClient.toMap())
copied to clipboard
Futures #
09 basiques functions in French and English version

xcAdd () or xcAjoute() : adding an entity
xcReadFirst() or xcLitPremier() : Read first row in table
xcReadLast() or xcLitDerneir() : Read last row in table
xcModify() or xcModifie() : Modify current entity
xcDelete() or xcSupprime() : Delete current entity
xcDeleteAll() or xcSupprimeTout() : Delete all entity
xcFind() or xcTrouve() : Seach in entity
xcReadNext() or xcLitSuivant() : Read next row
xcReadPrevious() or xcPrecedent() : Read previous row