SqfEntityField Unique? Primary key String? about sqfentity

[hhtokpinar]

in the next version (0.2.6) you can make..

[majdkz97]

thank you
When you expect the new version to be released
Sorry, but i'm Working project and string id is Very important to me.

[hhtokpinar]

Please update your version to 0.2.6
and you may add this property into your table model

primaryKeyType = PrimaryKeyType.text

and remove this line (if exists):

primaryKeyIsIdentity = true // (old version)

[majdkz97]

thanks for your effort
but it's not working
code:
await Users(id:'stringId',name: 'a1').save();
Error:
E/SQLiteLog( 8534): (20) statement aborts at 5: [INSERT OR REPLACE INTO users (id, userId,name,img,shortName,status,lastSeen,emails,isDeleted) VALUES (?,?,?,?,?,?,?,?,?)] datatype mismatch

[hhtokpinar]

I have tested this on ToDo table and it's worked.. can you send me your table model please?

  final td2 = Todos2();
  td2.id = "5d4c006c089eab33022cb432";
  td2.title = "test";
  var res = await td2.save();
  print(res.toString());
  // sample 2
  td2.id = "5d4c006c089eab33022cb433";
  td2.title = "test2";
  res = await td2.save();
  print(res.toString());

  td2.id = "5d4c006c089eab33022cb434";
  td2.title = "test3";
  res = await td2.saveAs();
  print(res.toString());

  final tdList = await Todos2().select().toList();
  for (var td in tdList) {
    print(td.toMap());
  }

  // getbyId sample 
  final td3 = await Todos2().getById("5d4c006c089eab33022cb434");
  print(td3.toMap());

and results:

I/flutter ( 3614): {id: 5d4c006c089eab33022cb434, title: test3, completed: false}
I/flutter ( 3614): {id: 5d4c006c089eab33022cb432, title: test, completed: false}
I/flutter ( 3614): {id: 5d4c006c089eab33022cb433, title: test2, completed: false}
I/flutter ( 3614): {id: 5d4c006c089eab33022cb434, title: test3, completed: false}

[majdkz97]

Did you edit your sqflite Library?
i think my proplem in sqflite library

[hhtokpinar]

Please remember that you have to re-generate model if you make changes on table or db model

[hhtokpinar]

@majdkz97 did you re-generate after modifying the model?

Please remember that you have to re-generate model if you make changes on table or db model