Skip to content

Instantly share code, notes, and snippets.

View SGCreations's full-sized avatar

SG Creations SGCreations

View GitHub Profile
DROP PROCEDURE IF EXISTS `drop_all_tables`;
DELIMITER $$
CREATE PROCEDURE `drop_all_tables` ()
BEGIN
DECLARE _done int DEFAULT FALSE;
DECLARE _tableName varchar(255);
DECLARE _cursor CURSOR FOR
SELECT
table_name
Search element via Regex:
jQuery.expr[':'].regex = function (elem, index, match) {
var matchParams = match[3].split(','),
validLabels = /^(data|css):/,
attr = {
method: matchParams[0].match(validLabels) ?
matchParams[0].split(':')[0] : 'attr',
property: matchParams.shift().replace(validLabels, '')
},
using System;
using System.Collections.Generic;
using System.Text;
using System.Xml.Serialization;
[XmlRoot("dictionary")]
public class SerializableDictionary<TKey, TValue>
: Dictionary<TKey, TValue>, IXmlSerializable
{
#region IXmlSerializable Members
select 'replacewithtablename' into @table;
select 'replacewithdatabasename' into @schema;
select concat('public class ',@table,'{')
union
select concat('public ',tps.dest,' ',column_name,'{get;set;}')
from information_schema.columns c
join (
select 'char' as orign ,'string' as dest union all
using System;
using System.Collections;
using System.Data;
using MySql.Data.MySqlClient;
using System.Linq;
using System.Xml;
namespace OBALog.Data
{
[System.Diagnostics.DebuggerStepThrough]
@SGCreations
SGCreations / gist:d43d4182421805393020
Last active April 27, 2016 14:46
Tomcat configuration
<filter>
<filter-name>HTTP Header Security Filter</filter-name>
<filter-class>org.apache.catalina.filters.HttpHeaderSecurityFilter</filter-class>
<init-param>
<param-name>antiClickJackingOption</param-name>
<param-value>ALLOW-FROM</param-value>
</init-param>
</filter>
<filter>
javascript:var inputs = document.getElementsByClassName('uiButton _1sm'); for(var i=0; i<inputs.length;i++) {inputs[i].click();}