src/org/sonews/storage/impl/JDBCDatabaseProvider.java
author František Kučera <franta-hg@frantovo.cz>
Sun Nov 06 00:08:05 2011 +0100 (2011-11-06)
changeset 116 4ddc1020a154
parent 44 5d7d1adf387f
permissions -rwxr-xr-x
Podpora Markdown syntaxe
na začátek odesílané zprávy stačí přidat:
#!markdown
a zpráva se pak prožene Markdown procesorem (spouštěno přes sudo pod jiným uživatelem)
a pak teprve přes standardní XSL transformaci.

1) Vytvořit uživatele a skupinu markdown

2) Do /etc/sudoers přidat:
Cmnd_Alias MARKDOWN = /usr/bin/markdown
%markdown ALL = (%markdown) NOPASSWD : MARKDOWN

3) Uivatele, pod kterým běží NNTP démon, přidat do skupiny markdown
     1 /*
     2  *   SONEWS News Server
     3  *   see AUTHORS for the list of contributors
     4  *
     5  *   This program is free software: you can redistribute it and/or modify
     6  *   it under the terms of the GNU General Public License as published by
     7  *   the Free Software Foundation, either version 3 of the License, or
     8  *   (at your option) any later version.
     9  *
    10  *   This program is distributed in the hope that it will be useful,
    11  *   but WITHOUT ANY WARRANTY; without even the implied warranty of
    12  *   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
    13  *   GNU General Public License for more details.
    14  *
    15  *   You should have received a copy of the GNU General Public License
    16  *   along with this program.  If not, see <http://www.gnu.org/licenses/>.
    17  */
    18 package org.sonews.storage.impl;
    19 
    20 import java.sql.SQLException;
    21 import java.util.Map;
    22 import java.util.concurrent.ConcurrentHashMap;
    23 import org.sonews.storage.Storage;
    24 import org.sonews.storage.StorageBackendException;
    25 import org.sonews.storage.StorageProvider;
    26 
    27 /**
    28  *
    29  * @author Christian Lins
    30  * @since sonews/1.0
    31  */
    32 public class JDBCDatabaseProvider implements StorageProvider {
    33 
    34 	protected static final Map<Thread, JDBCDatabase> instances =
    35 			new ConcurrentHashMap<Thread, JDBCDatabase>();
    36 
    37 	@Override
    38 	public boolean isSupported(String uri) {
    39 		return uri.startsWith("jdbc:mysql") || uri.startsWith("jdbc:postgresql");
    40 	}
    41 
    42 	@Override
    43 	public Storage storage(Thread thread)
    44 			throws StorageBackendException {
    45 		try {
    46 			if (!instances.containsKey(Thread.currentThread())) {
    47 				JDBCDatabase db = new JDBCDatabase();
    48 				db.arise();
    49 				instances.put(Thread.currentThread(), db);
    50 				return db;
    51 			} else {
    52 				return instances.get(Thread.currentThread());
    53 			}
    54 		} catch (SQLException ex) {
    55 			throw new StorageBackendException(ex);
    56 		}
    57 	}
    58 }