Skip to content

Instantly share code, notes, and snippets.

View tabiodun's full-sized avatar

Tobi Abiodun tabiodun

  • Toronto, ON
View GitHub Profile
@tabiodun
tabiodun / csv_generated_string_escape.py
Created March 31, 2020 14:58 — forked from seanieb/csv_generated_string_escape.py
Prevent CSV Injection when suing user generated data
def escape_csv(user_generated_string):
"""
CSV injection esacaping for Python. Excel treats a string as active content when it encounters a
"trigger" character at the start of the string. This method returns the string with
the triger character escaped.
"""
if user_generated_string[0] in ('@','+','-', '='):
user_generated_string = "'" + user_generated_string
import Ember from 'ember';
export default Ember.Controller.extend({
publishable: true,
actions: {
publish() {
console.log('publish');
}
}
@tabiodun
tabiodun / serialized_conversion.sql
Created December 13, 2018 00:41 — forked from statique/serialized_conversion.sql
PostgreSQL Convert Rails serialized YAML to JSON query
-- replace table_name with the name of your database table, e.g. users
-- replace data with the serialized field in the table, e.g. nicknames
-- output generates serialized data that decrypts to a Ruby array.
-- data with quotes, hyphens, or spaces will have issues with this query.
-- preview the YAML to JSON to confirm the conversion is working.
SELECT data, REPLACE(REPLACE(REPLACE(REPLACE(REGEXP_REPLACE(REPLACE(REPLACE(REPLACE(data,
' ', ''),
'...', ''),
'---', '["'),
@tabiodun
tabiodun / controllers.application.js
Last active July 31, 2018 20:30 — forked from k-fish/controllers.application.js
Flex box margin transition
import Ember from 'ember';
export default Ember.Controller.extend({
appName: 'Ember Twiddle',
actions: {
toggle() {
this.toggleProperty('isIn');
}
}