1 /* -*- Mode: C; tab-width: 8; indent-tabs-mode: t; c-basic-offset: 8 -*- */
3 * soup-cookie-jar-sqlite.c: ff sqlite-based cookie storage
5 * Using danw's soup-cookie-jar-text as template
6 * Copyright (C) 2008 Diego Escalante Urrelo
18 #include "soup-cookie-jar-sqlite.h"
19 #include "soup-cookie.h"
20 #include "soup-date.h"
23 * SECTION:soup-cookie-jar-sqlite
24 * @short_description: SQLite-based Cookie Jar
26 * #SoupCookieJarSqlite is a #SoupCookieJar that reads cookies from and
27 * writes them to an SQLite file in the new Mozilla format.
41 } SoupCookieJarSqlitePrivate;
43 #define SOUP_COOKIE_JAR_SQLITE_GET_PRIVATE(o) (G_TYPE_INSTANCE_GET_PRIVATE ((o), SOUP_TYPE_COOKIE_JAR_SQLITE, SoupCookieJarSqlitePrivate))
45 G_DEFINE_TYPE (SoupCookieJarSqlite, soup_cookie_jar_sqlite, SOUP_TYPE_COOKIE_JAR)
47 static void load (SoupCookieJar *jar);
48 static void changed (SoupCookieJar *jar,
49 SoupCookie *old_cookie,
50 SoupCookie *new_cookie);
52 static void set_property (GObject *object, guint prop_id,
53 const GValue *value, GParamSpec *pspec);
54 static void get_property (GObject *object, guint prop_id,
55 GValue *value, GParamSpec *pspec);
58 soup_cookie_jar_sqlite_init (SoupCookieJarSqlite *sqlite)
63 finalize (GObject *object)
65 SoupCookieJarSqlitePrivate *priv =
66 SOUP_COOKIE_JAR_SQLITE_GET_PRIVATE (object);
68 g_free (priv->filename);
70 G_OBJECT_CLASS (soup_cookie_jar_sqlite_parent_class)->finalize (object);
74 soup_cookie_jar_sqlite_class_init (SoupCookieJarSqliteClass *sqlite_class)
76 SoupCookieJarClass *cookie_jar_class =
77 SOUP_COOKIE_JAR_CLASS (sqlite_class);
78 GObjectClass *object_class = G_OBJECT_CLASS (sqlite_class);
80 g_type_class_add_private (sqlite_class, sizeof (SoupCookieJarSqlitePrivate));
82 cookie_jar_class->changed = changed;
84 object_class->finalize = finalize;
85 object_class->set_property = set_property;
86 object_class->get_property = get_property;
89 * SOUP_COOKIE_JAR_SQLITE_FILENAME:
91 * Alias for the #SoupCookieJarSqlite:filename property. (The
92 * cookie-storage filename.)
94 g_object_class_install_property (
95 object_class, PROP_FILENAME,
96 g_param_spec_string (SOUP_COOKIE_JAR_SQLITE_FILENAME,
98 "Cookie-storage filename",
100 G_PARAM_READWRITE | G_PARAM_CONSTRUCT_ONLY));
104 set_property (GObject *object, guint prop_id,
105 const GValue *value, GParamSpec *pspec)
107 SoupCookieJarSqlitePrivate *priv =
108 SOUP_COOKIE_JAR_SQLITE_GET_PRIVATE (object);
112 priv->filename = g_value_dup_string (value);
113 load (SOUP_COOKIE_JAR (object));
116 G_OBJECT_WARN_INVALID_PROPERTY_ID (object, prop_id, pspec);
122 get_property (GObject *object, guint prop_id,
123 GValue *value, GParamSpec *pspec)
125 SoupCookieJarSqlitePrivate *priv =
126 SOUP_COOKIE_JAR_SQLITE_GET_PRIVATE (object);
130 g_value_set_string (value, priv->filename);
133 G_OBJECT_WARN_INVALID_PROPERTY_ID (object, prop_id, pspec);
139 * soup_cookie_jar_sqlite_new:
140 * @filename: the filename to read to/write from, or %NULL
141 * @read_only: %TRUE if @filename is read-only
143 * Creates a #SoupCookieJarSqlite.
145 * @filename will be read in at startup to create an initial set of
146 * cookies. If @read_only is %FALSE, then the non-session cookies will
147 * be written to @filename when the 'changed' signal is emitted from
148 * the jar. (If @read_only is %TRUE, then the cookie jar will only be
149 * used for this session, and changes made to it will be lost when the
152 * Return value: the new #SoupCookieJar
157 soup_cookie_jar_sqlite_new (const char *filename, gboolean read_only)
159 g_return_val_if_fail (filename != NULL, NULL);
161 return g_object_new (SOUP_TYPE_COOKIE_JAR_SQLITE,
162 SOUP_COOKIE_JAR_SQLITE_FILENAME, filename,
163 SOUP_COOKIE_JAR_READ_ONLY, read_only,
167 #define QUERY_ALL "SELECT * FROM moz_cookies;"
168 #define CREATE_TABLE "CREATE TABLE moz_cookies (id INTEGER PRIMARY KEY, name TEXT, value TEXT, host TEXT, path TEXT,expiry INTEGER, lastAccessed INTEGER, isSecure INTEGER, isHttpOnly INTEGER)"
169 #define QUERY_INSERT "INSERT INTO moz_cookies VALUES(NULL, %Q, %Q, %Q, %Q, %d, NULL, %d, %d);"
170 #define QUERY_DELETE "DELETE FROM moz_cookies WHERE name=%Q AND host=%Q;"
186 callback (void *data, int argc, char **argv, char **colname)
188 SoupCookie *cookie = NULL;
189 SoupCookieJar *jar = SOUP_COOKIE_JAR (data);
191 char *name, *value, *host, *path;
193 gboolean http_only = FALSE, secure = FALSE;
197 name = argv[COL_NAME];
198 value = argv[COL_VALUE];
199 host = argv[COL_HOST];
200 path = argv[COL_PATH];
201 max_age = strtoul (argv[COL_EXPIRY], NULL, 10) - now;
206 http_only = (strcmp (argv[COL_HTTP_ONLY], "1") == 0);
207 secure = (strcmp (argv[COL_SECURE], "1") == 0);
209 cookie = soup_cookie_new (name, value, host, path, max_age);
212 soup_cookie_set_secure (cookie, TRUE);
214 soup_cookie_set_http_only (cookie, TRUE);
216 soup_cookie_jar_add_cookie (jar, cookie);
222 try_create_table (sqlite3 *db)
226 if (sqlite3_exec (db, CREATE_TABLE, NULL, NULL, &error)) {
227 g_warning ("Failed to execute query: %s", error);
228 sqlite3_free (error);
233 exec_query_with_try_create_table (sqlite3 *db,
235 int (*callback)(void*,int,char**,char**),
239 gboolean try_create = TRUE;
242 if (sqlite3_exec (db, sql, callback, argument, &error)) {
245 try_create_table (db);
246 sqlite3_free (error);
249 g_warning ("Failed to execute query: %s", error);
250 sqlite3_free (error);
256 load (SoupCookieJar *jar)
258 SoupCookieJarSqlitePrivate *priv =
259 SOUP_COOKIE_JAR_SQLITE_GET_PRIVATE (jar);
263 if (sqlite3_open (priv->filename, &db)) {
265 g_warning ("Can't open %s", priv->filename);
269 exec_query_with_try_create_table (db, QUERY_ALL, callback, jar);
275 changed (SoupCookieJar *jar,
276 SoupCookie *old_cookie,
277 SoupCookie *new_cookie)
279 SoupCookieJarSqlitePrivate *priv =
280 SOUP_COOKIE_JAR_SQLITE_GET_PRIVATE (jar);
284 if (sqlite3_open (priv->filename, &db)) {
286 g_warning ("Can't open %s", priv->filename);
291 query = sqlite3_mprintf (QUERY_DELETE,
294 exec_query_with_try_create_table (db, query, NULL, NULL);
295 sqlite3_free (query);
298 if (new_cookie && new_cookie->expires) {
301 expires = (gulong)soup_date_to_time_t (new_cookie->expires);
302 query = sqlite3_mprintf (QUERY_INSERT,
309 new_cookie->http_only);
310 exec_query_with_try_create_table (db, query, NULL, NULL);
311 sqlite3_free (query);