flutter_sqlite 1.0.2

flutter_sqlite: ^1.0.2 copied to clipboard

example/lib/main.dart

import 'package:flutter/material.dart';
import 'package:flutter_sqlite/flutter_sqlite.dart';

import 'user_model.dart';

void main() async {
  WidgetsFlutterBinding.ensureInitialized();

  final database = FlutterSqliteDatabase();

// Open database
  await database.open('my_database.db');

// Register tables
  await database.register<User>(() => User(name: '', email: '', age: 0));
  database.insert(User(name: 'Mohamed Shaheen', email: 'shaheen.swe@gmail.com', age: 34));
  users = await database.getAll<User>();

  runApp(const MyApp());
}

List users=[];

class MyApp extends StatelessWidget {
  const MyApp({super.key});
  @override
  Widget build(BuildContext context) {
    return MaterialApp(
      title: 'Flutter SQLite Example',
      home: Scaffold(
        appBar: AppBar(title: const Text('flutter_sqlite Example')),
        body: ListView.builder(
          itemCount: users.length,
          itemBuilder: (context, index) {
            final u = users[index];
            return ListTile(
              title: Text(u.name),
              subtitle: Text('ID: ${u.id ?? "N/A"}'),
            );
          },
        ),
      ),
    );
  }
}