Additional Keyword support for SQL Language - TextMate

31 Jul 2005

This was my first stab at editing a language
definition.  I tried to add "COPY" support as well,
but couldn't get it to work for whatever reason.  This
version supports most keywords in the spec.  I'll try
and add better stored procedure/function support as
well as get copy working and respam.

'njoy,
Mark

{	scopeName = "source.sql";
	fileTypes = ( "sql", "ddl", "dml" );
	foldingStartMarker = "\\s*\\(\\s*$";
	foldingStopMarker = "^\\s*\\)";
	patterns = (
		{	name = "declaration.create.sql";
			match =
"(?i:^\\s*(create)\\s+(aggregate|conversion|database|domain|function|group|(unique\\s+)?index|language|operator|operator
class|rule|schema|sequence|table|tablespace|trigger|type|user|view)\\s+)(\\w+)";
			captures = 
			{	1 = { name = "keyword.function.create.sql"; };
				2 = { name = "keyword.other.sql"; };
				4 = { name = "entity.name.function.sql"; };
			};
		},
		{	name = "keyword.other.DDL.create.II.sql";
			match = "(?i:\\s+(on\\s+|(not\\s+)?null)\\b)";
		},
		{	name = "declaration.drop.sql";
			match =
"(?i:^\\s*(drop)\\s+(aggregate|conversion|database|domain|function|group|index|language|operator|operator
class|rule|schema|sequence|table|tablespace|trigger|type|user|view))";
			captures = 
			{	1 = { name = "support.function.create.sql"; };
				2 = { name = "keyword.other.sql"; };
			};
		},
		{	name = "declaration.drop.sql";
			match =
"(?i:\\s*(drop)\\s+(table)\\s+(\\w+)(\\s+cascade)?\\b)";
			captures = 
			{	1 = { name = "support.function.create.sql"; };
				2 = { name = "keyword.other.table.sql"; };
				3 = { name = "entity.name.function.sql"; };
				4 = { name = "keyword.other.cascade.sql"; };
			};
		},
		{	name = "declaration.alter.sql";
			match =
"(?i:^\\s*(alter)\\s+(aggregate|conversion|database|domain|function|group|index|language|operator|operator
class|rule|schema|sequence|table|tablespace|trigger|type|user|view)\\s+)";
			captures = 
			{	1 = { name = "support.function.create.sql"; };
				2 = { name = "keyword.other.table.sql"; };
			};
		},
		{	name = "keyword.other.DML.sql";
			match =
"(?i:^\\s*([\\(]{0,}select(\\s+distinct)?|insert\\s+into|update|delete|from|where|group\\sby|and|union(\\s+all)?|having|order\\sby)\\b)";
		},
		{	name = "keyword.other.DML.II.sql";
			match = "(?i:\\s+values\\s+)";
		},
		{	name = "keyword.other.sql.LUW.sql";
			match =
"(?i:(begin(\\s+work)?|commit(\\s+work)?|rollback(\\s+work)?))";
		},
		{	name = "keyword.other.authorization.sql";
			match =
"(?i:(grant(\\swith\\sgrant\\soption)?|revoke))";
		},
		{	name = "storage.type.sql";
			match =
"(?i:^\\s*([A-Za-z0-9'_])+\\s+(bigint|bigserial|bit|bit\\svarying\\(\\d+\\)|boolean|box|bytea|character\\s(varying)?\\(\\d+\\)|char\\(\\d+\\)|var\\schar\\(\\d+\\)|cidr|circle|date|double\\sprecision|inet|int|integer|interval\\(\\d+\\)|line|lseg|macaddr|money|numeric(\\(\\d+,\\d+\\))?|oid|path|point|polygon|real|smallint|serial|text|times(\\(\\d+\\))(\\swithoutstimeszone)?|timestamp(s(\\(\\d+\\))(\\swithoutstimeszone)?)?|varchar(\\(\\d+\\))?)\\s*)";
		},
		{	name = "storage.modifier.sql";
			match =
"(?i:\\b(primary\\s+key|references|on\\sdelete(\\s+cascade)?|check)\\b)";
		},
		{	name = "keyword.other.data-integrity.sql";
			match = "(?i:\\bin\\b)";
		},
		{	name = "string.quoted.single.sql";
			begin = "'";
			end = "'";
			swallow = "\\\\.";
		},
		{	name = "keyword.other.object-comments.sql";
			match =
"(?i:^\\s*(comment\\s+on\\s+(table|column|aggregate|constraint|database|domain|function|index|operator|rule|schema|sequence|trigger|type|view))\\s+.*?\\s+(is)\\s+)";
		},
		{	name = "comment.line.double-dash.sql";
			match = "--.*$";
		},
		{	name = "string.quoted.double.sql";
			begin = "\"";
			end = "\"";
			patterns = ( 
				{	name = "string.interpolation.sql";
					match = "#\\{([^\\}]*)\\}";
				}
			);
		},
		{	name = "string.quoted.double.sql";
			begin = "%\\{";
			end = "\\}";
			patterns = ( 
				{	name = "string.interpolation.sql";
					match = "#\\{([^\\}]*)\\}";
				}
			);
		},
		{	name = "string.regexp.sql";
			begin = "/(?=\\S.*/)";
			end = "/";
			patterns = (
				{	name = "string.interpolation.sql";
					match = "#\\{([^\\}]*)\\}";
				},
				{	name = "string.escaped-slash.sql";
					match = "\\\\/";
				},
			);
		},
		{	name = "string.regexp.modr.sql";
			begin = "%r\\{";
			end = "\\}";
			patterns = (
				{	name = "string.interpolation.sql";
					match = "#\\{([^\\}]*)\\}";
				},
				{	name = "constant.character.escaped.slash.sql";
					match = "\\\\/";
				},
			);
		},
	);
	increaseIndentPattern =
"^\\s*(create|grant|insert|delete|update)\\s*";
}