github.com/erda-project/erda-infra@v1.0.10-0.20240327085753-f3a249292aeb/providers/mysqlxorm/sqlite3/examples/main.go (about)

     1  // Copyright (c) 2021 Terminus, Inc.
     2  //
     3  // Licensed under the Apache License, Version 2.0 (the "License");
     4  // you may not use this file except in compliance with the License.
     5  // You may obtain a copy of the License at
     6  //
     7  //      http://www.apache.org/licenses/LICENSE-2.0
     8  //
     9  // Unless required by applicable law or agreed to in writing, software
    10  // distributed under the License is distributed on an "AS IS" BASIS,
    11  // WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
    12  // See the License for the specific language governing permissions and
    13  // limitations under the License.
    14  
    15  package main
    16  
    17  import (
    18  	"context"
    19  	"fmt"
    20  	"os"
    21  
    22  	"github.com/erda-project/erda-infra/base/servicehub"
    23  	"github.com/erda-project/erda-infra/providers/mysqlxorm"
    24  	_ "github.com/erda-project/erda-infra/providers/mysqlxorm/sqlite3"
    25  )
    26  
    27  type provider struct {
    28  	Sqlite3 mysqlxorm.Interface
    29  }
    30  
    31  func (p *provider) Init(ctx servicehub.Context) error {
    32  	fmt.Println(p.Sqlite3)
    33  	fmt.Println(p.Sqlite3.DB().DataSourceName())
    34  
    35  	// get journal_mode
    36  	results, _ := p.Sqlite3.DB().Query("PRAGMA journal_mode;")
    37  	for _, row := range results {
    38  		for key, value := range row {
    39  			fmt.Printf("Key: %s\t, Value:%s\n", key, string(value))
    40  		}
    41  	}
    42  
    43  	return nil
    44  }
    45  
    46  func (p *provider) Run(ctx context.Context) error {
    47  	err := p.Sqlite3.DB().Ping()
    48  	if err != nil {
    49  		fmt.Printf("connect sqlite3 error : %s \n", err)
    50  		return err
    51  	}
    52  
    53  	p.Sqlite3.Close()
    54  	return nil
    55  }
    56  
    57  func init() {
    58  	servicehub.Register("example", &servicehub.Spec{
    59  		Services:     []string{"example"},
    60  		Dependencies: []string{"sqlite3-xorm"},
    61  		Description:  "sqlite3-xorm example",
    62  		Creator: func() servicehub.Provider {
    63  			return &provider{}
    64  		},
    65  	})
    66  }
    67  
    68  func main() {
    69  	hub := servicehub.New()
    70  	hub.Run("examples", "", os.Args...)
    71  }