TQuotTranscription.java

/* TQuotTranscription.java - SQL operations with the table 'quot_transcription'
 * in SQLite Android Wiktionary parsed database.
 *
 * Copyright (c) 2011-2012 Andrew Krizhanovsky <andrew.krizhanovsky at gmail.com>
 * Distributed under EPL/LGPL/GPL/AL/BSD multi-license.
 */

package wikokit.base.wikt.sql.quote;

import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;


/** Operations with the table 'quot_transcription' in MySQL Wiktionary parsed database. */
public class TQuotTranscription {

    /** Quotation unique identifier. */
    private int quote_id;

    /** Transcription text, field quot_transcription.text in database. */
    private String text;

    public TQuotTranscription(int _quote_id,String _text)
    {
        quote_id    = _quote_id;
        text        = _text;
    }

    /** Gets unique ID of quote from database */
    public int getID() {
        return quote_id;
    }

    /** Gets transcription text from database. */
    public String getText() {
        return text;
    }

    /** Inserts record into the table 'quot_transcription'.<br><br>
     * INSERT INTO quot_transcription (quote_id, text) VALUES (7, "test_apapl");
     *
     * @param quote_id  quotation unique identifier, reference to the table 'quote'
     * @param text      quote transcription
     * @return inserted record, or null if insertion failed
     */
    /*public static TQuotTranscription insert (Connect connect,int quote_id, String text) {

        if(null == text || text.length() == 0)
            return null;

        StringBuilder str_sql = new StringBuilder();
        str_sql.append("INSERT INTO quot_transcription (quote_id, text) VALUES (");
        str_sql.append(quote_id);
        str_sql.append(",\"");
        String safe_text = PageTableBase.convertToSafeStringEncodeToDBWunderscore(connect, text);
        str_sql.append(safe_text);
        str_sql.append("\")");
        try
        {
            Statement s = connect.conn.createStatement ();
            try {
                s.executeUpdate (str_sql.toString());
            } finally {
                s.close();
            }
        }catch(SQLException ex) {
            System.err.println("SQLException (TQuotTranscription.insert()):: text='"+text+"'; sql='" + str_sql.toString() + "' error=" + ex.getMessage());
        }
        return new TQuotTranscription(quote_id, text);
    }*/

    /** Selects row from the table 'quot_transcription' by ID.<br><br>
     * SELECT text FROM quot_transcription WHERE quote_id=1;
     * @return null if data is absent
     */
    public static TQuotTranscription getByID (SQLiteDatabase db,int _quote_id) {
        
        TQuotTranscription result = null;
        
        if(_quote_id <= 0)
            return null;
        
        // SELECT text FROM quot_transcription WHERE quote_id=1;
        Cursor c = db.query("quot_transcription", 
                new String[] { "text" }, // attention: + apostrophes for SQL keywords
                "quote_id=" + _quote_id, 
                null, null, null, null);
        
        if (c.moveToFirst()) {
            int i_text = c.getColumnIndexOrThrow("text");
            String _text = c.getString(i_text);
            
            result = new TQuotTranscription(_quote_id, _text);
        }
        if (c != null && !c.isClosed()) {
           c.close();
        }
        
        /*StringBuilder str_sql = new StringBuilder();
        str_sql.append("SELECT text FROM quot_transcription WHERE quote_id=");
        str_sql.append(quote_id);
        
        try {
            Statement s = connect.conn.createStatement ();
            try {
                ResultSet rs = s.executeQuery (str_sql.toString());
                try {
                    if (rs.next ())
                    {
                        String text = Encodings.bytesToUTF8(rs.getBytes("text"));
                        result = new TQuotTranscription(quote_id, text);
                    }
                } finally {
                    rs.close();
                }
            } finally {
                s.close();
            }
        } catch(SQLException ex) {
            System.err.println("SQLException (TQuotTranscription.getByID()):: sql='" + str_sql.toString() + "' " + ex.getMessage());
        }*/
        return result;
    }

    /** Deletes row from the table 'quot_transcription' by a value of ID.<br><br>
     * DELETE FROM quot_transcription WHERE quote_id=4;
     */
    /*public void delete (Connect connect) {

        StringBuilder str_sql = new StringBuilder();
        str_sql.append("DELETE FROM quot_transcription WHERE quote_id=");
        str_sql.append( quote_id );
        try {
            Statement s = connect.conn.createStatement ();
            try {
                s.execute (str_sql.toString());
            } finally {
                s.close();
            }
        } catch(SQLException ex) {
            System.err.println("SQLException (TQuotTranscription.delete()):: sql='" + str_sql.toString() + "' " + ex.getMessage());
        }
    }*/
}