INSERT and SELECT

Insert and read data with db.insert and db.query.

Querying records

To read records from a table, you use the db.query method. The return value is a List<Map>; each Map represents a row.

final rows = await db.query('users');
for (final row in rows) {
  print(row['name']);
}

Rows are accessed by column names.

Iterating rows

You iterate over the List<Map> returned by db.query with a for loop. You access each row's columns via row['columnName'].

final rows = await db.query('users');
for (final row in rows) {
  print('name: ${row['name']}');
}

This way you can list all records.

Exercise List all users

In the Veritabani class, write a tumKullanicilar method; call db.query('kullanicilar') and return the result. In main, call tumKullanicilar and print each row's 'isim' value with print('isim: ${satir['isim']}').

Show example solution

import 'package:sqflite/sqflite.dart';

class Veritabani {
  late Database db;

  Future<void> ac() async {
    db = await openDatabase('uygulama.db');
  }

  Future<List<Map<String, dynamic>>> tumKullanicilar() async {
    return await db.query('kullanicilar');
  }
}

void main() async {
  final vt = Veritabani();
  await vt.ac();
  final satirlar = await vt.tumKullanicilar();
  for (final satir in satirlar) {
    print('isim: ${satir['isim']}');
  }
}

Test yourself

What does db.query return?
- A String
- Rows as List<Map>
- A Future<void>
- A single int
Show answer

Rows as List<Map> — db.query returns the rows as List<Map>; each Map represents a row.

Read records with db.query

final satirlar = await db.____('kullanicilar');
for (final satir in satirlar) {
  print(satir['isim']);
}

Show answer

final satirlar = await db.query('kullanicilar');
for (final satir in satirlar) {
  print(satir['isim']);
}

Query records parts

db.query

Method reading rows from table
List<Map>

Return type representing rows
for döngüsü

Way to iterate rows
satir['isim']

Access to column value

Next lesson: Summary - sqflite

We Are Enhancing Your Experience

Cookie Preferences

Strictly Necessary Cookies

Analytical Cookies