デフォルトの設定ではMySQLサーバにネットワークから接続できない。
# mysql -u root -p
mysql> update mysql.user set password=old_password('abcd1234') where user='root';
mysql> grant all privileges on *.* to root@192.168.11.10 identified by 'abcd1234' with grant option;
mysql> flush privileges;
ラベル: MySQL
グラフの描画にはhtml5.jpを使うことにする。
ラベル: CSS, JavaScript, 相関くん
HTMLのページでグラフを描画する時はいつも悩ましい。
ラベル: JavaScript
Djangoでなにかウェブアプリを作ろうと思う。
Ubuntu 7.10 Gutsy
ラベル: Ubuntu
次期Ubuntuとなる8.04 Hardy Heronがダウンロードできる。
ラベル: Ubuntu
Python 2.5, Django 0.96
import models
my_obj = models.MyObj(name='ぱいそん', age='31')
my_obj.save()
import models
my_obj = models.MyObj.objects.get(100)
my_obj.age = 21
my_obj.save()
import models
my_objs = models.MyObj.objects.all()
import models
my_obj = models.MyObj.objects.get(100)
import models
my_objs = models.MyObj.objects.filter(name='ぱいそん')
import models
my_objs = models.MyObj.objects.filter(age__gte=20)
import models
my_objs = models.MyObj.objects.filter(age__gte=20).order_by('age')
*kawasaqさんのご指摘により訂正。ありがとうございます。
import models
my_objs = models.MyObj.objects.filter(name='ぱいそん')[:10]
import models
my_objs = models.MyObj.objects.filter(name='ぱいそん').filter(age__gte=20).order_by('-age')[2]
Python 2.5, Django 0.96
primary_key=Trueを指定しないと勝手に主キーのカラムidが作られる。
id = models.CharField(maxlength=200, primary_key=True)
3. 文字
i = models.IntegerField(core=True)
f = models.FloatField(max_digits=10, decimal_places=3)
max_digits: 整数の桁
decimal_places: 小数点以下の桁
4. 日付
c = models.CharField(maxlength=200)
t = models.TextField()
5. 外部キー
dt = models.DateTimeField('date created')
d = date = models.DateField('date created')
auto_now=True: 現在の日付が自動で書き込まれる
6. その他共通オプション(引数)
user = models.ForeignKey(UserInfo)
unique=True: ユニークOn
db_index=True: インデックスOn
maxlength=200: 値の長さ指定
Djangoのテンプレートでif文やfor文を使いたいとき。
<html>
<body>
{% for x in xs %}
<p>{{x}}</p>
{% endfor %}
</body>
</html>
<html>
<body>
{% if x and not y %}
<p>{{x}}</p>
{% endif %}
{% if y and not x %}
<p>{{y}}</p>
{% endif %}
</body>
</html>
<html>
<body>
{% for x in xs %}
{% ifchanged x %}
<p>{{x}}</p>
{% endifchanged %}
{% endfor %}
</body>
</html>
<html>
<body>
{% ifequal x y %}
<p>{{x}}, {{y}}</p>
{% endifequal %}
</body>
</html>
Ubuntu 7.10 Gutsy
ラベル: Ubuntu
MySQL 5.0, Ubuntu 7.10 Gutsy
mysql> STATUS;
Server characterset: latin1
Db characterset: latin1
Client characterset: latin1
Conn. characterset: latin1
mysql> SHOW VARIABLES LIKE 'char%';
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
[client]
default-character-set=utf8
[mysqld]
default-character-set=utf8
skip-character-set-client-handshake
mysql> STATUS;
Server characterset: utf8
Db characterset: utf8
Client characterset: utf8
Conn. characterset: utf8
mysql> SHOW VARIABLES LIKE 'char%';
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
mysql> use mydb
Ubuntu 7.10 Gutsy, GTP-recordMyDesktop 0.3.4
# sudo apt-get install gtk-recordmydesktop
Hardy Mariux Theme on Ubuntu 7.10 Gutsy
ラベル: Ubuntu
WinFF 0.33 on Ubuntu
ここからテーマを入手できる。
ラベル: Ubuntu
Ubuntu 7.10 Gutsy
ラベル: Ubuntu
Ubuntu 7.10 Gutsy MySQL 5.0
ラベル: MySQL
Ubuntu 7.10 Gutsy
Rails performed much better than Symfony. And Django performed much better than Rails.
# sudo apt-get install python-django
# cd /var/www
# sudo django-admin startproject myprj
# ls
<Location "/myprj/">
Options Indexes FollowSymLinks MultiViews
AllowOverride None
Order allow,deny
allow from all
SetHandler python-program
PythonPath "['/var/www'] + sys.path"
PythonHandler django.core.handlers.modpython
SetEnv DJANGO_SETTINGS_MODULE myprj.settings
PythonDebug On
</Location>
[DocumentRoot]
|-myprj
|-myapp
DEBUG = True
TEMPLATE_DEBUG = True
DATABASE_ENGINE = 'mysql'
DATABASE_NAME = 'myprg'
DATABASE_USER = 'root'
DATABASE_PASSWORD = 'mypassword'
DATABASE_HOST = '127.0.0.1'
DATABASE_PORT = '3306'
TIME_ZONE = 'Asia/Tokyo Japan'
TEMPLATE_DIRS = (
'/var/www/myprj/myapp/template',
)
INSTALLED_APPS = (
'django.contrib.auth',
'django.contrib.contenttypes',
'django.contrib.sessions',
'django.contrib.sites',
'myprj.myapp'
)
from django.db import models
# Create your models here.
class User(models.Model):
username = models.CharField(maxlength=200)
password = models.CharField(maxlength=200)
description = models.TextField()
score = models.IntegerField()
datetime = models.DateTimeField(auto_now=True)
[client]
default-character-set=utf8
[mysqld]
default-character-set=utf8
skip-character-set-client-handshake
# mysql -u root -p
mysql> create database myprj
mysql> quit
# python manage.py shell
>>> from myprj.myapps.models import *
>>> User(username='foo', password='brabra', description='Hello', score=0).save()
>>> User(username='hoge', password='brabra', description='Good-bye', score=0).save()
>>> us = User.objects.all()
>>> for u in us:
>>> print u.username, u.password, u.datetime
from django.shortcuts import render_to_response, get_object_or_404
import models
def index(request):
users = models.User.objects.all()
return render_to_response('index.html', { 'users': users })
<html>
<body>
{% for user in users %}
<p>{{user.username}}, {{user.password}}, {{user.description}}</p>
{% endfor %}
</body>
</html>
(r'^myprj/myapp/$', 'myprj.myapp.views.index')
/etc/init.d/apache2 restart
【Ubuntu】 LAMP (Linux, Apache2, MySQL, Python一発インストールのつづき。
cd /etc/apache2/sites-available/
sudo gedit default
<Directory /var/www/>
Options Indexes FollowSymLinks MultiViews
AllowOverride AuthConfig
Order allow,deny
allow from all
AddHandler mod_python .py
PythonHandler mod_python.publisher
PythonDebug On
# Uncomment this directive is you want to see apache2's
# default start page (in /apache2-default) when you go to /
#RedirectMatch ^/$ /apache2-default/
</Directory>
def index(req):
return "Test successful"
# sudo /etc/init.d/apache2 restart
Pythonで日付を扱うときはdatetime.dateのお世話になる。
>>> import datetime
>>> d = datetime.date(2008, 2, 29)
>>> print d
2008-02-29
>>> print d.year, d.month, d.day
2008 2 29
>>> next = d + datetime.timedelta(15)
>>> print next
2008-03-15
>>> import calendar
>>> calendar.monthrange(2008, 2)[1]
>>> today = datetime.date.today()
>>> print today
>>> print today - datetime.timedelta(1)
>>> print today + datetime.timedelta(1)
ラベル: python
最近のMySQLにはFULLTEXTというタイプのインデックスがサポートされている.
[mysqld]
ft_min_word_len=2
[myisamchk]
ft_min_word_len=2
# [mysql]/bin/mysqladmin shutdown -u root -p
# [mysql]/bin/mysqld_safe --user=mysql
# Ctrl+Z
# bg
# sudo [mysql]/bin/myisamchk --help
# sudo [mysql]/bin/myisamchk --recover --ft_min_word_len=2 [mysql]/var/mydb/mytbl.MYI
ラベル: MySQL
LAMPをapt-get一発でインストールする。
sudo apt-get -s install apache2 mysql-server python-mySQLdb libapache2-mod-python
# sudo apt-get install apache2 mysql-server python-mySQLdb libapache2-mod-python
# sudo /etc/init.d/apache2 start
# sudo /etc/init.d/apache2 stop
# mysql -u root -p
# sudo /etc/init.d/mysql stop
# sudo /etc/init.d/mysql start
Pythonでは日付はdatetime.dateで表現される。
>>> import datetime
>>> d = datetime.date(2008, 3, 5)
>>> d_mysql = d.strftime('%Y-%m-%d')
>>> tmp = x.split('-')
>>> d = datetime.date(int(tmp[0]), int(tmp[1]), inttmp[2]))
apt-get autoremoveで使用していない(依存関係がない)パッケージを自動で削除できる。
# sudo apt-get install
# sudo apt-get autoremove
contact[あっとまーく]srengine.com
[Recent Activity]
拡張現実AR: SREngineを考案し、iPhoneに実装。
[Academic publication]
1. Fukai T & Kanemura S (2000) Precisely-timed synchronization by depressing synapses. Neurocomputing 32-33: 133-140
2. Fukai T & Kanemura S (2001) Noise-tolerant stimulus discrimination by synchronization with depressing synapses. Biological Cybernetics 85: 107-116
登録
投稿 [Atom]
