I'm using Python/SQLite for accessing database. After running the query, and getting the result, I want to know the number of rows, the number of columns, and the name of the column from the queried result and database. For example if I run "SELECT * from table", and I get id name number -------------------- 1 John 10 2 ...
This post refers to this page for merging SQLite databases. The sequence is as follows. Let's say I want to merge a.db and b.db. In command line I do the following. sqlite3 a.db attach 'b.db' as toM; begin; <-- insert into benchmark select * from toM.benchmark; commit; <-- detach database toM; It works well, but in the referred si...
Hi guys i have a model livestream which has two columns in the database, 'user_id' and 'activity_id'. Very straight forward. Now when I try to insert multiple records into the database I get an invalid SQL statement: SQLite3::SQLException: near ",": syntax error: INSERT INTO livestreams (user_id, activity_id) VALUES (1, 2), ...
Hi, I'm developing an Iphone application that uses non-english strings (Hebrew) in sqlite3 DB. However, the application only displays my data when using english strings! Values with hebrew characters returns null. I've tried adding hebrew strings through sqlite on the mac, in the terminal - but sqlite won't even recognize the charact...
How do you obtain the current timestamp in Sqlite? current_time, current_date, current_timestamp both return formatted dates, instead of a long. sqlite> insert into events (timestamp) values (current_timestamp); sqlite> insert into events (timestamp) values (current_date); sqlite> insert into events (timestamp) values (current_time); sq...
Hi, What are the combination of characters for a table name in SQLite to be valid? Are all combinations of alphanumerics (A-Z, a-z and 0-9) constitute a valid name? Ex. CREATE TABLE 123abc(...); What about a combination of alphanumerics with dashes "-" and periods ".", is that valid as well? Ex. CREATE TABLE 123abc.txt(...); Ex. CR...
I'm working on a personal project focusing on analysis of text in a database. My intent is to do something interesting and learn about SQL and sqlite. So with my novice abilities in mind, I'd like to get advice on doing this more efficiently. Say, for example, I want to pick out the types of food in an article A. I parse my article, ...
Until now all my database access has been reading, but now I need to update (and after this insert) I have a database containing 'shows' in the app directory (read-only) and that's ok for me (I don't want to copy it to the documents folder as it's rather big and I don't need to change stuff in it. But I want the user to select some sh...
I wish to execute the following query on my application's SQliteDatabase. String sql = "Select col_1,row_id from Table1 where row_id IN(Select row_id from Table2 where key = 'key')"; I am using the rawQuery function of the SQLiteDataBase class for the same. The problem is when the inner query returns 0 objects the query runs and retur...
Hello all, I have a table which has an unique key with 2 constraints in it. I want to alter the table such that i can remove one of the constraint in unique field there. My current db schema : CREATE TABLE testtable(test1 TEXT, test2 TEXT, test3 TEXT, test4 TEXT DEFAULT FALSE,UNIQUE (test1,test2)) I already have this table populated ...
I'm using Luasqlite. If I wanted to write a test to verify that a table exists, that returns boolean, how would I go about doing it? It seems if I try selecting something from a table that doesn't exist, as my test, then the application errors out altogether. Thank you! ...
sqlite3 I have two tables. One contains some lists and the other contains each list's items. I want to create a select statement that grabs the rows in the lists table, but also creates a column which is a comma-delimited summary of the items in each list. I have this working as follows: select master._id as _id, master.name...
I'm trying to make a local backup of the data from my Rails app, which is deployed to Heroku, and running into problems. I followed the instructions here: http://docs.heroku.com/taps and installed Taps. I get two types of errors. I created a SQLite db locally and tried pulling data with this command: (sudo) heroku db:pull sqlite://...
is there a way to see what the resulting 'showStatement' is after sqlite3_prepare_v2 and sqlite3_bind_xxx ? Running this query : SELECT * FROM shows, locations WHERE (shows.day_id = 1) AND (shows.id IN (6,7,15,19,23,66)) AND (shows.location_id = locations.id) ORDER by locations.sort_order runs perfect in SQLite Manager and in ...
This question is really hard for me to describe, so any improvements on it would be nice. I am currently on Ubuntu 10.4, I have installed RVM (probably as root, that could be my mistake) I did what this guide told me to do: http://rubyonrails.dreamwidth.org/1713.html and from my point of view it worked. I was able to create a project ...
I am using a ContentProvider for caching results from a web-service query. It is an HTTP request and the response content is XML. Most of the data is cached, so I simply query the DB, if not found, request from webservice, insert in DB and requery the DB. Thus the response is always a Cursor from SQLiteDatabaseHelper. I have one resu...
Is there a way to define a column type in SQLite that holds any datatype that SQLite supports? I have unsigned chars, signedchars, unsigned ints, signed ints, UTF-8 chars and blobs that I want to populate in a single column. Reference to any literature is also appreciated. ...
I imported the libsqlite3.0.dylib framework but this code sqlite3 *database; generates an error saying that sqlite3 is undeclared. ...
This line of code if (sqlite3_open(([databasePath UTF8String], &database) == SQLITE_OK) generates an error saying that there are too few arguments to sqlite3_open. How many arguments are required? How can this be fixed? ...
Hi, i need to transfer data from one SQlite3 database to another, preserving all the associated records. For example, Person has many messages, each message has many attachments. I need to transfer, say only "Person1" and "Person2" with all messages, belonging to them and with all attachments, belonging to each message. I've heard ab...