Skip to content

Instantly share code, notes, and snippets.

@japj
Created March 2, 2016 21:19
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save japj/ec63305e3bdffaddfce0 to your computer and use it in GitHub Desktop.
Save japj/ec63305e3bdffaddfce0 to your computer and use it in GitHub Desktop.
sample rendering of biml syntax highlighting using rouge
<html>
<style type="text/css">
.highlight table td { padding: 5px; }
.highlight table pre { margin: 0; }
.highlight {
color: #faf6e4;
background-color: #122b3b;
}
.highlight .gl {
color: #dee5e7;
background-color: #4e5d62;
}
.highlight .c, .highlight .cd, .highlight .cm, .highlight .c1, .highlight .cs {
color: #6c8b9f;
font-style: italic;
}
.highlight .cp {
color: #b2fd6d;
font-weight: bold;
font-style: italic;
}
.highlight .err {
color: #fefeec;
background-color: #cc0000;
}
.highlight .gr {
color: #fefeec;
background-color: #cc0000;
}
.highlight .k, .highlight .kd, .highlight .kv {
color: #f6dd62;
font-weight: bold;
}
.highlight .o, .highlight .ow {
color: #4df4ff;
}
.highlight .p, .highlight .pi {
color: #4df4ff;
}
.highlight .gd {
color: #cc0000;
}
.highlight .gi {
color: #b2fd6d;
}
.highlight .ge {
font-style: italic;
}
.highlight .gs {
font-weight: bold;
}
.highlight .gt {
color: #dee5e7;
background-color: #4e5d62;
}
.highlight .kc {
color: #f696db;
font-weight: bold;
}
.highlight .kn {
color: #ffb000;
font-weight: bold;
}
.highlight .kp {
color: #ffb000;
font-weight: bold;
}
.highlight .kr {
color: #ffb000;
font-weight: bold;
}
.highlight .gh {
color: #ffb000;
font-weight: bold;
}
.highlight .gu {
color: #ffb000;
font-weight: bold;
}
.highlight .kt {
color: #b2fd6d;
font-weight: bold;
}
.highlight .no {
color: #b2fd6d;
font-weight: bold;
}
.highlight .nc {
color: #b2fd6d;
font-weight: bold;
}
.highlight .nd {
color: #b2fd6d;
font-weight: bold;
}
.highlight .nn {
color: #b2fd6d;
font-weight: bold;
}
.highlight .bp {
color: #b2fd6d;
font-weight: bold;
}
.highlight .ne {
color: #b2fd6d;
font-weight: bold;
}
.highlight .nl {
color: #ffb000;
font-weight: bold;
}
.highlight .nt {
color: #ffb000;
font-weight: bold;
}
.highlight .m, .highlight .mf, .highlight .mh, .highlight .mi, .highlight .il, .highlight .mo, .highlight .mb, .highlight .mx {
color: #f696db;
font-weight: bold;
}
.highlight .ld {
color: #f696db;
font-weight: bold;
}
.highlight .ss {
color: #f696db;
font-weight: bold;
}
.highlight .s, .highlight .sb, .highlight .sd, .highlight .s2, .highlight .sh, .highlight .sx, .highlight .sr, .highlight .s1 {
color: #fff0a6;
font-weight: bold;
}
.highlight .se {
color: #4df4ff;
font-weight: bold;
}
.highlight .sc {
color: #4df4ff;
font-weight: bold;
}
.highlight .si {
color: #4df4ff;
font-weight: bold;
}
.highlight .nb {
font-weight: bold;
}
.highlight .ni {
color: #999999;
font-weight: bold;
}
.highlight .w {
color: #BBBBBB;
}
.highlight .nf {
color: #a8e1fe;
}
.highlight .py {
color: #a8e1fe;
}
.highlight .na {
color: #a8e1fe;
}
.highlight .nv, .highlight .vc, .highlight .vg, .highlight .vi {
color: #a8e1fe;
font-weight: bold;
}
body {
color: #faf6e4;
background-color: #122b3b;
}
a {
color: #faf6e4;
background-color: #122b3b;
}
pre, code {
font-family: 'Source Code Pro', 'Menlo', 'Ubuntu Mono', 'Monaco', monospace;
font-size: 14px;
}
a { text-decoration: none }
</style>
<body>
<pre class="highlight"><code><span class="nt">&lt;#@ </span><span class="na">template language=</span><span class="s">"C#"</span> <span class="nt">#&gt;</span>
<span class="nt">&lt;#@ </span><span class="na">import namespace=</span><span class="s">"System.Data"</span> <span class="nt">#&gt;</span>
<span class="nt">&lt;Biml</span> <span class="na">xmlns=</span><span class="s">"http://schemas.varigence.com/biml.xsd"</span><span class="nt">&gt;</span>
<span class="nt">&lt;Connections&gt;</span>
<span class="c">&lt;!-- Creates a connection to the Adventure Works database --&gt;</span>
<span class="nt">&lt;Connection</span>
<span class="na">Name=</span><span class="s">"AdventureWorks"</span>
<span class="na">ConnectionString=</span><span class="s">"Provider=SQLNCLI10.1;Data Source=Localhost;Persist Security Info=False;Integrated Security=SSPI;Initial Catalog=AdventureWorksDW"</span>
<span class="nt">/&gt;</span>
<span class="nt">&lt;/Connections&gt;</span>
<span class="c">&lt;!-- Packages Collection --&gt;</span>
<span class="nt">&lt;Packages&gt;</span>
<span class="c">&lt;!-- A Package --&gt;</span>
<span class="nt">&lt;Package</span>
<span class="na">Name=</span><span class="s">"MyFirstPackage"</span>
<span class="na">ConstraintMode=</span><span class="s">"Linear"</span>
<span class="nt">&gt;</span>
<span class="c">&lt;!-- A Package's Tasks --&gt;</span>
<span class="nt">&lt;Tasks&gt;</span>
<span class="nt">&lt;ExecuteSQL</span> <span class="na">Name=</span><span class="s">"ExecuteStoredProc"</span> <span class="na">ConnectionName=</span><span class="s">"AdventureWorks"</span><span class="nt">&gt;</span>
<span class="nt">&lt;DirectInput&gt;</span>EXEC usp_StoredProc<span class="nt">&lt;/DirectInput&gt;</span>
<span class="nt">&lt;/ExecuteSQL&gt;</span>
<span class="nt">&lt;# </span><span class="k">foreach</span> <span class="p">(</span><span class="n">var</span> <span class="n">table</span> <span class="k">in</span> <span class="n">RootNode</span><span class="p">.</span><span class="n">Tables</span><span class="p">)</span> <span class="p">{</span><span class="nt"> #&gt;
&lt;Dataflow</span> <span class="na">Name=</span><span class="s">"Duplicate &lt;#=table.Name#&gt; Data"</span><span class="nt">&gt;</span>
<span class="nt">&lt;Transformations&gt;</span>
<span class="nt">&lt;OleDbSource</span> <span class="na">Name=</span><span class="s">"Retrieve Data"</span> <span class="na">ConnectionName=</span><span class="s">"AdventureWorks"</span><span class="nt">&gt;</span>
<span class="nt">&lt;DirectInput&gt;</span>SELECT * FROM <span class="nt">&lt;#=</span><span class="n">table</span><span class="p">.</span><span class="n">Name</span><span class="nt">#&gt;&lt;/DirectInput&gt;</span>
<span class="nt">&lt;/OleDbSource&gt;</span>
<span class="nt">&lt;OleDbDestination</span> <span class="na">Name=</span><span class="s">"Insert Data"</span> <span class="na">ConnectionName=</span><span class="s">"AdventureWorks"</span><span class="nt">&gt;</span>
<span class="nt">&lt;ExternalTableOutput</span> <span class="na">Table=</span><span class="s">"&lt;#=table.Name#&gt;"</span> <span class="nt">/&gt;</span>
<span class="nt">&lt;/OleDbDestination&gt;</span>
<span class="nt">&lt;/Transformations&gt;</span>
<span class="nt">&lt;/Dataflow&gt;</span>
<span class="nt">&lt;# </span><span class="p">}</span><span class="nt"> #&gt;
&lt;/Tasks&gt;</span>
<span class="nt">&lt;/Package&gt;</span>
<span class="nt">&lt;/Packages&gt;</span>
<span class="nt">&lt;/Biml&gt;</span></code></pre>
</body>
</html>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment