Class: Swift::DB::Sqlite3

Inherits:
Object
  • Object
show all
Defined in:
ext/swift/db/sqlite3/adapter.c

Defined Under Namespace

Classes: Result, Statement

Instance Method Summary collapse

Constructor Details

#initialize(options) ⇒ Object 



44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
 
# File 'ext/swift/db/sqlite3/adapter.c', line 44

VALUE db_sqlite3_adapter_initialize(VALUE self, VALUE options) {
    VALUE db;
    sqlite3* connection;
    Adapter *a = db_sqlite3_adapter_handle(self);

    if (TYPE(options) != T_HASH)
        rb_raise(eSwiftArgumentError, "options needs to be a hash");

    db = rb_hash_aref(options, ID2SYM(rb_intern("db")));
    if (NIL_P(db))
        rb_raise(eSwiftConnectionError, "Invalid db name");

    if (sqlite3_open_v2(CSTRING(db), &connection, SQLITE_OPEN_READWRITE | SQLITE_OPEN_CREATE, 0) != SQLITE_OK)
       rb_raise(eSwiftConnectionError, "%s", sqlite3_errmsg(connection));

    a->connection = connection;
    return Qnil;
}

Instance Method Details

#begin(*args) ⇒ Object 



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
 
# File 'ext/swift/db/sqlite3/adapter.c', line 78

VALUE db_sqlite3_adapter_begin(int argc, VALUE *argv, VALUE self) {
    int auto_commit;
    VALUE savepoint, sql;
    char command[256];

    Adapter *a = db_sqlite3_adapter_handle_safe(self);
    rb_scan_args(argc, argv, "01", &savepoint);

    if (a->t_nesting == 0) {
        sql = rb_str_new2("begin");
        db_sqlite3_adapter_execute(1, &sql, self);
        a->t_nesting++;
        if (NIL_P(savepoint))
            return Qtrue;
    }

    if (NIL_P(savepoint))
        savepoint = rb_uuid_string();

    snprintf(command, 256, "savepoint %s", CSTRING(savepoint));
    sql = rb_str_new2(command);
    db_sqlite3_adapter_execute(1, &sql, self);
    a->t_nesting++;
    return savepoint;
}

#close ⇒ Object 



193
194
195
196
197
198
199
200
201
 
# File 'ext/swift/db/sqlite3/adapter.c', line 193

VALUE db_sqlite3_adapter_close(VALUE self) {
    Adapter *a = db_sqlite3_adapter_handle(self);
    if (a->connection) {
        sqlite3_close(a->connection);
        a->connection = 0;
        return Qtrue;
    }
    return Qfalse;
}

#closed? ⇒ Boolean

Returns:

  • (Boolean) 


203
204
205
206
 
# File 'ext/swift/db/sqlite3/adapter.c', line 203

VALUE db_sqlite3_adapter_closed_q(VALUE self) {
    Adapter *a = db_sqlite3_adapter_handle(self);
    return a->connection ? Qfalse : Qtrue;
}

#commit(*args) ⇒ Object 



104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
 
# File 'ext/swift/db/sqlite3/adapter.c', line 104

VALUE db_sqlite3_adapter_commit(int argc, VALUE *argv, VALUE self) {
    VALUE savepoint, sql;
    char command[256];

    Adapter *a = db_sqlite3_adapter_handle_safe(self);
    rb_scan_args(argc, argv, "01", &savepoint);

    if (a->t_nesting == 0)
        return Qfalse;

    if (NIL_P(savepoint)) {
        sql = rb_str_new2("commit");
        db_sqlite3_adapter_execute(1, &sql, self);
        a->t_nesting--;
    }
    else {
        snprintf(command, 256, "release savepoint %s", CSTRING(savepoint));
        sql = rb_str_new2(command);
        db_sqlite3_adapter_execute(1, &sql, self);
        a->t_nesting--;
    }
    return Qtrue;
}

#escape(text) ⇒ Object 



213
214
215
216
217
218
219
220
 
# File 'ext/swift/db/sqlite3/adapter.c', line 213

