model/db_supports.py

   1 # -*- coding: utf-8 -*-
   2
   3 # constant numbers of database
   4 # データベース関連の定数値など
   5 # 2013/12/09 written by kei9
   6
   7 # import modules
   8
   9 # --- filenames ---
  10 ZIP_FILE = "data.zip"
  11 DB_FILE_NAME = "OmamoriMH4.sqlite3"
  12 SKILL_FILE_NAME = "skill.csv"
  13 AMULET_FILE_NAME = "amulet.csv"
  14 MIN_MAX_FILE_NAME = "minmax.csv"
  15 SUFFICIENT_FILE_NAME = "sufficient.csv"
  16 SEED2_SKILL2_FILE_NAME = "seed2_skill2.csv"
  17 SEED2_THRESHOLD1_FILE_NAME = "seed2_threshold1.csv"
  18
  19 # --- sql sentences of database ---
  20 # for skill table
  21 SKILL_TABLE_NAME = u"skill_table"
  22 SKILL_TABLE_COL_SKILL_NAME = u"skill_name"
  23 SKILL_TABLE_CREATE_SQL = u"""create table if not exists {table}
  24     (id integer primary key, {skill_name} varchar unique);""".format(
  25         table=SKILL_TABLE_NAME,
  26         skill_name=SKILL_TABLE_COL_SKILL_NAME)
  27 SKILL_TABLE_INSERT_SQL = u"""insert into {table}
  28     ({skill_col}) values(?);""".format(
  29         table=SKILL_TABLE_NAME,
  30         skill_col=SKILL_TABLE_COL_SKILL_NAME)
  31 SKILL_TABLE_ID2SKILL_SQL = u"""select {skill_col} from {table} where id='{{id}}'""".format(
  32         skill_col=SKILL_TABLE_COL_SKILL_NAME,
  33         table=SKILL_TABLE_NAME)
  34 SKILL_TABLE_SKILL2ID_SQL = u"""select id from {table} where {skill_col}='{{skill_name}}'""".format(
  35         skill_col=SKILL_TABLE_COL_SKILL_NAME,
  36         table=SKILL_TABLE_NAME)
  37 SKILL_TABLE_SELECT_ALL_SQL = u"""select id, {skill_col} from {table}""".format(
  38         skill_col=SKILL_TABLE_COL_SKILL_NAME,
  39         table=SKILL_TABLE_NAME)
  40
  41 # for amulet table
  42 AMULET_TABLE_NAME = u"amulet_table"
  43 AMULET_TABLE_COL_AMULET_NAME = u"amulet_name"
  44 AMULET_TABLE_CREATE_SQL = u"""create table if not exists {table}
  45     (id integer primary key, {amulet_name} varchar unique);""".format(
  46         table=AMULET_TABLE_NAME,
  47         amulet_name=AMULET_TABLE_COL_AMULET_NAME)
  48 AMULET_TABLE_INSERT_SQL = u"""insert into {table}
  49     ({amulet_col}) values(?);""".format(
  50         table=AMULET_TABLE_NAME,
  51         amulet_col=AMULET_TABLE_COL_AMULET_NAME)
  52 AMULET_TABLE_ID2AMULET_SQL = u"""select {amulet_col} from {table} where id='{{id}}'""".format(
  53         amulet_col=AMULET_TABLE_COL_AMULET_NAME,
  54         table=AMULET_TABLE_NAME)
  55 AMULET_TABLE_AMULET2ID_SQL = u"""select id from {table} where {amulet_col}='{{amulet_name}}'""".format(
  56         amulet_col=AMULET_TABLE_COL_AMULET_NAME,
  57         table=AMULET_TABLE_NAME)
  58 AMULET_TABLE_SELECT_ALL_SQL = u"""select id, {amulet_col} from {table}""".format(
  59         amulet_col=AMULET_TABLE_COL_AMULET_NAME,
  60         table=AMULET_TABLE_NAME)
  61
  62 # for minmax of skill
  63 MIN_MAX_MASTER_TABLE_NAME = u"skill_minmax_master"
  64 MIN_MAX_TABLE_NAME = u"skill_minmax_{id}"
  65 MIN_MAX_COL_AMULET_ID = u"amulet_id"
  66 MIN_MAX_COL_SKILL_TABLE_NAME = u"skill_table_name"
  67 MIN_MAX_COL_MIN1 = u"min1"
  68 MIN_MAX_COL_MIN2 = u"min2"
  69 MIN_MAX_COL_MAX1 = u"max1"
  70 MIN_MAX_COL_MAX2 = u"max2"
  71 MIN_MAX_COL_SKILL_ID = u"skill_id"
  72 MIN_MAX_MASTER_TABLE_CREATE_SQL = u"""create table if not exists {master}
  73     (id integer primary key, {amulet_id} integer, {table_name} varchar,
  74     foreign key(amulet_id) references {amulet_table}(id));""".format(
  75         master=MIN_MAX_MASTER_TABLE_NAME,
  76         amulet_id=MIN_MAX_COL_AMULET_ID,
  77         amulet_table=AMULET_TABLE_NAME,
  78         table_name=MIN_MAX_COL_SKILL_TABLE_NAME)
  79 MIN_MAX_TABLE_CREATE_SQL = u"""create table if not exists {{table_name}}
  80     (id integer primary key, {skill_id} integer,
  81     {min1} integer, {max1} integer, {min2} integer, {max2} integer,
  82     foreign key(skill_id) references {skill_table}(id));""".format(
  83         skill_id=MIN_MAX_COL_SKILL_ID,
  84         min1=MIN_MAX_COL_MIN1,
  85         min2=MIN_MAX_COL_MIN2,
  86         max1=MIN_MAX_COL_MAX1,
  87         max2=MIN_MAX_COL_MAX2,
  88         skill_table=SKILL_TABLE_NAME)
  89 MIN_MAX_MASTER_TABLE_INSERT_SQL = u"""insert into {master}
  90     ({amulet_id}, {table_col}) values(?,?);""".format(
  91         master=MIN_MAX_MASTER_TABLE_NAME,
  92         table_col=MIN_MAX_COL_SKILL_TABLE_NAME,
  93         amulet_id=MIN_MAX_COL_AMULET_ID)
  94 MIN_MAX_TABLE_INSERT_SQL = u"""insert into {{table_name}}
  95     ({skill_id}, {min1}, {max1}, {min2}, {max2}) values(?,?,?,?,?)""".format(
  96         skill_id=MIN_MAX_COL_SKILL_ID,
  97         min1=MIN_MAX_COL_MIN1,
  98         min2=MIN_MAX_COL_MIN2,
  99         max1=MIN_MAX_COL_MAX1,
 100         max2=MIN_MAX_COL_MAX2)
 101 MIN_MAX_MASTER_TABLE_SELECT_ALL_SQL = u"""select {amu_id}, {table_col} from {table}""".format(
 102         amu_id=MIN_MAX_COL_AMULET_ID,
 103         table_col=MIN_MAX_COL_SKILL_TABLE_NAME,
 104         table=MIN_MAX_MASTER_TABLE_NAME)
 105 MIN_MAX_TABLE_SELECT_ALL_SQL = u"""select {skill_id}, {min1}, {max1}, {min2}, {max2} from {{table_name}} """.format(
 106         skill_id=MIN_MAX_COL_SKILL_ID,
 107         min1=MIN_MAX_COL_MIN1,
 108         max1=MIN_MAX_COL_MAX1,
 109         min2=MIN_MAX_COL_MIN2,
 110         max2=MIN_MAX_COL_MAX2)
 111 MIN_MAX_TABLE_SELECT_NON_ZERO_SKILL1_ID_SQL = u"""select {skill_id} from {{table_name}}
 112     where {min1} != 0 and {max1} != 0""".format(
 113         skill_id=MIN_MAX_COL_SKILL_ID,
 114         min1=MIN_MAX_COL_MIN1,
 115         max1=MIN_MAX_COL_MAX1)
 116 MIN_MAX_TABLE_SELECT_NON_ZERO_SKILL2_ID_SQL = u"""select {skill_id} from {{table_name}}
 117     where {min2} != 0 and {max2} != 0""".format(
 118         skill_id=MIN_MAX_COL_SKILL_ID,
 119         min2=MIN_MAX_COL_MIN2,
 120         max2=MIN_MAX_COL_MAX2)
 121 MIN_MAX_TABLE_SELECT_MIN1_SQL = u"""select min({col}) from {{table_name}} """.format(
 122         col=MIN_MAX_COL_MIN1)
 123 MIN_MAX_TABLE_SELECT_MAX1_SQL = u"""select max({col}) from {{table_name}} """.format(
 124         col=MIN_MAX_COL_MAX1)
 125 MIN_MAX_TABLE_SELECT_MIN2_SQL = u"""select min({col}) from {{table_name}} """.format(
 126         col=MIN_MAX_COL_MIN2)
 127 MIN_MAX_TABLE_SELECT_MAX2_SQL = u"""select max({col}) from {{table_name}} """.format(
 128         col=MIN_MAX_COL_MAX2)
 129 MIN_MAX_TABLE_SELECT_MAX1_OF_SKILL_SQL = u"""select max({col}) from {{table_name}}
 130     where skill_id={{skill_id}}""".format(
 131         col=MIN_MAX_COL_MAX1)
 132 MIN_MAX_TABLE_SELECT_MAX2_OF_SKILL_SQL = u"""select max({col}) from {{table_name}}
 133     where skill_id={{skill_id}}""".format(
 134         col=MIN_MAX_COL_MAX2)
 135
 136 # for Seed2 to skill2
 137 u""" SEED2から各お守りの第2スキルへのテーブル """
 138 SEED2_SKILL2_MASTER_TABLE_NAME = u"seed2_skill2_master"
 139 SEED2_SKILL2_TABLE_NAME = u"seed2_skill2_{id}"
 140 SEED2_SKILL2_COL_AMULET_ID = u"amulet_id"
 141 SEED2_SKILL2_COL_SEED2_SKILL2_TABLE_NAME = u"seed2_skill2_table_name"
 142 SEED2_SKILL2_COL_SEED2 = u"random_seed2"
 143 SEED2_SKILL2_COL_SKILL2_ID1 = u"skill2_id1"
 144 SEED2_SKILL2_COL_SKILL2_ID2 = u"skill2_id2"
 145 SEED2_SKILL2_COL_SKILL2_ID3 = u"skill2_id3"
 146 SEED2_SKILL2_COL_SKILL2_ID4 = u"skill2_id4"
 147 SEED2_SKILL2_COL_SKILL2_ID5 = u"skill2_id5"
 148 SEED2_SKILL2_COL_SKILL2_ID6 = u"skill2_id6"
 149 SEED2_SKILL2_COL_SKILL2_ID7 = u"skill2_id7"
 150 SEED2_SKILL2_COL_SKILL2_LIST = [SEED2_SKILL2_COL_SKILL2_ID1, SEED2_SKILL2_COL_SKILL2_ID2, SEED2_SKILL2_COL_SKILL2_ID3, SEED2_SKILL2_COL_SKILL2_ID4, SEED2_SKILL2_COL_SKILL2_ID5, SEED2_SKILL2_COL_SKILL2_ID6, SEED2_SKILL2_COL_SKILL2_ID7]
 151 SEED2_SKILL2_MASTER_TABLE_CREATE_SQL = u"""create table if not exists {master}
 152     (id integer primary key, {amulet_id} integer, {table_name} varchar,
 153     foreign key(amulet_id) references {amulet_table}(id));""".format(
 154         master=SEED2_SKILL2_MASTER_TABLE_NAME,
 155         amulet_id=SEED2_SKILL2_COL_AMULET_ID,
 156         amulet_table=AMULET_TABLE_NAME,
 157         table_name=SEED2_SKILL2_COL_SEED2_SKILL2_TABLE_NAME)
 158 SEED2_SKILL2_TABLE_CREATE_SQL = u"""create table if not exists {{table_name}}
 159     (id integer primary key, {seed} integer unique,
 160     {skill_id1} integer, {skill_id2} integer, {skill_id3} integer,
 161     {skill_id4} integer, {skill_id5} integer, {skill_id6} integer, {skill_id7} integer,
 162     foreign key({skill_id1}) references {skill_table}(id),
 163     foreign key({skill_id2}) references {skill_table}(id),
 164     foreign key({skill_id3}) references {skill_table}(id),
 165     foreign key({skill_id4}) references {skill_table}(id),
 166     foreign key({skill_id5}) references {skill_table}(id),
 167     foreign key({skill_id6}) references {skill_table}(id),
 168     foreign key({skill_id7}) references {skill_table}(id));""".format(
 169         seed=SEED2_SKILL2_COL_SEED2,
 170         skill_id1=SEED2_SKILL2_COL_SKILL2_ID1,
 171         skill_id2=SEED2_SKILL2_COL_SKILL2_ID2,
 172         skill_id3=SEED2_SKILL2_COL_SKILL2_ID3,
 173         skill_id4=SEED2_SKILL2_COL_SKILL2_ID4,
 174         skill_id5=SEED2_SKILL2_COL_SKILL2_ID5,
 175         skill_id6=SEED2_SKILL2_COL_SKILL2_ID6,
 176         skill_id7=SEED2_SKILL2_COL_SKILL2_ID7,
 177         skill_table=SKILL_TABLE_NAME)
 178 SEED2_SKILL2_MASTER_TABLE_INSERT_SQL = u"""insert into {table}
 179     ({amulet_col}, {table_col}) values(?,?);""".format(
 180         table=SEED2_SKILL2_MASTER_TABLE_NAME,
 181         table_col=SEED2_SKILL2_COL_SEED2_SKILL2_TABLE_NAME,
 182         amulet_col=SEED2_SKILL2_COL_AMULET_ID)
 183 SEED2_SKILL2_TABLE_INSERT_SQL = u"""insert into {{table_name}}
 184     ({seed}, {skill_id1}, {skill_id2}, {skill_id3},
 185     {skill_id4}, {skill_id5}, {skill_id6}, {skill_id7}) values(?,?,?,?,?,?,?,?)""".format(
 186         seed=SEED2_SKILL2_COL_SEED2,
 187         skill_id1=SEED2_SKILL2_COL_SKILL2_ID1,
 188         skill_id2=SEED2_SKILL2_COL_SKILL2_ID2,
 189         skill_id3=SEED2_SKILL2_COL_SKILL2_ID3,
 190         skill_id4=SEED2_SKILL2_COL_SKILL2_ID4,
 191         skill_id5=SEED2_SKILL2_COL_SKILL2_ID5,
 192         skill_id6=SEED2_SKILL2_COL_SKILL2_ID6,
 193         skill_id7=SEED2_SKILL2_COL_SKILL2_ID7)
 194 SEED2_SKILL2_MASTER_TABLE_SELECT_ALL_SQL = u"""select {amu_id}, {table_col} from {table}""".format(
 195         amu_id=SEED2_SKILL2_COL_AMULET_ID,
 196         table_col=SEED2_SKILL2_COL_SEED2_SKILL2_TABLE_NAME,
 197         table=SEED2_SKILL2_MASTER_TABLE_NAME)
 198 SEED2_SKILL2_TABLE_SELECT_SEED_SQL = u"""select {seed} from {{table_name}} """.format(
 199         seed=SEED2_SKILL2_COL_SEED2)
 200 SEED2_SKILL2_TABLE_SELECT_ALL_SQL = u"""select {seed}, {skill_id1}, {skill_id2},
 201     {skill_id3}, {skill_id4}, {skill_id5}, {skill_id6}, {skill_id7} from {{table_name}} """.format(
 202         seed=SEED2_SKILL2_COL_SEED2,
 203         skill_id1=SEED2_SKILL2_COL_SKILL2_ID1,
 204         skill_id2=SEED2_SKILL2_COL_SKILL2_ID2,
 205         skill_id3=SEED2_SKILL2_COL_SKILL2_ID3,
 206         skill_id4=SEED2_SKILL2_COL_SKILL2_ID4,
 207         skill_id5=SEED2_SKILL2_COL_SKILL2_ID5,
 208         skill_id6=SEED2_SKILL2_COL_SKILL2_ID6,
 209         skill_id7=SEED2_SKILL2_COL_SKILL2_ID7)
 210
 211 # for seed2 to threshold1
 212 u""" SEED2から判定値1へのテーブル """
 213 SEED2_THRESHOLD1_TABLE_NAME = u"seed2_threshold1"
 214 SEED2_THRESHOLD1_COL_SEED2 = u"random_seed2"
 215 SEED2_THRESHOLD1_COL_THRESHOLD1_1 = u"threshold1_1"
 216 SEED2_THRESHOLD1_COL_THRESHOLD1_2 = u"threshold1_2"
 217 SEED2_THRESHOLD1_COL_THRESHOLD1_3 = u"threshold1_3"
 218 SEED2_THRESHOLD1_COL_THRESHOLD1_4 = u"threshold1_4"
 219 SEED2_THRESHOLD1_COL_THRESHOLD1_5 = u"threshold1_5"
 220 SEED2_THRESHOLD1_COL_THRESHOLD1_6 = u"threshold1_6"
 221 SEED2_THRESHOLD1_COL_THRESHOLD1_7 = u"threshold1_7"
 222 SEED2_THRESHOLD1_COL_THRESHOLD1_LIST = [SEED2_THRESHOLD1_COL_THRESHOLD1_1, SEED2_THRESHOLD1_COL_THRESHOLD1_2, SEED2_THRESHOLD1_COL_THRESHOLD1_3, SEED2_THRESHOLD1_COL_THRESHOLD1_4, SEED2_THRESHOLD1_COL_THRESHOLD1_5, SEED2_THRESHOLD1_COL_THRESHOLD1_6, SEED2_THRESHOLD1_COL_THRESHOLD1_7]
 223 SEED2_THRESHOLD1_TABLE_CREATE_SQL = u"""create table if not exists {table}
 224     (id integer primary key, {seed} integer unique,
 225     {threshold1_1} integer, {threshold1_2} integer, {threshold1_3} integer,
 226     {threshold1_4} integer, {threshold1_5} integer, {threshold1_6} integer, {threshold1_7} integer);""".format(
 227         table=SEED2_THRESHOLD1_TABLE_NAME,
 228         seed=SEED2_THRESHOLD1_COL_SEED2,
 229         threshold1_1=SEED2_THRESHOLD1_COL_THRESHOLD1_1,
 230         threshold1_2=SEED2_THRESHOLD1_COL_THRESHOLD1_2,
 231         threshold1_3=SEED2_THRESHOLD1_COL_THRESHOLD1_3,
 232         threshold1_4=SEED2_THRESHOLD1_COL_THRESHOLD1_4,
 233         threshold1_5=SEED2_THRESHOLD1_COL_THRESHOLD1_5,
 234         threshold1_6=SEED2_THRESHOLD1_COL_THRESHOLD1_6,
 235         threshold1_7=SEED2_THRESHOLD1_COL_THRESHOLD1_7)
 236 SEED2_THRESHOLD1_TABLE_INSERT_SQL = u"""insert into {table}
 237     ({seed}, {threshold1_1}, {threshold1_2}, {threshold1_3}, {threshold1_4}, {threshold1_5}, {threshold1_6}, {threshold1_7})
 238     values(?,?,?,?,?,?,?,?);""".format(
 239         table=SEED2_THRESHOLD1_TABLE_NAME,
 240         seed=SEED2_THRESHOLD1_COL_SEED2,
 241         threshold1_1=SEED2_THRESHOLD1_COL_THRESHOLD1_1,
 242         threshold1_2=SEED2_THRESHOLD1_COL_THRESHOLD1_2,
 243         threshold1_3=SEED2_THRESHOLD1_COL_THRESHOLD1_3,
 244         threshold1_4=SEED2_THRESHOLD1_COL_THRESHOLD1_4,
 245         threshold1_5=SEED2_THRESHOLD1_COL_THRESHOLD1_5,
 246         threshold1_6=SEED2_THRESHOLD1_COL_THRESHOLD1_6,
 247         threshold1_7=SEED2_THRESHOLD1_COL_THRESHOLD1_7)
 248 SEED2_THRESHOLD1_TABLE_SELECT_ALL_SQL = u"""select {seed}, {threshold1_1}, {threshold1_2},
 249     {threshold1_3}, {threshold1_4}, {threshold1_5}, {threshold1_6}, {threshold1_7} from {table} """.format(
 250         table=SEED2_THRESHOLD1_TABLE_NAME,
 251         seed=SEED2_THRESHOLD1_COL_SEED2,
 252         threshold1_1=SEED2_THRESHOLD1_COL_THRESHOLD1_1,
 253         threshold1_2=SEED2_THRESHOLD1_COL_THRESHOLD1_2,
 254         threshold1_3=SEED2_THRESHOLD1_COL_THRESHOLD1_3,
 255         threshold1_4=SEED2_THRESHOLD1_COL_THRESHOLD1_4,
 256         threshold1_5=SEED2_THRESHOLD1_COL_THRESHOLD1_5,
 257         threshold1_6=SEED2_THRESHOLD1_COL_THRESHOLD1_6,
 258         threshold1_7=SEED2_THRESHOLD1_COL_THRESHOLD1_7)
 259 SEED2_THRESHOLD1_TABLE_SELECT_SEEDS_FROM_THRESHOLD1_SQL = u"""
 260     select {seed} from {threshold1_table}
 261     where {threshold1_1} >= {{threshold1}} or
 262     {threshold1_2} >= {{threshold1}} or
 263     {threshold1_3} >= {{threshold1}} or
 264     {threshold1_4} >= {{threshold1}} or
 265     {threshold1_5} >= {{threshold1}} or
 266     {threshold1_6} >= {{threshold1}} or
 267     {threshold1_7} >= {{threshold1}}
 268     """.format(
 269         threshold1_table=SEED2_THRESHOLD1_TABLE_NAME,
 270         seed=SEED2_THRESHOLD1_COL_SEED2,
 271         threshold1_1=SEED2_THRESHOLD1_COL_THRESHOLD1_1,
 272         threshold1_2=SEED2_THRESHOLD1_COL_THRESHOLD1_2,
 273         threshold1_3=SEED2_THRESHOLD1_COL_THRESHOLD1_3,
 274         threshold1_4=SEED2_THRESHOLD1_COL_THRESHOLD1_4,
 275         threshold1_5=SEED2_THRESHOLD1_COL_THRESHOLD1_5,
 276         threshold1_6=SEED2_THRESHOLD1_COL_THRESHOLD1_6,
 277         threshold1_7=SEED2_THRESHOLD1_COL_THRESHOLD1_7)
 278
 279
 280 # inner join of seed2 -> skill2 & tthreshol1
 281 SEED2_THRESHOLD1_TABLE_SELECT_SEEDS_FROM_THRESHOLD1_AND_SKILL2_SQL = u"""
 282     select {threshold1_table}.{seed} from {threshold1_table}
 283     inner join {{skill_table}} on {threshold1_table}.{seed} = {{skill_table}}.{seed}
 284     where ({{skill_table}}.{skill_id1} == {{skill_id}} and {threshold1_table}.{threshold1_1} >= {{threshold1}}) or
 285     ({{skill_table}}.{skill_id2} == {{skill_id}} and {threshold1_table}.{threshold1_2} >= {{threshold1}}) or
 286     ({{skill_table}}.{skill_id3} == {{skill_id}} and {threshold1_table}.{threshold1_3} >= {{threshold1}}) or
 287     ({{skill_table}}.{skill_id4} == {{skill_id}} and {threshold1_table}.{threshold1_4} >= {{threshold1}}) or
 288     ({{skill_table}}.{skill_id5} == {{skill_id}} and {threshold1_table}.{threshold1_5} >= {{threshold1}}) or
 289     ({{skill_table}}.{skill_id6} == {{skill_id}} and {threshold1_table}.{threshold1_6} >= {{threshold1}}) or
 290     ({{skill_table}}.{skill_id7} == {{skill_id}} and {threshold1_table}.{threshold1_7} >= {{threshold1}})
 291     """.format(
 292         threshold1_table=SEED2_THRESHOLD1_TABLE_NAME,
 293         seed=SEED2_THRESHOLD1_COL_SEED2,
 294         skill_id1=SEED2_SKILL2_COL_SKILL2_ID1,
 295         skill_id2=SEED2_SKILL2_COL_SKILL2_ID2,
 296         skill_id3=SEED2_SKILL2_COL_SKILL2_ID3,
 297         skill_id4=SEED2_SKILL2_COL_SKILL2_ID4,
 298         skill_id5=SEED2_SKILL2_COL_SKILL2_ID5,
 299         skill_id6=SEED2_SKILL2_COL_SKILL2_ID6,
 300         skill_id7=SEED2_SKILL2_COL_SKILL2_ID7,
 301         threshold1_1=SEED2_THRESHOLD1_COL_THRESHOLD1_1,
 302         threshold1_2=SEED2_THRESHOLD1_COL_THRESHOLD1_2,
 303         threshold1_3=SEED2_THRESHOLD1_COL_THRESHOLD1_3,
 304         threshold1_4=SEED2_THRESHOLD1_COL_THRESHOLD1_4,
 305         threshold1_5=SEED2_THRESHOLD1_COL_THRESHOLD1_5,
 306         threshold1_6=SEED2_THRESHOLD1_COL_THRESHOLD1_6,
 307         threshold1_7=SEED2_THRESHOLD1_COL_THRESHOLD1_7)
 308
 309 # for sufficient value for slots
 310 SUFFICIENT_MASTER_TABLE_NAME = u"sufficient_master"
 311 SUFFICIENT_TABLE_NAME = u"sufficient_{id}"
 312 SUFFICIENT_COL_AMULET_ID = u"amulet_id"
 313 SUFFICIENT_COL_SUFFICIENT_TABLE_NAME = u"sufficient_table_name"
 314 SUFFICIENT_COL_SUFFICIENT_VALUE = u"sufficient_value"
 315 SUFFICIENT_COL_SLOT1_THRESHOLD = u"slot1_threshold"
 316 SUFFICIENT_COL_SLOT2_THRESHOLD = u"slot2_threshold"
 317 SUFFICIENT_COL_SLOT3_THRESHOLD = u"slot3_threshold"
 318 SUFFICIENT_MASTER_TABLE_CREATE_SQL = u"""create table if not exists {master}
 319     (id integer primary key, {amulet_id} integer, {table_name} varchar,
 320     foreign key(amulet_id) references {amulet_table}(id));""".format(
 321         master=SUFFICIENT_MASTER_TABLE_NAME,
 322         amulet_id=SUFFICIENT_COL_AMULET_ID,
 323         amulet_table=AMULET_TABLE_NAME,
 324         table_name=SUFFICIENT_COL_SUFFICIENT_TABLE_NAME)
 325 SUFFICIENT_TABLE_CREATE_SQL = u"""create table if not exists {{table_name}}
 326     (id integer primary key, {sufficient_val} integer unique,
 327     {slot1_val} integer, {slot2_val} integer, {slot3_val} integer) ;""".format(
 328         sufficient_val=SUFFICIENT_COL_SUFFICIENT_VALUE,
 329         slot1_val=SUFFICIENT_COL_SLOT1_THRESHOLD,
 330         slot2_val=SUFFICIENT_COL_SLOT2_THRESHOLD,
 331         slot3_val=SUFFICIENT_COL_SLOT3_THRESHOLD)
 332 SUFFICIENT_MASTER_TABLE_INSERT_SQL = u"""insert into {table}
 333     ({amulet_col}, {table_col}) values(?,?);""".format(
 334         table=SUFFICIENT_MASTER_TABLE_NAME,
 335         table_col=SUFFICIENT_COL_SUFFICIENT_TABLE_NAME,
 336         amulet_col=SUFFICIENT_COL_AMULET_ID)
 337 SUFFICIENT_TABLE_INSERT_SQL = u"""insert into {{table_name}}
 338     ({sufficient_val}, {slot1_val}, {slot2_val}, {slot3_val})
 339     values(?,?,?,?);""".format(
 340         sufficient_val=SUFFICIENT_COL_SUFFICIENT_VALUE,
 341         slot1_val=SUFFICIENT_COL_SLOT1_THRESHOLD,
 342         slot2_val=SUFFICIENT_COL_SLOT2_THRESHOLD,
 343         slot3_val=SUFFICIENT_COL_SLOT3_THRESHOLD)
 344 SUFFICIENT_MASTER_TABLE_SELECT_ALL_SQL = u"""select {amu_id}, {table_col} from {table}""".format(
 345         amu_id=SUFFICIENT_COL_AMULET_ID,
 346         table_col=SUFFICIENT_COL_SUFFICIENT_TABLE_NAME,
 347         table=SUFFICIENT_MASTER_TABLE_NAME)
 348 SUFFICIENT_TABLE_SELECT_ALL_SQL = u"""select {sufficient_val}, {slot1_val}, {slot2_val}, {slot3_val} from {{table_name}}""".format(
 349         sufficient_val=SUFFICIENT_COL_SUFFICIENT_VALUE,
 350         slot1_val=SUFFICIENT_COL_SLOT1_THRESHOLD,
 351         slot2_val=SUFFICIENT_COL_SLOT2_THRESHOLD,
 352         slot3_val=SUFFICIENT_COL_SLOT3_THRESHOLD)
 353 SUFFICIENT_TABLE_SELECT_THRESHOLD1_SQL = u"""select {slot1_val}, {slot2_val}, {slot3_val} from {{table_name}}
 354     where {sufficient_val}={{sufficient_val}}""".format(
 355         sufficient_val=SUFFICIENT_COL_SUFFICIENT_VALUE,
 356         slot1_val=SUFFICIENT_COL_SLOT1_THRESHOLD,
 357         slot2_val=SUFFICIENT_COL_SLOT2_THRESHOLD,
 358         slot3_val=SUFFICIENT_COL_SLOT3_THRESHOLD)
 359