#!/bin/python

from peewee import *

"""
Eskiel - minimal ORM adapter for IOT

License : WTFPL
Author : maidgirl21

# Deskripsi tambahan

Adapator minimal mengunakan Python untuk IOT

Instruksi Penginstallan Eskiel:

pip2 install peewee pymysql

Cara gunakan pevensey.py :

from pevensey import Eskiel

  - untuk query

      objek = Eskiel('localhost','test','root','',3306)
      objek.query('show tables') # bisa di ganti dengan kueri sendiri



 """
class Eskiel():
	# fungsi mysql_connect
	# db : urldatabase
	# dbn : nama database
	# u: username , p : password

	def __init__(self,db,dbn,u,p,pp):
		self.hostname = db
		self.database = dbn
		self.username = u
		self.password = p
		global mysql_db
		mysql_db = MySQLDatabase(self.database, user=self.username, password=self.password,
                         host=self.hostname, port=pp)
		if mysql_db.connect():
			print "[*] Sukses"
		else:
			print "[?] Gagal"


	def query(self,query):
		hasil_data = mysql_db.execute_sql(query);
		#for baris in hasil_data.fetchall():
		#	print baris

	#fungsi query
	#	Asumsi:
	#		Table DB : CREATE TABLE buku (judul varchar,penulis varchar);
	#			INSERT INTO buku VALUES ('r','r');
	#			SELECT * FROM buku;
	#
	# Eskiel.insert_to('buku',[('Anarko-Syndicalis','Rocker')....]