def parse(database, statement):
parser = Parser(statement)
parser.expect("CREATE")
parser.expectOptional("OR", "REPLACE")
parser.expect("VIEW")
viewName = parser.parseIdentifier()
columnsExist = parser.expectOptional("(")
columnNames = list()
if (columnsExist):
while not parser.expectOptional(")"):
columnNames.append(ParserUtils.getObjectName(parser.parseIdentifier()))
parser.expectOptional(",")
parser.expect("AS")
query = parser.getRest()
view = PgView(ParserUtils.getObjectName(viewName))
view.columnNames = columnNames
view.query = query
schemaName = ParserUtils.getSchemaName(viewName, database)
schema = database.getSchema(schemaName)
if schema is None:
raise Exception("CannotFindSchema" % (schemaName, statement))
schema.addView(view)
def parse(database, statement):
parser = Parser(statement)
parser.expect("CREATE", "SCHEMA")
if parser.expectOptional("AUTHORIZATION"):
schema = PgSchema(ParserUtils.getObjectName(parser.parseIdentifier()))
database.addSchema(schema)
schema.authorization = schema.name
else:
schemaName = ParserUtils.getObjectName(parser.parseIdentifier())
schema = PgSchema(schemaName)
database.schemas[schemaName] = schema
if parser.expectOptional("AUTHORIZATION"):
schema.authorization = ParserUtils.getObjectName(parser.parseIdentifier())
definition = parser.getRest()
if definition:
schema.definition = definition
def parse(database, statement):
parser = Parser(statement)
parser.expect("CREATE")
unique = parser.expectOptional("UNIQUE")
parser.expect("INDEX")
parser.expectOptional("CONCURRENTLY")
indexName = ParserUtils.getObjectName(parser.parseIdentifier())
parser.expect("ON")
tableName = parser.parseIdentifier()
definition = parser.getRest()
schemaName =ParserUtils.getSchemaName(tableName, database)
schema = database.getSchema(schemaName)
if (schema is None):
print 'ERROR: CreateIndexParser[Line 21]'
# throw new RuntimeException(MessageFormat.format(
# Resources.getString("CannotFindSchema"), schemaName,
# statement));
objectName = ParserUtils.getObjectName(tableName)
table = schema.getTable(objectName)
if (table is None):
print 'ERROR: CreateIndexParser[Line 32]'
# throw new RuntimeException(MessageFormat.format(
# Resources.getString("CannotFindTable"), tableName,
# statement));
index = PgIndex(indexName)
table.addIndex(index)
schema.addIndex(index)
index.definition = definition.strip()
index.tableName = table.name
index.unique = unique
def parse(database, statement):
parser = Parser(statement)
parser.expect("CREATE")
parser.expectOptional("OR", "REPLACE")
parser.expect("FUNCTION")
functionName = parser.parseIdentifier();
schemaName = ParserUtils.getSchemaName(functionName, database)
schema = database.getSchema(schemaName)
if schema is None:
raise Exception("Cannot find schema '%s' for statement '%s'. Missing CREATE SCHEMA statement?" % (schemaName, statement))
function = PgFunction()
function.name = ParserUtils.getObjectName(functionName)
parser.expect("(")
while not parser.expectOptional(")"):
mode = ''
if parser.expectOptional("IN"):
mode = "IN"
elif parser.expectOptional("OUT"):
mode = "OUT"
elif parser.expectOptional("INOUT"):
mode = "INOUT"
elif parser.expectOptional("VARIADIC"):
mode = "VARIADIC"
else:
mode = None
position = parser.position
argumentName = None
dataType = parser.parseDataType()
position2 = parser.position
if (not parser.expectOptional(")") and not parser.expectOptional(",")
and not parser.expectOptional("=")
and not parser.expectOptional("DEFAULT")):
parser.position = position
argumentName = ParserUtils.getObjectName(parser.parseIdentifier())
dataType = parser.parseDataType()
else:
parser.position = position2
defaultExpression = ''
if (parser.expectOptional("=")
or parser.expectOptional("DEFAULT")):
defaultExpression = parser.getExpression()
else:
defaultExpression = None
argument = Argument()
argument.dataType = dataType
argument.defaultExpression = defaultExpression
argument.mode = mode
argument.name = argumentName
function.addArgument(argument)
if (parser.expectOptional(")")):
break
else:
parser.expect(",")
function.body = parser.getRest()
schema.addFunction(function)
def parse(database, statement, ignoreSlonyTriggers):
parser = Parser(statement)
parser.expect("CREATE", "TRIGGER")
triggerName = parser.parseIdentifier()
objectName = ParserUtils.getObjectName(triggerName)
trigger = PgTrigger()
trigger.name = objectName
if parser.expectOptional("BEFORE"):
trigger.event = PgTrigger.EVENT_BEFORE
elif parser.expectOptional("AFTER"):
trigger.event = PgTrigger.EVENT_AFTER
elif parser.expectOptional("INSTEAD OF"):
trigger.event = PgTrigger.EVENT_INSTEAD_OF
first = True
while True:
if not first and not parser.expectOptional("OR"):
break
elif parser.expectOptional("INSERT"):
trigger.onInsert = True
elif parser.expectOptional("UPDATE"):
trigger.onUpdate = True
if parser.expectOptional("OF"):
while True:
trigger.updateColumns.append(parser.parseIdentifier())
if not parser.expectOptional(","):
break
elif parser.expectOptional("DELETE"):
trigger.onDelete = True
elif parser.expectOptional("TRUNCATE"):
trigger.onTruncate = True
elif (first):
break
else:
parser.throwUnsupportedCommand()
first = False
parser.expect("ON")
trigger.tableName = ParserUtils.getObjectName(parser.parseIdentifier())
if parser.expectOptional("FOR"):
parser.expectOptional("EACH")
if parser.expectOptional("ROW"):
trigger.forEachRow = True
elif parser.expectOptional("STATEMENT"):
trigger.forEachRow = False
else:
parser.throwUnsupportedCommand()
if parser.expectOptional("WHEN"):
parser.expect("(")
trigger.when = parser.getExpression()
parser.expect(")")
parser.expect("EXECUTE", "PROCEDURE")
trigger.function = parser.getRest()
ignoreSlonyTrigger = ignoreSlonyTriggers and ("_slony_logtrigger" == trigger.name or "_slony_denyaccess" == trigger.name)
if (not ignoreSlonyTrigger):
schema = database.getSchema(ParserUtils.getSchemaName(trigger.tableName, database))
container = schema.tables.get(trigger.tableName)
if not container:
container = schema.views.get(trigger.tableName)
if container:
container.triggers[trigger.name] = trigger
else:
raise Exception()
