<?xml version='1.0' encoding='UTF-8'?><?xml-stylesheet href="http://www.blogger.com/styles/atom.css" type="text/css"?><feed xmlns='http://www.w3.org/2005/Atom' xmlns:openSearch='http://a9.com/-/spec/opensearchrss/1.0/' xmlns:blogger='http://schemas.google.com/blogger/2008' xmlns:georss='http://www.georss.org/georss' xmlns:gd="http://schemas.google.com/g/2005" xmlns:thr='http://purl.org/syndication/thread/1.0'><id>tag:blogger.com,1999:blog-2440451350975988966</id><updated>2020-03-09T14:09:27.038+09:00</updated><category term="oracle"/><category term="python"/><category term="sphinx"/><category term="apache"/><category term="jquery"/><category term="perl"/><category term="php"/><category term="rasberry pi"/><category term="RecalBox"/><category term="bash"/><category term="c"/><category term="c#"/><category term="curl"/><category term="fckeditor"/><category term="firewall"/><category term="java"/><category term="lucene"/><category term="regexp"/><category term="svn"/><category term="trac"/><category term="vimrc"/><category term="windows"/><title type='text'>즐거운 인생</title><subtitle type='html'>재밌는 거 해~</subtitle><link rel='http://schemas.google.com/g/2005#feed' type='application/atom+xml' href='http://enjoy-etc.blogspot.com/feeds/posts/default'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2440451350975988966/posts/default?redirect=false'/><link rel='alternate' type='text/html' href='http://enjoy-etc.blogspot.com/'/><link rel='hub' href='http://pubsubhubbub.appspot.com/'/><link rel='next' type='application/atom+xml' href='http://www.blogger.com/feeds/2440451350975988966/posts/default?start-index=26&amp;max-results=25&amp;redirect=false'/><author><name>soldier of fortune</name><uri>http://www.blogger.com/profile/08252593453787801441</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><generator version='7.00' uri='http://www.blogger.com'>Blogger</generator><openSearch:totalResults>50</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>25</openSearch:itemsPerPage><entry><id>tag:blogger.com,1999:blog-2440451350975988966.post-3263237114899829802</id><published>2020-03-09T13:48:00.000+09:00</published><updated>2020-03-09T14:09:26.976+09:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="rasberry pi"/><title type='text'>Rc Car - 1</title><summary type="text">이전부터 진행하고 싶었던 라즈베리파이 Rc Car를 만들어 보았다.

1. 부품

라즈베리파이3, 휴대용 배터리, L298N, RC 자동차 키트, 카메라
휴대용 배터리는 출력이 2A는 재부팅이 되어서 DC 5V/3A 용량 구매
RC 자동차 키트, L298N 및 기타


2. RcCar 구성







RcCar 모형 &lt;그림.1&gt;







안드로이드 휴대폰 &lt;그림.2&gt;

3. 기본구성



라즈베리파이 : python twisted socket server, gpio(서보, DC모터 제어), motion streaming
안드로이드 : xamarin, 자이로(서보 모터), socket client
wifi를 이용한 socket 통신


4. 회로도


라즈베리 파이 - gpio BCM 0 : ENA, </summary><link rel='replies' type='application/atom+xml' href='http://enjoy-etc.blogspot.com/feeds/3263237114899829802/comments/default' title='댓글'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=2440451350975988966&amp;postID=3263237114899829802' title='0개의 덧글'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2440451350975988966/posts/default/3263237114899829802'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2440451350975988966/posts/default/3263237114899829802'/><link rel='alternate' type='text/html' href='http://enjoy-etc.blogspot.com/2020/03/rc-car-1.html' title='Rc Car - 1'/><author><name>soldier of fortune</name><uri>http://www.blogger.com/profile/08252593453787801441</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://1.bp.blogspot.com/-qVdJdBv9dpE/XmWwLRpNfeI/AAAAAAAAADA/i5Plxqn3ubko5AHk4UXELZwf2HvqrE0bQCNcBGAsYHQ/s72-c/RcCar.jpg" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2440451350975988966.post-4725626411521280381</id><published>2020-02-28T10:51:00.002+09:00</published><updated>2020-02-28T11:00:33.145+09:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="apache"/><title type='text'>apache mod_proxy active standby 설정</title><summary type="text">OS : Centos 7
webserver : apache2
was : tomcat8

내가 원하는 서버 구성은 아래 그림과 같다.












apache 에서 mod_proxy 설정으로 tomcat server 2개로 연결해서 사용하고 있는데 was1이 active고

was1이 서비스 중단 되었을때 바로  was2로 연결해서 무중단(?) 서비스를 설정하려고 한다.



