define(function () {
	var SQLite_driver = function () {
		return this;
	}
	
	SQLite_driver.prototype.getSchemaStructure = function (args) {
		/*
			We are going to get the schema structure by running a special query to get back the table 
			definitions.  We'll use that query to find the column names and types by parsing out the columns
			from the create table statements.
		*/
		// this query gets back a result set which contains each table, along with the create table statement used
		var schema_sql = "select * from sqlite_master where type IN ('table', 'view') and name != '__WebKitDatabaseInfoTable__' order by type,name";
		
		var localCallback = function (resultSets) {
			var colMap = {};
			var schemaStruct = [];
			
			for (var i in resultSets[0]["RESULTS"]["COLUMNS"])
			{
				colMap[resultSets[0]["RESULTS"]["COLUMNS"][i]] = i;
			}
			
			for (var j in resultSets[0]["RESULTS"]["DATA"])
			{
				var tableDef = resultSets[0]["RESULTS"]["DATA"][j][colMap["sql"]];
				var tableName = resultSets[0]["RESULTS"]["DATA"][j][colMap["name"]];
				var tableType = resultSets[0]["RESULTS"]["DATA"][j][colMap["type"]];

				var tableStruct = {
					"table_name": tableName,
					"table_type": tableType,
					"columns": []
				};

				if (tableType == "table") { // sadly, there is no easy way to get the columns back from views in WebSQL
					var colsDef = /^[\s\S]*?\(([\s\S]*)\)$/.exec(tableDef)[1].split(/,\s*/);
					
					
					for (var k in colsDef) {
						var col_components = colsDef[k].replace(/(^\s*)|(\s*$)/, '').split(/\s+/);
						tableStruct["columns"].push({
							"name": col_components.shift(), // first part of the col def
							"type": col_components.join(' ') // rest of the col def
						})
					}
				}
				schemaStruct.push(tableStruct);
			}
			
			args["callback"](schemaStruct);
			
		}
		
		
		// use the method available in child classes to get the results from our special query
		this.executeQuery({sql: schema_sql, "success": localCallback});
		
	}

	SQLite_driver.prototype.splitStatement = function (statements, separator)
	{
		if (! separator) separator = ";";
		var escaped_separator = separator.replace(/([.?*+^$[\]\\(){}|-])/g, "\\$1");
		
		var sArray = (statements ? statements.split(new RegExp(escaped_separator + "\s*\r?(\n|$)")) : []);
		return sArray; 
	}
	
	return SQLite_driver;
});