Skip to content

Instantly share code, notes, and snippets.

package jp.hermesian.excel2db;
import java.io.File;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.ResourceBundle;
import java.util.logging.Level;
import java.util.logging.Logger;
import org.dbunit.database.DatabaseConnection;
@yuriwoof
yuriwoof / model.py
Created December 31, 2016 02:24
petshop/model.py
from sqlalchemy import Column, DateTime, Integer, String
from db import db_session, Base
class Pet(Base):
__tablename__ = 'pets'
id = Column(Integer, primary_key=True)
name = Column(String(100))
tag = Column(String(20))
created = Column(DateTime())
@yuriwoof
yuriwoof / db.py
Created December 31, 2016 02:27
petshop/db.py
from sqlalchemy import create_engine
from sqlalchemy.orm import scoped_session, sessionmaker
from sqlalchemy.ext.declarative import declarative_base
engine = create_engine('sqlite:///petstore.db', convert_unicode=True)
db_session = scoped_session(sessionmaker(autocommit=False,
autoflush=False,
bind=engine))
Base = declarative_base()
@yuriwoof
yuriwoof / default_controller.py
Created December 31, 2016 02:28
petstore/default_controller.py
import logging
import datetime
from connexion import NoContent
from db import db_session
from models import Pet
from sqlalchemy import or_
from celery import Celery
def make_celery(app):
celery = Celery(app.import_name, broker=app.config['CELERY_BROKER_URL'])
celery.conf.update(app.config)
TaskBase = celery.Task
class ContextTask(TaskBase):
abstract = True
def __call__(self, *args, **kwargs):
class Config(object):
CELERY_BROKER_URL = 'pyamqp://vagrant:vagrant@localhost/vagrant'
from __future__ import absolute_import
from celery_flask import make_celery
from flask import Flask
from config import Config
config = Config()
flask_app = Flask(__name__)
flask_app.config.update(
CELERY_BROKER_URL=config.CELERY_BROKER_URL
# escape=`
FROM mcr.microsoft.com/windows/servercore/iis:windowsservercore-ltsc2019
# Install IIS, LogMonitor.exe and ServiceMonitor.exe
RUN powershell -Command `
New-Item -ItemType Directory C:\LogMonitor; `
$downloads = `
@( `
@{ `
# Disable IE enchanced security
$AdminKey = "HKLM:\SOFTWARE\Microsoft\Active Setup\Installed Components\{A509B1A7-37EF-4b3f-8CFC-4F3A74704073}"
$UserKey = "HKLM:\SOFTWARE\Microsoft\Active Setup\Installed Components\{A509B1A8-37EF-4b3f-8CFC-4F3A74704073}"
Set-ItemProperty -Path $AdminKey -Name "IsInstalled" -Value 0
Set-ItemProperty -Path $UserKey -Name "IsInstalled" -Value 0
# Disable lanuching server manager
New-ItemProperty -Path HKLM:\Software\Microsoft\ServerManager -Name DoNotOpenServerManagerAtLogon -PropertyType DWORD -Value "0x1" -Force
# Enable DNS feature