apache module 확인



      # httpd -M | grep proxy


      proxy_module (shared)

      proxy_ajp_module (shared)

      proxy_balancer_module (shared)

      proxy_connect_module (</summary><link rel='replies' type='application/atom+xml' href='http://enjoy-etc.blogspot.com/feeds/4725626411521280381/comments/default' title='댓글'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=2440451350975988966&amp;postID=4725626411521280381' title='0개의 덧글'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2440451350975988966/posts/default/4725626411521280381'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2440451350975988966/posts/default/4725626411521280381'/><link rel='alternate' type='text/html' href='http://enjoy-etc.blogspot.com/2020/02/apache-modproxy-active-standby.html' title='apache mod_proxy active standby 설정'/><author><name>soldier of fortune</name><uri>http://www.blogger.com/profile/08252593453787801441</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://1.bp.blogspot.com/-irchZ2vAzIg/XlhxZxXRQNI/AAAAAAAAAC0/G26_j1djwMQXLWEmsH7_NNbL_nnc-JJVgCNcBGAsYHQ/s72-c/%25EC%2584%259C%25EB%25B2%2584%25EA%25B5%25AC%25EC%2584%25B1.PNG" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2440451350975988966.post-827259899823795802</id><published>2020-02-08T19:33:00.000+09:00</published><updated>2020-02-10T20:42:40.623+09:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="python"/><title type='text'>ubuntu python 설정</title><summary type="text">python 3.6을 기본으로 사용하기

$ cat /etc/issue.net
Ubuntu 18.04.3 LTS


$ sudo update-alternatives --config python
update-alternatives: error: no alternatives for python

$ ls -lart /usr/bin/python*
-rwxr-xr-x 1 root root    1342 May  2  2016 /usr/bin/python3-jsonpointer
-rwxr-xr-x 1 root root    3661 Oct 29  2017 /usr/bin/python3-jsonpatch
-rwxr-xr-x 1 root root    1018 Oct 29  2017 /usr/bin/</summary><link rel='replies' type='application/atom+xml' href='http://enjoy-etc.blogspot.com/feeds/827259899823795802/comments/default' title='댓글'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=2440451350975988966&amp;postID=827259899823795802' title='0개의 덧글'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2440451350975988966/posts/default/827259899823795802'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2440451350975988966/posts/default/827259899823795802'/><link rel='alternate' type='text/html' href='http://enjoy-etc.blogspot.com/2020/02/ubuntu-python.html' title='ubuntu python 설정'/><author><name>soldier of fortune</name><uri>http://www.blogger.com/profile/08252593453787801441</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2440451350975988966.post-3548909898947570018</id><published>2020-02-08T19:16:00.001+09:00</published><updated>2020-02-08T19:16:57.837+09:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="RecalBox"/><title type='text'>RecalBox 설치</title><summary type="text">1. RecalBox 다운로드

https://archive.recalbox.com/





2. Etcher 다운로드(portable)


https://www.balena.io/etcher/


3. SD card Flash




4. ResberryPi 구동(전원연결), wifi 설정



5. Mame roms  추가


RecalBox ip -&gt; 192.168.0.100인 경우
웹 브라우저 -&gt; http://RecalBox ip 접속
Roms/Mame 메뉴에 롬 업로드











6. 조이스틱 설정


가지고 있던 조이스틱이 아무리 해도 설정이 안되는 경우.
가상 게임패드는 http://RecalBox ip:8080









그냥 저냥 할만하다. (조이스틱 사야지..)
</summary><link rel='replies' type='application/atom+xml' href='http://enjoy-etc.blogspot.com/feeds/3548909898947570018/comments/default' title='댓글'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=2440451350975988966&amp;postID=3548909898947570018' title='0개의 덧글'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2440451350975988966/posts/default/3548909898947570018'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2440451350975988966/posts/default/3548909898947570018'/><link rel='alternate' type='text/html' href='http://enjoy-etc.blogspot.com/2020/02/recalbox.html' title='RecalBox 설치'/><author><name>soldier of fortune</name><uri>http://www.blogger.com/profile/08252593453787801441</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://1.bp.blogspot.com/-09YhWwXoRm4/Xj6I2xw9tMI/AAAAAAAAABs/UyrmscvhTGo8bitTabdBv-Qyc0eE4yr4wCNcBGAsYHQ/s72-c/%25EB%25A1%25AC%25EA%25B4%2580%25EB%25A6%25AC.JPG" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2440451350975988966.post-741729641885908499</id><published>2020-02-07T22:11:00.001+09:00</published><updated>2020-02-28T10:54:55.899+09:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="c#"/><title type='text'>c# invoke, backgroundworker, socket client sample(돌아가기만 하는 코드)</title><summary type="text">using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Net;
using System.Net.Sockets;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace PiCalendar
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
</summary><link rel='replies' type='application/atom+xml' href='http://enjoy-etc.blogspot.com/feeds/741729641885908499/comments/default' title='댓글'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=2440451350975988966&amp;postID=741729641885908499' title='0개의 덧글'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2440451350975988966/posts/default/741729641885908499'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2440451350975988966/posts/default/741729641885908499'/><link rel='alternate' type='text/html' href='http://enjoy-etc.blogspot.com/2020/02/c-invoke-backgroundworker-socket-client.html' title='c# invoke, backgroundworker, socket client sample(돌아가기만 하는 코드)'/><author><name>soldier of fortune</name><uri>http://www.blogger.com/profile/08252593453787801441</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2440451350975988966.post-4058759328909564795</id><published>2020-02-07T21:56:00.000+09:00</published><updated>2020-02-07T22:00:57.808+09:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="rasberry pi"/><title type='text'>라즈베리 파이 pihole plex cups</title><summary type="text">1. 모니터 상하 변경 &amp;&amp; wifi
 $ sudo vi /boot/config.txt

 lcd_rotate=2

 # wifi는 그냥 디폴트 사용 - 국가를 바꾸면 접속 안됨.

2.  vim &amp;&amp; locale &amp;&amp; fonts
 $ sudo apt-get update &amp;&amp; sudo apt-get upgrade
 $ sudo apt-get install vim
 # locale 설정 sudo dpkg-reconfigure locales or gui화면에서 설정 폰트 설치
 $ sudo apt-get install fonts-unfonts-core

3. pihole 설치

 # 소스 설치
 $ sudo curl -sSL https://install.pi-hole.net | bash

 # pihole </summary><link rel='replies' type='application/atom+xml' href='http://enjoy-etc.blogspot.com/feeds/4058759328909564795/comments/default' title='댓글'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=2440451350975988966&amp;postID=4058759328909564795' title='0개의 덧글'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2440451350975988966/posts/default/4058759328909564795'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2440451350975988966/posts/default/4058759328909564795'/><link rel='alternate' type='text/html' href='http://enjoy-etc.blogspot.com/2020/02/pihole-plex-cups.html' title='라즈베리 파이 pihole plex cups'/><author><name>soldier of fortune</name><uri>http://www.blogger.com/profile/08252593453787801441</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2440451350975988966.post-6685929131074443181</id><published>2017-01-13T10:38:00.003+09:00</published><updated>2017-01-18T16:55:57.023+09:00</updated><title type='text'>oracle delete 데이터 복구(flashback query)</title><summary type="text">SQL&gt; show parameter undo;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
undo_management                      string      AUTO
undo_retention                       integer     900
undo_tablespace                      string      UNDOTBS1
-- 현재 900초로 되어있음

SQL&gt; alter system set undo_retention = 7200;

System </summary><link rel='replies' type='application/atom+xml' href='http://enjoy-etc.blogspot.com/feeds/6685929131074443181/comments/default' title='댓글'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=2440451350975988966&amp;postID=6685929131074443181' title='0개의 덧글'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2440451350975988966/posts/default/6685929131074443181'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2440451350975988966/posts/default/6685929131074443181'/><link rel='alternate' type='text/html' href='http://enjoy-etc.blogspot.com/2017/01/oracle-delete-flashback-query.html' title='oracle delete 데이터 복구(flashback query)'/><author><name>soldier of fortune</name><uri>http://www.blogger.com/profile/08252593453787801441</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2440451350975988966.post-8034409249095946295</id><published>2016-12-23T11:01:00.004+09:00</published><updated>2020-02-11T20:05:05.597+09:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="bash"/><title type='text'>bash shell 색상</title><summary type="text">
export LS_COLORS=&quot;di=01;33&quot;:&quot;fi=01;37&quot;:&quot;ex=01;32&quot;:&quot;ln=01;36&quot;:&quot;so=01;33&quot;

</summary><link rel='replies' type='application/atom+xml' href='http://enjoy-etc.blogspot.com/feeds/8034409249095946295/comments/default' title='댓글'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=2440451350975988966&amp;postID=8034409249095946295' title='0개의 덧글'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2440451350975988966/posts/default/8034409249095946295'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2440451350975988966/posts/default/8034409249095946295'/><link rel='alternate' type='text/html' href='http://enjoy-etc.blogspot.com/2016/12/bash-shell.html' title='bash shell 색상'/><author><name>soldier of fortune</name><uri>http://www.blogger.com/profile/08252593453787801441</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2440451350975988966.post-5300113024125982980</id><published>2012-06-19T10:00:00.002+09:00</published><updated>2017-01-18T16:56:48.275+09:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="oracle"/><title type='text'>oracle 전화번호에 &#39;-&#39; 삽입하기</title><summary type="text">
&#39;^02.{0}|^01.{1}|[[:digit:]]{3})([[:digit:]]+)([[:digit:]]{4})&#39;, &#39;\1-\2-\3&#39;

뭐 보면 금방 이해할것이고 문제는 어디서 봤는지 원본 url을 못찾겠다는게 문제네요.

REGEXP_REPLACE를 이용하면 해결 됨.

암튼 좋은 정보 주신분 감사합니다.</summary><link rel='replies' type='application/atom+xml' href='http://enjoy-etc.blogspot.com/feeds/5300113024125982980/comments/default' title='댓글'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=2440451350975988966&amp;postID=5300113024125982980' title='0개의 덧글'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2440451350975988966/posts/default/5300113024125982980'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2440451350975988966/posts/default/5300113024125982980'/><link rel='alternate' type='text/html' href='http://enjoy-etc.blogspot.com/2012/06/oracle.html' title='oracle 전화번호에 &#39;-&#39; 삽입하기'/><author><name>soldier of fortune</name><uri>http://www.blogger.com/profile/08252593453787801441</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2440451350975988966.post-4366186144938226723</id><published>2011-08-31T11:58:00.000+09:00</published><updated>2017-01-18T16:57:30.539+09:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="oracle"/><title type='text'>oracle dbms_job</title><summary type="text">dbms_job을 이용해서 dblink가 되있는 oracle server에 특정 쿼리를 날려야 된다.

5분 단위로 select 쿼리를 날린다.


check.sql
begin
dbms_job.submit(:jobno,&#39;begin declare aaa number := 0; begin select 1 into aaa from dual@aaa; end; end;&#39;,sysdate,&#39;sysdate + 5/24/60&#39;);
end;
/

sqlplus test/test

@check
print jobno
111 -- jobno 확인
exec dbms_job.run(jobno);
commit;

exec  dbms_job.run(jobno); -- 다시시작
exec  dbms_job.broken(jobno, TRUE</summary><link rel='replies' type='application/atom+xml' href='http://enjoy-etc.blogspot.com/feeds/4366186144938226723/comments/default' title='댓글'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=2440451350975988966&amp;postID=4366186144938226723' title='0개의 덧글'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2440451350975988966/posts/default/4366186144938226723'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2440451350975988966/posts/default/4366186144938226723'/><link rel='alternate' type='text/html' href='http://enjoy-etc.blogspot.com/2011/08/oracle-dbmsjob.html' title='oracle dbms_job'/><author><name>soldier of fortune</name><uri>http://www.blogger.com/profile/08252593453787801441</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2440451350975988966.post-7527282854304023227</id><published>2011-03-17T17:35:00.000+09:00</published><updated>2017-01-18T16:58:28.725+09:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="jquery"/><title type='text'>jquery 이것저것</title><summary type="text">전체 체크박스 전체 선택-해제

$(&#39;#allcheck&#39;).click(function() {
    if ($(&#39;#allcheck:checked&#39;).length &gt; 0) {
        $(&#39;.delcheck&#39;).attr(&#39;checked&#39;, &#39;checked&#39;);
    } else {
        $(&#39;.delcheck&#39;).attr(&#39;checked&#39;, &#39;&#39;);
    }
});

동일한 이름의 input name=&quot;test&quot;인걸 하나의 문자열로 변환
var ret = []; 
var cnt = 0;
$(&#39;input[name*=test]&#39;).each(function() {
    ret[cnt] = $(this).val();
    cnt += 1;
});
alert(ret.join());

select</summary><link rel='replies' type='application/atom+xml' href='http://enjoy-etc.blogspot.com/feeds/7527282854304023227/comments/default' title='댓글'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=2440451350975988966&amp;postID=7527282854304023227' title='0개의 덧글'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2440451350975988966/posts/default/7527282854304023227'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2440451350975988966/posts/default/7527282854304023227'/><link rel='alternate' type='text/html' href='http://enjoy-etc.blogspot.com/2011/03/jquery.html' title='jquery 이것저것'/><author><name>soldier of fortune</name><uri>http://www.blogger.com/profile/08252593453787801441</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2440451350975988966.post-6760974019232503531</id><published>2011-03-17T17:15:00.000+09:00</published><updated>2017-01-18T16:59:25.304+09:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="jquery"/><title type='text'>jquery autocomplete</title><summary type="text">jquery autocomplete 간단한 사용법

우선 사용하고자 하는 페이지의 자바스크립트
$(&#39;#name&#39;).autocomplete(uid, {
    minChars: 1,
    width: 210,
    max: 50,
    matchContains: true,
    autoFill: false,
    formatItem: function(row, i, max) {
        return i + &quot;/&quot; + max + &quot;: \&quot;&quot; + row.name + &quot;\&quot; [&quot; + row.to + &quot;]&quot;;
    },
    formatMatch: function(row, i, max) {
        return row.name + &quot; &quot; + row.to;
    },
    </summary><link rel='replies' type='application/atom+xml' href='http://enjoy-etc.blogspot.com/feeds/6760974019232503531/comments/default' title='댓글'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=2440451350975988966&amp;postID=6760974019232503531' title='0개의 덧글'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2440451350975988966/posts/default/6760974019232503531'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2440451350975988966/posts/default/6760974019232503531'/><link rel='alternate' type='text/html' href='http://enjoy-etc.blogspot.com/2011/03/jquery-autocomplete.html' title='jquery autocomplete'/><author><name>soldier of fortune</name><uri>http://www.blogger.com/profile/08252593453787801441</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2440451350975988966.post-7650289427988256410</id><published>2010-11-30T16:04:00.000+09:00</published><updated>2017-01-18T17:00:24.385+09:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="php"/><title type='text'>php soap</title><summary type="text">lighttpd냐 nginx냐 고민하다가 lighttpd로 결정했다. 이유는 nginx는 사용해 보지 않아서...

lighttpd + php5.2 + pear soap으로 서비스를 하는데 pear soap에서 complex type 선언할때

방법을 찾는데 좀 헤맸다.

$this-&gt;__dispatch_map[&#39;hello&#39;] =  array(  &#39;in&#39; =&gt; array(&#39;name&#39; =&gt; &#39;string&#39;),  &#39;out&#39; =&gt; array(&#39;ret&#39; =&gt; &#39;{&#39;.$this-&gt;__ns.&#39;}ArrayOfIHello&#39;));
$this-&gt;__typedef[&#39;{&#39;.$this-&gt;__ns.&#39;}StringOfHello&#39;] = array( &#39;a&#39; =&gt; &#39;int&#39;, &#39;b&#39; =&gt; &#39;string&#39;, &#39;c&#39; =&gt; &#39;string&#39;, </summary><link rel='replies' type='application/atom+xml' href='http://enjoy-etc.blogspot.com/feeds/7650289427988256410/comments/default' title='댓글'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=2440451350975988966&amp;postID=7650289427988256410' title='0개의 덧글'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2440451350975988966/posts/default/7650289427988256410'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2440451350975988966/posts/default/7650289427988256410'/><link rel='alternate' type='text/html' href='http://enjoy-etc.blogspot.com/2010/11/php-soap.html' title='php soap'/><author><name>soldier of fortune</name><uri>http://www.blogger.com/profile/08252593453787801441</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2440451350975988966.post-894023903458174959</id><published>2010-07-07T15:18:00.000+09:00</published><updated>2017-01-18T17:01:14.071+09:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="windows"/><title type='text'>windows7_64 gvim</title><summary type="text">구입한 노트북의 OS가 windows7_64  버전이다.

gvim을 설치 했더니 우측에 context menu에 추가가 안된다.

추가 방법은 reg 파일을 만들어서 추가하는 것과 sendto를 이용하는 방법이 있다.

reg파일의 내용은

Windows Registry Editor Version 5.00
[HKEY_CLASSES_ROOT\*\shell\Edit with Vim]
[HKEY_CLASSES_ROOT\*\shell\Edit with Vim\command]
@=&quot;C:\\Program Files (x86)\\Vim\\vim72\\gvim.exe \&quot;%1\&quot;&quot;
이 파일을 등록하면 마우스 우측버튼 클릭후에  Edit With Vim이 보인다.</summary><link rel='replies' type='application/atom+xml' href='http://enjoy-etc.blogspot.com/feeds/894023903458174959/comments/default' title='댓글'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=2440451350975988966&amp;postID=894023903458174959' title='0개의 덧글'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2440451350975988966/posts/default/894023903458174959'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2440451350975988966/posts/default/894023903458174959'/><link rel='alternate' type='text/html' href='http://enjoy-etc.blogspot.com/2010/07/windows764-gvun.html' title='windows7_64 gvim'/><author><name>soldier of fortune</name><uri>http://www.blogger.com/profile/08252593453787801441</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2440451350975988966.post-8160000742321308842</id><published>2010-05-04T11:34:00.000+09:00</published><updated>2017-01-18T17:54:52.666+09:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="oracle"/><title type='text'>oracle to sql server</title><summary type="text">이 자료는 oracle에서 sql server 2008로 db link를 통해 접속 하는 방법을 설명하는 자료이다.

platform
unbuntu 8.04
Oracle Database 10g r2
MS Sql Server 2008

필요한 package
# apt-get install unixodbc unixodbc-dev tdsodbc
freetds driver를 unixODBC에 인식
# odbcinst -i -d -f /usr/share/tdsodbc/odbcinst.ini
tamplate 생성후 unixODBC에 추가
# vi ms.ini
[MS]
Driver = TDS
Description = SQL Server
Trace = No
Server = 192.168.x.x
Database = </summary><link rel='replies' type='application/atom+xml' href='http://enjoy-etc.blogspot.com/feeds/8160000742321308842/comments/default' title='댓글'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=2440451350975988966&amp;postID=8160000742321308842' title='0개의 덧글'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2440451350975988966/posts/default/8160000742321308842'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2440451350975988966/posts/default/8160000742321308842'/><link rel='alternate' type='text/html' href='http://enjoy-etc.blogspot.com/2010/05/oracle-to-sql-server.html' title='oracle to sql server'/><author><name>soldier of fortune</name><uri>http://www.blogger.com/profile/08252593453787801441</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2440451350975988966.post-2226703677523724019</id><published>2010-04-13T13:01:00.000+09:00</published><updated>2017-01-18T17:57:19.674+09:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="oracle"/><title type='text'>oracle merge into</title><summary type="text">mysql의 replace into 기능을 oracle에서 찾아 봤더니 merge into가 있다.

MERGE INTO table_name alias
USING (table | view | subquery) alias -- 한개의 테이블 사용시 DUAL
ON (join condition) -- WHERE
WHEN MATCHED THEN 
UPDATE SET col1 = val1[, ...] 
WHEN NOT MATCHED THEN 
INSERT (column) VALUES (values); 
</summary><link rel='replies' type='application/atom+xml' href='http://enjoy-etc.blogspot.com/feeds/2226703677523724019/comments/default' title='댓글'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=2440451350975988966&amp;postID=2226703677523724019' title='0개의 덧글'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2440451350975988966/posts/default/2226703677523724019'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2440451350975988966/posts/default/2226703677523724019'/><link rel='alternate' type='text/html' href='http://enjoy-etc.blogspot.com/2010/04/oracle-merge-into.html' title='oracle merge into'/><author><name>soldier of fortune</name><uri>http://www.blogger.com/profile/08252593453787801441</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2440451350975988966.post-9084420288430886121</id><published>2009-12-29T15:49:00.000+09:00</published><updated>2017-01-18T18:06:04.080+09:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="perl"/><title type='text'>perl soap</title><summary type="text">perl SOAP::Lite 설치
# cpan -MCPAN -e shell
cpan&gt; get SOAP::Lite
# cd ~/.cpan/build/SOAP-Lite
# perl Makefile.PL
# make;sudo make install;

soap client
$ vi cli.pl
#!/usr/bin/perl

use strict;
use warnings;
use SOAP::Lite;

print SOAP::Lite-&gt;service(&#39;http://locahost/wsdl&#39;)-&gt;hello(&quot;test&quot;), &quot;\n&quot;;
$ perl cli.pl
hello test


물론 서버는 hello를 호출 하면 hello + string을 돌려준다.</summary><link rel='replies' type='application/atom+xml' href='http://enjoy-etc.blogspot.com/feeds/9084420288430886121/comments/default' title='댓글'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=2440451350975988966&amp;postID=9084420288430886121' title='0개의 덧글'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2440451350975988966/posts/default/9084420288430886121'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2440451350975988966/posts/default/9084420288430886121'/><link rel='alternate' type='text/html' href='http://enjoy-etc.blogspot.com/2009/12/perl-soap.html' title='perl soap'/><author><name>soldier of fortune</name><uri>http://www.blogger.com/profile/08252593453787801441</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2440451350975988966.post-272638555309593141</id><published>2009-08-25T12:10:00.000+09:00</published><updated>2017-01-18T18:08:05.513+09:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="apache"/><title type='text'>mod_deflate, mod_expire</title><summary type="text">

AddOutputFilterByType text/html text/plain text/css text/javascript application/x-javascript application/xml     application/xhtml+xml text/xml




apache1은 mod_gzip apache2는 mod_deflate

mod_expire는 
debian 또는 ubuntu를 사용하기에 a2enmod를 이용해서 추가후 설정


ExpiresActive On
ExpiresByType image/jpg &quot;access plus 1 day&quot;
ExpiresByType image/gif &quot;access plus 1 day&quot;
ExpiresByType image/jpeg &quot;access plus 1 day&quot;</summary><link rel='replies' type='application/atom+xml' href='http://enjoy-etc.blogspot.com/feeds/272638555309593141/comments/default' title='댓글'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=2440451350975988966&amp;postID=272638555309593141' title='0개의 덧글'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2440451350975988966/posts/default/272638555309593141'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2440451350975988966/posts/default/272638555309593141'/><link rel='alternate' type='text/html' href='http://enjoy-etc.blogspot.com/2009/08/moddeflate-modexpire.html' title='mod_deflate, mod_expire'/><author><name>soldier of fortune</name><uri>http://www.blogger.com/profile/08252593453787801441</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2440451350975988966.post-7767856369562988895</id><published>2009-08-18T15:41:00.000+09:00</published><updated>2011-03-09T16:49:51.889+09:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="oracle"/><title type='text'>hint를 이용한 채번</title><summary type="text">
SELECT /*+ INDEX_DESC(TABLENNAME INDEXNAME) */ NVL(MAX(COL), 0) + 1 FROM TABLENAME WHERE ROWNUM = 1;


이때 COL은 NOT NULL.</summary><link rel='replies' type='application/atom+xml' href='http://enjoy-etc.blogspot.com/feeds/7767856369562988895/comments/default' title='댓글'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=2440451350975988966&amp;postID=7767856369562988895' title='0개의 덧글'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2440451350975988966/posts/default/7767856369562988895'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2440451350975988966/posts/default/7767856369562988895'/><link rel='alternate' type='text/html' href='http://enjoy-etc.blogspot.com/2009/08/hint.html' title='hint를 이용한 채번'/><author><name>soldier of fortune</name><uri>http://www.blogger.com/profile/08252593453787801441</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2440451350975988966.post-3358076846440170438</id><published>2009-08-13T12:17:00.000+09:00</published><updated>2011-03-09T16:50:54.824+09:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="curl"/><title type='text'>curl</title><summary type="text">get

curl http://www.ex.com


post

curl -d &quot;a=b&amp;c=d&quot; http://www.ex.com


cookie

cookie.txt로 저장
curl -D cookie.txt http://www.ex.com
cookie.txt에 있는 cookie값 전송
curl -b cookie.txt http://www.ex.com


더 필요한건 사이트에 가서...

참조 url : http://curl.haxx.se/</summary><link rel='replies' type='application/atom+xml' href='http://enjoy-etc.blogspot.com/feeds/3358076846440170438/comments/default' title='댓글'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=2440451350975988966&amp;postID=3358076846440170438' title='0개의 덧글'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2440451350975988966/posts/default/3358076846440170438'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2440451350975988966/posts/default/3358076846440170438'/><link rel='alternate' type='text/html' href='http://enjoy-etc.blogspot.com/2009/08/curl.html' title='curl'/><author><name>soldier of fortune</name><uri>http://www.blogger.com/profile/08252593453787801441</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2440451350975988966.post-6546225562468892667</id><published>2009-07-06T15:04:00.000+09:00</published><updated>2011-03-09T16:51:37.605+09:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="oracle"/><title type='text'>oracle procedure</title><summary type="text">모든 procedure 확인하기

select text from user_source where name in (select object_name from user_objects where object_type = &#39;PROCEDURE&#39;)
</summary><link rel='replies' type='application/atom+xml' href='http://enjoy-etc.blogspot.com/feeds/6546225562468892667/comments/default' title='댓글'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=2440451350975988966&amp;postID=6546225562468892667' title='0개의 덧글'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2440451350975988966/posts/default/6546225562468892667'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2440451350975988966/posts/default/6546225562468892667'/><link rel='alternate' type='text/html' href='http://enjoy-etc.blogspot.com/2009/07/oracle-procedure.html' title='oracle procedure'/><author><name>soldier of fortune</name><uri>http://www.blogger.com/profile/08252593453787801441</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2440451350975988966.post-5449415481040971076</id><published>2009-07-06T14:37:00.000+09:00</published><updated>2011-03-09T16:52:43.512+09:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="oracle"/><title type='text'>오라클 mysql \G</title><summary type="text">
create or replace PROCEDURE TABLE_PRINT ( p_query in varchar2 )
IS
l_theCursor     integer default dbms_sql.open_cursor;
l_columnValue   varchar2(4000);
l_status        integer;
l_descTbl       dbms_sql.desc_tab;
l_colCnt        number;
BEGIN
execute immediate
&#39;alter session set 
nls_date_format=&#39;&#39;yyyy-mon-dd hh24:mi:ss&#39;&#39; &#39;;

dbms_sql.parse(  l_theCursor,  p_query, dbms_sql.native );
</summary><link rel='replies' type='application/atom+xml' href='http://enjoy-etc.blogspot.com/feeds/5449415481040971076/comments/default' title='댓글'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=2440451350975988966&amp;postID=5449415481040971076' title='0개의 덧글'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2440451350975988966/posts/default/5449415481040971076'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2440451350975988966/posts/default/5449415481040971076'/><link rel='alternate' type='text/html' href='http://enjoy-etc.blogspot.com/2009/07/mysql-g.html' title='오라클 mysql \G'/><author><name>soldier of fortune</name><uri>http://www.blogger.com/profile/08252593453787801441</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2440451350975988966.post-8587113286267455266</id><published>2009-05-20T17:58:00.000+09:00</published><updated>2011-03-09T16:54:38.216+09:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="oracle"/><title type='text'>oracle 백업 및 복구</title><summary type="text">구 서버 데이터 백업
exp user/passwd file=./data.dmp log=./data.log


이전 서버
모든 테이블 삭제
drop table test cascade constraints;


휴지통 보기
show recyclebin;

휴지통 비우기
purge recyclebin;


복구
imp user/passwd fromuser=user touser=user file=./data.dmp log=./data.log
</summary><link rel='replies' type='application/atom+xml' href='http://enjoy-etc.blogspot.com/feeds/8587113286267455266/comments/default' title='댓글'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=2440451350975988966&amp;postID=8587113286267455266' title='0개의 덧글'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2440451350975988966/posts/default/8587113286267455266'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2440451350975988966/posts/default/8587113286267455266'/><link rel='alternate' type='text/html' href='http://enjoy-etc.blogspot.com/2009/05/oracle.html' title='oracle 백업 및 복구'/><author><name>soldier of fortune</name><uri>http://www.blogger.com/profile/08252593453787801441</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2440451350975988966.post-1148176415630777915</id><published>2009-04-30T14:11:00.000+09:00</published><updated>2011-03-09T16:56:31.599+09:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="oracle"/><title type='text'>database link</title><summary type="text">tnsnames.ora
DEV =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = dev)(PORT = 1521))
    (CONNECT_DATA =
      (SERVICE_NAME = DEV)
    )
  )


일반유저에 권한 부여
GRANT CREATE DATABASE LINK TO ID;


생성 및 결과 확인
sqlplus id/password

CREATE DATABASE LINK DEV CONNECT TO USERID IDENTIFIED BY PASSWORD USING DEV;

SELECT * FROM TAB@DEV;


삭제
DROP DATABASE LINK DBLINKNAME;
</summary><link rel='replies' type='application/atom+xml' href='http://enjoy-etc.blogspot.com/feeds/1148176415630777915/comments/default' title='댓글'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=2440451350975988966&amp;postID=1148176415630777915' title='0개의 덧글'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2440451350975988966/posts/default/1148176415630777915'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2440451350975988966/posts/default/1148176415630777915'/><link rel='alternate' type='text/html' href='http://enjoy-etc.blogspot.com/2009/04/database-link.html' title='database link'/><author><name>soldier of fortune</name><uri>http://www.blogger.com/profile/08252593453787801441</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2440451350975988966.post-3612771761006729241</id><published>2008-12-04T14:27:00.000+09:00</published><updated>2011-03-09T16:57:04.401+09:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="python"/><title type='text'>python ConfigParser</title><summary type="text">설정파일
test.cnf

[db]
addr : localhost
user : user
passwd : passwd

[db2]
addr : localhost
user : user
passwd : passwd


예제

#!/usr/bin/env python

import ConfigParser

config = ConfigParser.ConfigParser()
config.read(&#39;test.cnf&#39;)

for section in config.sections():
print section
for option in config.options(section):
print &quot; &quot;, option, &quot;=&quot;, config.get(section, option)

config.add_section(&quot;db3&quot;)
</summary><link rel='replies' type='application/atom+xml' href='http://enjoy-etc.blogspot.com/feeds/3612771761006729241/comments/default' title='댓글'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=2440451350975988966&amp;postID=3612771761006729241' title='0개의 덧글'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2440451350975988966/posts/default/3612771761006729241'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2440451350975988966/posts/default/3612771761006729241'/><link rel='alternate' type='text/html' href='http://enjoy-etc.blogspot.com/2008/12/python-configparser.html' title='python ConfigParser'/><author><name>soldier of fortune</name><uri>http://www.blogger.com/profile/08252593453787801441</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry></feed>