Android Open Source - sqlite-provider Database Constants

• Back to SQLite/provider  ↑

From Project

Back to project page sqlite-provider.

License

The source code is released under:

Apache License

Java Source Code

package com.novoda.sqliteprovider.demo.persistance;
/* w w w  .j a  v  a 2 s  . c  om*/
public final class DatabaseConstants {

    private DatabaseConstants() {
    }

    protected static final String TBL_FIREWORKS = "firework";

    public static class Fireworks {
        protected static final String COL_NAME = "name";
        protected static final String COL_COLOR = "color";
        protected static final String COL_NOISE = "noise";
        protected static final String COL_TYPE = "ftype";
        protected static final String COL_PRICE = "price";
        protected static final String COL_SHOP = "shop_id";
    }

    protected static final String TBL_SHOPS = "shop";

    public static class Shops {
        protected static final String COL_NAME = "name";
        protected static final String COL_POSTCODE = "postcode";
    }

    public static class RawSql {
        public static final String SELECT_ALL = "SELECT * FROM firework;";

        public static final String INSERT_FIREWORK = "INSERT INTO firework " + "(name, color, noise, ftype, price, shop_id) " + "VALUES "
                + "(Na, Co, No, Ft, Pr, Sh);";

        public static final String SELECT_USING_PRIMARY_KEY = "SELECT * FROM firework WHERE (_id=1);";

        public static final String SELECT_USING_SHOP_FOREIGN_KEY = "SELECT * FROM firework WHERE (shop_id=1);";

        public static final String GROUP_BY = "SELECT shop_id, SUM(price) as total FROM firework GROUP BY shop_id HAVING SUM(price) > 40;";

        public static final String LIMIT = "SELECT * FROM firework LIMIT 3;";

        public static final String DISTINCT = "SELECT DISTINCT name, ftype, color, noise, price FROM firework;";
    }
}

Java Source Code List

• Back to SQLite/provider  ↑