fml/doc/ja/01_RFC_SQL.txt


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
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119

X-Sequence: fml-devel 204

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

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

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

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

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

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

	��: IO::Adapter �� 

		my $obj = new IO::Adapter $mapname, $config;

	�Ȥ���

	XXX	�ʲ�����Ǥ�
		useradd() ����Ȥ���members recipients
		�ν�� map ���ѹ����ʤ��Ȥ����ʤ�

�� cf ���㡧

member_maps 	= 	mysql:members

recipient_maps 	= 	mysql:recipients


[mysql:members]

sql_server	=	localhost
sql_user	=	fml
sql_password	=	uja
sql_database	=	fml
sql_table	=	ml

sql_get_next_key =	select fml_address from $sql_table
			where fml_ml = '$ml_name'
					and
				fml_domain = '$ml_domain'

sql_getline	=	select * from $sql_table
			where fml_ml = '$ml_name'
					and
				fml_domain = '$ml_domain'

sql_add		=	insert into $sql_table
			values ('$ml_name', '$ml_domain', '&address', 1, 1)

sql_delete	=	delete from $sql_table
			where	fml_ml = '$ml_name'
					and
				fml_domain = '$ml_domain'
					and
				fml_address = '&address'

sql_find	=	select * from $sql_table
			where	fml_ml = '$ml_name'
					and
				fml_domain = '$ml_domain'
					and
				fml_address like '&regexp'


[mysql:recipients]

sql_server	=	localhost
sql_user	=	fml
sql_password	=	uja
sql_database	=	fml
sql_table	=	ml

sql_get_next_key =	select fml_address from $sql_table
			where fml_ml = '$ml_name'
					and
				fml_domain = '$ml_domain'
					and
				fml_recipient = '1'

sql_getline	=	select * from $sql_table
			where fml_ml = '$ml_name'
					and
				fml_domain = '$ml_domain'
					and
				fml_recipient = '1'

sql_add		=	update ml
			set recipient = 1
			where fml_ml = '$ml_name'
					and
				fml_domain = '$ml_domain'
					and
				fml_address = '&address'

sql_delete	=	update ml
			set recipient = 0
			where fml_ml = '$ml_name'
					and
				fml_domain = '$ml_domain'
					and
				fml_address = '&address'


sql_find	=	select * from $sql_table
			where	fml_ml = '$ml_name'
					and
				fml_domain = '$ml_domain'
					and
				fml_recipient = '1'
					and
				fml_address like '&regexp'