X-Git-Url: https://git.phdru.name/?a=blobdiff_plain;f=mysql2sql%2Fprocess_tokens.py;h=7f30a5589b7fad13265b4a9e147fe6308afba545;hb=196c2e0ff729c9cf772bb0e9b521ce4f4fdf84cb;hp=ac9930eb81963b1e0c376ff67af035aaaca37679;hpb=c3477caa7a2663decd4d363dade4827fc37e18ea;p=sqlconvert.git diff --git a/mysql2sql/process_tokens.py b/mysql2sql/process_tokens.py index ac9930e..7f30a55 100644 --- a/mysql2sql/process_tokens.py +++ b/mysql2sql/process_tokens.py @@ -1,6 +1,7 @@ -from sqlparse.sql import TokenList -from sqlparse.tokens import Name, Error +from sqlparse.sql import Statement +from sqlparse.tokens import Name, Error, Punctuation, Comment, Newline, \ + Whitespace def requote_names(token_list): @@ -22,3 +23,28 @@ def find_error(token_list): if token.ttype is Error: return True return False + + +class StatementGrouper(object): + def __init__(self): + self.tokens = [] + self.statements = [] + + def get_statements(self): + for statement in self.statements: + yield statement + self.statements = [] + + def process(self, tokens): + for token in tokens: + self.tokens.append(token) + if (token.ttype == Punctuation) and (token.value == ';'): + self.statements.append(Statement(self.tokens)) + self.tokens = [] + + def close(self): + for token in self.tokens: + if (token.ttype not in (Comment.Single, Comment.Multiline, + Newline, Whitespace)): + raise ValueError("Incomplete SQL statement: %s" % self.tokens) + return self.tokens