This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
from sqlalchemy import create_engine | |
from sqlalchemy.ext.declarative import declarative_base | |
from sqlalchemy import Column, Integer, String, ForeignKey | |
from sqlalchemy.orm import sessionmaker | |
engine = create_engine('sqlite:///') | |
Session = sessionmaker(bind=engine) | |
sess = Session() | |
Base = declarative_base() |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
from sqlalchemy import create_engine | |
from sqlalchemy.ext.declarative import declarative_base | |
from sqlalchemy import Column, Integer, String, ForeignKey | |
from sqlalchemy.orm import sessionmaker | |
# engine = create_engine('sqlite:///') | |
engine = create_engine('sqlite:///') | |
Session = sessionmaker(bind=engine) | |
sess = Session() | |
Base = declarative_base() |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
from sqlalchemy import create_engine | |
from sqlalchemy.ext.declarative import declarative_base | |
from sqlalchemy import Column, Integer, String, ForeignKey | |
from sqlalchemy.orm import sessionmaker | |
# engine = create_engine('sqlite:///') | |
engine = create_engine('sqlite:///example_1_fk_check.db') | |
Session = sessionmaker(bind=engine) | |
sess = Session() | |
Base = declarative_base() |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
В SQLite порядок и отсутствуие ключе не важны В PG все иначе. Работает только если мы: | |
1. ссылаемся на существующие ключи | |
2. порядок добавления правильный. в начале добавляем adr1 потом user1 | |
from sqlalchemy import create_engine | |
from sqlalchemy.ext.declarative import declarative_base | |
from sqlalchemy import Column, Integer, String, ForeignKey | |
from sqlalchemy.orm import sessionmaker | |
from sqlalchemy_utils import database_exists, create_database |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
from sqlalchemy import create_engine | |
from sqlalchemy.ext.declarative import declarative_base | |
from sqlalchemy import Column, Integer, String, ForeignKey | |
from sqlalchemy.orm import sessionmaker | |
from sqlalchemy_utils import database_exists, create_database | |
engine = create_engine('sqlite:///') | |
engine = create_engine('sqlite:///example_1_fk_check.db') | |
# engine = create_engine("postgres://postgres@localhost/mydb_3") |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
def upgrade(migrate_engine): | |
# Upgrade operations go here. Don't create your own engine; bind | |
# migrate_engine to your metadata | |
metadata = MetaData(bind=migrate_engine) | |
user = Table('user', metadata, | |
Column('user_id', Integer, primary_key=True), | |
Column('user_name', String(16), nullable=False), | |
Column('email_address', String(60), key='email'), | |
Column('password', String(20), nullable=False) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
print('-----------') | |
print('Extracting data from client_id:', client_id) # перенесем сюда дял наглядности, чтобы выводом других ф-ций не ломать вывод | |
# Проинформируем о том в какиих случаях у нас нет данных | |
if not dict_list_1: | |
print('NO DATA for case: ', 'vrb_payout') | |
f = None | |
send_email(f, config, name_and_email[1]) | |
else: | |
print('[GOOD] DATA for case: ', 'vrb_payout') | |
f = write_reestr_as_csv(client_id, dict_list_1, 'vrb_payout') |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
import std.stdio; | |
import std.file; | |
import std.path; | |
import std.algorithm; | |
string folder = r"C:\temp2\contracts"; | |
void main() | |
{ | |
string [] dublicates_list; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
import os | |
# модуль для работы с ftp | |
import ftplib | |
from pathlib import Path | |
# модуль для работы с zip архивами | |
from zipfile import * | |
# Библиотека для работы с Oracle | |
import cx_Oracle | |
import datetime as dt | |
import time |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
import 'dart:convert'; | |
import 'package:flutter/material.dart'; | |
import 'package:flutter/widgets.dart'; | |
import 'package:http/http.dart' as http; | |
import 'select_regions.dart'; | |
import 'dart:convert'; | |
import 'package:provider/provider.dart'; | |
void main() => runApp(MyApp()); |