Channel created
salom
❤1
Qachonki Flutterda Sql databasedagi eski versiya bilan yangi versiyaga muammo bo'lsa, shunchaki yangisini versiyasi oshiriladi va Sql da onUpgrade deb yangi maydon uchun kod yoziladi
❤1
Flutter
Qachonki Flutterda Sql databasedagi eski versiya bilan yangi versiyaga muammo bo'lsa, shunchaki yangisini versiyasi oshiriladi va Sql da onUpgrade deb yangi maydon uchun kod yoziladi
class FlightLocalSaverDatabase {
static final FlightLocalSaverDatabase instance =
FlightLocalSaverDatabase._internal();

FlightLocalSaverDatabase._internal();

Database? _database;

Future<Database> database() async {
if (_database != null) {
return _database!;
}
_database = await createDatabase();
return _database!;
}

Future<Database> createDatabase() async {
String databasePath = await StorageService.getExternalStoragePath() ??
"/storage/emulated/0/Download/";

String database = join(databasePath, 'localFlights.db');

return await openDatabase(
database,
version: 2, // Versiyani 1 dan 2 ga oshirdik
onCreate: _onCreate,
onUpgrade: _onUpgrade,
onDowngrade: onDatabaseDowngradeDelete,
);
}

Future<void> _onCreate(Database db, int version) async {
await db.execute('''
CREATE TABLE UploadedLocalFlights(
id INTEGER PRIMARY KEY AUTOINCREMENT,
place_id INTEGER,
place_id_link INTEGER,
aircompany TEXT,
number TEXT,
route TEXT,
transtype TEXT,
flight_is_pay TEXT,
plan TEXT,
gate TEXT,
aircraft_type TEXT,
aircraft_weight INTEGER,
stand TEXT,
aircraft TEXT,
estimated TEXT,
start_time_for_deletion TEXT,
fullName TEXT,
flight_status TEXT
)
''');
}

Future<void> _onUpgrade(Database db, int oldVersion, int newVersion) async {
// Eski databaselarni yangilash uchun
if (oldVersion < 2) {
// 3 ta yangi ustunni qo'shamiz
await db.execute('ALTER TABLE UploadedLocalFlights ADD COLUMN gate TEXT');
await db.execute('ALTER TABLE UploadedLocalFlights ADD COLUMN aircraft_type TEXT');
await db.execute('ALTER TABLE UploadedLocalFlights ADD COLUMN aircraft_weight INTEGER');
}

// Kelajakda yangi ustunlar qo'shsangiz:
// if (oldVersion < 3) {
// await db.execute('ALTER TABLE UploadedLocalFlights ADD COLUMN new_column TEXT');
// }
}
}
❤1