Skip to content

Instantly share code, notes, and snippets.

View widoyo's full-sized avatar

Widoyo widoyo

View GitHub Profile
@widoyo
widoyo / mail_processor.py
Created February 11, 2013 15:06
Pembaca email (IMAP)
import re
import imaplib
import email
import datetime
import json
EMAIL_FROM = 'sparelog_hwi'
EMAIL_HOST = ''
EMAIL_USER = ''
EMAIL_PASS = ''
import re
import os, glob
order_num = []
filelist = glob.glob(os.path.join('.', 'feb_*.txt'))
re_order_num = re.compile('Order No: (?P<orderno>\d+)')
for f in filelist:
@widoyo
widoyo / import_handover1.py
Last active December 13, 2015 20:18
Script bantu data Sparelog
>>> # untuk import Lead Time yang berupa Matriks
>>>
>>> rdr = csv.reader(lines, delimiter='\t')
>>> h = rdr.next()[1:]
>>> for d in rdr:
... if d[0] != 'TANJUNG PANDAN':
... p1 = dpool[d[0]]
... i = 1
... for np in h:
... if np != 'TANJUNG PANDAN':
@widoyo
widoyo / latih1.py
Last active December 13, 2015 22:29
Mainan Akses Data dengan Django ORM
>>> # banyaknya Pool
>>> from hsm.models import Pool
>>> jumlah_pool = Pool.objects.count()
>>> # menampilkan nama-nama pool
>>> for p in Pool.objects.all():
... p.name
...
>>> # menampilkan nama dan region Pool yang ada di Region 3
[ui]
username = 'Widoyo <[email protected]>'
[paths]
default-push = http://[email protected]/widoyo/sparelog-hsm
[hooks]
precommit.put_rev = .hg/put_rev.sh
@widoyo
widoyo / AGA3.py
Created September 26, 2013 23:07 — forked from giljunqueira/AGA3.py
# -*- coding: utf-8 -*-
"""
Created on Fri Aug 27 09:16:20 2010
@author: g.junqueira
AGA3 METER GAS CALCULATION IMPLEMENTATION as a callable Python function
"""
import math
#Connection Strings
$Database = "Database"
$Server = "SQLServer"
#SMTP Relay Server
$SMTPServer = "smtp.domain.com"
#Export File
$AttachmentPath = "C:\SQLData.csv"
# Connect to SQL and query data, extract data to SQL Adapter
$SqlQuery = "SELECT * FROM dbo.Test_Table"
$SqlConnection = New-Object System.Data.SqlClient.SqlConnection
@widoyo
widoyo / query_2_csv.ps1
Created October 24, 2013 03:17
Export hasil query MS SQL ke CSV
#Connection Strings
$Database = "Database"
$Server = "SQLServer"
#Export File
$AttachmentPath = "C:\SQLData.csv"
# Connect to SQL and query data, extract data to SQL Adapter
$SqlQuery = "SELECT * FROM dbo.Test_Table"
$SqlConnection = New-Object System.Data.SqlClient.SqlConnection
@widoyo
widoyo / api.js
Created December 27, 2013 18:57 — forked from fwielstra/api.js
/* The API controller
Exports 3 methods:
* post - Creates a new thread
* list - Returns a list of threads
* show - Displays a thread and its posts
*/
var Thread = require('../models/thread.js');
var Post = require('../models/post.js');
@widoyo
widoyo / index.js
Created March 28, 2014 09:08
Client Side Chatting
function init() {
var serverBaseUrl = document.domain;
/*
On client init, try to connect to the socket.IO server.
Note we don't specify a port since we set up our server
to run on port 8080
*/
var socket = io.connect(serverBaseUrl);