Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Don't distribute your app with a huge txt-file and import it on the users device. This takes time and is annoying.</p> <p>Rather distribute your app with a pre-populated database and copy it over from the <code>res</code>-folder. You can use <a href="https://github.com/jgilfelt/android-sqlite-asset-helper" rel="nofollow">android-sqlite-asset-helper</a> to automate this.</p> <p>Also, yes. The Database is always stored on the internal memory and you can't access it on a non-rooted device (unless you're using the AVD).</p> <hr> <p>To import your txt-contents into a database, create a script or something that parses the contents and executes the corresponding SQL-queries. Again, your App should ship with the database, not the raw-file!</p> <hr> <p>I was a little bored and hacked together a short Python-Script to read all entries from your txt-file and insert them into a SQLite Database:</p> <pre><code>import sqlite3 import re counter = 0; pattern = re.compile('^([^\^]+)\^([\w\s]+)\^(yes|no)\^\w+$'); conn = sqlite3.connect("imported.db"); cursor = conn.cursor(); # Create the Table: conn.execute(''' CREATE TABLE Bands ( name TEXT, genre TEXT, popular INTEGER, selected INTEGER );'''); # Now, insert: with open('bands.txt', 'r') as f: for line in f: match = pattern.search(line); if match: cursor.execute(''' INSERT INTO Bands (name, genre, popular, selected) VALUES (?,?,?,0)''', ( match.group(1), match.group(2), (1 if match.group(3) == 'yes' else 0) ) ); counter+=1; conn.commit(); conn.close(); print "Imported ", counter, " bands!"; </code></pre> <p>This will assume that the txt-file is named <code>bands.txt</code>, each value is separated by a <code>/</code> and each entry will be on it's own line. The resulting database-file is <code>imported.db</code>.</p> <p>Also, I use <code>INTEGER</code> for all <code>True|False</code>-fields (popular, selected). These will then hold a <code>0</code> for false and a <code>1</code> for true.</p> <p>Last but not least, the RegEx only allows "yes" and "no" for the <code>popular</code>-value.</p>
    singulars
    1. This table or related slice is empty.
    1. POA .txt to modifiable android database
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USLukas Knuth
    1. USLukas Knuth
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POA .txt to modifiable android database
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COThanks for the reply! Since nothing in my list will be selected at first, I figured I'd just delete the selected column and insert zeros from code. Genres will also be represented as numbers. And, since I don't know Python that much, how do I start the code? :) (don't blame me, I am still a student! :)
      singulars
      1. PO
      1. USmurtaugh
    2. COSimply put what you want in your database in the form of `[Band Name]/[Genre Name, ID, whatever]/[popular: "yes" or "no"]/[selected]`. The script will set the `selected` to `0` for all entries, ignoring the contents from your file. To start the script, install python, copy the code into `sqlite_import.py` and (on a command-line/terminal) write `python sqlite_import.py`
      singulars
      1. PO
      1. USLukas Knuth
    3. COAnd if a band name contains `/`? (AC/DC for example)
      singulars
      1. PO
      1. USmurtaugh
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload