github.com/kotovmak/go-admin@v1.1.1/examples/datamodel/mysql_types.go (about)

     1  package datamodel
     2  
     3  import (
     4  	"github.com/kotovmak/go-admin/modules/db"
     5  	"github.com/kotovmak/go-admin/plugins/admin/modules/table"
     6  	"github.com/kotovmak/go-admin/template/types/form"
     7  )
     8  
     9  // GetAllTypesTable return the model of table types.
    10  func GetAllTypesTable() table.Table {
    11  
    12  	allTypesTable := table.NewDefaultTable(table.DefaultConfigWithDriver("mysql"))
    13  
    14  	info := allTypesTable.GetInfo()
    15  
    16  	info.AddField("Id", "id", db.Int)
    17  	info.AddField("Type_1", "type_1", db.Tinyint)
    18  	info.AddField("Type_2", "type_2", db.Smallint)
    19  	info.AddField("Type_3", "type_3", db.Mediumint)
    20  	info.AddField("Type_4", "type_4", db.Bigint)
    21  	info.AddField("Type_5", "type_5", db.Float)
    22  	info.AddField("Type_6", "type_6", db.Double)
    23  	info.AddField("Type_7", "type_7", db.Double)
    24  	info.AddField("Type_8", "type_8", db.Double)
    25  	info.AddField("Type_9", "type_9", db.Decimal)
    26  	info.AddField("Type_10", "type_10", db.Bit)
    27  	info.AddField("Type_11", "type_11", db.Tinyint)
    28  	info.AddField("Type_12", "type_12", db.Tinyint)
    29  	info.AddField("Type_13", "type_13", db.Decimal)
    30  	info.AddField("Type_14", "type_14", db.Decimal)
    31  	info.AddField("Type_15", "type_15", db.Decimal)
    32  	info.AddField("Type_16", "type_16", db.Char)
    33  	info.AddField("Type_17", "type_17", db.Varchar)
    34  	info.AddField("Type_18", "type_18", db.Tinytext)
    35  	info.AddField("Type_19", "type_19", db.Text)
    36  	info.AddField("Type_20", "type_20", db.Mediumtext)
    37  	info.AddField("Type_21", "type_21", db.Longtext)
    38  	info.AddField("Type_22", "type_22", db.Tinyblob)
    39  	info.AddField("Type_23", "type_23", db.Mediumblob)
    40  	info.AddField("Type_24", "type_24", db.Blob)
    41  	info.AddField("Type_25", "type_25", db.Longblob)
    42  	info.AddField("Type_26", "type_26", db.Binary)
    43  	info.AddField("Type_27", "type_27", db.Varbinary)
    44  	info.AddField("Type_28", "type_28", db.Enum)
    45  	info.AddField("Type_29", "type_29", db.Set)
    46  	info.AddField("Type_30", "type_30", db.Date)
    47  	info.AddField("Type_31", "type_31", db.Datetime)
    48  	info.AddField("Type_32", "type_32", db.Timestamp)
    49  	info.AddField("Type_33", "type_33", db.Time)
    50  	info.AddField("Type_34", "type_34", db.Year)
    51  	info.AddField("Type_35", "type_35", db.Geometry)
    52  	info.AddField("Type_36", "type_36", db.Point)
    53  	info.AddField("Type_39", "type_39", db.Multilinestring)
    54  	info.AddField("Type_41", "type_41", db.Multipolygon)
    55  	info.AddField("Type_37", "type_37", db.Linestring)
    56  	info.AddField("Type_38", "type_38", db.Polygon)
    57  	info.AddField("Type_40", "type_40", db.Multipoint)
    58  	info.AddField("Type_42", "type_42", db.Geometrycollection)
    59  	info.AddField("Type_50", "type_50", db.Double)
    60  	info.AddField("Type_51", "type_51", db.JSON)
    61  
    62  	info.SetTable("all_types").SetTitle("All_types").SetDescription("All_types")
    63  
    64  	formList := allTypesTable.GetForm()
    65  
    66  	formList.AddField("Id", "id", db.Int, form.Default)
    67  	formList.AddField("Type_1", "type_1", db.Tinyint, form.Number)
    68  	formList.AddField("Type_2", "type_2", db.Smallint, form.Number)
    69  	formList.AddField("Type_3", "type_3", db.Mediumint, form.Number)
    70  	formList.AddField("Type_4", "type_4", db.Bigint, form.Number)
    71  	formList.AddField("Type_5", "type_5", db.Float, form.Text)
    72  	formList.AddField("Type_6", "type_6", db.Double, form.Text)
    73  	formList.AddField("Type_7", "type_7", db.Double, form.Text)
    74  	formList.AddField("Type_8", "type_8", db.Double, form.Text)
    75  	formList.AddField("Type_9", "type_9", db.Decimal, form.Text)
    76  	formList.AddField("Type_10", "type_10", db.Bit, form.Text)
    77  	formList.AddField("Type_11", "type_11", db.Tinyint, form.Number)
    78  	formList.AddField("Type_12", "type_12", db.Tinyint, form.Number)
    79  	formList.AddField("Type_13", "type_13", db.Decimal, form.Text)
    80  	formList.AddField("Type_14", "type_14", db.Decimal, form.Text)
    81  	formList.AddField("Type_15", "type_15", db.Decimal, form.Text)
    82  	formList.AddField("Type_16", "type_16", db.Char, form.Text)
    83  	formList.AddField("Type_17", "type_17", db.Varchar, form.Text)
    84  	formList.AddField("Type_18", "type_18", db.Tinytext, form.RichText)
    85  	formList.AddField("Type_19", "type_19", db.Text, form.RichText)
    86  	formList.AddField("Type_20", "type_20", db.Mediumtext, form.RichText)
    87  	formList.AddField("Type_21", "type_21", db.Longtext, form.RichText)
    88  	formList.AddField("Type_22", "type_22", db.Tinyblob, form.Text)
    89  	formList.AddField("Type_23", "type_23", db.Mediumblob, form.Text)
    90  	formList.AddField("Type_24", "type_24", db.Blob, form.Text)
    91  	formList.AddField("Type_25", "type_25", db.Longblob, form.Text)
    92  	formList.AddField("Type_26", "type_26", db.Binary, form.Text)
    93  	formList.AddField("Type_27", "type_27", db.Varbinary, form.Text)
    94  	formList.AddField("Type_28", "type_28", db.Enum, form.Text)
    95  	formList.AddField("Type_29", "type_29", db.Set, form.Text)
    96  	formList.AddField("Type_30", "type_30", db.Date, form.Datetime)
    97  	formList.AddField("Type_31", "type_31", db.Datetime, form.Datetime)
    98  	formList.AddField("Type_32", "type_32", db.Timestamp, form.Datetime)
    99  	formList.AddField("Type_33", "type_33", db.Time, form.Datetime)
   100  	formList.AddField("Type_34", "type_34", db.Year, form.Datetime)
   101  	formList.AddField("Type_35", "type_35", db.Geometry, form.Text)
   102  	formList.AddField("Type_36", "type_36", db.Point, form.Text)
   103  	formList.AddField("Type_39", "type_39", db.Multilinestring, form.Text)
   104  	formList.AddField("Type_41", "type_41", db.Multipolygon, form.Text)
   105  	formList.AddField("Type_37", "type_37", db.Linestring, form.Text)
   106  	formList.AddField("Type_38", "type_38", db.Polygon, form.Text)
   107  	formList.AddField("Type_40", "type_40", db.Multipoint, form.Text)
   108  	formList.AddField("Type_42", "type_42", db.Geometrycollection, form.Text)
   109  	formList.AddField("Type_50", "type_50", db.Double, form.Text)
   110  	formList.AddField("Type_51", "type_51", db.JSON, form.Text)
   111  
   112  	formList.SetTable("all_types").SetTitle("All_types").SetDescription("All_types")
   113  
   114  	return allTypesTable
   115  }