Subversion Repositories SmartDukaan

package com.spice.profitmandi.dao.entity;

import java.io.Serializable;
import java.time.LocalDateTime;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.NamedQueries;
import javax.persistence.NamedQuery;
import javax.persistence.Table;

/**
 * This class basically contains api details
 * 
 * @author ashikali
 *
 */
@Entity
@Table(name="dtr.brands", schema = "dtr")
@NamedQueries({
        @NamedQuery(name = "Brand.selectCount", query = "select count(b) from Brand b"),
        @NamedQuery(name="Brand.selectAll",query="select b from Brand b where b.displayedInPreferencePage = :displayedInPreferencePage"),
        @NamedQuery(name="Brand.selectById",query="select b from Brand b where b.id= :id"),
        @NamedQuery(name="Brand.selectByName",query="select b from Brand b where b.name= :name"),
        @NamedQuery(name="Brand.selectByIdAndName",query="select b from Brand b where b.id = :id and b.name= :name"),
        @NamedQuery(name = "Brand.selectCountByName", query = "select count(b) from Brand b where b.name= :name"),
        @NamedQuery(name="Brand.deleteById",query="delete from Brand b where b.id= :id")
})
public class Brand implements Serializable{
        
        private static final long serialVersionUID = 1L;
        
        public Brand() {
        }
        
        @Id
        @Column(name="id", columnDefinition = "int(10) unsigned")
        @GeneratedValue(strategy = GenerationType.IDENTITY)
        private int id;
        
        @Column(name="name")
        private String name;
        
        @Column(name = "category_id")
        private int categoryId;
        
        @Column(name = "displayed_in_preference_page", columnDefinition="tinyint(1) default 0")
        private boolean displayedInPreferencePage;
        
        @Column(name = "created")
        private LocalDateTime createTimestamp;
        
        public int getId() {
                return id;
        }
        public void setId(int id) {
                this.id = id;
        }
        public void setName(String name) {
        this.name = name;
    }
    public String getName() {
        return name;
    }
    
    public int getCategoryId() {
                return categoryId;
        }
    public void setCategoryId(int categoryId) {
                this.categoryId = categoryId;
        }
    public boolean isDisplayedInPreferencePage() {
                return displayedInPreferencePage;
        }
    public void setDisplayedInPreferencePage(boolean displayedInPreferencePage) {
                this.displayedInPreferencePage = displayedInPreferencePage;
        }
    public LocalDateTime getCreateTimestamp() {
                return createTimestamp;
        }
    public void setCreateTimestamp(LocalDateTime createTimestamp) {
                this.createTimestamp = createTimestamp;
        }
        @Override
        public String toString() {
                return "Brand [id=" + id + ", name=" + name + ", categoryId=" + categoryId + ", displayedInPreferencePage="
                                + displayedInPreferencePage + ", createTimestamp=" + createTimestamp + "]";
        }
        
    
}