Форум сайта python.su
urlpatterns = patterns('', url(r'^look/(.*)$', 'envrnmnt.views.look'), )
def look(request, file_name=''): temp ={} user = None if request.method == 'POST': if 'fileBody' in request.POST: path_to_file = os.path.join('report', file_name) #full access to all #os.chmod(path_to_file, 0777) input_file = open(path_to_file, 'w') comment = request.POST.getlist('fileBody') goods_name = request.POST.getlist('fileHeader') for i in range(0, len(goods_name)): temp.update({goods_name[i].encode("utf8") : comment[i].encode("utf8")}) input_file.write(str(temp)) input_file.close() return render_to_response('look.html', {'file_name': file_name, 'dict': temp}) else: if not file_name: return render_to_response('look.html') else: _file = open(os.path.join('report', file_name), 'r')#a+ file_body = _file.read() if file_body: my_dict = eval(file_body) _file.close() #может можно привязаться к юзеру? #user = request.META['USERNAME'] #read only to all #os.chmod(_file.name, 0444) return render_to_response('look.html', {'file_name': file_name, 'dict': my_dict}) else: url = 'file:' + urllib.pathname2url(r'path to html') resp = urlopen(url) soup = BeautifulSoup(resp.read(), "html.parser") table = soup.find('table') rows = table.find_all('tr') goods_list = [] for row in rows: goods_name = row.find_all('td')[0].text if goods_name != 'Summary': if len(goods_name) > 2: goods_list .append(goods_name) _file.close() return render_to_response('look.html', {'input_file': file_body, 'file_name': file_name, 'parsed_files': file_name, 'goods_list': goods_list})
<html> <body> <div class="container"> {% if dict %} <h2>Goods report - "{{ file_name }}"</h2> <form id="form1" action="" method="post"> {% for key, value in dict.items %} <input type="text" class="input_style" name="fileHeader" value="{{ key }}"> <textarea style="border: none" class="text-block" name="fileBody">{{ value }}</textarea> <br><br> {% endfor %} <br><br> <button>Save</button> </form> {% elif parsed_files %} <h2>Goods report - "{{ file_name }}"</h2> <form id="form" action="" method="post"> {% for item in goods_list %} <input type="text" class="input_style" name="fileHeader" value="{{ item }}"> <textarea style="border: none" class="text-block" name="fileBody">{{ input_file }}</textarea> <br><br> {% endfor %} <br><br> <button>Save</button> </form> {% else %} <h2>Goods report</h2> <h3> Goods</h3> <textarea style="border: none" class="text-block" name="fileBody">{{ input_file }}</textarea> <br><br> {% endif %} </div> </body> </html>
#!/usr/bin/python3 import sys from PyQt5.QtGui import * from PyQt5.QtCore import * from PyQt5.QtWidgets import * font_family='LiberationMono' font_size=14 width=1024 height=768 article='''Макаров go (в сочетании с последующим герундием выражает действие, соответствующее значению герундия) Габон (государство в юго-западной Африке) присест (Баян) заход (I cannot do it in one go - Я не могу сделать это за один заход / с первого захода Баян) готовый к запуску ''' article=article.splitlines() for i in range(len(article)): article[i]=article[i].split('\t') app = QApplication(sys.argv) table = QTableWidget() tableItem = QTableWidgetItem() table.resize(width,height) table.setRowCount(len(article)) table.setColumnCount(len(article[0])) # Merge columns 1-4 of row 0 table.setSpan(0,1,1,4) standard_col = width/len(article[0]) for i in range(len(article[0])): table.setColumnWidth(i,standard_col) for i in range(len(article)): for j in range(len(article[i])): elem = QTableWidgetItem(article[i][j]) table.setItem(i,j,elem) elem.setTextAlignment(Qt.AlignLeft | Qt.AlignTop) elem.setFont(QFont(font_family,font_size)) table.verticalHeader().setSectionResizeMode(i,QHeaderView.ResizeToContents) table.show() app.exec_()
show_movie.showsMovie_originCountry.get_or_create(placeCountry_name=country)
django.db.utils.IntegrityError: duplicate key value violates unique constraint "place_countries_placeCountry_name_key" DETAIL: Key ("placeCountry_name")=(Польша) already exists.
# Первый проход\инстанс DEBUG -> show_movie: id: 42 ---->>>> Добрый день, я люблю тебя! ---->>>> Мелодрама DEBUG -> country: Польша DEBUG -> films_cast: Алексей Коморовский, Барбара Курдей, Павел Домагала DEBUG -> actor_position: (<ShowPersonsInShows: Актер>, False) DEBUG -> actor_position: (<ShowPersonsInShows: Актер>, False) DEBUG -> actor_position: (<ShowPersonsInShows: Актер>, False) DEBUG -> films_producer: Рышард Заторский DEBUG -> producer_position: (<ShowPersonsInShows: Режиссер>, False) DEBUG -> films_scenarist: Рышард Заторский DEBUG -> scenarist_position: (<ShowPersonsInShows: Сценарист>, False) # Второй проход\инстанс DEBUG -> show_movie: id: 43 ---->>>> Добрый день, я люблю тебя! ---->>>> Комедия DEBUG -> country: Польша Traceback (most recent call last): #### django.db.utils.IntegrityError: duplicate key value violates unique constraint "place_countries_placeCountry_name_key" DETAIL: Key ("placeCountry_name")=(Польша) already exists.
class Shows(models.Model): show_name = models.CharField(max_length=100, db_index=True) show_poster = models.ImageField('Poster') show_screen = models.ImageField('Screens') show_genre = models.CharField('Genre', max_length=20, blank=True) # show_length = models.IntegerField('Length', null=True) show_length = models.TimeField('Time', null=True) show_ageLimit = models.IntegerField('Age limit', null=True) show_description = models.TextField('Description', blank=True) show_youtubeUrl = models.URLField('Youtube', max_length=255, blank=True) show_person = models.ManyToManyField(ShowPersons, through='ShowPersonsInShows', related_name='%(app_label)s_%(class)s_related', verbose_name="People in movie") class Meta: db_table = 'shows' verbose_name = 'Show' verbose_name_plural = 'Shows' ordering = ['show_name'] class ShowsMovies(Shows): showsMovie_originalName = models.CharField('Original name', max_length=100, blank=True) showsMovie_budget = models.IntegerField('Budget', null=True) showsMovie_productionYear = models.IntegerField('Production year', null=True) showsMovie_officialSite = models.URLField('Official site', max_length=255, blank=True) showsMovie_originCountry = models.ManyToManyField('app_places.PlaceCountries', verbose_name='Origin country', db_table='m2m_shows_movies_to_place_countries') class Meta: db_table = 'shows_movies' verbose_name = 'Show Type - Movie' verbose_name_plural = 'Show Type - Movie'
class PlaceCountries(models.Model): placeCountry_name = models.CharField("Country's Name", max_length=60, unique=True) placeCountry_short_name = models.CharField("Country's Short name", max_length=5, unique=True) class Meta: db_table = 'place_countries' verbose_name = 'Country' verbose_name_plural = 'Countries' ordering = ['placeCountry_name']
for genre in films_genre.title().split(', '): show_movie, created = ShowsMovies.objects.get_or_create( show_name=film, show_genre=genre, show_length=films_length, show_ageLimit=films_age, show_description=films_description, show_youtubeUrl=films_youtube_url, showsMovie_originalName=films_original_name, showsMovie_productionYear=films_year, ) print('DEBUG -> show_movie:', 'id:', show_movie.id, '---->>>>', show_movie.show_name, '---->>>>', show_movie.show_genre) for country in films_country.split(', '): print('DEBUG -> country:', country) # Место возникновения ошибки show_movie.showsMovie_originCountry.get_or_create(placeCountry_name=country) if films_cast != ' ': print('DEBUG -> films_cast:', films_cast) for actor in films_cast.split(', '): # и таких еще 2 цилка, только для продюсера и сценариста get_showPersonsInShow_person, created = ShowPersons.objects.get_or_create(showPerson_fullname=actor) get_showPersonsInShow_show, created = Shows.objects.get_or_create(show_name=film, show_genre=genre) actor_position = ShowPersonsInShows.objects.get_or_create( showPersonsInShow_person=get_showPersonsInShow_person, showPersonsInShow_show=get_showPersonsInShow_show, showPersonsInShow_position='Актер' ) print('DEBUG -> actor_position:', actor_position)
Traceback (most recent call last): File "<console>", line 1, in <module> File "/home/antonio/projects/idemvdvoem.com/idemvdvoem.com/src/shared/parser.py", line 47, in __init__ self.films_list() File "/home/antonio/projects/idemvdvoem.com/idemvdvoem.com/src/shared/parser.py", line 91, in films_list self.detailed_films_info(films_dict) File "/home/antonio/projects/idemvdvoem.com/idemvdvoem.com/src/shared/parser.py", line 285, in detailed_films_info show_movie.showsMovie_originCountry.get_or_create(placeCountry_name=country) File "/home/antonio/projects/idemvdvoem.com/lib/python3.4/site-packages/django/db/models/fields/related.py", line 1029, in get_or_create obj, created = super(ManyRelatedManager, self.db_manager(db)).get_or_create(**kwargs) File "/home/antonio/projects/idemvdvoem.com/lib/python3.4/site-packages/django/db/models/manager.py", line 127, in manager_method return getattr(self.get_queryset(), name)(*args, **kwargs) File "/home/antonio/projects/idemvdvoem.com/lib/python3.4/site-packages/django/db/models/query.py", line 407, in get_or_create return self._create_object_from_params(lookup, params) File "/home/antonio/projects/idemvdvoem.com/lib/python3.4/site-packages/django/db/models/query.py", line 447, in _create_object_from_params six.reraise(*exc_info) File "/home/antonio/projects/idemvdvoem.com/lib/python3.4/site-packages/django/utils/six.py", line 659, in reraise raise value File "/home/antonio/projects/idemvdvoem.com/lib/python3.4/site-packages/django/db/models/query.py", line 439, in _create_object_from_params obj = self.create(**params) File "/home/antonio/projects/idemvdvoem.com/lib/python3.4/site-packages/django/db/models/query.py", line 348, in create obj.save(force_insert=True, using=self.db) File "/home/antonio/projects/idemvdvoem.com/lib/python3.4/site-packages/django/db/models/base.py", line 734, in save force_update=force_update, update_fields=update_fields) File "/home/antonio/projects/idemvdvoem.com/lib/python3.4/site-packages/django/db/models/base.py", line 762, in save_base updated = self._save_table(raw, cls, force_insert, force_update, using, update_fields) File "/home/antonio/projects/idemvdvoem.com/lib/python3.4/site-packages/django/db/models/base.py", line 846, in _save_table result = self._do_insert(cls._base_manager, using, fields, update_pk, raw) File "/home/antonio/projects/idemvdvoem.com/lib/python3.4/site-packages/django/db/models/base.py", line 885, in _do_insert using=using, raw=raw) File "/home/antonio/projects/idemvdvoem.com/lib/python3.4/site-packages/django/db/models/manager.py", line 127, in manager_method return getattr(self.get_queryset(), name)(*args, **kwargs) File "/home/antonio/projects/idemvdvoem.com/lib/python3.4/site-packages/django/db/models/query.py", line 920, in _insert return query.get_compiler(using=using).execute_sql(return_id) File "/home/antonio/projects/idemvdvoem.com/lib/python3.4/site-packages/django/db/models/sql/compiler.py", line 974, in execute_sql cursor.execute(sql, params) File "/home/antonio/projects/idemvdvoem.com/lib/python3.4/site-packages/django/db/backends/utils.py", line 79, in execute return super(CursorDebugWrapper, self).execute(sql, params) File "/home/antonio/projects/idemvdvoem.com/lib/python3.4/site-packages/django/db/backends/utils.py", line 64, in execute return self.cursor.execute(sql, params) File "/home/antonio/projects/idemvdvoem.com/lib/python3.4/site-packages/django/db/utils.py", line 97, in __exit__ six.reraise(dj_exc_type, dj_exc_value, traceback) File "/home/antonio/projects/idemvdvoem.com/lib/python3.4/site-packages/django/utils/six.py", line 658, in reraise raise value.with_traceback(tb) File "/home/antonio/projects/idemvdvoem.com/lib/python3.4/site-packages/django/db/backends/utils.py", line 64, in execute return self.cursor.execute(sql, params) django.db.utils.IntegrityError: duplicate key value violates unique constraint "place_countries_placeCountry_name_key" DETAIL: Key ("placeCountry_name")=(Польша) already exists.
DATABASES = { 'default': { 'ENGINE': 'django.db.backends.mysql', 'NAME': 'Django', 'USER': 'Django', 'PASSWORD': 'xxxxxxxx', 'HOST': '127.0.0.1', 'PORT': '3306', }, 'asterisk': { 'ENGINE': 'django.db.backends.postgresql_psycopg2', 'NAME': 'Django', 'USER': 'Django', 'PASSWORD': 'xxxxxx', 'HOST': 'public-host', 'PORT': '5432', } } DATABASE_ROUTERS = ['SiAsLo.routers.SisaloRoute','testapp.routers.TestappRoute']
class SisaloRoute(object): def db_for_read(self, model, **hints): if model._meta.app_label == 'SiAsLo': return 'asterisk' return None def db_for_write(self, model, **hints): if model._meta.app_label == 'SiAsLo': return 'asterisk' return None def allow_migrate(self, db, app_label, model=None, **hints): if model._meta.app_label == 'SiAsLo': return db == 'asterisk' return False
Django=# \dt No relations found.
pQtCoreQt.o sipQtCorequintptr.o sipQtCoreQSysInfo.o -L/home/silentstorm/Downloads/PyQt-x11-gpl-4.11.4/qpy/QtCore -L/usr/lib/x86_64-linux-gnu -lqpycore -lQtCore -lpthread
/usr/bin/ld: cannot find -lqpycore
collect2: error: ld returned 1 exit status
make[1]: *** [QtCore.so] Ошибка 1
make[1]: Выход из каталога `/home/silentstorm/Downloads/PyQt-x11-gpl-4.11.4/QtCore'
make: *** [install] Ошибка 2
... from lib.local.rds_services import Logger from lib.local.exceptions import * class RDSmanager(object): clc_user = 'user' clc_password = 'password' rdsmanager_localpath = os.path.dirname(os.path.abspath(__file__)) logger = Logger(rdsmanager_localpath) if os.environ.get('bamboo_working_directory'): local_source_dir = os.environ['bamboo_working_directory'] elif os.environ.get('RDS_HOME'): local_source_dir = os.environ['RDS_HOME'] else: raise NoSourceDirVariableError(logger, 'Directory with project source files not found. Exit.') ... ... class Options(RDSmanager): ... def getopts(self): ... parser = argparse.ArgumentParser() subparsers = parser.add_subparsers() # Unity options parser_unity = subparsers.add_parser('unity', help='Unity application options') parser_unity.set_defaults(func=self.handler_unity) parser_unity.add_argument('-r', '--refresh', action='store_true', dest='unity_refresh', help='Copy necessarry DLLs to Copy necessarry DLLs ' 'to MainApplication\\Assets\\PreparedPlugins and ' 'NGUIProject\\Assets\\PreparedPlugins before build.') ... def handler_unity(self, options_list): """Select and run specified command line options""" if options_list.unity_refresh: self.logger.logger.info('Running Unity refresh modules before Application build') from lib.unity.refresh import Refresh unity = Refresh() unity.refresh() ...
... from RDSmanager import RDSmanager from lib.unity.unity_services import UnityServices class Refresh(RDSmanager): def refresh(self): self.logger.logger(self.__class__.__name__) unity = UnityServices() modules_list = unity.modules_list() for modname in modules_list: ... if moddstdir: self.logger.logger.info('Copy file {} to {}'.format(module_src_dll_file, moddstdir)) shutil.copy(module_src_dll_file, moddstdir) ...
... from lib.local.exceptions import * from RDSmanager import RDSmanager class UnityServices(RDSmanager): ... def modules_list(self): ... return modules_names def module_csproj_file(self, module_name): ... return module_csproj_file ...
import serial import time import os import sys import win from win import * from PyQt5 import QtCore, QtGui, QtWidgets class Okno (QtWidgets.QMainWindow): def __init__(self, parent=None): QtWidgets.QWidget.__init__(self, parent) self.ui = Ui_MainWindow() self.ui.setupUi(self) self.ui.pushButton.clicked.connect (self.send) def send (self): dat1 = str(self.ui.lineEdit.text()) print (dat1) ser = serial.Serial('COM2', 9600) data = (bytes(dat1, encoding='ascii')) ser.write (data) s=str(ser.readline()) s=s[3:5] print (s) self.ui.label.setText ("%s" % s) temp = QtCore.pyqtSignal(int) self.temp.connect(self.ui.LcdNumber.display) self.temp.emit(s) app = QtWidgets.QApplication(sys.argv) MainWindow = QtWidgets.QMainWindow() okoshko = Okno() okoshko.show() sys.exit(app.exec_())
import sys from PyQt5 import QtCore, QtGui, QtWidgets class Ui_MainWindow(object): def setupUi(self, MainWindow): MainWindow.setObjectName("MainWindow") MainWindow.resize(551, 217) self.centralwidget = QtWidgets.QWidget(MainWindow) self.centralwidget.setObjectName("centralwidget") self.pushButton = QtWidgets.QPushButton(self.centralwidget) self.pushButton.setGeometry(QtCore.QRect(380, 20, 111, 61)) self.pushButton.setObjectName("pushButton") self.lcdNumber = QtWidgets.QLCDNumber(self.centralwidget) self.lcdNumber.setGeometry(QtCore.QRect(40, 50, 161, 71)) self.lcdNumber.setObjectName("lcdNumber") self.label = QtWidgets.QLabel(self.centralwidget) self.label.setGeometry(QtCore.QRect(280, 30, 71, 41)) self.label.setObjectName("label") self.label_2 = QtWidgets.QLabel(self.centralwidget) self.label_2.setGeometry(QtCore.QRect(80, 10, 71, 21)) self.label_2.setObjectName("label_2") self.lineEdit = QtWidgets.QLineEdit(self.centralwidget) self.lineEdit.setGeometry(QtCore.QRect(380, 110, 113, 20)) self.lineEdit.setObjectName("lineEdit") MainWindow.setCentralWidget(self.centralwidget) self.menubar = QtWidgets.QMenuBar(MainWindow) self.menubar.setGeometry(QtCore.QRect(0, 0, 551, 21)) self.menubar.setObjectName("menubar") MainWindow.setMenuBar(self.menubar) self.statusbar = QtWidgets.QStatusBar(MainWindow) self.statusbar.setObjectName("statusbar") MainWindow.setStatusBar(self.statusbar) self.retranslateUi(MainWindow) QtCore.QMetaObject.connectSlotsByName(MainWindow) def retranslateUi(self, MainWindow): _translate = QtCore.QCoreApplication.translate MainWindow.setWindowTitle(_translate("MainWindow", "MainWindow")) self.pushButton.setText(_translate("MainWindow", "Отправить")) self.label.setText(_translate("MainWindow", "TextLabel")) self.label_2.setText(_translate("MainWindow", "Температура")) if __name__ == "__main__": app = QtWidgets.QApplication(sys.argv) MainWindow = QtWidgets.QMainWindow() ui = Ui_MainWindow() ui.setupUi(MainWindow) MainWindow.show() sys.exit(app.exec_())
import threading class SomeThread(threading.Thread): def __init__(self): super(SomeThread, self).__init__() self.start() def run(self): thname = threading.current_thread() print("Hello Thread: %s" % (thname)) [SomeThread() for _ in range(5)]