query = """
     INSERT INTO credit
         (bank, number, card, int1, value, type, int2)
     VALUES
          (?, ?, ?, ?, ?, ?, ?)
        """
data = ['Citi', '5567', 'visa', 6000, 9.99, '23', 9000]
Passing SQLite variables in Python