summaryrefslogtreecommitdiff
path: root/fml/doc/ja/01_RFC_SQL.txt
blob: b83ba2407490cde8fe535aad085d2cf5f5494e16 (plain)
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
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
X-Sequence: fml-devel 204

Q:  sql ��������Ĥ� cf �ե�����˽񤱤�褦�ˤ��Ƥ�������

A1: ���롼�ԥ󥰤�ɽ��

	mysql:ID �ʤɤȽ񤤤����ˡ����� ID �ǤΥ��롼�ԥ󥰤�ɽ���Ǥ�
	����ɤ��� ���� .ini �������� :-)

A2: SQL ��ʸ��񤱤�褦�ˤ��Ƥ����Ф褤��

	�ؿ����ƤФ줿���˻Ϥ�Ʒ�ޤ��ѿ��⤢��Τ�
	cf ������������뤳�ȤϤǤ��ʤ���

	lexical scope �Ǽ�갷�����ѿ���ɽ��������в�衩
	��: &varname ��ˡ(����)

	��: IO::Adapter �� new IO::Adapter $mapname $config �ʤɤȤ���

�� cf ���㡧

member_maps 	= 	mysql:database

recipient_maps 	= 	mysql:database

[mysql:database]

sql_server	=	localhost
sql_user	=	fml
sql_password	=	pa$$word
sql_database	=	ml
sql_table	=	fml

get_next_key	=	select address from $sql_table
			where ml = '&ml_name' and type = '&type'

getline		=	select * from $sql_table
			where ml = '&ml_name' and type = '&type'

add		=	insert into $sql_table
			values ('$ml_name', '&address', '&type')

delete		=	delete from $sql_table
			where ml = '&ml_name' and addrss = '&address'

find		=	select * from $sql_table
			where ml = '&ml_name' and address like '&regexp'