routines.html (12190B)
1 <!DOCTYPE html> 2 <html> 3 <head> 4 <meta charset="utf-8"> 5 <meta http-equiv="X-UA-Compatible" content="IE=edge"> 6 <title>postgres.c2ec</title> 7 <!-- Tell the browser to be responsive to screen width --> 8 <meta content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no" name="viewport"> 9 <link rel="icon" type="image/png" sizes="16x16" href="favicon.png"> 10 <!-- Bootstrap 3.3.5 --> 11 <link rel="stylesheet" href="bower/admin-lte/bootstrap/css/bootstrap.min.css"> 12 <!-- Font Awesome --> 13 <link rel="stylesheet" href="bower/font-awesome/css/font-awesome.min.css"> 14 <!-- Ionicons --> 15 <link rel="stylesheet" href="bower/ionicons/css/ionicons.min.css"> 16 <!-- DataTables --> 17 <link rel="stylesheet" href="bower/datatables.net-bs/css/dataTables.bootstrap.min.css"> 18 <link rel="stylesheet" href="bower/datatables.net-buttons-bs/css/buttons.bootstrap.min.css"> 19 <!-- Code Mirror --> 20 <link rel="stylesheet" href="bower/codemirror/codemirror.css"> 21 <!-- Fonts --> 22 <link href='fonts/indieflower/indie-flower.css' rel='stylesheet' type='text/css'> 23 <link href='fonts/source-sans-pro/source-sans-pro.css' rel='stylesheet' type='text/css'> 24 25 <!-- Theme style --> 26 <link rel="stylesheet" href="bower/admin-lte/dist/css/AdminLTE.min.css"> 27 <!-- Salvattore --> 28 <link rel="stylesheet" href="bower/salvattore/salvattore.css"> 29 <!-- AdminLTE Skins. Choose a skin from the css/skins 30 folder instead of downloading all of them to reduce the load. --> 31 <link rel="stylesheet" href="bower/admin-lte/dist/css/skins/_all-skins.min.css"> 32 <!-- SchemaSpy --> 33 <link rel="stylesheet" href="schemaSpy.css"> 34 35 <!-- HTML5 Shim and Respond.js IE8 support of HTML5 elements and media queries --> 36 <!-- WARNING: Respond.js doesn't work if you view the page via file:// --> 37 <!--[if lt IE 9]> 38 <script src="bower/html5shiv/html5shiv.min.js"></script> 39 <script src="bower/respond/respond.min.js"></script> 40 <![endif]--> 41 </head> 42 <!-- ADD THE CLASS layout-top-nav TO REMOVE THE SIDEBAR. --> 43 <body class="hold-transition skin-blue layout-top-nav"> 44 <div class="wrapper"> 45 <header class="main-header"> 46 <nav class="navbar navbar-static-top"> 47 <div class="container"> 48 <div class="navbar-header"> 49 <a href="index.html" class="navbar-brand"><b>postgres</b></a><span class="navbar-brand" style="padding-left: 0">.c2ec</span> 50 <button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#navbar-collapse"><i class="fa fa-bars"></i></button> 51 </div> 52 53 <!-- Collect the nav links, forms, and other content for toggling --> 54 <div class="collapse navbar-collapse pull-left" id="navbar-collapse"> 55 <ul class="nav navbar-nav"> 56 <li><a href="index.html">Tables <span class="sr-only">(current)</span></a></li> 57 <li><a href="columns.html" title="All of the columns in the schema">Columns</a></li> 58 <li><a href="constraints.html" title="Useful for diagnosing error messages that just give constraint name or number">Constraints</a></li> 59 <li><a href="relationships.html" title="Diagram of table relationships">Relationships</a></li> 60 <li><a href="orphans.html" title="View of tables with neither parents nor children">Orphan Tables</a></li> 61 <li><a href="anomalies.html" title="Things that might not be quite right">Anomalies</a></li> 62 <li><a href="routines.html" title="Procedures and functions">Routines</a></li> 63 </ul> 64 </div> 65 <!-- /.navbar-collapse --> 66 <!-- Navbar Right Menu --> 67 </div> 68 <!-- /.container-fluid --> 69 </nav> 70 </header> 71 <!-- Main content --> 72 <!-- Full Width Column --> 73 <div class="content-wrapper"> 74 <!-- Content Header (Page header) --> 75 <section class="content-header"> 76 <h1>Routines</h1> 77 </section> 78 <!-- Main content --> 79 <section class="content"> 80 <div class="box box-primary"> 81 <div class="box-header with-border"> 82 <i class="fa fa-file-code-o" aria-hidden="true"></i> 83 <h3 class="box-title">Routines</h3> 84 </div> 85 <div class="box-body"> 86 <table 87 id="routine_table" 88 class="table table-bordered table-striped dataTable" 89 role="grid" 90 data-paging="true" 91 data-page-length="50" 92 data-length-change="false"> 93 <thead align='left'> 94 <tr> 95 <th>Name</th> 96 <th>Type</th> 97 <th>Language</th> 98 <th>Deterministic</th> 99 <th>Return Type</th> 100 <th>Security Restriction</th> 101 <th title='Comments' class="toggle"><span>Comments</span></th> 102 </tr> 103 </thead> 104 <tbody> 105 <tr> 106 <td><a href="routines/emit_transfer_notification___ed278d94.html">emit_transfer_notification()</a></td> 107 <td>FUNCTION</td> 108 <td>plpgsql</td> 109 <td>false</td> 110 <td>trigger</td> 111 <td>INVOKER</td> 112 <td><p>The function emits the request_uid of a transfer which shall trigger a transfer by the receiver of the notification.</p></td> 113 </tr> 114 <tr> 115 <td><a href="routines/emit_withdrawal_status___b48bc651.html">emit_withdrawal_status()</a></td> 116 <td>FUNCTION</td> 117 <td>plpgsql</td> 118 <td>false</td> 119 <td>trigger</td> 120 <td>INVOKER</td> 121 <td><p>The function encodes the wopid in base64 and sends a notification on the channel “w_{wopid}” with the status in the payload.</p></td> 122 </tr> 123 <tr> 124 <td><a href="routines/emit_payment_notification___f8fd6071.html">emit_payment_notification()</a></td> 125 <td>FUNCTION</td> 126 <td>plpgsql</td> 127 <td>false</td> 128 <td>trigger</td> 129 <td>INVOKER</td> 130 <td><p>The function emits the name of the provider, row id of the withdrawal and the provider_transaction_id, on the channel “payment_notification”. The format of the payload is as follows: “{PROVIDER_NAME}|{WITHDRAWAL_ID}|{PROVIDER_TRANSACTION_ID}”. The subscriber shall decide which attestation process to use, based on the name of the provider.</p></td> 131 </tr> 132 <tr> 133 <td><a href="routines/emit_retry_notification___f0cf628f.html">emit_retry_notification()</a></td> 134 <td>FUNCTION</td> 135 <td>plpgsql</td> 136 <td>false</td> 137 <td>trigger</td> 138 <td>INVOKER</td> 139 <td><p>The function emits the id of the withdrawal for which the last retry timestamp was updated. This shall trigger a retry operation. How many retries are attempted is specified and handled by the application</p></td> 140 </tr> 141 </tbody> 142 </table> 143 </div> 144 </div> 145 </section> 146 <script> 147 var config = { 148 pagination: true 149 } 150 </script> 151 </div> 152 <!-- /.content-wrapper --> 153 <footer class="main-footer"> 154 <div> 155 <div class="pull-right hidden-xs"> 156 <a href="https://github.com/schemaspy/schemaspy" title="GitHub for SchemaSpy"><i class="fa fa-github-square fa-2x"></i></a> 157 <a href="http://stackoverflow.com/questions/tagged/schemaspy" title="StackOverflow for SchemaSpy"><i class="fa fa-stack-overflow fa-2x"></i></a> 158 </div> 159 <strong>Generated by <a href="http://schemaspy.org/" class="logo-text"><i class="fa fa-database"></i> SchemaSpy 6.2.4</a></strong> 160 </div> 161 <!-- /.container --> 162 </footer> 163 </div> 164 <!-- ./wrapper --> 165 166 <!-- jQuery 2.2.3 --> 167 <script src="bower/admin-lte/plugins/jQuery/jquery-2.2.3.min.js"></script> 168 <script src="bower/admin-lte/plugins/jQueryUI/jquery-ui.min.js"></script> 169 <!-- Bootstrap 3.3.5 --> 170 <script src="bower/admin-lte/bootstrap/js/bootstrap.min.js"></script> 171 <!-- DataTables --> 172 <script src="bower/datatables.net/jquery.dataTables.min.js"></script> 173 <script src="bower/datatables.net-bs/js/dataTables.bootstrap.min.js"></script> 174 <script src="bower/datatables.net-buttons/dataTables.buttons.min.js"></script> 175 <script src="bower/datatables.net-buttons-bs/js/buttons.bootstrap.min.js"></script> 176 <script src="bower/datatables.net-buttons/buttons.html5.min.js"></script> 177 <script src="bower/datatables.net-buttons/buttons.print.min.js"></script> 178 <script src="bower/datatables.net-buttons/buttons.colVis.min.js"></script> 179 <!-- SheetJS --> 180 <script src="bower/js-xlsx/xlsx.full.min.js"></script> 181 <!-- pdfmake --> 182 <script src="bower/pdfmake/pdfmake.min.js"></script> 183 <script src="bower/pdfmake/vfs_fonts.js"></script> 184 <!-- SlimScroll --> 185 <script src="bower/admin-lte/plugins/slimScroll/jquery.slimscroll.min.js"></script> 186 <!-- FastClick --> 187 <script src="bower/admin-lte/plugins/fastclick/fastclick.js"></script> 188 <!-- Salvattore --> 189 <script src="bower/salvattore/salvattore.min.js"></script> 190 <!-- AnchorJS --> 191 <script src="bower/anchor-js/anchor.min.js"></script> 192 <!-- CodeMirror --> 193 <script src="bower/codemirror/codemirror.js"></script> 194 <script src="bower/codemirror/sql.js"></script> 195 <!-- AdminLTE App --> 196 <script src="bower/admin-lte/dist/js/app.min.js"></script> 197 <script src="routines.js"></script> 198 <script src="schemaSpy.js"></script> 199 </body> 200 </html>