package com.ping.greendao.gen;

import android.database.Cursor;
import android.database.sqlite.SQLiteStatement;

import org.greenrobot.greendao.AbstractDao;
import org.greenrobot.greendao.Property;
import org.greenrobot.greendao.internal.DaoConfig;
import org.greenrobot.greendao.database.Database;
import org.greenrobot.greendao.database.DatabaseStatement;

import cn.flightfeather.thirdapp.bean.entity.Inspection;

// THIS CODE IS GENERATED BY greenDAO, DO NOT EDIT.
/** 
 * DAO for table "INSPECTION".
*/
public class InspectionDao extends AbstractDao<Inspection, String> {

    public static final String TABLENAME = "INSPECTION";

    /**
     * Properties of entity Inspection.<br/>
     * Can be used for QueryBuilder and for referencing column names.
     */
    public static class Properties {
        public final static Property Guid = new Property(0, String.class, "guid", true, "GUID");
        public final static Property Stguid = new Property(1, String.class, "stguid", false, "STGUID");
        public final static Property Sguid = new Property(2, String.class, "sguid", false, "SGUID");
        public final static Property Scensename = new Property(3, String.class, "scensename", false, "SCENSENAME");
        public final static Property Scenseaddress = new Property(4, String.class, "scenseaddress", false, "SCENSEADDRESS");
        public final static Property Istogether = new Property(5, Boolean.class, "istogether", false, "ISTOGETHER");
        public final static Property Entouraget = new Property(6, String.class, "entouraget", false, "ENTOURAGET");
        public final static Property Entouragewx = new Property(7, String.class, "entouragewx", false, "ENTOURAGEWX");
        public final static Property Entourage = new Property(8, String.class, "entourage", false, "ENTOURAGE");
        public final static Property Executionstarttime = new Property(9, java.util.Date.class, "executionstarttime", false, "EXECUTIONSTARTTIME");
        public final static Property Executionendtime = new Property(10, java.util.Date.class, "executionendtime", false, "EXECUTIONENDTIME");
        public final static Property Problemcount = new Property(11, Integer.class, "problemcount", false, "PROBLEMCOUNT");
        public final static Property Isrechecked = new Property(12, Boolean.class, "isrechecked", false, "ISRECHECKED");
        public final static Property Recheckcount = new Property(13, Integer.class, "recheckcount", false, "RECHECKCOUNT");
        public final static Property Promissednum = new Property(14, Integer.class, "promissednum", false, "PROMISSEDNUM");
        public final static Property Changednum = new Property(15, Integer.class, "changednum", false, "CHANGEDNUM");
        public final static Property Ischanged = new Property(16, Boolean.class, "ischanged", false, "ISCHANGED");
        public final static Property Isrvaluated = new Property(17, Boolean.class, "isrvaluated", false, "ISRVALUATED");
        public final static Property Ispromissed = new Property(18, Boolean.class, "ispromissed", false, "ISPROMISSED");
        public final static Property Promissedtime = new Property(19, java.util.Date.class, "promissedtime", false, "PROMISSEDTIME");
        public final static Property Promisseduserguid = new Property(20, String.class, "promisseduserguid", false, "PROMISSEDUSERGUID");
        public final static Property Promissedusername = new Property(21, String.class, "promissedusername", false, "PROMISSEDUSERNAME");
        public final static Property Promisseduserrealname = new Property(22, String.class, "promisseduserrealname", false, "PROMISSEDUSERREALNAME");
        public final static Property Promissedway = new Property(23, String.class, "promissedway", false, "PROMISSEDWAY");
        public final static Property Promisseddeadline = new Property(24, java.util.Date.class, "promisseddeadline", false, "PROMISSEDDEADLINE");
        public final static Property Promissbookpath = new Property(25, String.class, "promissbookpath", false, "PROMISSBOOKPATH");
        public final static Property Signpath = new Property(26, String.class, "signpath", false, "SIGNPATH");
        public final static Property Extension1 = new Property(27, String.class, "extension1", false, "EXTENSION1");
        public final static Property Extension2 = new Property(28, String.class, "extension2", false, "EXTENSION2");
        public final static Property Extension3 = new Property(29, String.class, "extension3", false, "EXTENSION3");
        public final static Property Remark = new Property(30, String.class, "remark", false, "REMARK");
    }


    public InspectionDao(DaoConfig config) {
        super(config);
    }
    
    public InspectionDao(DaoConfig config, DaoSession daoSession) {
        super(config, daoSession);
    }

    /** Creates the underlying database table. */
    public static void createTable(Database db, boolean ifNotExists) {
        String constraint = ifNotExists? "IF NOT EXISTS ": "";
        db.execSQL("CREATE TABLE " + constraint + "\"INSPECTION\" (" + //
                "\"GUID\" TEXT PRIMARY KEY NOT NULL ," + // 0: guid
                "\"STGUID\" TEXT," + // 1: stguid
                "\"SGUID\" TEXT," + // 2: sguid
                "\"SCENSENAME\" TEXT," + // 3: scensename
                "\"SCENSEADDRESS\" TEXT," + // 4: scenseaddress
                "\"ISTOGETHER\" INTEGER," + // 5: istogether
                "\"ENTOURAGET\" TEXT," + // 6: entouraget
                "\"ENTOURAGEWX\" TEXT," + // 7: entouragewx
                "\"ENTOURAGE\" TEXT," + // 8: entourage
                "\"EXECUTIONSTARTTIME\" INTEGER," + // 9: executionstarttime
                "\"EXECUTIONENDTIME\" INTEGER," + // 10: executionendtime
                "\"PROBLEMCOUNT\" INTEGER," + // 11: problemcount
                "\"ISRECHECKED\" INTEGER," + // 12: isrechecked
                "\"RECHECKCOUNT\" INTEGER," + // 13: recheckcount
                "\"PROMISSEDNUM\" INTEGER," + // 14: promissednum
                "\"CHANGEDNUM\" INTEGER," + // 15: changednum
                "\"ISCHANGED\" INTEGER," + // 16: ischanged
                "\"ISRVALUATED\" INTEGER," + // 17: isrvaluated
                "\"ISPROMISSED\" INTEGER," + // 18: ispromissed
                "\"PROMISSEDTIME\" INTEGER," + // 19: promissedtime
                "\"PROMISSEDUSERGUID\" TEXT," + // 20: promisseduserguid
                "\"PROMISSEDUSERNAME\" TEXT," + // 21: promissedusername
                "\"PROMISSEDUSERREALNAME\" TEXT," + // 22: promisseduserrealname
                "\"PROMISSEDWAY\" TEXT," + // 23: promissedway
                "\"PROMISSEDDEADLINE\" INTEGER," + // 24: promisseddeadline
                "\"PROMISSBOOKPATH\" TEXT," + // 25: promissbookpath
                "\"SIGNPATH\" TEXT," + // 26: signpath
                "\"EXTENSION1\" TEXT," + // 27: extension1
                "\"EXTENSION2\" TEXT," + // 28: extension2
                "\"EXTENSION3\" TEXT," + // 29: extension3
                "\"REMARK\" TEXT);"); // 30: remark
    }

    /** Drops the underlying database table. */
    public static void dropTable(Database db, boolean ifExists) {
        String sql = "DROP TABLE " + (ifExists ? "IF EXISTS " : "") + "\"INSPECTION\"";
        db.execSQL(sql);
    }

