sugiana

import os
import subprocess
from appy.pod.renderer import Renderer
from time import time
from pyramid.view import view_config
from pyramid.response import (
    Response,
    FileIter,
    )
from ..tools import get_settings

sugiana

# http://python.web.id/angka-terbilang-pada-python/#.VQpS8s2sXQo

satuan = ['', 'satu', 'dua', 'tiga', 'empat', 'lima', 'enam', 'tujuh',
          'delapan', 'sembilan', 'sepuluh', 'sebelas']
    
def terbilang_(n):
    n = int(n)
    if n >= 0 and n <= 11:
        hasil = [satuan[n]]
    elif n >= 12 and n <= 19:

sugiana

# -*- coding: utf-8 -*-
from sqlalchemy.sql.expression import asc, desc
from sqlalchemy.sql import or_, and_
from sqlalchemy.orm.properties import RelationshipProperty
from sqlalchemy.sql.expression import cast
from sqlalchemy import String

from collections import namedtuple

ColumnTuple = namedtuple('ColumnDT', ['column_name', 'mData', 'search_like', 'filter'])

sugiana

#!/usr/bin/python

import sys
import subprocess


cmd = ['/usr/sbin/adduser'] + sys.argv[1:]
subprocess.call(cmd)
if sys.argv[1:]:
    username = sys.argv[1]

sugiana

from sqlalchemy import (
    Table,
    MetaData,
    )
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import sessionmaker
from sqlalchemy.schema import PrimaryKeyConstraint


Base = declarative_base()

sugiana

import string


def clean(s):
    r = ''
    for ch in s:
        if ch not in string.printable:
            ch = ' '
        r += ch
    return r

sugiana

from sqlalchemy import create_engine

db_url = 'oracle://user:pass@ip/db'
engine = create_engine(db_url)

sql = """INSERT INTO sync_sppt_ora2pg (kd_propinsi, kd_dati2,
kd_kecamatan, kd_kelurahan, kd_blok, no_urut, kd_jns_op,
thn_pajak_sppt, jns_sinkron) VALUES ('36','76','052', '004',
'007', '3522', '0', '2014', '2')"""

sugiana

from sqlalchemy import (create_engine, Column, Integer, String, ForeignKey,
                        UniqueConstraint)
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import sessionmaker


Base = declarative_base()


class User(Base):

sugiana

import os
import sys
from optparse import OptionParser
from sqlalchemy import create_engine
from time import sleep
import signal
import commands
import conf

sugiana

import sqlalchemy as sa
import csv
import sys

tablename = sys.argv[1]
filename = '%s.csv' % tablename

url = 'postgresql://user:pass@host/dbname'
eng = sa.create_engine(url)
q = eng.execute("SELECT * FROM %s" % tablename)