force_not_null = 'FORCE NOT NULL ' + ','.join('"%s"' % c for c in not_null_cols)
else:
force_not_null = ''
- command = "COPY {table_name} ({columns}) FROM '{csvpath}' CSV HEADER {force_not_null}"
+ command = "COPY %(table_name)s (%(columns)s) FROM '%(csvpath)s' CSV HEADER %(force_not_null)s"
session.connection().execute(
- command.format(
- table_name=table_name,
- csvpath=csvpath,
- columns=','.join('"%s"' % c for c in column_names),
- force_not_null=force_not_null,
- )
+ command % dict(
+ table_name=table_name,
+ csvpath=csvpath,
+ columns=','.join('"%s"' % c for c in column_names),
+ force_not_null=force_not_null,
)
+ )
session.commit()
print_done()
continue
u"""Returns the Pokémon's name, including its form if applicable."""
if self.form_name:
- return u'{0} {1}'.format(self.form_name, self.name)
+ return u'%s %s' % (self.form_name, self.name)
else:
return self.name
if not self.name:
return None
elif self.form_group and self.form_group.term:
- return u'{0} {1}'.format(self.name, self.form_group.term)
+ return u'%s %s' % (self.name, self.form_group.term)
else:
return self.name
"""
if self.name:
- return u'{0} {1}'.format(self.name, self.form_base_pokemon.name)
+ return u'%s %s' % (self.name, self.form_base_pokemon.name)
else:
return self.form_base_pokemon.name