    @Override
    protected final void bindValues(DatabaseStatement stmt, Inspection entity) {
        stmt.clearBindings();
 
        String guid = entity.getGuid();
        if (guid != null) {
            stmt.bindString(1, guid);
        }
 
        String stguid = entity.getStguid();
        if (stguid != null) {
            stmt.bindString(2, stguid);
        }
 
        String sguid = entity.getSguid();
        if (sguid != null) {
            stmt.bindString(3, sguid);
        }
 
        String scensename = entity.getScensename();
        if (scensename != null) {
            stmt.bindString(4, scensename);
        }
 
        String scenseaddress = entity.getScenseaddress();
        if (scenseaddress != null) {
            stmt.bindString(5, scenseaddress);
        }
 
        Boolean istogether = entity.getIstogether();
        if (istogether != null) {
            stmt.bindLong(6, istogether ? 1L: 0L);
        }
 
        String entouraget = entity.getEntouraget();
        if (entouraget != null) {
            stmt.bindString(7, entouraget);
        }
 
        String entouragewx = entity.getEntouragewx();
        if (entouragewx != null) {
            stmt.bindString(8, entouragewx);
        }
 
        String entourage = entity.getEntourage();
        if (entourage != null) {
            stmt.bindString(9, entourage);
        }
 
        java.util.Date executionstarttime = entity.getExecutionstarttime();
        if (executionstarttime != null) {
            stmt.bindLong(10, executionstarttime.getTime());
        }
 
        java.util.Date executionendtime = entity.getExecutionendtime();
        if (executionendtime != null) {
            stmt.bindLong(11, executionendtime.getTime());
        }
 
        Integer problemcount = entity.getProblemcount();
        if (problemcount != null) {
            stmt.bindLong(12, problemcount);
        }
 
        Boolean isrechecked = entity.getIsrechecked();
        if (isrechecked != null) {
            stmt.bindLong(13, isrechecked ? 1L: 0L);
        }
 
        Integer recheckcount = entity.getRecheckcount();
        if (recheckcount != null) {
            stmt.bindLong(14, recheckcount);
        }
 
        Integer promissednum = entity.getPromissednum();
        if (promissednum != null) {
            stmt.bindLong(15, promissednum);
        }
 
        Integer changednum = entity.getChangednum();
        if (changednum != null) {
            stmt.bindLong(16, changednum);
        }
 
        Boolean ischanged = entity.getIschanged();
        if (ischanged != null) {
            stmt.bindLong(17, ischanged ? 1L: 0L);
        }
 
        Boolean isrvaluated = entity.getIsrvaluated();
        if (isrvaluated != null) {
            stmt.bindLong(18, isrvaluated ? 1L: 0L);
        }
 
        Boolean ispromissed = entity.getIspromissed();
        if (ispromissed != null) {
            stmt.bindLong(19, ispromissed ? 1L: 0L);
        }
 
        java.util.Date promissedtime = entity.getPromissedtime();
        if (promissedtime != null) {
            stmt.bindLong(20, promissedtime.getTime());
        }
 
        String promisseduserguid = entity.getPromisseduserguid();
        if (promisseduserguid != null) {
            stmt.bindString(21, promisseduserguid);
        }
 
        String promissedusername = entity.getPromissedusername();
        if (promissedusername != null) {
            stmt.bindString(22, promissedusername);
        }
 
        String promisseduserrealname = entity.getPromisseduserrealname();
        if (promisseduserrealname != null) {
            stmt.bindString(23, promisseduserrealname);
        }
 
        String promissedway = entity.getPromissedway();
        if (promissedway != null) {
            stmt.bindString(24, promissedway);
        }
 
        java.util.Date promisseddeadline = entity.getPromisseddeadline();
        if (promisseddeadline != null) {
            stmt.bindLong(25, promisseddeadline.getTime());
        }
 
        String promissbookpath = entity.getPromissbookpath();
        if (promissbookpath != null) {
            stmt.bindString(26, promissbookpath);
        }
 
        String signpath = entity.getSignpath();
        if (signpath != null) {
            stmt.bindString(27, signpath);
        }
 
        String extension1 = entity.getExtension1();
        if (extension1 != null) {
            stmt.bindString(28, extension1);
        }
 
        String extension2 = entity.getExtension2();
        if (extension2 != null) {
            stmt.bindString(29, extension2);
        }
 
        String extension3 = entity.getExtension3();
        if (extension3 != null) {
            stmt.bindString(30, extension3);
        }
 
        String remark = entity.getRemark();
        if (remark != null) {
            stmt.bindString(31, remark);
        }
    }

