1: <?php
2:
3: /**
4: * Picon Framework
5: * http://code.google.com/p/picon-framework/
6: *
7: * Copyright (C) 2011-2012 Martin Cassidy <martin.cassidy@webquub.com>
8:
9: * Picon Framework is free software: you can redistribute it and/or modify
10: * it under the terms of the GNU General Public License as published by
11: * the Free Software Foundation, either version 3 of the License, or
12: * (at your option) any later version.
13:
14: * Picon Framework is distributed in the hope that it will be useful,
15: * but WITHOUT ANY WARRANTY; without even the implied warranty of
16: * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
17: * General Public License for more details.
18:
19: * You should have received a copy of the GNU General Public License
20: * along with Picon Framework. If not, see <http://www.gnu.org/licenses/>.
21: * */
22:
23: namespace picon;
24:
25: /**
26: * All database operations that are expected
27: * @author Martin Cassidy
28: * @package database/template
29: */
30: interface DataBaseOperations
31: {
32: /**
33: * Run a query of given SQL.
34: * Invoke the row mapper for each result found
35: * Replace values in the query with the passed arguments. Query
36: * values should be a type specifier
37: */
38: function query($sql, RowMapper $mapper, $arguments = null);
39:
40: /**
41: * Run a query of given SQL.
42: * Replace values in the query with the passed arguments. Query
43: * values should be a type specifier
44: * @return the number of affected records
45: */
46: function update($sql, $arguments = null);
47:
48: /**
49: * Run the given SQL
50: */
51: function execute($sql);
52:
53: /**
54: * Run the given SQL, with arguments
55: * A single record with a single column is expected. This will be returned
56: * as an integer
57: */
58: function queryForInt($sql, $arguments = null);
59:
60: /**
61: * Run the query and return the last inserted it
62: */
63: function insert($sql, $arguments = null);
64: }
65:
66: ?>
67: