ObjSQLite3  Diff

Differences From Artifact [317568a3ca]:

To Artifact [6260188b5f]:


1
2
3
4
5
6
7
8
9
/*
 * Copyright (c) 2020 Jonathan Schleifer <js@nil.im>
 *
 * https://fl.nil.im/objsqlite3
 *
 * Permission to use, copy, modify, and/or distribute this software for any
 * purpose with or without fee is hereby granted, provided that the above
 * copyright notice and this permission notice appear in all copies.
 *

|







1
2
3
4
5
6
7
8
9
/*
 * Copyright (c) 2020, 2024 Jonathan Schleifer <js@nil.im>
 *
 * https://fl.nil.im/objsqlite3
 *
 * Permission to use, copy, modify, and/or distribute this software for any
 * purpose with or without fee is hereby granted, provided that the above
 * copyright notice and this permission notice appear in all copies.
 *
20
21
22
23
24
25
26





27
28
29
30
31
32
33
34
35



36




37
38
39






40









41
42






43








44




45




46




47







48
49
50
51

#include <sqlite3.h>

OF_ASSUME_NONNULL_BEGIN

@class SL3Connection;






@interface SL3PreparedStatement: OFObject
{
#ifdef SL3_PUBLIC_IVARS
@public
#endif
	SL3Connection *_connection;
	sqlite3_stmt *_stmt;
}




@property (readonly, nonatomic) OFArray *rowArray;




@property (readonly, nonatomic)
    OFDictionary OF_GENERIC(OFString *, id) *rowDictionary;







- (void)bindWithArray: (OFArray *)array;









- (void)bindWithDictionary:
    (OFDictionary OF_GENERIC(OFString *, id) *)dictionary;






- (void)clearBindings;








- (bool)step;




- (id)objectForColumn: (size_t)column;




- (size_t)columnCount;




- (OFString *)nameForColumn: (size_t)column;







- (void)reset;
@end

OF_ASSUME_NONNULL_END







>
>
>
>
>









>
>
>
|
>
>
>
>

|

>
>
>
>
>
>

>
>
>
>
>
>
>
>
>


>
>
>
>
>
>

>
>
>
>
>
>
>
>

>
>
>
>
|
>
>
>
>

>
>
>
>

>
>
>
>
>
>
>




20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111

#include <sqlite3.h>

OF_ASSUME_NONNULL_BEGIN

@class SL3Connection;

/**
 * @class SL3PreparedStatement SL3PreparedStatement.h ObjSQLite3/ObjSQLite3.h
 *
 * @brief A prepared statement.
 */
@interface SL3PreparedStatement: OFObject
{
#ifdef SL3_PUBLIC_IVARS
@public
#endif
	SL3Connection *_connection;
	sqlite3_stmt *_stmt;
}

/**
 * @brief The current row as an array.
 */
@property (readonly, nonatomic) OFArray *currentRowArray;

/**
 * @brief The current row as a dictionary.
 */
@property (readonly, nonatomic)
    OFDictionary OF_GENERIC(OFString *, id) *currentRowDictionary;

/**
 * @brief Binds the objects from the specified array.
 *
 * @param array An array of objects to bind
 * @throw OFOutOfRangeException The array has more objects than columns
 */
- (void)bindWithArray: (OFArray *)array;

/**
 * @brief Binds the objects from the specified dictionary that maps each column
 *	  name to a value.
 *
 * @param dictionary A map of column names to values
 * @throw OFUndefinedKeyException A column name which does not exist was
 *				  specified
 */
- (void)bindWithDictionary:
    (OFDictionary OF_GENERIC(OFString *, id) *)dictionary;

/**
 * @brief Clears all bindings.
 *
 * @throw SL3ClearBindingsFailedException The bindings could not be cleared
 */
- (void)clearBindings;

/**
 * @brief Steps the prepared statement, returning the next row, if any.
 *
 * @return Whether there was another row
 * @throw SL3ExecuteStatementFailedException Executing the prepared statement
 *					     failed
 */
- (bool)step;

/**
 * @brief Returns the object for the specified column of the current row.
 */
- (id)objectForCurrentRowAtColumn: (size_t)column;

/**
 * @brief The number of columns.
 */
- (size_t)columnCount;

/**
 * @brief Returns the name for the specified column.
 */
- (OFString *)nameForColumn: (size_t)column;

/**
 * @brief Resets the prepared statement.
 *
 * @throw SL3ResetStatementFailedException The prepared statement could not be
 *					   reset
 */
- (void)reset;
@end

OF_ASSUME_NONNULL_END