VALUE db_sqlite3_adapter_escape(VALUE self, VALUE text) {
    VALUE escaped;
    Adapter *a = db_sqlite3_adapter_handle_safe(self);
    char *sqlite3_escaped = sqlite3_mprintf("%q", CSTRING(text));
    escaped = rb_str_new2(sqlite3_escaped);
    sqlite3_free(sqlite3_escaped);
    return escaped;
}

#execute(*args) ⇒ Object 



63
64
65
66
67
68
69
70
71
72
 
# File 'ext/swift/db/sqlite3/adapter.c', line 63

VALUE db_sqlite3_adapter_execute(int argc, VALUE *argv, VALUE self) {
    VALUE sql, bind;
    rb_scan_args(argc, argv, "10*", &sql, &bind);

    return db_sqlite3_statement_execute(
        RARRAY_LEN(bind),
        RARRAY_PTR(bind),
        db_sqlite3_statement_initialize(db_sqlite3_statement_allocate(cDSS), self, sql)
    );
}

#ping ⇒ Object 



208
209
210
211
 
# File 'ext/swift/db/sqlite3/adapter.c', line 208

VALUE db_sqlite3_adapter_ping(VALUE self) {
    Adapter *a = db_sqlite3_adapter_handle(self);
    return a->connection ? Qtrue : Qfalse;
}

#prepare(sql) ⇒ Object 



74
75
76
 
# File 'ext/swift/db/sqlite3/adapter.c', line 74

VALUE db_sqlite3_adapter_prepare(VALUE self, VALUE sql) {
    return db_sqlite3_statement_initialize(db_sqlite3_statement_allocate(cDSS), self, sql);
}

#rollback(*args) ⇒ Object 



128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
 
# File 'ext/swift/db/sqlite3/adapter.c', line 128

VALUE db_sqlite3_adapter_rollback(int argc, VALUE *argv, VALUE self) {
    VALUE savepoint, sql;
    char command[256];

    Adapter *a = db_sqlite3_adapter_handle_safe(self);
    rb_scan_args(argc, argv, "01", &savepoint);

    if (a->t_nesting == 0)
        return Qfalse;

    if (NIL_P(savepoint)) {
        sql = rb_str_new2("rollback");
        db_sqlite3_adapter_execute(1, &sql, self);
        a->t_nesting--;
    }
    else {
        snprintf(command, 256, "rollback to savepoint %s", CSTRING(savepoint));
        sql = rb_str_new2(command);
        db_sqlite3_adapter_execute(1, &sql, self);
        a->t_nesting--;
    }
    return Qtrue;
}

#transaction(*args) ⇒ Object 



152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
 
# File 'ext/swift/db/sqlite3/adapter.c', line 152

VALUE db_sqlite3_adapter_transaction(int argc, VALUE *argv, VALUE self) {
    int status;
    VALUE savepoint, block, block_result;

    Adapter *a = db_sqlite3_adapter_handle_safe(self);
    rb_scan_args(argc, argv, "01&", &savepoint, &block);

    if (NIL_P(block))
        rb_raise(eSwiftRuntimeError, "sqlite3 transaction requires a block");

    if (a->t_nesting == 0) {
        db_sqlite3_adapter_begin(1, &savepoint, self);
        block_result = rb_protect(rb_yield, self, &status);
        if (!status) {
            db_sqlite3_adapter_commit(1, &savepoint, self);
            if (!NIL_P(savepoint))
                db_sqlite3_adapter_commit(0, 0, self);
        }
        else {
            db_sqlite3_adapter_rollback(1, &savepoint, self);
            if (!NIL_P(savepoint))
                db_sqlite3_adapter_rollback(0, 0, self);
            rb_jump_tag(status);
        }
    }
    else {
        if (NIL_P(savepoint))
            savepoint = rb_uuid_string();
        db_sqlite3_adapter_begin(1, &savepoint, self);
        block_result = rb_protect(rb_yield, self, &status);
        if (!status)
            db_sqlite3_adapter_commit(1, &savepoint, self);
        else {
            db_sqlite3_adapter_rollback(1, &savepoint, self);
            rb_jump_tag(status);
        }
    }

    return block_result;
}