Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.python > #77166

Re: python string, best way to concat

Show all headers | View raw

On Wed, Aug 27, 2014 at 1:31 PM,  <dennisearlevans@gmail.com> wrote:
>
>   Hi,
>
>   Sorry about the simple question but I am very new to Python.
>
>   Anyway, I have a function that will be used to call a stored procedure and I need to format the string with the correct number of parameter markers for the ODBC driver, fairly standard stuff.
>
>   What I have works but looks ugly, is there a better way to build or concatenate a string or is a list or a tuple a better option?
>
> the function looks like this
>
>   def callSp(self, schema, spName) :
>    sqlCode = "{call " + schema + "." + spName + "("
>    par_Markers = ""
>    y = len(self.param)
>    x = 0
>    while x < y :
>      par_Markers = par_Markers.join("?")
>      if (x < y - 1) :
>        par_Markers = par_Markers.join(", ")
>      x += 1
>    self.cmdText = sqlCode + par_Markers + ")}"
>    self.ExecuteCursor()
>
>    return
>
> self.param is a list of parameters.  sself.cmdText is the text that will be used to call the stored procedure.
>
> the function would be called like this
>
>   class.AddParameter(some value 1)
>   class.AddParameter(some value 2)
>   callSp("schemaName", "storedProcedureName")
>
>   the self.cmdText will look like this just before the ExecuteCursor call
>
>   "{call schemaName.StoredProcedureName(?, ?)}"
>
>   the code works, but as I said is a bit ugly, is there better methods?
>
>   thanks
>
>   Dennis

If you have a constant number of things to put in a string, often 'abc
{} ghi {}'.format('def', 'jkl') is good - this will produce 'abc def
ghi jkl'.

If you have a variable number of things to put in a string, toss them
all in a list, and join them:
list_ = ['abc, 'def', 'ghi']
for number in range(4):
   list_.append(str(number))
list_.extend(['jkl', 'mno')

# elements of the list will be separated by one space:
string = ' '.join(list_)

Back to comp.lang.python | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

python string, best way to concat dennisearlevans@gmail.com - 2014-08-27 13:31 -0700
  Re: python string, best way to concat Dan Stromberg <drsalists@gmail.com> - 2014-08-27 15:30 -0700
  Re: python string, best way to concat Peter Otten <__peter__@web.de> - 2014-08-28 00:34 +0200
  Re: python string, best way to concat MRAB <python@mrabarnett.plus.com> - 2014-08-27 23:42 +0100
  Re: python string, best way to concat Tim Chase <python.list@tim.thechases.com> - 2014-08-27 17:44 -0500
  Re: python string, best way to concat Chris Angelico <rosuav@gmail.com> - 2014-08-28 08:55 +1000
  Re: python string, best way to concat Peter Otten <__peter__@web.de> - 2014-08-28 00:59 +0200
  Re: python string, best way to concat MRAB <python@mrabarnett.plus.com> - 2014-08-28 08:12 +0100
  Re: python string, best way to concat peter <peter.mosley@talk21.com> - 2014-08-28 01:30 -0700
    Re: python string, best way to concat Marko Rauhamaa <marko@pacujo.net> - 2014-08-28 11:34 +0300
    Re: python string, best way to concat Mark Lawrence <breamoreboy@yahoo.co.uk> - 2014-08-28 09:43 +0100
    Re: python string, best way to concat Chris Angelico <rosuav@gmail.com> - 2014-08-28 18:58 +1000
    Re: python string, best way to concat Roy Smith <roy@panix.com> - 2014-08-28 08:08 -0400
      Re: python string, best way to concat Mihamina Rakotomandimby <mihamina.rakotomandimby@rktmb.org> - 2014-08-28 15:19 +0300
      Re: python string, best way to concat Mark Lawrence <breamoreboy@yahoo.co.uk> - 2014-08-28 15:48 +0100

csiph-web