def setUp(self): self.config = testing.setUp() from sqlalchemy import create_engine engine = create_engine('sqlite://') from lingvodoc.models import (Base) DBSession.configure(bind=engine) Base.metadata.create_all(engine)
def async_convert_dictionary(client_id, object_id, parent_client_id, parent_object_id, dictionary_client_id, dictionary_object_id, perspective_client_id, perspective_object_id, user_id, task_id=None): DBSession.configure(bind=celery_engine) client = DBSession.query(Client).filter_by(id=user_id).first() user = client.user blob = DBSession.query(UserBlobs).filter_by(client_id=client_id, object_id=object_id).first() # convert_one(blob.real_storage_path, # user.login, # user.password.hash, # parent_client_id, # parent_object_id) # NOTE: doesn't work on Mac OS otherwise convert_one(blob.real_storage_path, user.login, user.password.hash, parent_client_id, parent_object_id, dictionary_client_id, dictionary_object_id, perspective_client_id, perspective_object_id, task_id=task_id) return
def setUp(self): self.config = testing.setUp() import webtest from pyramid import paster from sqlalchemy import create_engine engine = create_engine('sqlite://') myapp = paster.get_app('testing.ini') self.app = webtest.TestApp(myapp) from lingvodoc.models import ( Base, Locale, User, Passhash, Client ) DBSession.configure(bind=engine) Base.metadata.create_all(engine) with transaction.manager: ru_locale = Locale(id=1, shortcut="ru", intl_name="Русский") DBSession.add(ru_locale) en_locale = Locale(id=2, shortcut="en", intl_name="English") DBSession.add(en_locale) DBSession.flush() new_user = User(id=1, login='******', default_locale_id = 1) new_pass = Passhash(password='******') DBSession.add(new_pass) new_user.password = new_pass DBSession.add(new_user) new_client = Client(id=1, user=new_user) DBSession.add(new_client)
def setUp(self): self.config = testing.setUp() from sqlalchemy import create_engine engine = create_engine('sqlite://') from lingvodoc.models import ( Base ) DBSession.configure(bind=engine) Base.metadata.create_all(engine)
def setUp(self): self.config = testing.setUp() self.config.testing_securitypolicy(userid='1', permissive=True) import webtest from pyramid import paster from sqlalchemy import create_engine engine = create_engine('sqlite://') myapp = paster.get_app('testing.ini') self.app = webtest.TestApp(myapp) from lingvodoc.models import (Base) DBSession.configure(bind=engine) Base.metadata.create_all(engine)
def setUp(self): self.config = testing.setUp() from sqlalchemy import create_engine engine = create_engine('sqlite://') from lingvodoc.models import (Base, Language) DBSession.configure(bind=engine) Base.metadata.create_all(engine) with transaction.manager: new_lang = Language(client_id=1, object_id=1, translation_string='test') DBSession.add(new_lang)
def setUp(self): self.config = testing.setUp() from sqlalchemy import create_engine engine = create_engine('sqlite://') from lingvodoc.models import ( Base, Language ) DBSession.configure(bind=engine) Base.metadata.create_all(engine) with transaction.manager: new_lang = Language(client_id=1, object_id=1, translation_string='test') DBSession.add(new_lang)
def convert_all(blob_client_id, blob_object_id, language_client_id, language_object_id, user_id, gist_client_id, gist_object_id, sqlalchemy_url, storage): log = logging.getLogger(__name__) log.setLevel(logging.DEBUG) try: engine = create_engine(sqlalchemy_url) DBSession.configure(bind=engine) status = convert_db_new( blob_client_id, blob_object_id, language_client_id, language_object_id, user_id, gist_client_id, gist_object_id, storage) except Exception as e: log.error("Converting failed") log.error(e.__traceback__) raise log.debug(status) log.debug('we are the champions') return status
def convert_all(dictionary_client_id, dictionary_object_id, user_id, client_id, object_id, sqlalchemy_url, storage, eaf_url, sound_url=None): engine = create_engine(sqlalchemy_url) DBSession.configure(bind=engine) convert_five_tiers(dictionary_client_id, dictionary_object_id, user_id, client_id, object_id, sqlalchemy_url, storage, eaf_url, sound_url) DBSession.flush()
def setUp(self): self.config = testing.setUp() self.config.testing_securitypolicy(userid='1', permissive=True) import webtest from pyramid import paster from sqlalchemy import create_engine engine = create_engine('sqlite://') myapp = paster.get_app('testing.ini') self.app = webtest.TestApp(myapp) from lingvodoc.models import ( Base ) DBSession.configure(bind=engine) Base.metadata.create_all(engine)
def setUp(self): self.config = testing.setUp() import webtest from pyramid import paster from sqlalchemy import create_engine engine = create_engine('sqlite://') myapp = paster.get_app('testing.ini') self.app = webtest.TestApp(myapp) from lingvodoc.models import (Base, Language, Locale, UserEntitiesTranslationString, User, Passhash, Client) DBSession.configure(bind=engine) Base.metadata.create_all(engine) with transaction.manager: ru_locale = Locale(id=1, shortcut="ru", intl_name="Русский") DBSession.add(ru_locale) en_locale = Locale(id=2, shortcut="en", intl_name="English") DBSession.add(en_locale) DBSession.flush() new_user = User(id=1, login='******', default_locale_id=1) new_pass = Passhash(password='******') DBSession.add(new_pass) new_user.password = new_pass DBSession.add(new_user) new_client = Client(id=1, user=new_user) DBSession.add(new_client) DBSession.flush() new_uets = UserEntitiesTranslationString(object_id=1, client_id=1, locale_id=1, translation_string='test', translation='not working') DBSession.add(new_uets) new_lang = Language(client_id=1, object_id=1, translation_string='test') DBSession.add(new_lang) new_lang = Language(client_id=1, object_id=2, translation_string='testy') DBSession.add(new_lang)
def setUp(self): self.config = testing.setUp() from lingvodoc.models import ( Base, Language, UserEntitiesTranslationString, Locale ) from sqlalchemy import create_engine engine = create_engine('sqlite://') DBSession.configure(bind=engine) Base.metadata.create_all(engine) with transaction.manager: ru_locale = Locale(id=1, shortcut="ru", intl_name="Русский") DBSession.add(ru_locale) DBSession.flush() new_uets = UserEntitiesTranslationString(object_id = 1, client_id = 1, locale_id=1, translation_string = 'test', translation = 'working') DBSession.add(new_uets) new_lang=Language(client_id=1, object_id=1, translation_string = 'test') DBSession.add(new_lang)
def setUp(self): self.config = testing.setUp() self.config.testing_securitypolicy(userid='1', permissive=True) import webtest from pyramid import paster from sqlalchemy import create_engine engine = create_engine('sqlite://') myapp = paster.get_app('testing.ini') self.app = webtest.TestApp(myapp) from lingvodoc.models import ( Base, User, Client, Passhash, Locale, UserEntitiesTranslationString, Language ) DBSession.configure(bind=engine) Base.metadata.create_all(engine) with transaction.manager: ru_locale = Locale(id=1, shortcut="ru", intl_name="Русский") DBSession.add(ru_locale) en_locale = Locale(id=2, shortcut="en", intl_name="English") DBSession.add(en_locale) DBSession.flush() new_user = User(id=1, login='******', default_locale_id = 1) new_pass = Passhash(password='******') DBSession.add(new_pass) new_user.password = new_pass DBSession.add(new_user) new_client = Client(id=1, user=new_user) DBSession.add(new_client) new_uets= UserEntitiesTranslationString(client_id = 1, object_id = 1, locale_id=2, translation_string = 'imastring') DBSession.add(new_uets) new_lang = Language(client_id=1, object_id=1, translation_string='testy') DBSession.add(new_lang)
def setUp(self): self.config = testing.setUp() from lingvodoc.models import (Base, Language, UserEntitiesTranslationString, Locale) from sqlalchemy import create_engine engine = create_engine('sqlite://') DBSession.configure(bind=engine) Base.metadata.create_all(engine) with transaction.manager: ru_locale = Locale(id=1, shortcut="ru", intl_name="Русский") DBSession.add(ru_locale) DBSession.flush() new_uets = UserEntitiesTranslationString(object_id=1, client_id=1, locale_id=1, translation_string='test', translation='working') DBSession.add(new_uets) new_lang = Language(client_id=1, object_id=1, translation_string='test') DBSession.add(new_lang)
def setUp(self): self.config = testing.setUp() import webtest from pyramid import paster from sqlalchemy import create_engine engine = create_engine('sqlite://') myapp = paster.get_app('testing.ini') self.app = webtest.TestApp(myapp) from lingvodoc.models import ( Base, Dictionary, Language, Organization, Locale, User, Passhash, Client, DictionaryPerspective ) DBSession.configure(bind=engine) Base.metadata.create_all(engine) with transaction.manager: pass
def convert_all(dictionary_client_id, dictionary_object_id, user_id, client_id, object_id, sqlalchemy_url, storage, eaf_url, sound_url=None ): engine = create_engine(sqlalchemy_url) DBSession.configure(bind=engine) convert_five_tiers( dictionary_client_id, dictionary_object_id, user_id, client_id, object_id, sqlalchemy_url, storage, eaf_url, sound_url )
def setUp(self): self.config = testing.setUp() import webtest from pyramid import paster from sqlalchemy import create_engine engine = create_engine('sqlite://') myapp = paster.get_app('testing.ini') self.app = webtest.TestApp(myapp) from lingvodoc.models import ( Base, Dictionary, Language, Organization, Locale, User, Passhash, Client, DictionaryPerspective, UserEntitiesTranslationString ) DBSession.configure(bind=engine) Base.metadata.create_all(engine) with transaction.manager: ru_locale = Locale(id=1, shortcut="ru", intl_name="Русский") DBSession.add(ru_locale) en_locale = Locale(id=2, shortcut="en", intl_name="English") DBSession.add(en_locale) DBSession.flush() new_user = User(id=1, login='******', default_locale_id = 1) new_pass = Passhash(password='******') DBSession.add(new_pass) new_user.password = new_pass DBSession.add(new_user) new_client = Client(id=1, user=new_user) DBSession.add(new_client) new_user2 = User(id=2, login='******', default_locale_id = 1) new_pass2 = Passhash(password='******') DBSession.add(new_pass) new_user2.password = new_pass2 DBSession.add(new_user2) new_client = Client(id=2, user=new_user2) DBSession.add(new_client) new_client = Client(id=3, user=new_user) DBSession.add(new_client) DBSession.flush() new_user3 = User(id=3, login='******', default_locale_id = 1) new_pass3 = Passhash(password='******') DBSession.add(new_pass3) new_user3.password = new_pass3 DBSession.add(new_user3) new_client = Client(id=4, user=new_user3) DBSession.add(new_client) new_user4 = User(id=4, login='******', default_locale_id = 1) new_pass4 = Passhash(password='******') DBSession.add(new_pass4) new_user4.password = new_pass4 DBSession.add(new_user4) new_client = Client(id=5, user=new_user4) DBSession.add(new_client) new_lang1 = Language(client_id=1, object_id=1, translation_string='head') DBSession.add(new_lang1) new_lang2 = Language(client_id=2, object_id=5, translation_string='left son', parent=new_lang1) DBSession.add(new_lang2) new_lang3 = Language(client_id=1, object_id=3, translation_string='right son', parent=new_lang1) DBSession.add(new_lang3) new_lang4 = Language(client_id=2, object_id=4, translation_string='first grand son', parent=new_lang3) DBSession.add(new_lang4) new_lang5 = Language(client_id=1, object_id=5, translation_string='second grand son', parent=new_lang3) DBSession.add(new_lang5) new_lang6 = Language(client_id=1, object_id=6, translation_string='third grand son', parent=new_lang3) DBSession.add(new_lang6) new_lang7 = Language(client_id=1, object_id=7, translation_string='grand grand son', parent=new_lang5) DBSession.add(new_lang7) new_lang8 = Language(client_id=1, object_id=8, translation_string='second head') DBSession.add(new_lang8) new_lang9 = Language(client_id=1, object_id=9, translation_string='second left son', parent=new_lang8) DBSession.add(new_lang9) new_lang10 = Language(client_id=1, object_id=10, translation_string='second right son', parent=new_lang8) DBSession.add(new_lang10) new_org1 = Organization(name='first') new_org1.users.append(new_user) new_org1.users.append(new_user3) DBSession.add(new_org1) new_org2 = Organization(name='second') DBSession.add(new_org2) new_dict = Dictionary(client_id=1, object_id=1, name='dict') DBSession.add(new_dict) DBSession.flush() new_persp1 = DictionaryPerspective(client_id=1, object_id=1, name='persp', parent=new_dict) DBSession.add(new_persp1) new_persp2 = DictionaryPerspective(client_id=2, object_id=2, name='persp', parent=new_dict) DBSession.add(new_persp2) uets = UserEntitiesTranslationString(locale_id=1, translation_string='persp', translation='персп')