Re: MySQL to Oracle db engine

2008-10-21 Thread Ian
tributeError: 'module' object has no attribute 'NCLOB' > > Has anyone seen this before - not much on the web. > > Thanks, > > Martin Hi Martin, What version of cx_Oracle do you have installed? As noted in the installation guide, Django requires at least v

Re: Oracle Clob Field type

2008-11-06 Thread Ian
something somebody's come across before. Django doesn't use LONG columns. Please make sure that you're using Django 1.0+ and *not* a 0.96 release. The oracle backend included in 0.96 was incomplete and should not be used. Hope that helps, Ian --~--~-~--~~~--

Re: Testing with an Oracle DB

2008-07-21 Thread Ian
chema and tablespace, not a full database (take a look at django/db/backends/oracle/ creation.py for the full details). Hope that answers your question, Ian --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Django us

Re: DBA-level DB options?

2008-09-15 Thread Ian
e tables manually and build models from them, you can do that as well using the inspectdb management command. The introspection is not perfect, so without a doubt you will need to edit the generated models to some extent. -Ian --~--~-~--~~~---~--~~ You received this

Re: Oracle DateTime SQL error

2008-10-10 Thread Ian
ull=True, db_column='TS', blank=True) >     class Meta: >         db_table = u'IFS_UIFN_SLO_TUJ' This would happen if the Oracle type of the datum_* columns is DATE rather than TIMESTAMP. If that's the case, you need to represent those columns in your model using Dat

Re: Raw SQL parameters

2009-01-20 Thread Ian
t a bug, but a design question: should Django support passing query parameters as mappings; if so, should the backend pass the engine's native style through unchanged, or should we standardize on "pyformat" (as we have already standardized on "format" when the parameters

Re: Search in a ManyToManyField in Admin interface

