aFuyMpwf

1package init_db
2
3 import _ "fmt" import "database/sql" import _
4 "github.com/go-sql-driver/mysql" import "github.com/kataras/iris"
5
6 var db *sql.DB
7
8 //typed collections of fields type dbInit_message struct {
9    dbInit_message_title       string   dbInit_message_description string
10 }
11
12 func MainPage(c *iris.Context) {   //create sys_group_users table
13    stmt, err := db.Prepare("CREATE TABLE IF NOT EXISTS `sys_group_users`
14 (`id` int(11) NOT NULL AUTO_INCREMENT, `level` varchar(50) DEFAULT
15 NULL, `deskripsi` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`))
16 ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;")     if err !=
17 nil {      panic(err.Error())  }   stmt.Exec()     stmt.Close()
18
19    //c.HTML(iris.StatusOK, "ssd")
20    //c.Render("templates/admin2/db_success_init.html",
21 dbInit_message{"Database has been installed and configured", "Great,
22 Your database has been installed with your username : superadmin and
23 password superadmin"}, iris.RenderOptions{"gzip": true}) }
24	
25package init_db
26
27 import "database/sql" import _ "github.com/go-sql-driver/mysql" import
28 "github.com/kataras/iris"
29
30 func Database_connect(c *iris.Context) {   db, err := sql.Open("mysql",
31 "root:123empatlima@/php_beckend_admin_generator")  if err != nil {
32        panic(err.Error()) // munculin error db     }   // sql.DB menutup
33 koneksi db     defer db.Close()
34
35    // cek database konfigurasi     err = db.Ping()     if err != nil {
36        panic(err.Error())  } }