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

Groups > comp.lang.python > #61771

Re: Code suggestion - List comprehension

Show all headers | View raw

Shyam Parimal Katti <spk265@nyu.edu> writes:

> A semi-colon in the string value  indicates the termination of a sql query.
> So the expected out come is a conversion to a list of valid sql queries:
> ['drop table sample_table;', 'create table sample_test (col1 int);',
> 'select col1 from sample_test;']

I presume these strings are split from lines of input. If so, you would
be better advised to use an SQL parsing library in the first place
<URL:https://pypi.python.org/pypi/sqlparse/>, to get distinct SQL
statements from a text stream.

-- 
 \       “We must find our way to a time when faith, without evidence, |
  `\    disgraces anyone who would claim it.” —Sam Harris, _The End of |
_o__)                                                     Faith_, 2004 |
Ben Finney

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

Thread

Re: Code suggestion - List comprehension Ben Finney <ben+python@benfinney.id.au> - 2013-12-13 09:35 +1100

csiph-web