def get_kintone_data(app_id, limit=None, offset=None, query=None):
result = False
records = None
errmsg = None
ktn_key = None
try:
ktn_key = Kintone_Key.objects.get(app_id=app_id)
except Kintone_Key.DoesNotExist:
return result, records, errmsg
if offset == None:
offset = 0
if limit == None:
limit = 500
if query == None:
query = ''
else:
query += ' '
r = pykintone.app(ktn_key.domain, ktn_key.app_id, ktn_key.api_token).select(query + "limit " + str(limit) + " offset " + str(offset))
if not r.ok:
errmsg = r.error
return result, records, errmsg
result = True
records = r.records
return result, records, errmsg
def notify():
env = Environment()
kintone = pykintone.app(env.kintone.domain, env.kintone.app_id, env.kintone.api_token)
waitings = kintone.select('ステータス = "通知待ち"').records
# todo reply to reported user
result = kintone.batch_proceed(waitings, action="完了")
return result
def lambda_handler(event=None, context=None):
r = pykintone.app("yarou", "5",
"BAHSTXI4IJozgIShRbpZiEB16ERrg7AMPDuJ8nsf").select()
if r.ok:
records = r.records
logger.info(json.dumps(records, ensure_ascii=False, indent=2))
logger.info('Lambda function invoked index()')
return 'hello from Flask!'
def post_to_kintone(kw):
import pykintone
app = pykintone.app('mitou', '90', 'ry4O9PfUuPqoc0uQT75kXu5eaA5dpH6hM1o6Jo0U')
from pykintone import model
class Person(model.kintoneModel):
def __init__(self, kw):
super(Person, self).__init__()
self.name = kw['name']
self.name_en = kw['name_en']
self.self_intro = kw['SelfIntroduction']
self.interested_in = kw['InterestedIn']
app.create(Person(kw))
def test_api_interface(self):
# load from file
kintone = pykintone.load(envs.FILE_PATH)
app = kintone.app()
self.assertTrue(app)
# login
app = pykintone.login("domain", "user_id", "password").app(1, api_token="token")
self.assertTrue(app)
# app
app = pykintone.app("domain", 1, "token")
self.assertTrue(app)
def lambda_handler(event, context):
#print("Received event: " + json.dumps(event, indent=2))
bucket = event['Records'][0]['s3']['bucket']['name']
key = urllib.parse.unquote_plus(event['Records'][0]['s3']['object']['key'],
encoding='utf-8')
try:
response = s3.get_object(Bucket=bucket, Key=key)
json_stream = response['Body'].read()
json_stream = json_stream.decode('utf-8')
decoder = json.JSONDecoder()
while len(json_stream) > 0:
record, index = decoder.raw_decode(json_stream)
json_stream = json_stream[index:]
print(record)
soracom = Soracom(data=record)
app = pykintone.app(os.environ['KINTONE_SUBDOMAIN'],
os.environ['KINTONE_APP_ID'],
os.environ['KINTONE_API_TOKEN'])
r = app.create(soracom)
if r.ok:
created_id = r.record_id
print(created_id)
response = {
"statusCode": 200,
"body": {json.dumps({"id": created_id})}
}
return response
except Exception as e:
print(e)
print(
'Error getting object {} from bucket {}. Make sure they exist and your bucket is in the same region as this function.'
.format(key, bucket))
raise e
response = {"statusCode": 500, "body": json.dumps(e)}
return response
def __init__(self, domain, app, token):
self.app = pykintone.app(domain, app, token)
def get_app():
app = pykintone.app('mitou', secret.JINZAI_APPID, secret.JINZAI_TOKEN)
return app
def get_app():
app = pykintone.app('mitou', secret.JINZAI_APPID, secret.JINZAI_TOKEN)
return app
def get_kintone():
env = Environment()
kintone = pykintone.app(env.kintone.domain, env.kintone.app_id, env.kintone.api_token)
return kintone
import pykintone
from pykintone import model
import warnings
class Value(model.kintoneModel):
def __init__(self):
super(Value, self).__init__()
self.value = ""
TOKEN = 'mzJ3ef3m1ijBGDVsWwpje8KtBeWYyqsjAzARCKA5'
app = pykintone.app('bozuman', 15786, TOKEN, {'timeout': 10})
import serial
port = serial.Serial("/dev/ttyACM0", baudrate=9600, timeout=0.1)
while True:
v = port.read(1024) # throw old data away
if not v: break
port = serial.Serial("/dev/ttyACM0", baudrate=9600, timeout=3.0)
while True:
try:
s = port.readline()
i = int(s.strip())
v = Value()
v.value = i
with warnings.catch_warnings():
warnings.simplefilter("ignore")
app.create(v)
print i
except Exception, e:
def __init__(self, subdomain, app_id, token):
self.application = pykintone.app(subdomain, app_id, token)
