xc_db_maker 1.1.0
xc_db_maker: ^1.1.0 copied to clipboard

Flutter Sqlite db bridge, This package is use to create easily an instance of sqlite db and ready to use. Quick and easy to integrate

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

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())

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
2
likes
80
pub points
29%
popularity

Publisher

Unknown

Flutter Sqlite db bridge, This package is use to create easily an instance of sqlite db and ready to use. Quick and easy to integrate

Repository (GitHub)
View/report issues

Documentation

API reference

License

MIT (LICENSE)

Dependencies

flutter, path, path_provider, sqflite

More

Packages that depend on xc_db_maker