Groups
Conversations
All groups and messages
Send feedback to Google
Help
Training
Sign in
Groups
sqlparse
Conversations
About
sqlparse
Contact owners and managers
1–30 of 43
Support and development discussion about sqlparse, a SQL parser module for Python:
http://code.google.
com/p/python-sqlparse
.
Posts from new member to this group are moderated.
Mark all as read
Report group
0 selected
hanga...@gmail.com
,
Andi Albrecht
2
3/30/19
split comment lines
It's a bit hard to distinguish where the comment belongs to: Is it a comment for the preceding
unread,
split comment lines
It's a bit hard to distinguish where the comment belongs to: Is it a comment for the preceding
3/30/19
zabbi...@gmail.com
3/25/19
performance about split
Hi: I have a large sql file have almost 5MB, when i use sqlparse.split, it took me 30seconds. What
unread,
performance about split
Hi: I have a large sql file have almost 5MB, when i use sqlparse.split, it took me 30seconds. What
3/25/19
hanga...@gmail.com
,
Andi Albrecht
6
3/21/19
How To modify table name and format the SQL?
I've found the way to do this, Thank you. 在 2019年3月21日星期四 UTC+8下午9:01:04,Andi Albrecht写道: Hi, you
unread,
How To modify table name and format the SQL?
I've found the way to do this, Thank you. 在 2019年3月21日星期四 UTC+8下午9:01:04,Andi Albrecht写道: Hi, you
3/21/19
Matthew Moisen
,
Andi Albrecht
2
8/28/17
How can we go about customizing sqlparse?
Hi Matthew, there are already some formatting options. Run "sqlformat --help" to see
unread,
How can we go about customizing sqlparse?
Hi Matthew, there are already some formatting options. Run "sqlformat --help" to see
8/28/17
Russell Wallace
6/1/17
sqlformat create table
I tried using sqlformat -r on some SQL create table statements, and it produced this: CREATE TABLE
unread,
sqlformat create table
I tried using sqlformat -r on some SQL create table statements, and it produced this: CREATE TABLE
6/1/17
Eric L
,
Ahmad Zareef
2
2/22/17
extract_tables() issue
You may replace the following function in the example: extract_table_identifiers(token_stream) with
unread,
extract_tables() issue
You may replace the following function in the example: extract_table_identifiers(token_stream) with
2/22/17
Thomas Seaford
,
Andi Albrecht
2
1/24/17
Splitting sql queries not separated by semicolons
Hi, this is the expected behavior. sqlparse does it's best to analyze even broken queries. But
unread,
Splitting sql queries not separated by semicolons
Hi, this is the expected behavior. sqlparse does it's best to analyze even broken queries. But
1/24/17
yoav moon
12/3/16
Parse Values from Insert Statement
Hi, I need to extract one of the values from a bunch of insert statements. I don't have all the
unread,
Parse Values from Insert Statement
Hi, I need to extract one of the values from a bunch of insert statements. I don't have all the
12/3/16
Nix
, …
Donald Lindsay
3
11/11/16
Extract all references tables?
This doesn't seem to work with JOINs ? I replaced the canned string (assigned to variable '
unread,
Extract all references tables?
This doesn't seem to work with JOINs ? I replaced the canned string (assigned to variable '
11/11/16
義務優愛
6/21/16
Getting statements in function body
Say I have this function definition (for Postgres): CREATE OR REPLACE FUNCTION func() RETURNS setof
unread,
Getting statements in function body
Say I have this function definition (for Postgres): CREATE OR REPLACE FUNCTION func() RETURNS setof
6/21/16
idan...@gmail.com
,
Andi Albrecht
3
2/14/16
Position of tokens
My end goal isn't syntax highlighting, but something else, and I'd need the positions and
unread,
Position of tokens
My end goal isn't syntax highlighting, but something else, and I'd need the positions and
2/14/16
Dan Frank
,
Andi Albrecht
2
10/30/15
Alternate indentation & newline conventions
Hi, right now it's not possible. But I'm planning to integrate new features to fine tune the
unread,
Alternate indentation & newline conventions
Hi, right now it's not possible. But I'm planning to integrate new features to fine tune the
10/30/15
ocicat
,
Andi Albrecht
2
9/16/15
column_defs_lowlevel.py broken?
Hi, yepp, it's broken ATM. I'll hope to have some time to fix it soon. Regards, Andi ocicat
unread,
column_defs_lowlevel.py broken?
Hi, yepp, it's broken ATM. I'll hope to have some time to fix it soon. Regards, Andi ocicat
9/16/15
Dimitri Vorona
,
Andi Albrecht
2
5/17/15
DDL parsing broken
Hi Dimitri, sorry for the late reply, I got stuck in a relocation for the past few weeks. Yes,
unread,
DDL parsing broken
Hi Dimitri, sorry for the late reply, I got stuck in a relocation for the past few weeks. Yes,
5/17/15
Michael
,
Amjith Ramanujam
4
2/8/15
FROM tree?
Ohh very good, thanks. I notice a couple cases that don't work with delete and update, but the
unread,
FROM tree?
Ohh very good, thanks. I notice a couple cases that don't work with delete and update, but the
2/8/15
Amjith Ramanujam
2
12/21/14
extract_tables fails to detect a handful of special names
Never mind. I should have been grepping with case-insensitive. I see that 'table_name' is
unread,
extract_tables fails to detect a handful of special names
Never mind. I should have been grepping with case-insensitive. I see that 'table_name' is
12/21/14
Vitor Hirota
9/30/14
Class diagram
I was looking for something like Zql in Python when I found sqlparse. Thanks for your work! I
unread,
Class diagram
I was looking for something like Zql in Python when I found sqlparse. Thanks for your work! I
9/30/14
Bill S
,
Andi Albrecht
2
2/8/14
Love it! question about table indentation following from extra tabs
Hi, this is not the expected behavior. I've opened a bug with a simplified example here: https://
unread,
Love it! question about table indentation following from extra tabs
Hi, this is not the expected behavior. I've opened a bug with a simplified example here: https://
2/8/14
Andi Albrecht
1/24/14
Re: Extracting SQL identifiers from queries
Hi Michael, sorry for the late reply. To me the output looks (almost) good: In the SELECT clause all
unread,
Re: Extracting SQL identifiers from queries
Hi Michael, sorry for the late reply. To me the output looks (almost) good: In the SELECT clause all
1/24/14
Michael Renner
1/21/14
Extracting sql identifiers with sqlparse
Hi, I'm trying to extract all SQL identifiers (table and column references) from a given
unread,
Extracting sql identifiers with sqlparse
Hi, I'm trying to extract all SQL identifiers (table and column references) from a given
1/21/14
Cristian Orellana
, …
Anders Qvist
4
1/7/14
Adding new Keywords
Submit a patch? On Jan 7, 2014 7:22 PM, "Cristian Orellana" <cror...@gmail.com>
unread,
Adding new Keywords
Submit a patch? On Jan 7, 2014 7:22 PM, "Cristian Orellana" <cror...@gmail.com>
1/7/14
Ishaan Joshi
11/4/13
Performance Problems.
Andi, I've been using sqlparse for a while to strip out comments and split queries. These are the
unread,
Performance Problems.
Andi, I've been using sqlparse for a while to strip out comments and split queries. These are the
11/4/13
Jucélio Moura
,
Andi Albrecht
2
6/30/13
example delphi
Hi, thanks for the example! Andi Am Freitag, 28. Juni 2013 schrieb Jucélio Moura : var lParams :
unread,
example delphi
Hi, thanks for the example! Andi Am Freitag, 28. Juni 2013 schrieb Jucélio Moura : var lParams :
6/30/13
Andi Albrecht
6/29/13
sqlparse 0.1.8
I'm pleased to announce sqlparse 0.1.8 Bug Fixes * Whitespaces within certain keywords are now
unread,
sqlparse 0.1.8
I'm pleased to announce sqlparse 0.1.8 Bug Fixes * Whitespaces within certain keywords are now
6/29/13
Andi Albrecht
,
pir...@gmail.com
2
4/6/13
ANN: sqlparse 0.1.7
Congrats dude! :-) 2013/4/6 Andi Albrecht <albrec...@gmail.com>: > Hi, > > I'm
unread,
ANN: sqlparse 0.1.7
Congrats dude! :-) 2013/4/6 Andi Albrecht <albrec...@gmail.com>: > Hi, > > I'm
4/6/13
Ishaan Joshi
, …
pir...@gmail.com
6
2/28/13
python2.4 compatibility.
Andi, El - Apologies for the late reply, I should have enabled email notifications. Thanks a ton for
unread,
python2.4 compatibility.
Andi, El - Apologies for the late reply, I should have enabled email notifications. Thanks a ton for
2/28/13
Andi Albrecht
,
pir...@gmail.com
7
1/2/13
sqlparse 0.1.6
Ok ;-) Sent from my Android cell phone, please forgive the lack of format on the text, and my fat
unread,
sqlparse 0.1.6
Ok ;-) Sent from my Android cell phone, please forgive the lack of format on the text, and my fat
1/2/13
Andi Albrecht
,
Friedhold Matz
4
11/18/12
ANN: sqlparse 0.1.5
Hi Andi, many thanks for your reply, I will try now some select statements. Best regards Friedhold
unread,
ANN: sqlparse 0.1.5
Hi Andi, many thanks for your reply, I will try now some select statements. Best regards Friedhold
11/18/12
ncsaba
,
Andi Albrecht
2
7/27/12
backslash escapes regex
Hi Csaba, On Thu, Jul 26, 2012 at 4:33 PM, ncsaba <ncs...@gmail.com> wrote: > Hi all, >
unread,
backslash escapes regex
Hi Csaba, On Thu, Jul 26, 2012 at 4:33 PM, ncsaba <ncs...@gmail.com> wrote: > Hi all, >
7/27/12
Anders Qvist
, …
Andi Albrecht
8
4/26/12
How are comments supposed to be tokenized?
On Thu, Apr 26, 2012 at 10:05 PM, Anders Qvist <bitt...@gmail.com> wrote: > Filters are
unread,
How are comments supposed to be tokenized?
On Thu, Apr 26, 2012 at 10:05 PM, Anders Qvist <bitt...@gmail.com> wrote: > Filters are
4/26/12