2009-01-28 Thread Ian
(perhaps you changed the model but didn't drop and recreate the table), you would get that error when you tried to search over it. To fix it, either replace the offending CharField with a TextField, or change the offending CLOB to a VARCHAR2. Hope that helps, Ian --~--~-~--~-

Re: Search in a ManyToManyField in Admin interface

2009-01-28 Thread Ian
re your models that way. Probably your best solution will be to put the TextField in a separate one-to-one related model. If you do that, and you avoid using the `list_select_related` admin option, and you exclude the related model from the `list_display` admin option, then you should be okay.

Re: db error after migrating from postgres to oracle

2009-11-18 Thread Ian
uires naive datetimes. I'm not sure what the official status of the PostgreSQL backend is with regard to timezone-aware datetimes, although evidently it works. I would suggest taking a look at the django-timezones app. I haven't used it myself, but I believe it's supposed to handle

Re: loaddata encoding problem

2009-12-01 Thread Ian
chemas? > > Thanks, > Johan Hi Johan, Do you only have VARCHAR2 / CLOB columns in the tables, or are there any NVARCHAR2 / NCLOB columns (which Django creates by default)? If the latter, then what is the NLS_NCHAR_CHARACTERSET of each database? Also, the dumpdata output should be in utf-8. Can

Re: Couldn't create tables.

2009-12-11 Thread Ian
e are few questions to be answered. > - Why did the tables not get created ? Without the output of your syncdb, I have no way of answering that. > - How can i create them ? Just run syncdb again. Regards, Ian -- You received this message because you are subscribed to the Google Groups &

Re: Django ugettext() got an unexpected keyword argument 'default' (template error)

2009-12-17 Thread Ian
. I'm not sure how having a too long column name results in the particular error you're reporting, but if an untruncated column name is being passed to the database, that's a bug, and you should create a ticket for it. Ian -- You received this message because you are subscribed to the

Re: Oracle - DatabaseError: ORA-01830 with a legacy db

2010-04-18 Thread Ian
ld to a DateField, and you should be okay. HTH, Ian -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-us...@googlegroups.com. To unsubscribe from this group, send email to django-users+unsubs

Re: Oracle cursor.execute problem

2010-04-23 Thread Ian
han the 'named' style natively used by cx_Oracle [1]. To convert your query, replace the parameter markers with %s and pass the parameters as a list rather than a dictionary. If you instead want to work with the underlying cx_Oracle cursor directly, you can access that as cursor.cursor.

Re: Oracle cursor.execute problem

2010-04-23 Thread Ian
On Apr 23, 2:44 pm, Ian wrote: > Django cursors universally use the 'format' dbapi paramstyle rather > than the 'named' style natively used by cx_Oracle [1].  To convert > your query, replace the parameter markers with %s and pass the > parameters as a list rath

Re: Oracle cursor.execute problem

2010-04-23 Thread Ian
r in the query.  The string-formatting link is a not really > germane .. Despite the '%s', it's purely a placeholder syntax, not a formatting system. The params don't have to be strings, because they don't actually get interpolated into the query at any point. Ints, floats

Re: Oracle cursor.execute problem

2010-04-26 Thread Ian
ut incorrect for PL/ SQL. The easiest fix is to add a space or a second semicolon at the end. Or you can do what Django does internally, which is to terminate the PL/SQL block with a forward-slash on its own line after the semicolon, as if the block were to be entered into sqlplus. In that

Re: Oracle cursor.execute problem

2010-04-28 Thread Ian
k with creating a > specific Oracle connection to do this? That would be a bug. I've just checked in a fix, which will be included in Django 1.2 and the next 1.1.X release. If you're not willing to use trunk or wait for the release, my recommendation would be to use cursor.callf

Re: Oracle cursor.execute problem

2010-06-15 Thread Ian
n creating the ticket, please be sure to indicate what version of Django you are using, and be specific about the conditions under which the bug appears. Currently all the test cases for queryset.only() are passed by the oracle backend. Thanks, Ian -- You received this message because you are sub

Re: Special characters and symbols in django?

2010-06-17 Thread Ian
uded in ISO-8859-1. If the column is NCLOB or NVARCHAR2, then Django should handle the encoding conversions for you. Ian -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-us...@googlegroups.com

Re: Special characters and symbols in django?

2010-06-18 Thread Ian
issue of some sort, then switching to a unicode build of cx_Oracle should hopefully clear it up. HTH, Ian -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-us...@googlegroups.com. To unsubsc

Re: renaming database constraint names

2010-08-03 Thread Ian
ngo schema to something more descriptive. If anyone has > any experience with that and has some suggestions on how to do it, I'd > love to hear from you. > > Thanks, > > Shirley In a dbshell: ALTER TABLE tablename RENAME CONSTRAINT old_name TO new_name; HTH, Ian -- You recei

Re: Bind variables in Oracle backend - how to use them?

2010-08-13 Thread Ian
ngo placeholders always use the %s syntax regardless of backend, so you'll need to use that rather than the named syntax normally used with Oracle. HTH, Ian -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send

Re: Bind variables in Oracle backend - how to use them?

2010-08-17 Thread Ian
A raw query is written entirely by the developer, so there is no reason for it to have an "extra" method. Cheers, Ian -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-us...@googlegroups

Re: Bind variables in Oracle backend - how to use them?

2010-08-19 Thread Ian
ass in django/db/ backends/oracle/base.py, which is used within the "RETURNING INTO" clause of an insert statement to receive the primary key of the inserted object. Hope this helps, Ian -- You received this message because you are subscribed to the Google Groups "Django users" group

Re: Oracle Database Other User Tables/Views

2010-10-20 Thread Ian
er interior quoting, e.g.: db_table = 'other_schema"."some_table' This is sufficient to trick Django into doing the right thing in most cases. Cheers, Ian -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this

Django-reviews: cannot set content-type

2010-11-17 Thread Ian
I'm using django-reviews (http://code.google.com/p/django-reviews/) and having trouble getting the content-type set for a review. Simple example: def check_review(request): if request.method == 'POST': reviewed_item = get_object_or_404(MyModel, pk=request.POST['object_pk']) rev

Re: Django 1.2.3, Oracle with Character Set WE8MSWIN1252 - 'utf8' codec can't decode bytes

2010-12-01 Thread Ian
g the appropriate values? $ export NLS_LANG=.UTF8 $ python >>> import cx_Oracle >>> conn = cx_Oracle.connect('username/passw...@dsn') >>> cursor = conn.cursor() >>> cursor.execute("SELECT PROBLEM_COLUMN FROM TERMINOLOGY_MAP WHERE ID = 206") >>

Re: ORA-01425

2010-12-02 Thread Ian
7; USING NCHAR_CS) ESCAPE TRANSLATE('\' USING NCHAR_CS)") I'd like to know whether this will work for autodetection. Thanks, Ian -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send ema

Re: ORA-01425

2010-12-03 Thread Ian
>  > ((1,),) Nuts. What if you remove the first TRANSLATE call, i.e. cursor.execute(r"SELECT 1 FROM DUAL WHERE 'A' LIKE TRANSLATE('A' USING NCHAR_CS) ESCAPE TRANSLATE('\' USING NCHAR_CS)") If that also doesn't trigger the error, then maybe we

Populating a model field with an implicit default values with request data from the admin interface

2010-01-26 Thread Ian
Given a model that looks like this class Article(models.Model): title = models.CharField(max_length=31) blurb = models.CharField(max_length=255) created_by = models.CharField(max_length=31) created_at = models.DateTimeField('Created Date') How would you populate the created_by fie

Re: Populating a model field with an implicit default values with request data from the admin interface

2010-01-26 Thread Ian
updated_by fields to blank=True in the model to defeat the validator, even though the semantics are that they shouldn't be blank (seems hacky, is there a better way?). On Jan 26, 11:50 am, Eugene Wee wrote: > Hi, > > On Wed, Jan 27, 2010 at 3:35 AM, Ian wrote: > > How wou

Re: Admin interface not working in Oracle

2010-01-26 Thread Ian
ere is something else going on here. I wonder if your admin site urlconf is correct. Note that when migrating, you need to change the regular expression also: r'^admin/ (.*)$' becomes simply r'^admin/'. Hope this helps, Ian -- You received this message because you are subscr

v1.2a change in ModelAdmin: save_model not called by add_view

2010-01-28 Thread Ian
I have an hook in a v1.1.1 admin app that sets some default values when adding an object - it works by overriding ModelAdmin.save_model Well, I just tried it with v1.2a and it fails, it looks like the call to save_model that preceded the calls to save_formset was removed. Without save_model, is th

Re: read only django admin

2010-01-28 Thread Ian
Despite the pedantic admonishments offered by others, there are use cases for readonly fields beyond primary keys. Metadata or implicit data that really shouldn't be changed isn't a "trust" issue, it's semantically different that application domain data. Anyway, I found this code has some issues b

Re: v1.2a change in ModelAdmin: save_model not called by add_view

2010-01-28 Thread Ian
Bug tracking system says it was fixed two weeks ago in trunk http://code.djangoproject.com/changeset/12206 - referenced by http://code.djangoproject.com/ticket/12696 -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send em

Re: Custom primary key using Oracle 10g

2007-08-15 Thread Ian
This is true across all the backends, not just Oracle. -Ian On Aug 14, 5:34 pm, Catriona <[EMAIL PROTECTED]> wrote: > Hi Jon > > Thanks for your reply. I read the article but with Oracle, a sequence > and trigger needs to be created for autogenerated primary keys. If I > try

Re: Custom primary key using Oracle 10g

2007-08-15 Thread Ian
On Aug 15, 9:43 pm, Catriona <[EMAIL PROTECTED]> wrote: > Hi Ian > > Sorry I wasn't really clear in what I want to achieve. I really just > want to call my primary key, in this case, employee_id and have it > incremented automatically. Sorry I misunderstood you. The co

Re: oracle and syncdb

2007-08-17 Thread Ian
David, I haven't seen this one before. I just tried a syncdb against the current trunk (rev 5918) with no problems. Would you please create a bug report with an example we can use to reproduce this? Thanks, Ian On Aug 16, 6:56 pm, "[EMAIL PROTECTED]" <[EMAIL PROTECTED

Re: Oracle invalid environment variables

2008-03-04 Thread Ian
here. You might also try asking your question on the cx_Oracle mailing list. Somebody there may have better insight into your problem. Hope that helps, Ian Kelly On Mar 4, 1:45 am, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: > Hello Django Users, > > Althought this is p

Re: DB migration from Oracle to MySQL

2008-04-03 Thread Ian
On Apr 3, 11:20 am, olive <[EMAIL PROTECTED]> wrote: > Hello again, > > I've tried dumpdata after having copied back my tweaked models.py to > the Oracle powered Django project. > > After 1 minute of intensive CPU activity this message appears: > > D:\test>python manage.py dumpdata test > Tracebac

ASP.Net GridView Equivalent in Django

2008-06-04 Thread Ian
I am .Net developer looking to switch over to Python. I have started looking at Django and was wondering if there is a widget equivalent to ASP.Net's GridView in terms of richness of functionality. If someone knows of any and has some examples of its use I would greatly appreciate it. --~--~

Re: Oracle syncdb

2008-07-03 Thread Ian
nce it raises an error at the sequence, the AutoField trigger doesn't get created either, and so you get the second error when trying to save objects. Did you perhaps create the schema once before, but then dropped all the tables without also dropping the sequences? Try clearing out the sch

Newforms: Is the current method of multiple field comparison the best way?

2007-03-16 Thread Ian
= UniqueCharField(cls=User, error="Another user has this username") email = forms.EmailField() password = forms.CharField(widget=PasswordInput(render_value=False)) confirm_password = ConfirmCharField(field=password, error="The passwords must match") Anyone have any th

Re: Newforms: Is the current method of multiple field comparison the best way?

2007-03-16 Thread Ian
ms.EmailField() password = forms.CharField(widget=PasswordInput(render_value=False)) confirm_password = forms.CharField(widget=PasswordInput(render_value=False)) > (also, django-developers is probably a better place to discuss this, > since it's a design issue in Django itself) You&

Re: Newforms: Is the current method of multiple field comparison the best way?

2007-03-16 Thread Ian
Here's another brainstorm that's sort of a combination. :) It's a Form that handles confirmation validation, but does so at the field level. Code will help illuminate what I mean: class ConfirmForm(forms.Form): """ ... """ def __init__(self, *args, **kwargs): super(Conf

Re: Newforms: Is the current method of multiple field comparison the best way?

2007-03-16 Thread Ian
> super(ConfirmForm2,self).__init__(*args,**kwargs) Copy paste edit: ConfirmForm, not with the 2. :) --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email

