SQLite Keywords

Few days back i was working with an android project which requires database. So one of the table column name was match, but i was getting error for that. I searched on the net and found that it is a SQLite Keywords. Here is the list below

ABORT
ACTION
ADD
AFTER
ALL
ALTER
ANALYZE
AND
AS
ASC
ATTACH
AUTOINCREMENT
BEFORE
BEGIN
BETWEEN
BY
CASCADE
CASE
CAST
CHECK
COLLATE
COLUMN
COMMIT
CONFLICT
CONSTRAINT
CREATE
CROSS
CURRENT_DATE
CURRENT_TIME
CURRENT_TIMESTAMP
DATABASE
DEFAULT
DEFERRABLE
DEFERRED
DELETE
DESC
DETACH
DISTINCT
DROP
EACH
ELSE
END
ESCAPE
EXCEPT
EXCLUSIVE
EXISTS
EXPLAIN
FAIL
FOR
FOREIGN
FROM
FULL
GLOB
GROUP
HAVING
IF
IGNORE
IMMEDIATE
IN
INDEX
INDEXED
INITIALLY
INNER
INSERT
INSTEAD
INTERSECT
INTO
IS
ISNULL
JOIN
KEY
LEFT
LIKE
LIMIT
MATCH
NATURAL
NO
NOT
NOTNULL
NULL
OF
OFFSET
ON
OR
ORDER
OUTER
PLAN
PRAGMA
PRIMARY
QUERY
RAISE
RECURSIVE
REFERENCES
REGEXP
REINDEX
RELEASE
RENAME
REPLACE
RESTRICT
RIGHT
ROLLBACK
ROW
SAVEPOINT
SELECT
SET
TABLE
TEMP
TEMPORARY
THEN
TO
TRANSACTION
TRIGGER
UNION
UNIQUE
UPDATE
USING
VACUUM
VALUES
VIEW
VIRTUAL
WHEN
WHERE
WITH
WITHOUT

source : http://www.sqlite.org/lang_keywords.html

WorldCup Football 2014 Android Application

We Just lunched our latest Android app on WorldCup 2014. Here are few reason how this app will increase your productivity and reduce your effort during this World Cup.

1. keep yourself updated with the most accurate schedule of every match,
2. Set reminder for your every favorite matches ,
3. App will detect your local time zone so just set the reminder and enjoy.
4. Live score updated

Our promotional flyer
world_cup

Play Store Link

img

Back in 2012 we started a small start-up called Rupantor (Transform). This is our 9th app, please support us on Facebook

Thanks, Enjoy 🙂

টার্মিনাল কমান্ড বাংলায় (Termianl Commands in Bangla)

Few days ago i wrote some code to execute terminal commands in Bangla.

Code

// Author Shouro and Mahbub
// 24 February, 2014
alias লিস্ট='ls'
alias ঢুকি='cd'
alias দেখ='vim'
alias কপি='cp'
alias মুছ='rm'
alias পুস্তিকাবানাও='mkdir'

For Mac

The following command will append the code in your .bash_profile file

$ echo alias ঢুকি='cd' >> .bash_profile

To see the changes

$ cat .bash_profile

Now try the bangla command in a new Terminal window

Video
https://www.youtube.com/watch?v=_uBdt6DcU5E

view raw
README.md
hosted with ❤ by GitHub

Video

Enjoy 🙂

Understanding Android Activity Lifecycle (Part Four)

1. when the user close the application forcefully
2. when Android it self destroy the Activity.
3. when user hits the back button

Unfortunately you can not distinguish between 1 and 2.

But you can do something when user clicks the back button since onPause() is called after onBackPressed(),
so you can put a flag in the onBackPressed(). That way you can distinguish how it landed here

onBackPressed() -> onPause() or

home button / multitask button -> onPause()

Enjoy 🙂

Vertical Scroll Bar in Android

XML

<TextView android:id="@+id/response_sms_textView3" android:layout_width="fill_parent" android:layout_height="wrap_content" android:layout_marginLeft="10dp" android:layout_marginRight="10dp" android:layout_marginTop="20dp" android:background="@color/White" android:gravity="center" android:lines="8" android:maxLines="8" android:scrollbars="vertical" android:text=”@string/without_account_response_sms_tv3″ android:textAppearance=”?android:attr/textAppearanceMedium” android:textColor=”@color/Black” />

code

tv3.setMovementMethod(new ScrollingMovementMethod()); // include

but if you put this inside ScrollView layout, it might not work. Thanks

Here is a funny meme 🙂
4314173_700b

Understanding Android Activity Lifecycle (Part Three)

Today i am gonna ask a question and later we will try to answer that :p

Observations: Well we understood that when we hit the home or multitask button, the current Activity goes to background, but before going to background it called onPause() method for sure.

Question 1: Unfortunately this method also gets called

1. when the user close the application forcefully
2. when Android it self destroy the Activity.
3. when user hits the back button

So curious minds want to know, how can i distinguishes among them.

coming soon
Understanding Android Activity Lifecycle (Part Four)

Enjoy 🙂

Android Time Class

Get Old Month Using Time Class

// Author: Mahbub

/*
http://developer.android.com/reference/android/text/format/Time.html

just provide the month, year and day and get previous dates

Since Time class does not provides months and day name, you have to do that by yourself
*/

public void oldDate(int month, int year, int day) {
    
    --month;

    oldDay = 1; // here i did not vary the old months date

    String s;
    
    for (int i = 1; i <= 5; ++i) { // i am fetching last 5 month data
        
        if (month == -1) {
            month = 11;
            year = year - 1;
        }

        oldYear = year;
        oldMonth = month;
        
        Time old = new Time();
        old.set(oldDay, oldMonth, oldYear);
        s = "Month of "+old.month+ +old.year;
        
        // update
        --month;
    }
}



https://gist.github.com/lifeparticle/7139069