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

     1  // Code generated by qtc from "statement.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/statement.sql:2
     8  package ddl
     9  
    10  //line queries/ddl/statement.sql:2
    11  import (
    12  	qtio422016 "io"
    13  
    14  	qt422016 "github.com/valyala/quicktemplate"
    15  )
    16  
    17  //line queries/ddl/statement.sql:2
    18  var (
    19  	_ = qtio422016.Copy
    20  	_ = qt422016.AcquireByteBuffer
    21  )
    22  
    23  //line queries/ddl/statement.sql:2
    24  func StreamStatementDrop(qw422016 *qt422016.Writer) {
    25  //line queries/ddl/statement.sql:2
    26  	qw422016.N().S(`
    27  if exists (select * from sysobjects where name='statement' and xtype='U')
    28  drop table "statement";
    29  -- `)
    30  //line queries/ddl/statement.sql:5
    31  }
    32  
    33  //line queries/ddl/statement.sql:5
    34  func WriteStatementDrop(qq422016 qtio422016.Writer) {
    35  //line queries/ddl/statement.sql:5
    36  	qw422016 := qt422016.AcquireWriter(qq422016)
    37  //line queries/ddl/statement.sql:5
    38  	StreamStatementDrop(qw422016)
    39  //line queries/ddl/statement.sql:5
    40  	qt422016.ReleaseWriter(qw422016)
    41  //line queries/ddl/statement.sql:5
    42  }
    43  
    44  //line queries/ddl/statement.sql:5
    45  func StatementDrop() string {
    46  //line queries/ddl/statement.sql:5
    47  	qb422016 := qt422016.AcquireByteBuffer()
    48  //line queries/ddl/statement.sql:5
    49  	WriteStatementDrop(qb422016)
    50  //line queries/ddl/statement.sql:5
    51  	qs422016 := string(qb422016.B)
    52  //line queries/ddl/statement.sql:5
    53  	qt422016.ReleaseByteBuffer(qb422016)
    54  //line queries/ddl/statement.sql:5
    55  	return qs422016
    56  //line queries/ddl/statement.sql:5
    57  }
    58  
    59  // --
    60  
    61  //line queries/ddl/statement.sql:7
    62  func StreamStatementCreate(qw422016 *qt422016.Writer) {
    63  //line queries/ddl/statement.sql:7
    64  	qw422016.N().S(`
    65  if not exists (select * from sysobjects where name='statement' and xtype='U')
    66  create table "statement" (
    67    "id" uniqueidentifier not null,
    68    "session_id" int not null,
    69    "action" nvarchar(255) not null,
    70    "succeeded" bit not null,
    71    "principal" nvarchar(max) not null,
    72    "database" nvarchar(max) not null,
    73    "filename" nvarchar(max) not null,
    74    "host" nvarchar(max) not null,
    75    "transaction_id" int not null,
    76    "client_ip" nvarchar(max) not null,
    77    "duration" int not null,
    78    "connection_id" uniqueidentifier not null,
    79    "rows_affected" int not null,
    80    "rows_returned" int not null,
    81    "sql" nvarchar(max) not null,
    82    "types" nvarchar(max) not null,
    83    "values" nvarchar(max) not null,
    84    "occurred" datetime not null,
    85    primary key ("id")
    86  );
    87  
    88  if not exists (select * from sys.indexes where name='statement' and object_id=object_id('statement__action_idx'))
    89  create index "statement__action_idx" on "statement" ("action");
    90  -- `)
    91  //line queries/ddl/statement.sql:33
    92  }
    93  
    94  //line queries/ddl/statement.sql:33
    95  func WriteStatementCreate(qq422016 qtio422016.Writer) {
    96  //line queries/ddl/statement.sql:33
    97  	qw422016 := qt422016.AcquireWriter(qq422016)
    98  //line queries/ddl/statement.sql:33
    99  	StreamStatementCreate(qw422016)
   100  //line queries/ddl/statement.sql:33
   101  	qt422016.ReleaseWriter(qw422016)
   102  //line queries/ddl/statement.sql:33
   103  }
   104  
   105  //line queries/ddl/statement.sql:33
   106  func StatementCreate() string {
   107  //line queries/ddl/statement.sql:33
   108  	qb422016 := qt422016.AcquireByteBuffer()
   109  //line queries/ddl/statement.sql:33
   110  	WriteStatementCreate(qb422016)
   111  //line queries/ddl/statement.sql:33
   112  	qs422016 := string(qb422016.B)
   113  //line queries/ddl/statement.sql:33
   114  	qt422016.ReleaseByteBuffer(qb422016)
   115  //line queries/ddl/statement.sql:33
   116  	return qs422016
   117  //line queries/ddl/statement.sql:33
   118  }