Skip to content

Instantly share code, notes, and snippets.

@afarber
Created October 3, 2018 13:49
Show Gist options
  • Save afarber/d51fb18fe0700c14830a628d981fb17d to your computer and use it in GitHub Desktop.
Save afarber/d51fb18fe0700c14830a628d981fb17d to your computer and use it in GitHub Desktop.
Despite successful @TypeConverter call: NOT NULL constraint failed: table_games.pile
{
"formatVersion": 1,
"database": {
"version": 1,
"identityHash": "b4b5c4981b24b731a84a2c6cd13f8c1a",
"entities": [
{
"tableName": "table_config",
"createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`uid` INTEGER NOT NULL, `visited` INTEGER NOT NULL, `banned` TEXT, `vip` TEXT, `grand` TEXT, `elo` INTEGER NOT NULL, `coins` INTEGER NOT NULL, `medals` INTEGER NOT NULL, PRIMARY KEY(`uid`))",
"fields": [
{
"fieldPath": "uid",
"columnName": "uid",
"affinity": "INTEGER",
"notNull": true
},
{
"fieldPath": "visited",
"columnName": "visited",
"affinity": "INTEGER",
"notNull": true
},
{
"fieldPath": "banned",
"columnName": "banned",
"affinity": "TEXT",
"notNull": false
},
{
"fieldPath": "vip",
"columnName": "vip",
"affinity": "TEXT",
"notNull": false
},
{
"fieldPath": "grand",
"columnName": "grand",
"affinity": "TEXT",
"notNull": false
},
{
"fieldPath": "elo",
"columnName": "elo",
"affinity": "INTEGER",
"notNull": true
},
{
"fieldPath": "coins",
"columnName": "coins",
"affinity": "INTEGER",
"notNull": true
},
{
"fieldPath": "medals",
"columnName": "medals",
"affinity": "INTEGER",
"notNull": true
}
],
"primaryKey": {
"columnNames": [
"uid"
],
"autoGenerate": false
},
"indices": [],
"foreignKeys": []
},
{
"tableName": "table_games",
"createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`gid` INTEGER NOT NULL, `bid` INTEGER NOT NULL, `chat1` INTEGER NOT NULL, `created` INTEGER NOT NULL, `expire1` INTEGER NOT NULL, `expire2` INTEGER NOT NULL, `finished` INTEGER NOT NULL, `pilelen` INTEGER NOT NULL, `played1` INTEGER NOT NULL, `played2` INTEGER NOT NULL, `player1` INTEGER NOT NULL, `player2` INTEGER NOT NULL, `score` INTEGER NOT NULL, `score1` INTEGER NOT NULL, `score2` INTEGER NOT NULL, `given1` TEXT NOT NULL, `given2` TEXT, `hint1` TEXT, `photo1` TEXT, `photo2` TEXT, `reason` TEXT, `state1` TEXT, `hand1` TEXT NOT NULL, `pile` TEXT NOT NULL, `tiles` TEXT NOT NULL, `letters` TEXT NOT NULL, `values` TEXT NOT NULL, PRIMARY KEY(`gid`))",
"fields": [
{
"fieldPath": "gid",
"columnName": "gid",
"affinity": "INTEGER",
"notNull": true
},
{
"fieldPath": "bid",
"columnName": "bid",
"affinity": "INTEGER",
"notNull": true
},
{
"fieldPath": "chat1",
"columnName": "chat1",
"affinity": "INTEGER",
"notNull": true
},
{
"fieldPath": "created",
"columnName": "created",
"affinity": "INTEGER",
"notNull": true
},
{
"fieldPath": "expire1",
"columnName": "expire1",
"affinity": "INTEGER",
"notNull": true
},
{
"fieldPath": "expire2",
"columnName": "expire2",
"affinity": "INTEGER",
"notNull": true
},
{
"fieldPath": "finished",
"columnName": "finished",
"affinity": "INTEGER",
"notNull": true
},
{
"fieldPath": "pilelen",
"columnName": "pilelen",
"affinity": "INTEGER",
"notNull": true
},
{
"fieldPath": "played1",
"columnName": "played1",
"affinity": "INTEGER",
"notNull": true
},
{
"fieldPath": "played2",
"columnName": "played2",
"affinity": "INTEGER",
"notNull": true
},
{
"fieldPath": "player1",
"columnName": "player1",
"affinity": "INTEGER",
"notNull": true
},
{
"fieldPath": "player2",
"columnName": "player2",
"affinity": "INTEGER",
"notNull": true
},
{
"fieldPath": "score",
"columnName": "score",
"affinity": "INTEGER",
"notNull": true
},
{
"fieldPath": "score1",
"columnName": "score1",
"affinity": "INTEGER",
"notNull": true
},
{
"fieldPath": "score2",
"columnName": "score2",
"affinity": "INTEGER",
"notNull": true
},
{
"fieldPath": "given1",
"columnName": "given1",
"affinity": "TEXT",
"notNull": true
},
{
"fieldPath": "given2",
"columnName": "given2",
"affinity": "TEXT",
"notNull": false
},
{
"fieldPath": "hint1",
"columnName": "hint1",
"affinity": "TEXT",
"notNull": false
},
{
"fieldPath": "photo1",
"columnName": "photo1",
"affinity": "TEXT",
"notNull": false
},
{
"fieldPath": "photo2",
"columnName": "photo2",
"affinity": "TEXT",
"notNull": false
},
{
"fieldPath": "reason",
"columnName": "reason",
"affinity": "TEXT",
"notNull": false
},
{
"fieldPath": "state1",
"columnName": "state1",
"affinity": "TEXT",
"notNull": false
},
{
"fieldPath": "hand1",
"columnName": "hand1",
"affinity": "TEXT",
"notNull": true
},
{
"fieldPath": "pile",
"columnName": "pile",
"affinity": "TEXT",
"notNull": true
},
{
"fieldPath": "tiles",
"columnName": "tiles",
"affinity": "TEXT",
"notNull": true
},
{
"fieldPath": "letters",
"columnName": "letters",
"affinity": "TEXT",
"notNull": true
},
{
"fieldPath": "values",
"columnName": "values",
"affinity": "TEXT",
"notNull": true
}
],
"primaryKey": {
"columnNames": [
"gid"
],
"autoGenerate": false
},
"indices": [],
"foreignKeys": []
},
{
"tableName": "table_social",
"createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`social` INTEGER NOT NULL, `sid` TEXT NOT NULL, `auth` TEXT NOT NULL, `given` TEXT NOT NULL, `family` TEXT, `photo` TEXT, `lat` REAL, `lng` REAL, `stamp` INTEGER NOT NULL, PRIMARY KEY(`social`))",
"fields": [
{
"fieldPath": "social",
"columnName": "social",
"affinity": "INTEGER",
"notNull": true
},
{
"fieldPath": "sid",
"columnName": "sid",
"affinity": "TEXT",
"notNull": true
},
{
"fieldPath": "auth",
"columnName": "auth",
"affinity": "TEXT",
"notNull": true
},
{
"fieldPath": "given",
"columnName": "given",
"affinity": "TEXT",
"notNull": true
},
{
"fieldPath": "family",
"columnName": "family",
"affinity": "TEXT",
"notNull": false
},
{
"fieldPath": "photo",
"columnName": "photo",
"affinity": "TEXT",
"notNull": false
},
{
"fieldPath": "lat",
"columnName": "lat",
"affinity": "REAL",
"notNull": false
},
{
"fieldPath": "lng",
"columnName": "lng",
"affinity": "REAL",
"notNull": false
},
{
"fieldPath": "stamp",
"columnName": "stamp",
"affinity": "INTEGER",
"notNull": true
}
],
"primaryKey": {
"columnNames": [
"social"
],
"autoGenerate": false
},
"indices": [],
"foreignKeys": []
},
{
"tableName": "table_words",
"createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`word` TEXT NOT NULL, `expl` TEXT, PRIMARY KEY(`word`))",
"fields": [
{
"fieldPath": "word",
"columnName": "word",
"affinity": "TEXT",
"notNull": true
},
{
"fieldPath": "expl",
"columnName": "expl",
"affinity": "TEXT",
"notNull": false
}
],
"primaryKey": {
"columnNames": [
"word"
],
"autoGenerate": false
},
"indices": [],
"foreignKeys": []
}
],
"setupQueries": [
"CREATE TABLE IF NOT EXISTS room_master_table (id INTEGER PRIMARY KEY,identity_hash TEXT)",
"INSERT OR REPLACE INTO room_master_table (id,identity_hash) VALUES(42, \"b4b5c4981b24b731a84a2c6cd13f8c1a\")"
]
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment