Exemplo n.º 1
0
 def temp():
     insert_query = ssu.get_n_item_insert_query(4).format(
         sql.Identifier('cards', 'set_info'),
         sql.Identifier('set'),
         sql.Identifier('full_name'),
         sql.Identifier('release'),
         sql.Identifier('size'))
     db_cursor.execute(insert_query, (code, full_name, release_date, size))
Exemplo n.º 2
0
 def insert_query():
     insert_query = ssu.get_n_item_insert_query(3).format(
         sql.Identifier('cards', 'pt'), sql.Identifier('card'),
         sql.Identifier('power'), sql.Identifier('toughness'))
     db_cursor.execute(insert_query, (card_name, power, toughness))
Exemplo n.º 3
0
 def insert_query():
     insert_query = ssu.get_n_item_insert_query(2).format(
         sql.Identifier('cards', 'colors'), sql.Identifier('card'),
         sql.Identifier('color'))
     db_cursor.execute(insert_query, (card_name, color.lower()))
Exemplo n.º 4
0
 def insert_query():
     insert_query = ssu.get_n_item_insert_query(3).format(
         sql.Identifier('cards', 'printings'), sql.Identifier('card'),
         sql.Identifier('set'), sql.Identifier('rarity'))
     db_cursor.execute(insert_query, (card_name, printing, rarity))
Exemplo n.º 5
0
 def insert_query():
     insert_query = ssu.get_n_item_insert_query(2).format(
         sql.Identifier('cards', 'types'), sql.Identifier('card'),
         sql.Identifier('type'))
     db_cursor.execute(insert_query, (card_name, card_type))