<commit_before>package org.damage.db;

import org.sahana.share.db.AbstractSQLGenerator;


public class SQLGenerator extends AbstractSQLGenerator{

    public static String getSQLForAddDamagedHouse(){
        String s = "INSERT INTO "
                    + DBConstants.Tables.HOUSE
                    +"("
                    //+DBConstants.TableColumns.ID + ", "
                    +DBConstants.TableColumns.DISTRICT_CODE + ", "
                    +DBConstants.TableColumns.DIVISION + ", "
                    +DBConstants.TableColumns.GSN + ", "
                    +DBConstants.TableColumns.OWNER + ", "
                    +DBConstants.TableColumns.DISTANCE_FROM_SEA + ", "
                    +DBConstants.TableColumns.CITY + ", "
                    +DBConstants.TableColumns.NO_AND_STREET + ", "
                    +DBConstants.TableColumns.CURRENT_ADDRESS + ", "
                    +DBConstants.TableColumns.FLOOR_AREA + ", "
                    +DBConstants.TableColumns.NO_OF_STORIES + ", "
                    +DBConstants.TableColumns.TYPE_OF_OWNERSHIP + ", "
                    +DBConstants.TableColumns.NO_OF_RESIDENTS + ", "
                    +DBConstants.TableColumns.TYPE_OF_CONSTRUCTION + ", "
                    +DBConstants.TableColumns.PROPERTY_TAX_NO + ", "
                    +DBConstants.TableColumns.TOTAL_DAMAGED_COST + ", "
                    +DBConstants.TableColumns.LAND_AREA + ", "
                    +DBConstants.TableColumns.RELOCATE + ", "
                    +DBConstants.TableColumns.INSURED + ", "
                    +DBConstants.TableColumns.DAMAGE_TYPE + ", "
                    +DBConstants.TableColumns.COMMENTS
                    + ")"
                    +" VALUES "
                    +"(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";

        return s;
    }

    public static String getSQLForAddDamagedHouse_Damage_Moreinfo(){
        String s = "INSERT INTO "
                    + DBConstants.Tables.HOUSE_DAMAGE_MOREINFO
                    +"("
                    +DBConstants.TableColumns.HOUSE_ID + ", "
                    +DBConstants.TableColumns.DAMAGE_INFO
                    + ")"
                    +" VALUES"
                    +"(?,?)";

        return s;
    }

