Android Open Source - SyncFrameworkAndroid Database

• Back to Framework/framework  ↑

From Project

Back to project page SyncFrameworkAndroid.

License

The source code is released under:

Apache License

Java Source Code

/***
 Copyright (c) 2014 Selvin/*from  w  w  w .j av a  2s. c om*/
 Licensed under the Apache License, Version 2.0 (the "License"); you may not
 use this file except in compliance with the License. You may obtain a copy
 of the License at http://www.apache.org/licenses/LICENSE-2.0. Unless required
 by applicable law or agreed to in writing, software distributed under the
 License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS
 OF ANY KIND, either express or implied. See the License for the specific
 language governing permissions and limitations under the License.
 */

package pl.selvin.android.listsyncsample.provider;

import pl.selvin.android.syncframework.ColumnType;
import pl.selvin.android.syncframework.annotation.Cascade;
import pl.selvin.android.syncframework.annotation.Column;
import pl.selvin.android.syncframework.annotation.Table;
import pl.selvin.android.syncframework.annotation.TableName;

@SuppressWarnings("unused")
public class Database {

    static final String DS = "DefaultScope";

    @Table(primaryKeys = {Status.ID}, scope = DS, readonly = true)
    public static interface Status {
        @TableName
        public static final String TABLE_NAME = "Status";

        @Column
        public static final String ID = "ID";

        @Column(type = ColumnType.VARCHAR, extras = Column.COLLATE)
        public static final String NAME = "Name";
    }

    @Table(primaryKeys = {Tag.ID}, scope = DS, readonly = true)
    public static interface Tag {
        @TableName
        public static final String TABLE_NAME = "Tag";

        @Column
        public static final String ID = "ID";

        @Column(type = ColumnType.VARCHAR, extras = Column.COLLATE)
        public static final String NAME = "Name";
    }

    @Table(primaryKeys = {Priority.ID}, scope = DS, readonly = true)
    public static interface Priority {
        @TableName
        public static final String TABLE_NAME = "Priority";

        @Column
        public static final String ID = "ID";

        @Column(type = ColumnType.VARCHAR, extras = Column.COLLATE)
        public static final String C_NAME = "Name";
    }

    @Table(primaryKeys = {User.ID}, scope = DS, readonly = true)
    public static interface User {
        @TableName
        public static final String TABLE_NAME = "User";

        @Column(type = ColumnType.GUID)
        public static final String ID = "ID";

        @Column(type = ColumnType.VARCHAR, extras = Column.COLLATE)
        public static final String NAME = "Name";
    }

    @Table(primaryKeys = {List.ID}, scope = DS, delete = {@Cascade(table = Item.TABLE_NAME, pk = {
            List.ID, List.USERID}, fk = {Item.LISTID, Item.USERID})})
    public static interface List {
        @TableName
        public static final String TABLE_NAME = "List";

        @Column(type = ColumnType.GUID)
        public static final String ID = "ID";

        @Column(type = ColumnType.VARCHAR, extras = Column.COLLATE)
        public static final String NAME = "Name";

        @Column(type = ColumnType.VARCHAR, extras = Column.COLLATE, nullable = true)
        public static final String DESCRIPTION = "Description";

        @Column(type = ColumnType.GUID)
        public static final String USERID = "UserID";

        @Column(type = ColumnType.DATETIME)
        public static final String CREATEDATE = "CreatedDate";

        // this is the only sneeky part computed ... but well see @Column doc :)
        @Column(type = ColumnType.VARCHAR, computed = List.NAME + " || ' ' || "
                + List.DESCRIPTION)
        public static final String NAME_DESCRIPTION = "N_D";

        // this is the only sneeky part computed ... but well see @Column doc :)
        @Column(type = ColumnType.VARCHAR, computed = List.NAME + " || ' ' || "
                + List.DESCRIPTION + " || ' ' || " + List.CREATEDATE)
        public static final String NAME_DESCRIPTION_CREATE = "N_D_C";
    }

    @Table(primaryKeys = {Item.ID}, scope = DS, delete = {@Cascade(table = TagItemMapping.TABLE_NAME, pk = {
            Item.ID, Item.USERID}, fk = {TagItemMapping.ITEMID,
            TagItemMapping.USERID})})
    public static interface Item {
        @TableName
        public static final String TABLE_NAME = "Item";

        @Column(type = ColumnType.GUID)
        public static final String ID = "ID";

        @Column(type = ColumnType.GUID)
        public static final String LISTID = "ListID";

        @Column(type = ColumnType.GUID)
        public static final String USERID = "UserID";

        @Column(type = ColumnType.VARCHAR, extras = Column.COLLATE)
        public static final String NAME = "Name";

        @Column(type = ColumnType.VARCHAR, extras = Column.COLLATE, nullable = true)
        public static final String DESCRIPTION = "Description";

        @Column(type = ColumnType.INTEGER, nullable = true)
        public static final String PRIORITY = "Priority";

        @Column(type = ColumnType.INTEGER, nullable = true)
        public static final String STATUS = "Status";

        @Column(type = ColumnType.DATETIME, nullable = true)
        public static final String STARTDATE = "StartDate";

        @Column(type = ColumnType.DATETIME, nullable = true)
        public static final String ENDDATE = "EndDate";
    }

    @Table(primaryKeys = {TagItemMapping.TAGID, TagItemMapping.ITEMID,
            TagItemMapping.USERID}, scope = DS)
    public static interface TagItemMapping {
        @TableName
        public static final String TABLE_NAME = "TagItemMapping";

        @Column(type = ColumnType.INTEGER)
        public static final String TAGID = "TagID";

        @Column(type = ColumnType.GUID)
        public static final String ITEMID = "ItemID";

        @Column(type = ColumnType.GUID)
        public static final String USERID = "UserID";
    }

}

Java Source Code List

• Back to Framework/framework  ↑