github.com/kyleu/dbaudit@v0.0.2-0.20240321155047-ff2f2c940496/queries/ddl/connection.sql.go (about)

     1  // Code generated by qtc from "connection.sql". DO NOT EDIT.
     2  // See https://github.com/valyala/quicktemplate for details.
     3  
     4  // -- Content managed by Project Forge, see [projectforge.md] for details.
     5  // --
     6  
     7  //line queries/ddl/connection.sql:2
     8  package ddl
     9  
    10  //line queries/ddl/connection.sql:2
    11  import (
    12  	qtio422016 "io"
    13  
    14  	qt422016 "github.com/valyala/quicktemplate"
    15  )
    16  
    17  //line queries/ddl/connection.sql:2
    18  var (
    19  	_ = qtio422016.Copy
    20  	_ = qt422016.AcquireByteBuffer
    21  )
    22  
    23  //line queries/ddl/connection.sql:2
    24  func StreamConnectionDrop(qw422016 *qt422016.Writer) {
    25  //line queries/ddl/connection.sql:2
    26  	qw422016.N().S(`
    27  if exists (select * from sysobjects where name='connection' and xtype='U')
    28  drop table "connection";
    29  -- `)
    30  //line queries/ddl/connection.sql:5
    31  }
    32  
    33  //line queries/ddl/connection.sql:5
    34  func WriteConnectionDrop(qq422016 qtio422016.Writer) {
    35  //line queries/ddl/connection.sql:5
    36  	qw422016 := qt422016.AcquireWriter(qq422016)
    37  //line queries/ddl/connection.sql:5
    38  	StreamConnectionDrop(qw422016)
    39  //line queries/ddl/connection.sql:5
    40  	qt422016.ReleaseWriter(qw422016)
    41  //line queries/ddl/connection.sql:5
    42  }
    43  
    44  //line queries/ddl/connection.sql:5
    45  func ConnectionDrop() string {
    46  //line queries/ddl/connection.sql:5
    47  	qb422016 := qt422016.AcquireByteBuffer()
    48  //line queries/ddl/connection.sql:5
    49  	WriteConnectionDrop(qb422016)
    50  //line queries/ddl/connection.sql:5
    51  	qs422016 := string(qb422016.B)
    52  //line queries/ddl/connection.sql:5
    53  	qt422016.ReleaseByteBuffer(qb422016)
    54  //line queries/ddl/connection.sql:5
    55  	return qs422016
    56  //line queries/ddl/connection.sql:5
    57  }
    58  
    59  // --
    60  
    61  //line queries/ddl/connection.sql:7
    62  func StreamConnectionCreate(qw422016 *qt422016.Writer) {
    63  //line queries/ddl/connection.sql:7
    64  	qw422016.N().S(`
    65  if not exists (select * from sysobjects where name='connection' and xtype='U')
    66  create table "connection" (
    67    "id" uniqueidentifier not null,
    68    "name" nvarchar(max) not null,
    69    "icon" nvarchar(max) not null,
    70    "engine" nvarchar(255) not null,
    71    "server" nvarchar(max) not null,
    72    "port" int not null,
    73    "username" nvarchar(max) not null,
    74    "password" nvarchar(max) not null,
    75    "database" nvarchar(max) not null,
    76    "schema" nvarchar(max) not null,
    77    "conn_override" nvarchar(max) not null,
    78    primary key ("id")
    79  );
    80  
    81  if not exists (select * from sys.indexes where name='connection' and object_id=object_id('connection__engine_idx'))
    82  create index "connection__engine_idx" on "connection" ("engine");
    83  -- `)
    84  //line queries/ddl/connection.sql:26
    85  }
    86  
    87  //line queries/ddl/connection.sql:26
    88  func WriteConnectionCreate(qq422016 qtio422016.Writer) {
    89  //line queries/ddl/connection.sql:26
    90  	qw422016 := qt422016.AcquireWriter(qq422016)
    91  //line queries/ddl/connection.sql:26
    92  	StreamConnectionCreate(qw422016)
    93  //line queries/ddl/connection.sql:26
    94  	qt422016.ReleaseWriter(qw422016)
    95  //line queries/ddl/connection.sql:26
    96  }
    97  
    98  //line queries/ddl/connection.sql:26
    99  func ConnectionCreate() string {
   100  //line queries/ddl/connection.sql:26
   101  	qb422016 := qt422016.AcquireByteBuffer()
   102  //line queries/ddl/connection.sql:26
   103  	WriteConnectionCreate(qb422016)
   104  //line queries/ddl/connection.sql:26
   105  	qs422016 := string(qb422016.B)
   106  //line queries/ddl/connection.sql:26
   107  	qt422016.ReleaseByteBuffer(qb422016)
   108  //line queries/ddl/connection.sql:26
   109  	return qs422016
   110  //line queries/ddl/connection.sql:26
   111  }