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: