Skip to content

Instantly share code, notes, and snippets.

@leenasn
leenasn / offset_id_fields_mysql.sql
Created March 18, 2011 09:03
An SQL script to offset the id fields across all tables in a DB.
/*
This script is for updating the auto_increment field by an offset. The logic applied is
max(AUTO_INCREMENT) + current value in the table.
*/
SET @db:='id_new';
select @max_id:=max(AUTO_INCREMENT) from information_schema.tables;
select concat('update ',table_name,' set ', column_name,' = ',column_name,'+',@max_id,' ; ') from information_schema.columns where table_schema=@db and column_name like '%id' into outfile 'update_ids.sql';
[<% @users.each_with_index do |user, index| %>{
"id" : "<%= user.id %>" ,
"name" : "<%= user.full_name.split.first %>",
"profile_image_url" : "<%= user.profile_image_thumbnail.remote_url %>"
}<%= ((index + 1) == @users.size)? "" : "," %><% end %>]
[<% @users.each_with_index do |user, index| %>{
"id" : "<%= user.id %>" ,
"name" : "<%= user.full_name.split.first %>",
"profile_image_url" : "<%= user.profile_image_thumbnail.remote_url %>"
}<%= ((index + 1) == @users.count)? "" : "," %><% end %>]

Make it real

Ideas are cheap. Make a prototype, sketch a CLI session, draw a wireframe. Discuss around concrete examples, not hand-waving abstractions. Don't say you did something, provide a URL that proves it.

Ship it

Nothing is real until it's being used by a real user. This doesn't mean you make a prototype in the morning and blog about it in the evening. It means you find one person you believe your product will help and try to get them to use it.

Do it with style

@leenasn
leenasn / notification.js
Last active October 11, 2017 10:11
Push notification configure
import PushNotification from 'react-native-push-notification'
//App.js
async componentDidMount(){
PushNotification.configure({
popInitialNotification: true,
requestPermissions: true,
// (required) Called when a remote or local notification is opened or received
onNotification(notification) {
console.log('NOTIFICATION:', notification)
class PDFGenerator
def generate_pdf_from_text(text,font_attributes)
#Call the RGhost’s implementation
end
def generate_pdf_from_image(image_path,image_attributes)
#Call the LaTex’s implementation
end
def generate_pdf_from_image(image_path,image_attributes)
if USE_LATEX
#new implementation
else
#old implementation
end
end
def test_reverse
input = "abc";
result = reverse(input);
assert_equal("cba", result);
end
<div data-controller="auto-complete" data-auto-complete-url="/customers/search/">
<input type="text" name="search" id="search"
placeholder="Customer search [Name or Phone number]" list="members"
autocomplete="off" data-action="input->auto-complete#search"
data-target="auto-complete.source">
<datalist id="members" data-target="auto-complete.members">
</datalist>
</div>
import { Controller } from "stimulus"
export default class extends Controller {
static targets = [ "source", "members" ]
search(){
var searchString = this.sourceTarget.value
fetch(this.data.get("url")+"?query="+searchString)
.then(response => response.text())
.then(html => {