    @Override
    protected final void bindValues(SQLiteStatement stmt, Inspection entity) {
        stmt.clearBindings();
 
        String guid = entity.getGuid();
        if (guid != null) {
            stmt.bindString(1, guid);
        }
 
        String stguid = entity.getStguid();
        if (stguid != null) {
            stmt.bindString(2, stguid);
        }
 
        String sguid = entity.getSguid();
        if (sguid != null) {
            stmt.bindString(3, sguid);
        }
 
        String scensename = entity.getScensename();
        if (scensename != null) {
            stmt.bindString(4, scensename);
        }
 
        String scenseaddress = entity.getScenseaddress();
        if (scenseaddress != null) {
            stmt.bindString(5, scenseaddress);
        }
 
        Boolean istogether = entity.getIstogether();
        if (istogether != null) {
            stmt.bindLong(6, istogether ? 1L: 0L);
        }
 
        String entouraget = entity.getEntouraget();
        if (entouraget != null) {
            stmt.bindString(7, entouraget);
        }
 
        String entouragewx = entity.getEntouragewx();
        if (entouragewx != null) {
            stmt.bindString(8, entouragewx);
        }
 
        String entourage = entity.getEntourage();
        if (entourage != null) {
            stmt.bindString(9, entourage);
        }
 
        java.util.Date executionstarttime = entity.getExecutionstarttime();
        if (executionstarttime != null) {
            stmt.bindLong(10, executionstarttime.getTime());
        }
 
        java.util.Date executionendtime = entity.getExecutionendtime();
        if (executionendtime != null) {
            stmt.bindLong(11, executionendtime.getTime());
        }
 
        Integer problemcount = entity.getProblemcount();
        if (problemcount != null) {
            stmt.bindLong(12, problemcount);
        }
 
        Boolean isrechecked = entity.getIsrechecked();
        if (isrechecked != null) {
            stmt.bindLong(13, isrechecked ? 1L: 0L);
        }
 
        Integer recheckcount = entity.getRecheckcount();
        if (recheckcount != null) {
            stmt.bindLong(14, recheckcount);
        }
 
        Integer promissednum = entity.getPromissednum();
        if (promissednum != null) {
            stmt.bindLong(15, promissednum);
        }
 
        Integer changednum = entity.getChangednum();
        if (changednum != null) {
            stmt.bindLong(16, changednum);
        }
 
        Boolean ischanged = entity.getIschanged();
        if (ischanged != null) {
            stmt.bindLong(17, ischanged ? 1L: 0L);
        }
 
        Boolean isrvaluated = entity.getIsrvaluated();
        if (isrvaluated != null) {
            stmt.bindLong(18, isrvaluated ? 1L: 0L);
        }
 
        Boolean ispromissed = entity.getIspromissed();
        if (ispromissed != null) {
            stmt.bindLong(19, ispromissed ? 1L: 0L);
        }
 
        java.util.Date promissedtime = entity.getPromissedtime();
        if (promissedtime != null) {
            stmt.bindLong(20, promissedtime.getTime());
        }
 
        String promisseduserguid = entity.getPromisseduserguid();
        if (promisseduserguid != null) {
            stmt.bindString(21, promisseduserguid);
        }
 
        String promissedusername = entity.getPromissedusername();
        if (promissedusername != null) {
            stmt.bindString(22, promissedusername);
        }
 
        String promisseduserrealname = entity.getPromisseduserrealname();
        if (promisseduserrealname != null) {
            stmt.bindString(23, promisseduserrealname);
        }
 
        String promissedway = entity.getPromissedway();
        if (promissedway != null) {
            stmt.bindString(24, promissedway);
        }
 
        java.util.Date promisseddeadline = entity.getPromisseddeadline();
        if (promisseddeadline != null) {
            stmt.bindLong(25, promisseddeadline.getTime());
        }
 
        String promissbookpath = entity.getPromissbookpath();
        if (promissbookpath != null) {
            stmt.bindString(26, promissbookpath);
        }
 
        String signpath = entity.getSignpath();
        if (signpath != null) {
            stmt.bindString(27, signpath);
        }
 
        String extension1 = entity.getExtension1();
        if (extension1 != null) {
            stmt.bindString(28, extension1);
        }
 
        String extension2 = entity.getExtension2();
        if (extension2 != null) {
            stmt.bindString(29, extension2);
        }
 
        String extension3 = entity.getExtension3();
        if (extension3 != null) {
            stmt.bindString(30, extension3);
        }
 
        String remark = entity.getRemark();
        if (remark != null) {
            stmt.bindString(31, remark);
        }
    }

    @Override
    public String readKey(Cursor cursor, int offset) {
        return cursor.isNull(offset + 0) ? null : cursor.getString(offset + 0);
    }    

    @Override
    public Inspection readEntity(Cursor cursor, int offset) {
        Inspection entity = new Inspection( //
            cursor.isNull(offset + 0) ? null : cursor.getString(offset + 0), // guid
            cursor.isNull(offset + 1) ? null : cursor.getString(offset + 1), // stguid
            cursor.isNull(offset + 2) ? null : cursor.getString(offset + 2), // sguid
            cursor.isNull(offset + 3) ? null : cursor.getString(offset + 3), // scensename
            cursor.isNull(offset + 4) ? null : cursor.getString(offset + 4), // scenseaddress
            cursor.isNull(offset + 5) ? null : cursor.getShort(offset + 5) != 0, // istogether
            cursor.isNull(offset + 6) ? null : cursor.getString(offset + 6), // entouraget
            cursor.isNull(offset + 7) ? null : cursor.getString(offset + 7), // entouragewx
            cursor.isNull(offset + 8) ? null : cursor.getString(offset + 8), // entourage
            cursor.isNull(offset + 9) ? null : new java.util.Date(cursor.getLong(offset + 9)), // executionstarttime
            cursor.isNull(offset + 10) ? null : new java.util.Date(cursor.getLong(offset + 10)), // executionendtime
            cursor.isNull(offset + 11) ? null : cursor.getInt(offset + 11), // problemcount
            cursor.isNull(offset + 12) ? null : cursor.getShort(offset + 12) != 0, // isrechecked
            cursor.isNull(offset + 13) ? null : cursor.getInt(offset + 13), // recheckcount
            cursor.isNull(offset + 14) ? null : cursor.getInt(offset + 14), // promissednum
            cursor.isNull(offset + 15) ? null : cursor.getInt(offset + 15), // changednum
            cursor.isNull(offset + 16) ? null : cursor.getShort(offset + 16) != 0, // ischanged
            cursor.isNull(offset + 17) ? null : cursor.getShort(offset + 17) != 0, // isrvaluated
            cursor.isNull(offset + 18) ? null : cursor.getShort(offset + 18) != 0, // ispromissed
            cursor.isNull(offset + 19) ? null : new java.util.Date(cursor.getLong(offset + 19)), // promissedtime
            cursor.isNull(offset + 20) ? null : cursor.getString(offset + 20), // promisseduserguid
            cursor.isNull(offset + 21) ? null : cursor.getString(offset + 21), // promissedusername
            cursor.isNull(offset + 22) ? null : cursor.getString(offset + 22), // promisseduserrealname
            cursor.isNull(offset + 23) ? null : cursor.getString(offset + 23), // promissedway
            cursor.isNull(offset + 24) ? null : new java.util.Date(cursor.getLong(offset + 24)), // promisseddeadline
            cursor.isNull(offset + 25) ? null : cursor.getString(offset + 25), // promissbookpath
            cursor.isNull(offset + 26) ? null : cursor.getString(offset + 26), // signpath
            cursor.isNull(offset + 27) ? null : cursor.getString(offset + 27), // extension1
            cursor.isNull(offset + 28) ? null : cursor.getString(offset + 28), // extension2
            cursor.isNull(offset + 29) ? null : cursor.getString(offset + 29), // extension3
            cursor.isNull(offset + 30) ? null : cursor.getString(offset + 30) // remark
        );
        return entity;
    }
     
    @Override
    public void readEntity(Cursor cursor, Inspection entity, int offset) {
        entity.setGuid(cursor.isNull(offset + 0) ? null : cursor.getString(offset + 0));
        entity.setStguid(cursor.isNull(offset + 1) ? null : cursor.getString(offset + 1));
        entity.setSguid(cursor.isNull(offset + 2) ? null : cursor.getString(offset + 2));
        entity.setScensename(cursor.isNull(offset + 3) ? null : cursor.getString(offset + 3));
        entity.setScenseaddress(cursor.isNull(offset + 4) ? null : cursor.getString(offset + 4));
        entity.setIstogether(cursor.isNull(offset + 5) ? null : cursor.getShort(offset + 5) != 0);
        entity.setEntouraget(cursor.isNull(offset + 6) ? null : cursor.getString(offset + 6));
        entity.setEntouragewx(cursor.isNull(offset + 7) ? null : cursor.getString(offset + 7));
        entity.setEntourage(cursor.isNull(offset + 8) ? null : cursor.getString(offset + 8));
        entity.setExecutionstarttime(cursor.isNull(offset + 9) ? null : new java.util.Date(cursor.getLong(offset + 9)));
        entity.setExecutionendtime(cursor.isNull(offset + 10) ? null : new java.util.Date(cursor.getLong(offset + 10)));
        entity.setProblemcount(cursor.isNull(offset + 11) ? null : cursor.getInt(offset + 11));
        entity.setIsrechecked(cursor.isNull(offset + 12) ? null : cursor.getShort(offset + 12) != 0);
        entity.setRecheckcount(cursor.isNull(offset + 13) ? null : cursor.getInt(offset + 13));
        entity.setPromissednum(cursor.isNull(offset + 14) ? null : cursor.getInt(offset + 14));
        entity.setChangednum(cursor.isNull(offset + 15) ? null : cursor.getInt(offset + 15));
        entity.setIschanged(cursor.isNull(offset + 16) ? null : cursor.getShort(offset + 16) != 0);
        entity.setIsrvaluated(cursor.isNull(offset + 17) ? null : cursor.getShort(offset + 17) != 0);
        entity.setIspromissed(cursor.isNull(offset + 18) ? null : cursor.getShort(offset + 18) != 0);
        entity.setPromissedtime(cursor.isNull(offset + 19) ? null : new java.util.Date(cursor.getLong(offset + 19)));
        entity.setPromisseduserguid(cursor.isNull(offset + 20) ? null : cursor.getString(offset + 20));
        entity.setPromissedusername(cursor.isNull(offset + 21) ? null : cursor.getString(offset + 21));
        entity.setPromisseduserrealname(cursor.isNull(offset + 22) ? null : cursor.getString(offset + 22));
        entity.setPromissedway(cursor.isNull(offset + 23) ? null : cursor.getString(offset + 23));
        entity.setPromisseddeadline(cursor.isNull(offset + 24) ? null : new java.util.Date(cursor.getLong(offset + 24)));
        entity.setPromissbookpath(cursor.isNull(offset + 25) ? null : cursor.getString(offset + 25));
        entity.setSignpath(cursor.isNull(offset + 26) ? null : cursor.getString(offset + 26));
        entity.setExtension1(cursor.isNull(offset + 27) ? null : cursor.getString(offset + 27));
        entity.setExtension2(cursor.isNull(offset + 28) ? null : cursor.getString(offset + 28));
        entity.setExtension3(cursor.isNull(offset + 29) ? null : cursor.getString(offset + 29));
        entity.setRemark(cursor.isNull(offset + 30) ? null : cursor.getString(offset + 30));
     }
    
    @Override
    protected final String updateKeyAfterInsert(Inspection entity, long rowId) {
        return entity.getGuid();
    }
    
    @Override
    public String getKey(Inspection entity) {
        if(entity != null) {
            return entity.getGuid();
        } else {
            return null;
        }
    }

    @Override
    public boolean hasKey(Inspection entity) {
        return entity.getGuid() != null;
    }

    @Override
    protected final boolean isEntityUpdateable() {
        return true;
    }
    
}