    public static String getSQLForAddDamagedHouse_Facility_Info(){
        String s = "INSERT INTO "
                    + DBConstants.Tables.HOUSE_FACILITY_INFO
                    +"("
                    +DBConstants.TableColumns.HOUSE_ID + ", "
                    +DBConstants.TableColumns.FACILITY_NAME + ", "
                    +DBConstants.TableColumns.DESCRIPTION
                    + ")"
                    +" VALUES"
                    +"(?,?,?)";

        return s;
    }
      public static String getSQLForSearchCriteria() {

       String H = "H";
       String H_MORE = "H_MORE";
       String H_F = "HF";

//           private String districtCode;
//    private String division;
//    private String gsn;
//    private String owner;
//    private double distanceFromSea;
//    private String city;
//    private String noAndStreet;
//    private String currentAddress;
//    private double floorArea;
//    private int noOfStories;
//    private String typeOfOwnership;
//    private int noOfResidents;
//    private String typeOfConstruction;
//    private String propertyTaxNo;
//    private double totalDamagedCost;
//    private double landArea;
//    private boolean relocate;
//    private boolean insured;
//    private String damageType;
//    private String comments;

        return "SELECT "
            + DBConstants.TableColumns.DISTRICT_CODE + ","
            + DBConstants.TableColumns.DIVISION + ","
            + DBConstants.TableColumns.GSN + ","
            + DBConstants.TableColumns.OWNER + ","
            + DBConstants.TableColumns.DISTANCE_FROM_SEA + ","
            + DBConstants.TableColumns.FLOOR_AREA + ","
            + DBConstants.TableColumns.NO_OF_STORIES + ","
            + DBConstants.TableColumns.DAMAGE_TYPE + ","
            + DBConstants.TableColumns.TYPE_OF_OWNERSHIP + ","
            + DBConstants.TableColumns.TYPE_OF_CONSTRUCTION + ","
            + DBConstants.TableColumns.PROPERTY_TAX_NO + ","
            + DBConstants.TableColumns.TOTAL_DAMAGED_COST + ","
            + DBConstants.TableColumns.LAND_AREA + ","
            + DBConstants.TableColumns.RELOCATE + ","
            + DBConstants.TableColumns.INSURED + ","
            + DBConstants.TableColumns.DAMAGE_TYPE + ","
            + DBConstants.TableColumns.COMMENTS + ","<commit_msg>*** empty log message ***<commit_after>package org.damage.db;

import org.sahana.share.db.AbstractSQLGenerator;


public class SQLGenerator extends AbstractSQLGenerator{

    public static String getSQLForAddDamagedHouse(){
        String s = "INSERT INTO "
                    + DBConstants.Tables.HOUSE
                    +"("
                    //+DBConstants.TableColumns.ID + ", "
                    +DBConstants.TableColumns.DISTRICT_CODE + ", "
                    +DBConstants.TableColumns.DIVISION + ", "
                    +DBConstants.TableColumns.GSN + ", "
                    +DBConstants.TableColumns.OWNER + ", "
                    +DBConstants.TableColumns.DISTANCE_FROM_SEA + ", "
                    +DBConstants.TableColumns.CITY + ", "
                    +DBConstants.TableColumns.NO_AND_STREET + ", "
                    +DBConstants.TableColumns.CURRENT_ADDRESS + ", "
                    +DBConstants.TableColumns.FLOOR_AREA + ", "
                    +DBConstants.TableColumns.NO_OF_STORIES + ", "
                    +DBConstants.TableColumns.TYPE_OF_OWNERSHIP + ", "
                    +DBConstants.TableColumns.NO_OF_RESIDENTS + ", "
                    +DBConstants.TableColumns.TYPE_OF_CONSTRUCTION + ", "
                    +DBConstants.TableColumns.PROPERTY_TAX_NO + ", "
                    +DBConstants.TableColumns.TOTAL_DAMAGED_COST + ", "
                    +DBConstants.TableColumns.LAND_AREA + ", "
                    +DBConstants.TableColumns.RELOCATE + ", "
                    +DBConstants.TableColumns.INSURED + ", "
                    +DBConstants.TableColumns.DAMAGE_TYPE + ", "
                    +DBConstants.TableColumns.COMMENTS
                    + ")"
                    +" VALUES "
                    +"(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";

        return s;
    }

    public static String getSQLForAddDamagedHouse_Damage_Moreinfo(){
        String s = "INSERT INTO "
                    + DBConstants.Tables.HOUSE_DAMAGE_MOREINFO
                    +"("
                    +DBConstants.TableColumns.HOUSE_ID + ", "
                    +DBConstants.TableColumns.DAMAGE_INFO
                    + ")"
                    +" VALUES"
                    +"(?,?)";

        return s;
    }

    public static String getSQLForAddDamagedHouse_Facility_Info(){
        String s = "INSERT INTO "
                    + DBConstants.Tables.HOUSE_FACILITY_INFO
                    +"("
                    +DBConstants.TableColumns.HOUSE_ID + ", "
                    +DBConstants.TableColumns.FACILITY_NAME + ", "
                    +DBConstants.TableColumns.DESCRIPTION
                    + ")"
                    +" VALUES"
                    +"(?,?,?)";

        return s;
    }
      public static String getSQLForSearchCriteria() {

       String H = "H";
       String H_MORE = "HM";
       String H_F = "HF";

        return "SELECT "
            + DBConstants.TableColumns.DISTRICT_CODE + ","
            + DBConstants.TableColumns.DIVISION + ","
            + DBConstants.TableColumns.GSN + ","
            + DBConstants.TableColumns.OWNER + ","
            + DBConstants.TableColumns.DISTANCE_FROM_SEA + ","
            + DBConstants.TableColumns.FLOOR_AREA + ","
            + DBConstants.TableColumns.NO_OF_STORIES + ","
            + DBConstants.TableColumns.DAMAGE_TYPE + ","
            + DBConstants.TableColumns.TYPE_OF_OWNERSHIP + ","
            + DBConstants.TableColumns.TYPE_OF_CONSTRUCTION + ","
            + DBConstants.TableColumns.PROPERTY_TAX_NO + ","
            + DBConstants.TableColumns.TOTAL_DAMAGED_COST + ","
            + DBConstants.TableColumns.LAND_AREA + ","
            + DBConstants.TableColumns.RELOCATE + ","
            + DBConstants.TableColumns.INSURED + ","
            + DBConstants.TableColumns.DAMAGE_TYPE + ","
            + DBConstants.TableColumns.COMMENTS 
{'fraction_non_alphanumeric': 0.11433993595065828, 'fraction_numerical': 0.0, 'mean_word_length': 1.6465787821720026, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '5901136', 'n_tokens_mistral': 2353, 'n_tokens_neox': 2185, 'n_words': 270}