rename Chinese filenames to pinyin 中文文件名 重命名 拼音

PHP rename may not be able to read Chinese filename properly, then you can do the following to convert the filenames.

before we get started, here's a bash to clean the filenames:

Bash script to replace spaces in file names

find . -depth -name '* *' \
| while IFS= read -r f ; do mv -i "$f" "$(dirname "$f")/$(basename "$f"|tr ' ' _)" ; done




This script can not work recursively. 

How to rename Unicode Chinese files to Pinyin?

Posted on February 8, 2013 by hxin

I googled and found no existing tools. That’s very rare and even weird. The only useful piece of information I got was a mapping file that contains a Unicode Pinyin table. So I have to do it myself… to write a script to convert the Unicode Chinese file names to Pinyin using the mapping file.
Since I was doing Python Challenge at the time, natually I just scripted something in Python to get the job done.

The reason I did that was this. I have a HDTV that has a feature to play music from an USB drive. When I wanted to play the songs I downloaded from the Voice of China. I had a problem. The file name of the songs had many Unicode Chinese characters. The TV obviously doesn’t support Unicode. It just doesn’t display those Chinese characters at all. For example:

01 04张玮 – High歌.mp3
05 09吉克隽逸 – I Fell Good.mp3

I can only see:
01 04 – High.mp3
05 09 – I Fell Good.mp3

If those above are okay, then the following ones are ridiculous:
11 11 – .mp3
11 12 – .mp3
11 13 – .mp3
11 14 – .mp3

I have no idea what was what when I tried to choose the songs. Actually their filenames are as the following:
11 11大山 – 王妃.mp3
11 12王韵壹 – 你快乐所以我快乐.mp3
11 13金池 – 后知后觉.mp3
11 14吴莫愁 – 痒.mp3

Putting the mapping file and the script in one folder, all renaming Unicode files under a sub folder “VoC”, then just run the script. Finally I got all the file names like this, not perfect but I am able to tell what songs they are:
11 11 DaShan – WangFei.mp3
11 12 WangYunYi – NiKuaiLeSuoYiWoKuaiLe.mp3
11 13 JinChi – HouZhiHouJue.mp3
11 14 WuMoChou – Yang.mp3

I hope you find my solution helpful. Here is my Python script.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30

# renameCH2Pinyin.py # Rename filename from Chinese characters to capitalized pinyin using the # mapping file and taking out the tone numbers   import os import re   # File uni2pinyin is a mapping from hex to Pinyin with a tone number f = open('uni2pinyin') wf = f.read() # read the whole mapping file   os.chdir('voc') # to rename all files in sub folder 'voc' myulist = os.listdir(u'.') # read all file names in unicode mode for x in myulist: # each file name     filenamePY = ''     for y in x: # each character         if 0x4e00 <= ord(y) <= 0x9fff: # Chinese Character Unicode range             hexCH = (hex(ord(y))[2:]).upper() # strip leading '0x' and change                                               # to uppercase             p = re.compile(hexCH+'\t([a-z]+)[\d]*') # define the match pattern             mp = p.search(wf)             filenamePY+=mp.group(1).title() # get the pinyin without the tone                                             # number and capitalize it         else:             filenamePY+=y     print x     filename = filenamePY     print filename     os.rename(x, filename) os.chdir('..') # go back to the parent folder

This is the link where I got the mapping file:

ftp://ftp.cuhk.hk/pub/chinese/ifcss/software/data/Uni2Pinyin.gz

Raspberry Pi • View topic - Pi 3 bluetooth - needing to re-pair keyboard, like Ariston

Raspberry Pi • View topic - Pi 3 bluetooth - needing to re-pair keyboard, like Ariston



bluetoothctl -a
scan on
pair xx:xx:xx:xx:xx:xx
trust xx:xx:xx:xx:xx:xx
connect xx:xx:xx:xx:xx:xx

Save Symfony's Stopwatch data to log — Aleksander Cyrkulewski — To Get You Started

Save Symfony's Stopwatch data to log — Aleksander Cyrkulewski — To Get You Started

In one of our services we use a lot of API calls. At certain point I realised the need of speed-tracking for those API calls. On the dev environment it's pretty easy to do with @debug.stopwatch. But I wanted to measure the speed on production and save data to log file. To solve it I wrapped original stopwatch service with logger functionality. It's pretty much of configuration + small service class. I also have done it in the way when I can turn service on/off via configuration parameter stopwatch_enable: true or stopwatch_enable: false

As a result log file (the name could be prod.api.watch.log, you can specify any name you want inconfig_{env}.yml) will contain entries like following

[2014-11-26 18:56:53] api.DEBUG: API_getSomething, 1938 {"extraParamIfNeeded":"value"}

So, lets start with adding the parameter to environment we want to have stopwatch enabled:app/config/parameters_prod.yml.

stopwatch_enable: true

Next is service by self. Simple class, dependent on:

1. Symfony Stopwatch,
2. Logger,
3. turn on/off parameter.

/**
 * Wrapper for basic Symfony's Stopwatch service
 * It add logging functionality for basic one
 */
namespace CompanyName\CompanyBundle\Service;

use Symfony\Component\HttpKernel\Log\LoggerInterface;
use Symfony\Component\Stopwatch\Stopwatch;
use Symfony\Component\Stopwatch\StopwatchEvent;

class StopwatchService
{
    /**
     * @var Stopwatch
     */
    private $stopwatch;

    /**
     * @var LoggerInterface
     */
    private $logger;

    /**
     * @var bool
     */
    private $stopwatchEnabled;

    /**
     * @param Stopwatch $stopwatch
     * @param LoggerInterface $logger
     * @param bool $stopwatchEnabled
     */
    public function __construct(
        Stopwatch $stopwatch, 
        LoggerInterface $logger, 
        $stopwatchEnabled = false
    ) {
        $this->stopwatch = $stopwatch;
        $this->logger = $logger;
        $this->stopwatchEnabled = $stopwatchEnabled;
    }

    /**
     * @see Stopwatch::start
     * @param string $eventName
     * @return false|StopwatchEvent
     */
    public function start($eventName)
    {
        return ($this->stopwatchEnabled) ? $this->stopwatch->start($eventName) : false;
    }

    /**
     * @see Stopwatch::stop
     * @param string $eventName
     * @param array $extraParams
     * @return false|StopwatchEvent
     */
    public function stop($eventName, array $extraParams = array())
    {
        if (! $this->stopwatchEnabled) {
            return false;
        }
        $event = $this->stopwatch->stop($eventName);
        $this->logEvent($event, $eventName, $extraParams);
        return $event;
    }

    /**
     * Save event data to the log
     *
     * @param StopwatchEvent $event
     * @param string $eventName
     * @param array $params
     */
    private function logEvent(StopwatchEvent $event, $eventName, array $params)
    {
        $this->logger->debug($eventName . ', ' . $event->getDuration(), $params);
    }
}

Now we need to specify StopwatchService in service config
src/CompanyName/CompanyBundle/Resources/config/services.yml

symfony.stopwatch.service:
    class: Symfony\Component\Stopwatch\Stopwatch

api.stopwatch:
    class: CompanyName\CompanyBundle\Service\StopwatchService
    arguments: [ @symfony.stopwatch.service, @logger, %stopwatch_enable% ]
    tags:
        - { name: monolog.logger, channel: api }

And configure new logger. You need to do this in config_{env}.yml file.

main:
    type:         fingers_crossed
    action_level: error
    handler:      nested
    channels:     [!api]
api:
    type: stream
    path: %kernel.logs_dir%/%kernel.environment%.api.watch.log
    level: debug
    channels: [api]

And finally call the service from the place where you want to measure execution time. Here I give the example of how to call stopwatch in controller. In real life you probably make an API calls from withing other services or models. In this case you need to inject stopwatch service to your model.

$stopwatch = $this->container->get('api.stopwatch'); 
$stopwatch->start('API_getSomething');

// ... API call or some other code you need to measure ...

$stopwatch->stop('API_getSomething', array('extraParamIfNeeded' => 'value'));

[ubuntu] List all files that start with lower case letters

[ubuntu] List all files that start with lower case letters

ls [[:lower:]]*

MySQL script: drop all tables in a db and import a .sql file - Justin Kelly

MySQL script: drop all tables in a db and import a .sql file - Justin Kelly



#!/bin/bash

MUSER="-- Insert Db username here --"
MPASS="-- Insert Db password here --"
MDB="-- Insert Db name here --"
FILE="/home/user/path/to/your/import_file.sql"
 
# Detect paths
MYSQL=$(which mysql)
AWK=$(which awk)
GREP=$(which grep)
 
TABLES=$($MYSQL -u $MUSER -p$MPASS $MDB -e 'show tables' | $AWK '{ print $1}' | $GREP -v 'Tables' )
 
for t in $TABLES
do
    echo "Deleting $t table from $MDB database..."
    $MYSQL -u $MUSER -p$MPASS $MDB -e "drop table $t"
done

cat $FILE | mysql -u $MUSER -p$MPASS $MDB
echo "Sql imported"





PS:

fixed version

which mysql may return ''

suggest drop database instead of delete all tables

replace - Linux - Replacing spaces in the file names - Stack Overflow

replace - Linux - Replacing spaces in the file names - Stack Overflow

for file in *; do mv "$file" `echo $file | tr ' ' '_'` ; done

MySQL: Change Domain Name on email address (leave username) / mountainash - Snipt

 MySQL: Change Domain Name on email address (leave username) / mountainash - Snipt





update [TABLE] set [EMAIL] = replace([EMAIL], SUBSTRING_INDEX([EMAIL], '@', -1), '@XYZ.COM');