def test_where_8(self):
obj = SqlMaker()
obj.Where('(col1=%s', 'val1')
obj.Where('(col2=%s', 'val2')
obj.WhereOr('col3=%s))', 'val3')
obj.Where('col4=%s', 'val4')
self.assertEqual('WHERE \r(col1=%s\rAND (col2=%s\rOR col3=%s))\rAND col4=%s\r', str(obj))
def test_from_5(self):
obj = SqlMaker()
self.assertRaises(Exception, obj.From, None)
def test_from_3(self):
obj = SqlMaker()
obj.From('c1', 'c2', {'c3': 'a'})
self.assertEqual('FROM c1, c2, c3 AS a\r', str(obj))
def test_from_2(self):
obj = SqlMaker()
obj.From('c1')
self.assertEqual('FROM c1\r', str(obj))
def test_from_1(self):
obj = SqlMaker()
obj.From('c1', 'c2')
self.assertEqual('FROM c1, c2\r', str(obj))
def test_select_8(self):
obj = SqlMaker()
self.assertRaises(Exception, obj.Select, {'c2': 'column'}, None, 'c1')
def test_where_4(self):
obj = SqlMaker()
obj.WhereOr('col1=%s', 'val1')
obj.WhereOr('col2=%s', 'val2')
self.assertEqual('WHERE \rcol1=%s\rOR col2=%s\r', str(obj))
def test_update_4(self):
obj = SqlMaker()
self.assertRaises(Exception, obj.Update, 'table', 'a1')
def test_select_4(self):
obj = SqlMaker()
obj.Select()
self.assertEqual('SELECT *\r', str(obj))
def test_select_3(self):
obj = SqlMaker()
obj.Select('c1')
self.assertEqual('SELECT c1\r', str(obj))
def test_select_2(self):
obj = SqlMaker()
obj.Select('c1', 'c2')
self.assertEqual('SELECT c1, c2\r', str(obj))
def test_delete_1(self):
obj = SqlMaker()
obj.Delete('table')
self.assertEqual('DELETE FROM table\r', str(obj))
def test_select_1(self):
obj = SqlMaker()
obj.Select('c1', 'c2', {'c3': 'column'})
self.assertEqual('SELECT c1, c2, c3 AS column\r', str(obj))
def test_from_6(self):
obj = SqlMaker()
obj.From({'c3': 'a'})
self.assertEqual('FROM c3 AS a\r', str(obj))
def test_select_5(self):
obj = SqlMaker()
obj.Select('c1', {'c2': 'column'}, 'c3')
self.assertEqual('SELECT c1, c2 AS column, c3\r', str(obj))
def test_update_2(self):
obj = SqlMaker()
obj.Update('table', {'a1': 0}, {'a2': 'asd'})
self.assertEqual('UPDATE table SET a1 = %s, a2 = %s\r', str(obj))
def test_select_7(self):
obj = SqlMaker()
self.assertRaises(Exception, obj.Select, None)
def test_where_1(self):
obj = SqlMaker()
obj.Where('col1=%s', 'val1')
self.assertEqual('WHERE \rcol1=%s\r', str(obj))
scheme_1_id, status, permission)
return page_id
except Exception as e:
db.Rollback()
raise Exception('RouterModel: Can`t add page!')
else:
return {'domen_id': domen_id, 'section_id': section_id,
'alaise_id': alias_id, 'page_id': page_id,
'domen': url_obj['domen'], 'section': url_obj['section'],
'alias': url_obj['alias'], 'url': url}
def UpdateScheme(self, scheme_id, scheme_text):
pass
conn = psycopg2.connect(host='192.168.100.6', database="SomeWiki", user="******", password="******")
db = SqlMaker(conn=conn, type_db='pg', pref='tbl_', debug=False)
url = 'http://hghltd.yandex.net:888/ывффывор?fmode=inject&url=http%3A%2F%2Fmetro.yandex.ru%2Fmoscow&tld=ru&text=%D0%BA%D0%B0%D1%80%D1%82%D0%B0%20%D0%BC%D0%B5%D1%82%D1%80%D0%BE%20%D0%BC%D0%BE%D1%81%D0%BA%D0%B2%D1%8B&l10n=ru&mime=html&sign=cbab244bf9a8313ebdb1944b0aaa9274&keyno=0&aParam%5B0%5D=1&aParam%5B1%5D=4&aParam%5Ba%5D=b&aParam%5Bc%5D=d'
#url = 'http://ru.wikipedia.org/wiki/%D0%A1%D0%BF%D0%B8%D1%81%D0%BE%D0%BA_%D0%BF%D1%80%D0%BE%D0%B8%D0%B7%D0%B2%D0%B5%D0%B4%D0%B5%D0%BD%D0%B8%D0%B9_%D0%96%D1%8E%D0%BB%D1%8F_%D0%92%D0%B5%D1%80%D0%BD%D0%B0'
#url = 'http://ru.wikipedia.org/%E0%AA%AA%E0%AB%83%E0%AA%B7%E0%AB%8D%E0%AA%A0%E0%AB%8B%E0%AA%A8%E0%AB%87_%E0%AA%B6%E0%AB%8B%E0%AA%A7%E0%AA%B5%E0%AA%BE_%E0%AA%95%E0%AB%87_%E0%AA%86_%E0%AA%B6%E0%AB%80%E0%AA%B0%E0%AB%8D%E0%AA%B7%E0%AA%95_%E0%AA%B2%E0%AA%BF%E0%AA%82%E0%AA%95.html/'
request = Request(url)
model = RouterModel()
result = model.AddPage(db, url, 0, 0)
print(result)
#m = model.AddAlias(db, request.aliase)
#print('Aliase ID:', m, request.aliase)
#m = model.AddSection(db, request.section)
#print('Section ID:', m, request.section)
#m = model.AddDomen(db, request.domen)
