Skip to content

Instantly share code, notes, and snippets.

View n1k0's full-sized avatar
✏️
writing a github status

Nicolas Perriault n1k0

✏️
writing a github status
View GitHub Profile
<!DOCTYPE html>
<html>
<head>
<meta name="description" content="A sample react dropdown menu component" />
<script src="//fb.me/react-with-addons-0.10.0.js"></script>
<meta charset="utf-8">
<title>JS Bin</title>
</head>
<body>
<div id="menu"></div>

How to export/import a mysql database with utf-8

Not easy, but doable:

  1. Exporting the database:

    $ mysqldump -uuser -p --opt --default-character-set=utf8 mabase > mabase.sql
  2. Charset conversion:
<?php
class fooActions extends sfActions
{
/**
* Changes current user culture, and redirect the user to the translated doctrine
* route url he came from (especially useful when you have these pretty things
* called translated slugs in your I18nized doctrine models).
*
* PLEASE NOTE: it might be the most awful piece of code I ever produced, but...
* well, it works™
<?php
/**
* @see ioCombinerResponse
*/
class RdcCombinerResponse extends ioCombinerResponse
{
/**
* Use this to replace all the specified javascripts in the response
* with the combined javascript
*/
<?php
/**
* Generates a toucan.
*
*/
class sfGenerateToucanTask extends sfTask
{
const TOUCAN = 'ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIC
@n1k0
n1k0 / getchromium.sh
Created February 15, 2010 10:51
OSX Chromium.app upgrader
# code has moved there http://github.com/n1k0/chromium-updater
@n1k0
n1k0 / sfMongoDatabase.class.php
Created February 22, 2010 08:42
sfDatabase compatible MongoDB database backend driver
<?php
/**
* sfDatabase compatible MongoDB database backend driver
*
* @package database
* @author Nicolas Perriault
*/
class sfMongoDatabase extends sfDatabase
{
/**
@n1k0
n1k0 / TextUtilsHelper.php
Created March 9, 2010 16:11
Linkifies a text. Will use the `truncate_text` function of Symfony's Text helper.
<?php
/**
* Linkifies a text. Will use the `truncate_text` function of Symfony's Text helper.
*
* I'm not really proud of it, but eh, it works™.
*
* @param string $text Initial text
* @param int $maxLength Max link caption length
* @param Boolean $nofollow Add rel="nofollow" to generated links
*
@n1k0
n1k0 / MardownHelper.php
Created April 7, 2010 09:40
Mardown syntax rendering helper for the Symfony framework
<?php
require_once dirname(__FILE__).'/../vendor/php-markdown/markdown.php';
/**
* Markdown Symfony Helper, require PHP Markdown library: http://michelf.com/projects/php-markdown/
*
* The idea is to parse and render text written using the Markdown format directly from your
* Symfony templates.
*
* Sample usage:
from django.db import models
from django.db.models import Avg, Max, Min, Count
class Fortune(models.Model):
author = models.CharField(max_length=45, blank=False)
title = models.CharField(max_length=200, blank=False)
content = models.TextField(blank=False)
pub_date = models.DateTimeField('date published', auto_now_add=True)
votes = models.IntegerField(default=0)