Re: Prevent URLs from being called directly

2007-03-30 Thread Ian
This situation is greatly helped if the same view displays the form as well as processes it. So it could look something like this: def write_entry(request): form = EntryForm() if request.POST: form = EntryForm(request.POST) if form.is_valid(): ... save entry,

Re: Django IDE

2007-04-07 Thread Ian
Greg: Command-` from within X application. On Apr 5, 6:24 pm, "Greg Donald" <[EMAIL PROTECTED]> wrote: > On 4/5/07, John Goodleaf <[EMAIL PROTECTED]> wrote: > > > > > Wing IDE. > > It looks really nice but then I discovered I would have to run an > Xserver to run it on my Mac. That's not a huge

Re: Problem using newforms cleaned_data with Oracle and DateField

2007-09-18 Thread Ian
Catriona, What versions of Python and Django are you using? What output do you get from running a describe on the Survey model's table? Ian On Sep 17, 5:07 pm, Catriona <[EMAIL PROTECTED]> wrote: > Hello > > I'm a newbie to Django and Python so sorry if this is a du

Re: Problem using newforms cleaned_data with Oracle and DateField

2007-09-18 Thread Ian
I'm unable to reproduce the error you're getting. The default table name would be app_survey rather than just survey, where app is the name of the application, so you might check that the table you listed is the same table that Django is using. Hope that helps, Ian On Sep 18, 5:03 pm

Re: Trying to install trunk version - svn error

2007-09-20 Thread Ian
> Any suggestion will be welcome. If you're using Oracle, then you absolutely want to be using trunk rather than 0.96. The svn error is likely a firewall issue [1]. I don't think that code.djangoproject.com accepts https connections, so your best bet is to reconfigure the fire

Re: Django - Oracle support

2007-10-16 Thread Ian
ould look into enabling it. I don't know off the top of my head how complex that kind of change would be. Ian --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this gr

Re: multiple database support: oracle backend

2007-10-17 Thread Ian
in multi-db environments that mix Oracle databases with non-Oracle databases, since OracleQuerySet replaces QuerySet entirely when Oracle is used. However, OracleQuerySet is a hack that will be going away after the QuerySet refactor, which solves both problems in the long run. Ian --~--~

Re: Oracle Backend - syncdb

2007-11-21 Thread Ian
those to be a cleaner solution than patching the provided apps. Thanks for bringing this up again, by the way. It will give me something to work on at the upcoming sprint. :-) Ian [1] http://groups.google.com/group/django-developers/browse_thread/thread/32d9d02ab0d13231/442f69bd72f75853

Re: Oracle usage

2007-11-27 Thread Ian
nk for all Oracle installations. Ian --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to

Re: Specifying tables with schema names in models

2007-12-06 Thread Ian
on doesn't understand it, and so syncdb will generate erroneous sql for those models. This hasn't proven problematic for us yet, since we don't use syncdb to generate our schemas except in the early stages of development. It sounds like you're probably not using it to

Re: Fast hosting for Django

2006-09-25 Thread ian
che server. This gives them maximum flexibility to start/stop > their Apache server on their own and edit their httpd.conf file as > they > want. > But we also configure our main Apache server to serve static data > (images, stylesheets, ...) directly, for maximum sp

Was: [Re: Why I'm giving up on Django] Now: Creating Debian Application Installer package

2006-10-02 Thread ian
rfakeroot The parent directory should now have a file called hello-world_1.0.0-1_all.deb which is your Debian package to install where you like with dpkg -i hello-world_1.0.0-1_all.deb []'s -- Ian Lawrence Centre for Bioinformatics INSTITUTO NACIONAL DE PESQUISAS DA AMAZÔNIA-INPA RUA ANDRÉ A

long db field names

2006-10-02 Thread ian
-width classes from previous Django versions have been removed. so maybe i have found a bug Ubuntu Dapper 6.06 LTS Dapper Drake Ubuntu/dapper-security Firefox/1.5.0.7 []'s -- Ian Lawrence Centre for Bioinformatics INSTITUTO NACIONAL DE PESQUISAS DA AMAZÔNIA-INPA RUA ANDRÉ ARAÚJO N º .2936 , B

Re: follow-the-tutorial.. little problem..

2006-10-04 Thread ian
sions/models.py > in get_decoded, line 65 > > I use svn version, where could be my error ? > > Thanks > > MA. > > > > Ola, I got this when i changed my secret key after I had created my models... []'s Ian -- Ian Lawrence Centre for Bioinformatics INSTITUT

Re: Does anybody solved the django project distribution problem?

2006-10-05 Thread ian
sure you could buy something to do the same thing. HTH []'s -- Ian Lawrence Centre for Bioinformatics INSTITUTO NACIONAL DE PESQUISAS DA AMAZÔNIA-INPA RUA ANDRÉ ARAÚJO N º .2936 , BAIRRO DO ALEIXO MANAUS-AMAZONAS-BRAZIL Research Program in Biodiversity http://ppbio.inpa.gov.br PHONE: 055-92-3

Re: sharing session information with plone

2006-10-06 Thread ian
ple of the GMail plugin here: http://plone.org/products/gmailauthplugin which is very simple and and can be used as a learning tool or even a template. If you do write something for Django send it to the list []'s -- Ian Lawrence Centre for Bioinformatics INSTITUTO NACIONAL DE PESQUISAS

Re: python textile library?

2006-10-09 Thread ian
get this and how can I install it? > > Thanks, > Ryan > > > > > Ola, On Debian/Ubuntu: [EMAIL PROTECTED]:$apt-get install python-textile []'s Ian -- Ian Lawrence Centre for Bioinformatics INSTITUTO NACIONAL DE PESQUISAS DA AMAZÔNIA-INPA RUA ANDRÉ ARAÚJO N º .293

Re: Django Hosting

2006-10-19 Thread ian
yes, after remi posted here a while back i took the plunge with webfaction. I have a couple of sites up and running now and i haven't had any problems or had to talk to anyone...really excellent stuff +1 webfaction []'s -- Ian Lawrence Centre for Bioinformatics INSTITUTO NACIONAL DE PE

Re: ¿django-es?

2007-02-13 Thread ian
> > Hola, si te refieres a una lista de django en español, si la tenemos > la formamos hace un tiempo atras, si deseas suscribirte esta en: [portuguese] Opa, seja bem vindo!! valeu, []'s Ian [english uk] Crikey, you are welcome salute's []'s Ian F U

psycopg error

2006-09-13 Thread Ian
s spatially enabled?..i am not sure. Or maybe i should revert to psycopg1?.New to Django to be honest. Any advice thx []'s -- Ian Lawrence Centre for Bioinformatics INSTITUTO NACIONAL DE PESQUISAS DA AMAZÔNIA – INPA RUA ANDRÉ ARAÚJO N º .2936 – BAIRRO DO ALEIXO MANAUS-AMAZONAS-BRAZIL

MySQL error when running manage.py init on Mac OS X with Fink installed

2006-03-05 Thread Ian
e and user that exist and are correct. I have also tried setting and unsetting the DATABASE_HOST, but get the error message either way. Any help would be appreciated. thanks, ian. --~--~-~--~~~---~--~~ You received this message because you are subscribed to t

Re: Oracle schema not working

2012-06-04 Thread Ian
= 'foo' # Django will take foo and change it to "FOO", which is how Oracle interprets foo not: db_table = '"foo"' # Since this is already quoted, I think Django won't change it, and then Oracle won't be able to find the table because it is explicit

Re: Getting at Oracle ROWID

2012-06-07 Thread Ian
> a PK with a few restrictions. But it's a LOB, so a cast to string is > normally required to fetch it: SELECT ROWID || '' > Writing this expression a piece of cake for CakePHP and its > virtualFields. Can Django do the same? MyModel.objects.extra(select={'

Re: Getting at Oracle ROWID

2012-06-12 Thread Ian
es isn't acceptable, you should be able to write a custom Field class for rowids and add that to your models with primary_key=True. It will probably break syncdb (but I assume this is a pre-existing table anyway if you need to use rowids). https://docs.djangoproject.com/en/dev/howto/c

Re: more than 1 level of belongsTo

2012-06-12 Thread Ian
I thought I'd rewrite this simple app in Django while learning it > at the same time. But Django doesn't really allow me to use such > virtual fields easily. Ian gave me a solution to my problem here: > > http://groups.google.com/group/django-users/browse_thread/thread/

Re: Getting at Oracle ROWID

2012-06-13 Thread Ian
On Wednesday, June 13, 2012 5:48:07 AM UTC-6, rahajiyev wrote: > > DatabaseError at / > > ORA-01446: cannot select ROWID from, or sample, a view with DISTINCT, GROUP > BY, etc. > > > Unfortunately Django doesn't show the precise statement that caused the > error. > The query it generates is: S

Re: Oracle: blank, null, and empty_strings_allowed

2012-06-18 Thread Ian
e the empty string as a possible value, and it can be stored like that in any of the other backends; it's just not accepted by the admin site. In this case it's mainly a cross-compatibility issue -- if an app stores the empty string on a blank=False field in Postgres, it should be ab

Re: Oracle: blank, null, and empty_strings_allowed

2012-06-19 Thread Ian
uppose a CHECK constraint would be required. Cheers, Ian * Of course with any backend there is the option of writing custom DDL and running it instead of or in addition to syncdb. -- You received this message because you are subscribed to the Google Groups "Django users" g

Re: Oracle: blank, null, and empty_strings_allowed

2012-06-21 Thread Ian
On Wednesday, June 20, 2012 1:38:45 PM UTC-6, André Pang wrote: > > 1. In Oracle's case, what if you have a model with a primary key that's > a CharField? I suspect that Oracle backend will coerce that to be > null=True, so now you have a primary key field that could have NULL. > Primary keys

Re: Oracle: blank, null, and empty_strings_allowed

2012-06-21 Thread Ian
On Thursday, June 21, 2012 4:37:35 AM UTC-6, Melvyn Sopacua wrote: > > Which is /exactly/ why I mention it. If the default value is inserted > instead of an empty string, you can pre-insert the default value and > have it linked to an invalid entry. Any attempts to insert the default > value on

Re: Catching Oracle Errors

2012-07-11 Thread Ian
On Tuesday, July 10, 2012 7:45:58 AM UTC-6, Dan Gentry wrote: > > My Django app runs on an Oracle database. > > A few times a year, the database is unavailable because of a scheduled > process or unplanned downtime. However, I can't see how to catch the error > and give a useful message back to t

Re: Oracle error when filtering on one2many related TextField (nclob)

2012-07-13 Thread Ian
the code patch in that ticket and see if it clears up the error. Ian -- You received this message because you are subscribed to the Google Groups "Django users" group. To view this discussion on the web visit https://groups.google.com/d/msg/django-users/-/f0pTxq1QBwkJ. To post to

Re: Syncdb Error With Oracle Database - IntegrityError Exception

2012-08-31 Thread Ian
On Friday, August 31, 2012 12:10:54 AM UTC-6, Amyth wrote: > > Hey Jon, > > I guess this is because of a bug in django. Django already has a open > ticket for this bug. Check it out > here > . > > As described in that ticket, the reason for the proble

Re: Can't Find libclntsh.so.11.1 With Oracle Backend

2012-09-10 Thread Ian
rocess's environment variables when Apache is started. Or as a third option, use ldconfig to make the Oracle library path globally visible. Cheers, Ian -- You received this message because you are subscribed to the Google Groups "Django users" group. To view this discussion on the w

Re: reading raw binary data from clob columns using oracle backend

2012-11-08 Thread Ian
On Wednesday, November 7, 2012 6:16:23 AM UTC-7, Michał Nowotka wrote: > > Hello, > I'm working with oracle legacy DB and need to read and write binary data > (png images, and and MDL *Molfiles*). > Django's inspectdb command generated text fields for these columns, saying > that's only a guess.

Platform system with Django?

2011-09-25 Thread Ian
I'm new to django, and at this point all I've done is the tutorial. But my end goal is to create a website that serves as a platform system. I want users to go to my site, create an account, edit some settings/ preferences, and a subdomain (can you do this with django?). Then within each subdoma

Re: Platform system with Django?

2011-09-26 Thread Ian
m, jmontoya wrote: > You can use pinax is based in django and it has a lots of "website > templates", intranet, blog, social etc > You can easly customized it ... > > http://pinaxproject.com/ > > Regards, > > Julio > > On Sep 26, 6:18 am, Ian wrote: >

Re: Randomly clearing database tables

2011-10-04 Thread Ian
On Oct 4, 10:30 am, msbuck wrote: > Good news! Yesterday, I was repeatedly starting the development server > from Eclipse which is on the Run As  -> menu which cascades to Run > Server or Run Python Unit Test. I must have accidently clicked that we > I really wanted to start my server. That comman

Django image upload

2011-10-05 Thread Ian
Hey Everyone, I'm new to django, but I love it so far! I'm trying to figure out how to upload an image (restrict it to images only) and resave it as a different name. Eventually, I'll want to upload it to S3, but for now, I'm just testing it on my computer with runserver (so I'm not sure where it

Re: Django image upload

2011-10-06 Thread Ian
p://www.sebastienbillion.com/> > > Le 06/10/2011 05:22, Ian a �crit : > > > > > > > > > Hey Everyone, > > > I'm new to django, but I love it so far! > > > I'm trying to figure out how to upload an image (restrict it to images > >

Re: Django image upload

2011-10-06 Thread Ian
then, is that the file gets stored here: > > > /Users/storefiles/pluginfiles/2011/10/06/02/38/somefile.zip > > > So, you must have at least one of those set and the path must be fully > > write enabled for whatever process is running your Django app. For my > > testing, I j

Re: Django image upload

2011-10-06 Thread Ian
> image, if I understand it correctly. > > > > > > > > On Thu, Oct 6, 2011 at 6:21 PM, Ian wrote: > > Ah! Got it working! How do I make sure the files are only images?  Is > > there a way to check the extension?  Also, how would I rename the > > file

Re: Django image upload

2011-10-06 Thread Ian
> image, if I understand it correctly. > > > > > > > > On Thu, Oct 6, 2011 at 6:21 PM, Ian wrote: > > Ah! Got it working! How do I make sure the files are only images?  Is > > there a way to check the extension?  Also, how would I rename the > > file

PayPal Adaptive Payments

2011-10-08 Thread Ian
I've been looking at this: https://www.x.com/docs/DOC-3084 but I'm trying to set it up with Adaptive Payments. Basically, I need a payment to be split between a few users... so if I purchase something from seller A: seller A gets 90% person B gets 5% person C gets 5% This is easy to do with PayP

Re: PayPal Adaptive Payments

2011-10-09 Thread Ian
Thanks, Markus! That looks perfect! Shawn, I was more curious if this is even possible to do with django. I was just doing research and wanted to know if there was a better payment system tailored for django (the 'merchant' project looks perfect) thanks guys! On Oct 8, 4:26 pm, Markus Gattol wr

Re: PayPal Adaptive Payments

2011-10-09 Thread Ian
So I got the basic merchant functionality working, but I can't figure out the best way to automatically split the payment 3 ways... advice? On Oct 9, 3:02 pm, Ian wrote: > Thanks, Markus! That looks perfect! > > Shawn, I was more curious if this is even possible to do with django

Re: PUNTARE CON DJANGO SU BILANCIATORE ORACLE ATTRAVERSO IL TSNAME

2011-10-18 Thread Ian
e setting.py potete aiutarmi If you don't have a TNS name, you can identify the database by hostname, listener port, and SID. See the second example at: https://docs.djangoproject.com/en/1.3/ref/databases/#id11 Cheers, Ian -- You received this message because you are subscribed to the Googl

Re: PUNTARE CON DJANGO SU BILANCIATORE ORACLE ATTRAVERSO IL TSNAME

2011-10-18 Thread Ian
On Oct 18, 5:17 am, Maksymus007 wrote: > englishoo speakino list only. That was rude and uncalled for. -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com. To unsubscribe from this

Re: django get value from oracle function

2012-01-27 Thread Ian
p://cx-oracle.sourceforge.net/html/cursor.html#Cursor.callfunc Cheers, Ian -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com. To unsubscribe from this group, send email t

Re: IntegerField and SmallIntegerFields maps to the same db type on Oracle.

2012-12-13 Thread Ian
On Thursday, December 13, 2012 4:29:30 AM UTC-7, Michał Nowotka wrote: > > Does anyone knows the reason why IntegerField and SmallIntegerFields both > map to NUMBER(11,0) in Orcale? > I would expect SmallIntegerFiled map to something smaller ;) > Beats me. Although note that Oracle itself equate

Re: ORM, Oracle and UTF-8 encoding problem.

2013-01-09 Thread Ian
On Wednesday, January 9, 2013 12:38:28 AM UTC-7, Jani Tiainen wrote: > > Tested against latest master. Same behaviour. > > In Oracle backend base.py is following piece of code: > > # Check whether cx_Oracle was compiled with the WITH_UNICODE option. > This will > # also be True in Python 3.0.

Re: Pluggable Q&A Django App

2013-01-10 Thread ian
Hi Natasha, I'm looking for the same thing you are, that's how I found your post! Did you find anything that can be plugged or wrote your own? On Tuesday, August 7, 2012 1:53:03 PM UTC-4, natash...@utoronto.ca wrote: > > Hi All, > > I'm looking to implement a Stack Overflow style Q&A feed on my

Re: charField null=false not enforced for table creation in oracle

2013-02-23 Thread Ian
On Friday, February 22, 2013 11:27:59 PM UTC-7, Skylar Saveland wrote: > > This is still a good question :) > The answer is that there is no way to instruct Django that you really, truly want this CharField to be NOT NULL even on Oracle, and that is unlikely to change. Part of the philosophy in

  1   2   3   4   5   6   7   >