예제 #1
0
	public function deleteQuery($queryId)
	{
		$sql = new SLS_Sql();
		$req = '
			DELETE
			        gq,
			        gqc,
			        gqj,
			        gqw,
			        gqg,
			        gqo,
			        gql
			FROM
			        sls_graph_query gq LEFT JOIN
			        sls_graph_query_column gqc ON (gq.sls_graph_query_id = gqc.sls_graph_query_id) LEFT JOIN
			        sls_graph_query_join gqj ON (gq.sls_graph_query_id = gqj.sls_graph_query_id) LEFT JOIN
			        sls_graph_query_where gqw ON (gq.sls_graph_query_id = gqw.sls_graph_query_id) LEFT JOIN
			        sls_graph_query_group gqg ON (gq.sls_graph_query_id = gqg.sls_graph_query_id) LEFT JOIN
			        sls_graph_query_order gqo ON (gq.sls_graph_query_id = gqo.sls_graph_query_id) LEFT JOIN
			        sls_graph_query_limit gql ON (gq.sls_graph_query_id = gql.sls_graph_query_id)
			WHERE
			        gq.sls_graph_query_id = '.$queryId;
		$sql->delete($req);
	}