formating query with empty parameter

[Diez B. Roggisch]

someone wrote:

> Hello!
> 
> if one of parameter in values is empty, I'm getting
> TypeError: not enough arguments for format string
> 
> But how to handle such situation? It is ok for DB, that some of values
> are empty.
> 
> 
> 
> def __insert(self, data):
>         query = """
>             BEGIN;
>                 INSERT INTO table
>                     (a,  b,  c,  d,  e,  f,  g)
>                     VALUES
>                     (%s, %s, %s, %s, %s, %s, %s);
>             COMMIT;
>             """
>         values = [
>             data['a'],
>             data['b'],
>             data['c'],
>             data['d'],
>             data['e'],
>             data['f'],
>             data['g']
>             ]
>         self.db.execute(query, *values)

You need to pass 

None

then as that parameter.

Diez